On Mon, Mar 26, 2012 at 11:38 PM, YAN HONG YE <[email protected]> wrote:
> WHEN I export sqlite database to a html file or txt file, I couldn't know how 
> to include the database table head.
> who can tell me?
> Thank you!

Use -header like this:
  sqlite3 -html -header my.db "select * from mytable"

See output of:
  sqlite3 -help
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to