On Tue, Aug 2, 2011 at 1:13 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> copy your data across using INSERT INTO myTable SELECT a,b,c,d FROM > myOldTable > DROP the old TABLE > or, similarly: CREATE TABLE myTable AS SELECT ... FROM myOldTable; Though there might be subtle differences between the two which i'm not aware of. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
