http://snippets.dzone.com/posts Fri, 05 Sep 2008 10:39:09 GMT DZone Snippets: xml code http://snippets.dzone.com/posts/show/3077 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: <br /> <br /><code> <br />mysql -e "SELECT * FROM mytable WHERE somecondition='somevalue'" <br /></code> <br /> <br />The resulting output will be a mess of +, - and | characters used to frame boxes around the values. Now consider instead: <br /> <br /><code> <br />mysql -H -e "SELECT * FROM mytable WHERE somecondition='somevalue'" <br /></code> <br /> <br />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: <br /> <br /><code> <br />mysql -H < myqueries.sql <br /></code> <br /> <br />Note that no HTML is generated for any query that does not have a result set (like INSERT or UPDATE). <br /> <br />Change the -H to a -X to get XML output (without a DTD/XSL description, unfortunately). Mon, 04 Dec 2006 18:26:26 GMT http://snippets.dzone.com/posts/show/3077 ttmrichter (Michael T. Richter)