Re: MySQL XML retrieval

Play the video

Subject: Re: MySQL XML retrieval
From: Ben Trafford <ben@xxxxxxxxxxx>
Date: Tue, 02 Dec 2003 06:42:27 -0500

At 04:50 PM 12/2/2003 +0530, karthikeyan.balasubramanian 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

I'm in the middle of doing this, myself.

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:

        <database name="DATABASE_NAME">
                <table name="TABLE_NAME>
                        <row>
                                <field name="FIELD_NAME">FIELD_DATA</field>
                                ...more fields...
                        </row>
                        ...more rows...
                </table>
                ...more tables...
        </database>

I have some XSLT files designed to strip out data from that format. Drop me a private email if you'd like them, and I'll ship them off. I haven't done any work to format them yet.

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 ->
MySQL XML retrieval, karthikeyan.balasubr	Thread	Re: MySQL XML retrieval, Rajeshwar
Re: Passing XML data to HTML , andrew . curry	Date	RE: MySQL XML retrieval, Harihara Vinayakaram
	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 >