MySQL : XML from a resultset?

Question

Is it possible to generate an XML (or csv) string from a resultset in MySQL ?

Basically I'd like to have the contents of an entire record in 1 string...

score 1 · Answer 1 · edited May 23 '17 at 12:04

1

Yes, here is the documentation for XML, and a reference to the CSV question on SO.

edited May 23 '17 at 12:04

Community

answered Dec 29 '10 at 18:18

Demitrius Nelon

score 0 · Answer 2 · answered Dec 29 '10 at 18:19

Just a quick example, you can use xml_tag like this:

select xml_tag('table',table_name,null,null)
from information_schema.tables
where table_schema = 'INFORMATION_SCHEMA'

Comprehensive Docs:

2 Answers2