title: How to store MySQL query results in another Table?
body: <p>How to store results from following query into another table. Considering there is an appropriate table already created. </p>
  
  <pre><code>SELECT labels.label,shortabstracts.ShortAbstract,images.LinkToImage,types.Type
  FROM ner.images,ner.labels,ner.shortabstracts,ner.types
  WHERE
    labels.Resource=images.Resource
    AND labels.Resource=shortabstracts.Resource
    AND labels.Resource=types.Resource;
  </code></pre>