On 14 Jun 2009, at 6:52pm, Tim Bradshaw wrote: > Well, it can if you are willing to be a bit devious. Something like > this works: > > create table frobs ( > id integer primary key, > frob varchar); > > create temporary table frobs_import ( > frob varchar); > > .import data frobs_import > > insert into frobs(frob) > select * from frobs_import;
Okay, that wins my deviousity award of the day. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users