title: shell script to load xml file into mysql database
body: <p>I have an xml file as:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="no"?&gt;
  &lt;table name="abc"&gt;
  &lt;row&gt;
  &lt;field name="year"&gt;2015&lt;/field&gt;
  &lt;field name="copyright"&gt;Various&lt;/field&gt;
  &lt;field name="review"&gt;Various&lt;/field&gt;
  &lt;/row&gt;
  &lt;field name="year"&gt;2015&lt;/field&gt;
  &lt;field name="copyright"&gt;Various&lt;/field&gt;
  &lt;field name="review"&gt;Various&lt;/field&gt;
  &lt;row&gt;
  &lt;field name="year"&gt;2015&lt;/field&gt;
  &lt;field name="copyright"/&gt;
  &lt;field name="review"/&gt;
  &lt;/row&gt;
  &lt;/table&gt;
  </code></pre>
  
  <p>The command for loading this xml file into mysql database is :</p>
  
  <pre><code>LOAD XML LOCAL INFILE '/home/first.xml' INTO TABLE abc;
  </code></pre>
  
  <p>But this command is showing fields in database having proper closing tags.
  In the third row copyright and review are having closing tags as <code>/&gt;</code> So its showing entire row values as NULL even if <code>year</code> is having value as <code>2015</code>. How this issue can be resolved any ideas??</p>