On Sun, Aug 15, 2010 at 4:40 PM, Peng Yu <pengyu...@gmail.com> wrote: > On Sun, Aug 15, 2010 at 5:58 PM, Simon Slavin <slav...@bigfraud.org> wrote: >> >> On 15 Aug 2010, at 11:31pm, Peng Yu wrote: >>> sqlite3 main.db < file.txt <<EOF >> Some of those lines are commands to your Unix shell and others are commands >> for the sqlite3 program. You cannot mix a shell script and SQL commands >> like that. Try these three files: > > This is called here document in bash. You can mix sqlite3 code with bash code.
Aren't you setting stdin for the sqlite3 utility to file.txt, AND to the contents of the here document. How is sqlite3 supposed to distinguish between the two types of data coming into it on stdin? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
