Answer Posted / Jitender Kumar
To return query output in XML format, you can use the EXTRACTXML function in MySQL. Here's an example:n```sqlnSELECT EXTRACTXML(XML_DOCUMENT, '/root/element') AS my_element FROM ( SELECT @xml_doc := CONCAT( '<?xml version="1.0"?>n', XML_PRETTY_PRINT( SELECT * FROM table_name ) ) AS XML_DOCUMENT FROM dual ) AS temp;n```
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
