title: Issue with Load XML
body: <p>I have an xml file which has data like:</p>
  
  <pre><code>&lt;root&gt;
  &lt;application&gt;
      &lt;field name="ApplicationName"&gt;Google App&lt;/field&gt;
      &lt;Group&gt;
      &lt;field name="GroupName"&gt;MidasGoogleAppsUsers&lt;/field&gt;
  
      &lt;field name="UserName"&gt;knikkhoo&lt;/field&gt;
      &lt;field name="UserName"&gt;devendrat&lt;/field&gt;
      &lt;/Group&gt;    
  
  &lt;/application&gt;
  
  &lt;/root&gt;
  </code></pre>
  
  <p>Then I tried LOAD XML function to insert data of this XML into the database:</p>
  
  <pre><code>LOAD XML LOCAL INFILE 'UserApplication.xml'
  INTO TABLE userapplication
   ROWS IDENTIFIED BY '&lt;application&gt;';
  </code></pre>
  
  <p>But after insertion I get only 1 single row with data as:</p>
  
  <pre><code>ID  ApplicationName GroupName   UserName
  1   Google App  MidasGoogleAppsUsers    devendrat
  </code></pre>
  
  <p>The output I desire is:</p>
  
  <pre><code>ID  ApplicationName GroupName   UserName
  1   Google App  MidasGoogleAppsUsers    devendrat
  2   Google App  MidasGoogleAppsUsers    knikkhoo
  </code></pre>
  
  <p>Please help...</p>