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

Reply via email to