LOAD XML Statement target table’s columns equal to the values of those variables using  SET . You can perform both of these operations in a single statement, as shown here: The names of the user variables  must  match those of the corresponding fields from the XML file, with the addition of the required  @  prefix to indicate that they are variables. The user variables need not be listed or assigned in the same order as the corresponding fields. Using a  ROWS IDENTIFIED BY ’< tagname >’  clause, it is possible to import data from the same XML file into database tables with different definitions. For this example, suppose that you have a file named address.xml  which contains the following XML: You can again use the  test.person  table as defined previously in this section, after clearing all the existing records from the table and then showing its structure as shown here: 2656 mysql>  LOAD XML INFILE ’../bin/person-dump.xml’ -> INTO TABLE test.individual (@person_id, @fname, @lname, @created) -> SET individual_id=@person_id, name1=@fname, name2=@lname, made=@created; Query OK, 8 rows affected (0.05 sec) Records: 8 Deleted: 0 Skipped: 0 Warnings: 0 mysql>  SELECT * FROM individual; +---------------+--------+------------+---------------------+ | individual_id | name1 | name2 | made | +---------------+--------+------------+---------------------+ | 1 | Kapek | Sainnouine | 2007-07-13 16:18:47 | | 2 | Sajon | Rondela | 2007-07-13 16:18:47 | | 3 | Likema | Örrtmons | 2007-07-13 16:18:47 | | 4 | Slar | Manlanth | 2007-07-13 16:18:47 | | 5 | Stoma | Nilu | 2007-07-13 16:18:47 | | 6 | Nirtam | Sklöd | 2007-07-13 16:18:47 | | 7 | Sungam | Dulbåd | 2007-07-13 16:18:47 | | 8 | Srraf | Encmelt | 2007-07-13 16:18:47 | +---------------+--------+------------+---------------------+ 8 rows in set (0.00 sec) <?xml version="1.0"?> <list> <person person_id="1"> <fname>Robert</fname> <lname>Jones</lname> <address address_id="1" street="Mill Creek Road" zip="45365" city="Sidney"/> <address address_id="2" street="Main Street" zip="28681" city="Taylorsville"/> </person> <person person_id="2"> <fname>Mary</fname> <lname>Smith</lname> <address address_id="3" street="River Road" zip="80239" city="Denver"/> <!-- <address address_id="4" street="North Street" zip="37920" city="Knoxville"/> --> </person> </list> mysql<  TRUNCATE person; Query OK, 0 rows affected (0.04 sec) mysql<  SHOW CREATE TABLE person\G *************************** 1. row *************************** Table: person Create Table: CREATE TABLE ‘person‘ ( ‘person_id‘ int(11) NOT NULL, ‘fname‘ varchar(40) DEFAULT NULL, ‘lname‘ varchar(40) DEFAULT NULL, ‘created‘ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,