xsl-list
[Top] [All Lists]

Re: MySQL XML retrieval

2003-12-02 05:00:17
Hi Ben,

Which version of MySQL are you using? The xml output format is not available in the distribution I have (3.23.36).

regards
Rajeshwar


Ben Trafford wrote:

  Just wondering if we can get data in mysql
as an xml and use xslt to format it.

  Anybody who have done this can chip
in their input so that I can get enlightened



Assuming you're using Linux, if you go to the command line and type:

mysqldump -X --password='YOUR_PASSWORD' DATABASE_NAME >XML_FILE.xml

        ...you'll get an XML data file in the format:

<snip>




XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list



<Prev in Thread] Current Thread [Next in Thread>