Result in XML format

[Pankaj Patro]

hi,

Can it possible to get the results in XML format when it is queried agnist MySql data base.

I have a sample query of DB2 data base, where you can get the result in XML formatted way:
SELECT REC2XML (0.001,'COLATTVAL','row',tabname,colname,typename,length,default,nulls) as "xmlData" FROM syscat.columns
here the REC2XML function makes the XML format data after querying from DB2 database.

Can any one help me, how it can be done it in MySql and Oracle database.

[Agador Paloi]

for oracle , something like this should work:

Select xmlelement("fld1_name",col1) , xmlelement("fld2_name",col2)
From some_table ;

if you want to aggregate it you can use xmlagg

[Pankaj Patro]

Adagort, thanks for reply.

like REC2XML in DB2 there is a function in Oracle XMLFOREST,
Is there any built in function in MySql for XML.