title: Can't extract xml to sql
body: <p>New to xml->mysql extract, and I have an xml file trying to map out to a mysql table. xml file fields are different from my phpmyadmin table fields so I need to map them (<strong>can't change the fields or recreate tables</strong>) like below;
  test.xml;</p>
  
  <pre><code>&lt;persons&gt;
  &lt;person&gt;
  &lt;name&gt;Al&lt;/name&gt;
  &lt;hobby&gt;Golf&lt;/hobby&gt;
  &lt;description&gt;been doing this for years&lt;/description&gt;
  &lt;age&gt;45&lt;/age&gt;
  &lt;latitude&gt;42.7303&lt;/latitude&gt;
  &lt;longitude&gt;85.7741&lt;longitude&gt;
  &lt;/person&gt;
  &lt;/persons&gt;
  </code></pre>
  
  <p>tbTest fields are; id, player, experience, age, latitude, longitude, etc........
  When I run this</p>
  
  <pre><code>LOAD DATA INFILE "test.xml" INTO TABLE tbTest() 
  </code></pre>
  
  <p>Instead of one row, I get 16 rows with bits and pieces in each row and one of them has the full description, which is really all I need. But it should only be one row, right? </p>
  
  <p>Then when I run this instead</p>
  
  <pre><code>LOAD DATA INFILE "test.xml" INTO TABLE listing ROWS IDENTIFIED BY ,    '&lt;description&gt;';
  </code></pre>
  
  <p>I get the one row I want but no data whatsoever.</p>
  
  <p>I've also tried</p>
  
  <pre><code>LOAD XML INFILE 'test.xml' INTO TABLE 
  tbTest(description,Longitude,Longitude) 
  ROWS IDENTIFIED BY '&lt;persons&gt;';
  </code></pre>
  
  <p>Then I tried to add fields to tbTest(col1, col2, col3) VALUES (id='col3', player='col2'....) and no luck with that at all.</p>
  
  <p>Thanks in advance</p>