Home   My Faqts   Contributors   About   Help   Link to FAQTS

faqts : Computers : Databases : MySQL : Tips and Tricks

Did You Find This Entry Useful? 4 of 4 people (100%) answered Yes Recently 4 of 4 people (100%) answered Yes

How do you convert table output to XML or HTML?

Jun 19th, 2004 06:17

Mike Chirico
http://osdn.dl.sourceforge.net/sourceforge/souptonuts/README_mysql.txt

Try the following from the Unix/Linux command prompt:
$ mysql -X -e "select * from exams" test
The line above will select all records from exams in the test database,
with output in XML format.
To get HTML format, changed the -X above to -H.
Hope it helps.

© 1999-2005 PowWeb Inc.