I would like to know a way to create an XML file using MySQL queries only. without using any scripting language at all.
Are there any books, tutorials on this topic ?
I would like to clear it out that I want to use sql queries which would forward XML data to a php Script.
xml_escape(value) - replace characters not allowed in xml with the escape sequences xml_attr(name, value) - create an xml attribute xml_tag(tagname, tagvalue, attrs, subtags) - create a tag
SELECT whatever FROM whereever INTO OUTFILE '/path/to/file.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'
Combining these two techniques should let you create an XML file without any scripting.