If you want it just DIY...
.mode html select "<table>"; select * from stuff; select "</table>"; Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Roger Binns [rog...@rogerbinns.com] Sent: Wednesday, August 10, 2011 10:56 AM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Shell doesn't do <TABLE></TABLE> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 08/10/2011 09:13 PM, Simon Slavin wrote: > The content is fine, but it doesn't do <TABLE> or </TABLE>. My shell copies the SQLite shell and also outputs only rows. The reason is that multiple statements could be used to generate output so you do not assume each one is complete. eg: .mode html select x,y from tablea where ...; select x,y from tableb where ...; A full html output would also have to generate html/head/body etc where it is virtually impossible to guess what the requirements are. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk5CqkAACgkQmOOfHg372QT8KgCgrCiEoFK6/73GN7+PxLDXdSZL qNUAoKFbRqojRSxpe/KjHZ49BYd/nPhR =kql0 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users