DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Michael has posted 7 posts at DZone. View Full User Profile

Get HTML/XML Output Of Your MySQL Queries.

12.04.2006
| 14038 views |
  • submit to reddit
        The mysql command line utility can be used to build databases, manipulate them, etc.  It can also be used as an ad-hoc query tool with HTML-snippet output.  Consider this code:

mysql -e "SELECT * FROM mytable WHERE somecondition='somevalue'"

The resulting output will be a mess of +, - and | characters used to frame boxes around the values.  Now consider instead:

mysql -H -e "SELECT * FROM mytable WHERE somecondition='somevalue'"

The output of this is <TABLE/><TR/><TD/> code that can be cut-and-pasted into your HTML editor of choice.  Complex queries not easily put into a single -e string can be done thus:

mysql -H < myqueries.sql

Note that no HTML is generated for any query that does not have a result set (like INSERT or UPDATE).

Change the -H to a -X to get XML output (without a DTD/XSL description, unfortunately).