sqlite3 main.db < main.txt or cat main.txt | sqlite3 main.db or echo "create table tbl1(one varchar(10), two smallint);" | sqlite3 main.db Michael D. Black Senior Scientist Northrop Grumman Mission Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of Peng Yu Sent: Tue 5/25/2010 9:20 AM To: sqlite-users@sqlite.org Subject: [sqlite] How accept sqlite3 commands from stdin I got the following error when I try to read the commands from the command line. Would you please let me know how to let sqlite3 read from stdin? $ cat main.txt create table tbl1(one varchar(10), two smallint); $ echo main.txt |sqlite3 main.db Incomplete SQL: main.txt -- Regards, Peng _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users