StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>XSLT transforms a document tree to another document tree. As I know there are no direct connectors to MySQL that could insert transformed data into MYSQL.</p> <p>Another option might be to generate an XML that could be imported by MySQL.</p> <p><code>mysqldump</code> utility accepts --xml option that allows to dump data in XML format (so you can transform your data to the format). Unfortunatelly, loading the data from the file back is a trick that is <a href="http://dev.mysql.com/tech-resources/articles/xml-in-mysql5.1-6.0.html#xml-5.1-importing-sp" rel="nofollow noreferrer">available only from MySQL 5.1</a>. In MySQL 6.0.3 though there appears a new LOAD XML statement that can be used for the purpose.</p> <p>I believe that the task can easily be solved by reading the XML with an XML-reader and inserting the data row by row using standard database connectors in any modern programming language.</p> <p><strong>UPD</strong>:</p> <p>An xsl might look as following:</p> <pre><code><?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="text"/> <xsl:template match="breakfast_menu"> <xsl:apply-templates mode="insert-to-food" select="food" /> <xsl:apply-templates mode="insert-to-breakfast_menu" select="food" /> </xsl:template> <xsl:template mode="insert-to-food" match="food"> <xsl:text>INSERT INTO food(</xsl:text> <xsl:number /> <xsl:text>, '</xsl:text> <xsl:value-of select="name" /> <xsl:text>', '</xsl:text> <xsl:value-of select="price" /> <xsl:text>', '</xsl:text> <xsl:value-of select="description" /> <xsl:text>', </xsl:text> <xsl:value-of select="calories" /> <xsl:text>);&#xA;</xsl:text> </xsl:template> <xsl:template mode="insert-to-breakfast_menu" match="food"> <xsl:text>INSERT INTO breakfast_menu(1, </xsl:text> <xsl:number /> <xsl:text>);&#xA;</xsl:text> </xsl:template> </xsl:stylesheet> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload