This schema describes the format of the XML documents
generated by the mysql command line utility.
Start the mysql command line utility with the -X
or --xml option to achieve this effect.
The mysql command line utility will then output
each resultset as a distinct XML document.
Even when the SELECT expressions are executed from within
a procedure, each SELECT expression still generates it's
own document.
More information about the command line utility
can be found at:
http://dev.mysql.com/doc/refman/5.0/en/mysql.html
Document element (root element).
Acts as container for the rows in the resultset.
The type of the document element.
This is basically a container of row elements
The row element represents one database row
retrieved by the query.
The statement attribute contains the
SQL-expression that generated the resultset.
This might be a simple SELECT expression, or a
call to a stored procedure.
Resultsets returned from a stored procedure
always have the outer CALL statement here, *NOT*
the actual SELECT expression-or procedure call
producing the result.
Even when you use nested procedure calls, only the
outer expression is used.
The type a row element.
Corresponds to a row returned by the query
A field element. Corresponds to a column
retrieved in the resultset.
The type for field elements.
This is defined to store a text value.
The column expression. This might be a simple column name,
or a complex expression.