On Mon, 11 Feb 2013 05:42:17 -0800 (PST), Jeff Steffanina
<[email protected]> wrote:
>
>Hello All,
>During a sqlite3 session, I need to APPEN output to a FILE in the HTML mode.
>
>Here is my SELECT: Select * from Booking;
>
>What I really want to say is Set the mode, Execute select and append to
>MySummary:
>
>mode html Select * from Booking >> MySummary.html
Two oneliners (possibly wrapped in transmission)
1)
printf ".mode html\nSELECT * FROM Booking;\n"|sqlite3 Mydb >>My.html
2)
sqlite3 -html Mydb "SELECT * FROM Booking;" >>My.html
Try:
sqlite3 -help
for more options.
--
Groet, Cordialement, Pozdrawiam, Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
