title: Export MySQL Table to XML for use with .NET system.data.DataTable ReadXML()
body: <p>I have a situation where I need to export a MySQL table with schema and data to XML on a server, and import that XML into a System.Data.DataTable using <a href="https://msdn.microsoft.com/en-us/library/yfxbc3by(v=vs.110).aspx" rel="nofollow noreferrer">DataTable.ReadXML()</a>. I'm doing the client-side work and someone else is doing the server-side work. The server-side is using PHP. I've read that using <strong>FOR XML</strong> on the MySQL query will output results in XML, but it's unclear how to get a XML Document with the table's schema that is compatible with DataTable.ReadXML(). Has anyone got a simple way to handle the PHP side of  this?</p>
  
  <p>Many thanks in advance!</p>