title: Copy content of one table to another, where column content is different
body: <p>I need to copy the content of a source table (val &amp; name columns) to a target table (Using MySQL).</p>
  
  <p>However, I only wish to copy the content if the val fields in the source table are different to the val fields in the target table.</p>
  
  <p>I have the following so far:</p>
  
  <p><strong>QUERY</strong></p>
  
  <pre><code>INSERT INTO target_tbl (val, name) SELECT val, name source_tbl WHERE [CODE_HERE];
  </code></pre>