"for xml" - how can I do the same with mysql?

[Max Favilli]

Hello everybody,

I have just installed mysql to evaluate it, I have an application based
on mssql which extensively use the "for xml" clause to retrieve data from
the db as xml well formed document (actually "for xml explicit").
How can I do the same thing with mysql? I understood there's no native
support for retrieving data as xml document, but there is any add-on,
plugin, library... Anything which is very very fast (I intend to use it in
very intense environment, where performance are crucial), and I can relay to
smoothly switch from mssql to mysql?
By the way the application is written in c#.

Thanks,
Max

[Bill Karwin]

Max Favilli wrote:

I have an application based
on mssql which extensively use the "for xml" clause to retrieve data from
the db as xml well formed document (actually "for xml explicit").
How can I do the same thing with mysql?

The mysql and mysqldump tools have options for producing XML output, but
that does not comprise a programming interface.

There's also MyXML, which is a GPL'd library of UDFs that you can use in
your SELECT queries to return data in XML format.
http://solutions.mysql.com/software/?item=292
I found this in the MySQL.com partner directory.

Other than that, you could search for a solution for formatting an ODBC
or ADO result set in XML. You should be able to query MySQL using ODBC
or ADO from your C# code.

Regards,
Bill K.