How to add data from XML file to MySQL Database?

Question

I have an XML file called categories.xml. Here is a sample of the file:

<?xml version="1.0" encoding="UTF-8"?>
<categories>
<category>
<filter>julyfourth</filter>
<name>4th Of July</name>
</category>
<category>
<filter>accessories</filter>
<name>Accessories</name>
</category>
.
.
.

For each category I need to add its data to the tblCategories table. How would I go about doing this? Any help is appreciated, thanks!

Adrian Cornish · Accepted Answer · 2011-10-15 02:30:50Z

1

Did you even look for an answer http://dev.mysql.com/doc/refman/5.5/en/load-xml.html

answered Oct 15, 2011 at 2:30

Adrian Cornish

24k13 gold badges64 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Adrian Cornish Over a year ago

What other sort of XML is there?

Collectives™ on Stack Overflow

How to add data from XML file to MySQL Database?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related