Re: [xsl] MySQL XML retrieval

Subject: Re: [xsl] MySQL XML retrieval
From: Rajeshwar <kr@xxxxxxxxxx>
Date: Tue, 02 Dec 2003 17:30:17 +0530
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


Current Thread