LOAD XML Syntax (MySQL)

[crayon-6a61940bca9b7428558633/]
The LOAD XML statement reads data from an XML file into a table. The file_name must be given as a literal string. The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >).

To illustrate how this statement is used, suppose that we have a table created as follows:
[crayon-6a61940bca9bc655257554/]
Suppose further that this table is initially empty.

Now suppose that we have a simple XML file person.xml, whose contents are as shown here:
[crayon-6a61940bca9be494167854/]
Each of the permissible XML formats discussed previously is represented in this example file.

To import the data in person.xml into the person table, you can use this statement:
[crayon-6a61940bca9c0851364953/]

mysql> LOAD XML LOCAL INFILE 'person.xml'
-> INTO TABLE person
-> ROWS IDENTIFIED BY '';

Query OK, 6 rows affected (0.00 sec)
Records: 6 Deleted: 0 Skipped: 0 Warnings: 0

Here, we assume that person.xml is located in the MySQL data directory. If the file cannot be found, the following error results:

ERROR 2 (HY000): File '/person.xml' not found (Errcode: 2)

More information

https://dev.mysql.com/doc/refman/5.5/en/load-xml.html