MySQL Forums
Forum List  »  Connector/Node.js

Re: MySQL and XML
Posted by: freqout
Date: November 09, 2005 11:49AM

I think I'm looking for the same answer as Roscoe, and I have searched, and read docs, but I'm getting the feeling that mysql just does not support what I and many others are looking for, from mysql.

With the mysql and mysqldump command line tools, you can get output in xml format using the -xml parameter.

There are a growing number of databases that will return SQL results in XML format when using special parameters in the query. For example, in a SQL Server query you add on FOR XML <MODE>.

Is there a way to get mysql to return query results in XML when using PHP, Perl, Java, etc. _without_ needing to have some type of PHP, Perl, Java post-process to take the resultset and format it into SQL/XML??

If I can't get an answer to this soon, then I will have to leave mysql behind.

Roscoe P. Coletrain wrote:
> question....
> I recently started a MySQL project and put all of
> my business logic into stored procedures. Now I
> am trying to take the output from the procedures
> and convert it into XML. Looking around there
> seem to be a fair number of solutions involving
> PHP, Perl, etc... taking it out of the db. I was
> wondering if there were any examples of people
> doing it within stored procedures or on the db
> somehow.
> thanks

Options: ReplyQuote

Written By
October 25, 2005 04:39PM
Re: MySQL and XML
November 09, 2005 11:49AM
February 05, 2006 02:16PM
February 12, 2006 11:33PM
March 14, 2006 06:00PM
April 24, 2006 06:19AM
April 24, 2006 08:29AM
June 08, 2006 08:16AM
May 02, 2006 11:10AM
July 07, 2006 05:28PM
September 04, 2006 10:28AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.