very cool! Thanks, Gabor. On Sun, Apr 18, 2010 at 12:16 PM, Gabor Grothendieck <ggrothendi...@gmail.com> wrote: > 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 >
-- ============================== WenSui Liu Blog : statcompute.spaces.live.com Tough Times Never Last. But Tough People Do. - Robert Schuller ============================== _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users