MySQL Forums
Forum List  »  Connector/Node.js

Import XML to MySql Table
Posted by: Paul House
Date: March 14, 2006 07:08AM

Hello I know this question has been asked in an earlier thread but without an answer so i'm gonna ask again. I want to put an XML file into a MySql table (without the use of Navicat or something similar). I assume this can be done without the use of XSLT and the XML data can be directly inserted into a table. Can anyone help?



The XML:-

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Edited with XML Spy v2006 ( -->
<?xml-stylesheet type="text/xsl" href="birds.xsl" ?>


<name>Golden oriole</name>
<latin>Oriolus oriolus</latin>
<Image ID="123" URI="golden_oriole.jpg"/>
<url address="" />


<latin>Accipiter nisus</latin>
<Image ID="123" URI="sparrowhawk.jpg"/>
<url address="" />

<latin>Carduelis spinus</latin>
<Image ID="123" URI="siskin.jpg"/>
<url address="" />

<latin>Upupa epops</latin>
<Image ID="123" URI="hoopoe.jpg"/>
address="" />


Options: ReplyQuote

Written By
Import XML to MySql Table
March 14, 2006 07:08AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.