Re: [xsl] MySQL XML retrieval

Cart

XML Editor - Download a Free Trial >

See What's New >

Buy Now >

[Home] [By Thread] [By Date] [Recent Entries]

Subject: Re: 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
MySQL XML retrieval karthikeyan.balasubramanian - Tue, 2 Dec 2003 06:25:24 -0500 (EST) Ben Trafford - Tue, 2 Dec 2003 06:39:15 -0500 (EST) Rajeshwar - Tue, 2 Dec 2003 07:08:04 -0500 (EST) <= Ben Trafford - Tue, 2 Dec 2003 07:15:04 -0500 (EST) Jim Melton - Tue, 2 Dec 2003 12:37:18 -0500 (EST) <Possible follow-ups> Harihara Vinayakaram - Tue, 2 Dec 2003 06:42:20 -0500 (EST)

<- Previous	Index	Next ->
Re: MySQL XML retrieval, Ben Trafford	Thread	Re: MySQL XML retrieval, Ben Trafford
Re: number of rows, David Carlisle	Date	RE: Passing XML data to HTML , SHEIKH Sajjad
	Month

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >