On Mon, Mar 26, 2012 at 11:38 PM, YAN HONG YE <yanhong...@mpsa.com> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
