very cool! Thanks, Gabor. On Sun, Apr 18, 2010 at 12:16 PM, Gabor Grothendieck <[email protected]> wrote: > On Sun, Apr 18, 2010 at 12:02 PM, Wensui Liu <[email protected]> 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 > [email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
