exporting data from .xml file to mysql

[nitish0401]

Hi,

I am using a tool that gives output in xml format and i want to save that output data in Mysql,
Can anyone explain me the procedure to export data from .xml to mysql.

Thanks in advance
Nitish

[masijade]

Parse it using an xml parser (there are some built into the java language) and use jdbc to insert it into the db. See the tutorials on both of those items, and then combine them.

[nitish0401]

Hi,thank you so much for your help.
Actually im not very good in java and need to do things at the earliest so if you can provide me code for that,i will be highly obliged.
Thank you
Nitish

[masijade]

I'll bet you would be, since you then would not have had to do anything. Hint, tutorials have code in them.

[AlphaSupport]

Not related to Java, but this might be useful: 12.2.7. LOAD XML Syntax

[jacobblack]

Dear all
i am having a mysql database which is fed with a php form. i want to add an additional featute to the form: enter the data in mysql database using an xml file.

The XML file may contain 1-10,000 enteries and each entry should form a unique entry in the mysql database. Please help me how can i
1) enter the xml data directly into the mysql db
2) Enter data from XML file using a php form.



Any of the methods to enter the data are welcome.

I am attaching a sample XML file which contains a number of enteries. Each entry starts with <PubmedArticle> tag and ends with </PubmedArticle> tag.

Thanks in advance.