I'll try. Thanks. This seems just what I need.
Bertwim
On 09/21/2013 06:12 AM, Bernhard Amann wrote:
INSERT INTO <newtable> SELECT * FROM <oldtable>;
However, this only works if <newtable> already exists, which is actually quite
cumbersome..
Is there a way to make the new table 'on the fly"?
create table newtable as select * from oldtable;
Bernhard
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
