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