9 Mar
2010
9 Mar
'10
9:51 p.m.
On Tue, Mar 09, 2010 at 09:46:31PM +0000, Chris G wrote:
It sounds like it should be easy but I can't see any reasonable way of doing it. How do you make a copy of a table in an sqlite3 database?
I can copy the database, that's trivial, but I want to duplicate a *table* within a database and that seems distinctly un-trivial.
INSERT INTO newtable SELECT * FROM oldtable;
assuming newtable and oldtable share the same schema?
J.
--
Web [ Sleep? Isn't that some inferior replacement for caffeine? ]
site: http:// [ ] Made by
www.earth.li/~noodles/ [ ] HuggieTag 0.0.24