title: How to import part of xml to mysql table?
body: <p>I'd like to import some of the items in an large xml file to mysql table. Lets say the xml contains thousands of  items like:</p>
  
  <pre><code>&lt;CD&gt;
  &lt;TITLE&gt;Empire Burlesque&lt;/TITLE&gt;
  &lt;ARTIST&gt;Bob Dylan&lt;/ARTIST&gt;
  &lt;COUNTRY&gt;USA&lt;/COUNTRY&gt;
  &lt;COMPANY&gt;Columbia&lt;/COMPANY&gt;
  &lt;PRICE&gt;10.90&lt;/PRICE&gt;
  &lt;YEAR&gt;1985&lt;/YEAR&gt;
  &lt;/CD&gt;
  </code></pre>
  
  <p>But I need only 'TITLE' and 'YEAR' of each CD to be imported to mysql's cd table. </p>
  
  <p>I know that there is a 'LOAD XML'  mysql 5.+ to get data from xml to mysql, but apparently it maps the whole xml, which is not what I need. So I appreciate your help.</p>