On Sun, Apr 18, 2010 at 12:02 PM, Wensui Liu <liuwen...@gmail.com> wrote: > dear listers, > i am wondering if there is a way to submit a file with many sql > statements, say several hundred lines, to sqlite. > > thanks for your insight.
C:\tmp2>type a.sql create table tab (a,b); insert into tab values(1, 2); insert into tab values(1, 2); select * from tab; C:\tmp2>sqlite3 a.db < a.sql 1|2 1|2 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users