Derrell Lipman wrote:
> On Feb 16, 2008 12:01 PM, Fred J. Stephens <[EMAIL PROTECTED]> wrote:
>> How can I issue 2 commands to SQLite at the same time in a shell script?
>> I want to temporarily change the separator for the returned data,
>> something like:
>> sqlite3 database.db ".separator " ", SELECT first,last FROM address;"
>
> sqlite3 database.db <<'EOF'
> .separator " "
> SELECT first, last FROM address;
> EOF
Ah, the here doc! I hadn't thought of that.
Thanks very much.
Fred
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
