MySQL Forums
Forum List  »  Connector/Node.js

How to get xml output for a query
Posted by: Amit Jhingran
Date: June 23, 2010 01:43PM

How can we get output from a query as xml, I tried using --xml options but not able to use it.

I alos tried to use the query
select Concat('<row>\n',
Concat(' <id>', id, '</id>\n'),
Concat(' <fname>', fname, '</fname>\n'),
'</row>') as xmldoc from user;

But the problem with this query is that the I don't get any root tag for the xml output. Please help

Amit Jhingran

Options: ReplyQuote

Written By
How to get xml output for a query
June 23, 2010 01:43PM

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.