On March 26, YAN HONG YE wrote:
(apparently quoting Steinar Midtskogen, quotation demarked)
> to export to the html file command is:
sqlite3 -html film.db "select * from film" > mm.html
but the result had no table,only a text file without line feed, how to export
the html with tables and table column header?
The output in the SQLite shell's html mode is not a valid instance of
HTML. It is something that can be embedded in a valid HTML document.
To use that output, you will have to have all the usual HTML opening and
closing constructs. You will need to bone up on HTML, or do some study
of HTML instances that have tables in them, and figure out how to put a
sqlite shell generated table into one which otherwise says what you
want. (For example, tables usually have a title, or something
explaining what they are.)
--
Larry Brasfield
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users