# XML to MySQL

**URL:** https://forum.kirupa.com/t/xml-to-mysql/224105
**Category:** programming
**Created:** [April 28, 2007, 5:09pm UTC](https://forum.kirupa.com/t/xml-to-mysql/224105 "2007-04-28T17:09:01Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![hanabara](https://avatars.discourse-cdn.com/v4/letter/h/90ced4/32.png) [@hanabara](https://forum.kirupa.com/u/hanabara)
#### Post date: [April 28, 2007, 5:09pm UTC](https://forum.kirupa.com/t/xml-to-mysql/224105/1 "2007-04-28T17:09:01Z")

</div>

Dear All,

I’m a new forum member and I would like to ask some questions. I have an xml file and i want to insert it into mysql table. I wondering if you could help, This my xml format :

\<?xml version=“1.0” encoding=“UTF-8”?\>  
\<XML\>\<RECORDS\>  
\<RECORD\>  
\<REFERENCE\_TYPE\>31\</REFERENCE\_TYPE\>  
\<AUTHORS\>  
\<AUTHOR\>Author\</AUTHOR\>  
\</AUTHORS\>  
\<YEAR\>2007\</YEAR\>  
\<TITLE\>Title\</TITLE\>  
\<SECONDARY\_AUTHORS\>  
\<SECONDARY\_AUTHOR\>Editor\</SECONDARY\_AUTHOR\>  
\</SECONDARY\_AUTHORS\>  
\<SECONDARY\_TITLE\>Book Title\</SECONDARY\_TITLE\>  
\<PLACE\_PUBLISHED\>City\</PLACE\_PUBLISHED\>  
\<PUBLISHER\>Publisher\</PUBLISHER\>  
\<VOLUME\>V\</VOLUME\>  
\<PAGES\>Pages\</PAGES\>  
\<TERTIARY\_AUTHORS\>  
\<TERTIARY\_AUTHOR\>Series Editor\</TERTIARY\_AUTHOR\>  
\</TERTIARY\_AUTHORS\>  
\<TERTIARY\_TITLE\>Serie Title\</TERTIARY\_TITLE\>  
\<EDITION\>Edition\</EDITION\>  
\<ISBN\>ISBN\</ISBN\>  
\<ACCESSION\_NUMBER\>Accession Number\</ACCESSION\_NUMBER\>  
\<CALL\_NUMBER\>Call Number\</CALL\_NUMBER\>  
\<KEYWORDS\>  
\<KEYWORD\>Key\</KEYWORD\>  
\<KEYWORD\>Words\</KEYWORD\>  
\</KEYWORDS\>  
\<ABSTRACT\>Abstract\</ABSTRACT\>  
\<NOTES\>Notes\</NOTES\>  
\<URL\>URL\</URL\>  
\</RECORD\>  
\</RECORDS\>\</XML\>

Best Regards