MySQL Forums :: JavaScript, JSON, Node.js :: Import XML to MySql Table

Advanced Search

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

Subject Written By Posted
Import XML to MySql Table Paul House 03/14/2006 07:08AM
Re: Import XML to MySql Table Roland Bouman 03/14/2006 05:48PM

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.