Re: MySQL and XML

[freqout]

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