MySQL client and the XML format

[Bjarke Walling Petersen]

Hi,

I have been playing around with the XML feature in the MySQL client. Is it possible to include the type of each field?

Try this query: SELECT NULL, 'NULL'; You won't be able to tell if a field is NULL or contains the string NULL. It could be nice as well to tell if a field is an integer, a string or something else.

I will also look forward to have a XML output feature included directly in the MySQL server.

Thanks in advance,
Bjarke Walling Petersen