On 14 Jun 2009, at 18:33, Simon Slavin wrote: >> I hope sqlite3 > .import FILE >> can do it > > It can't.
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; --tim _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
