# Load xml data local infile 'person.xml' into table person

**URL:** <https://www.ruby-forum.com/t/load-xml-data-local-infile-person-xml-into-table-person/175459>\
**Category:** Rails\
**Created:** [September 14, 2009, 10:02am UTC](https://www.ruby-forum.com/t/load-xml-data-local-infile-person-xml-into-table-person/175459 "2009-09-14T10:02:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![zubair](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/848f3c/32.png) [@zubair](https://www.ruby-forum.com/u/zubair)\
**Post date:** [September 14, 2009, 10:02am UTC](https://www.ruby-forum.com/t/load-xml-data-local-infile-person-xml-into-table-person/175459/1 "2009-09-14T10:02:18Z")

</div>

Hi This is zubair working in cleartrip on mysql. when trying to load  
xml file into mysql table …  
load xml data local infile ‘person.xml’ into table person

ERROR:

ERROR 1064 (42000): You have an error in your SQL syntax; check the  
manual that corresponds to your MySQL server version for the right  
syntax to use near ‘xml local infile ‘person.xml’ into table person’  
at line 1

can anybody give solution using mysql 5.0

---

<div class="post-metadata">

**Author:** ![zubair](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/z/848f3c/32.png) [@zubair](https://www.ruby-forum.com/u/zubair)\
**Post date:** [September 14, 2009, 10:05am UTC](https://www.ruby-forum.com/t/load-xml-data-local-infile-person-xml-into-table-person/175459/2 "2009-09-14T10:05:49Z")

</div>

On Sep 14, 5:30 am, zubair [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> can anybody give solution using mysql 5.0

Load xml doesn’t exist in mysql 5.0 ([http://dev.mysql.com/doc/refman/](http://dev.mysql.com/doc/refman/)  
5.4/en/load-xml.html says it was added in 5.4.4). Most obvious  
solution would be to write some code to parse the xml and insert the  
records for you.

Fred