Re: MySQL XML retrieval

Play the video

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

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >