title: How can I compare two tables with same structure and find unmatched records with mySQL?
body: <p>I have two tables with same structure.</p>
  
  <pre><code>TABLE-1
  --------
  ID  NAME
  1   AAAA
  2   BBBB
  3   CCCC
  4   DDDD
  
  TABLE-2
  --------
  ID  NAME
  1   AAAA
  2   BBBB
  3   CCCC
  4   DDDD
  5   eeee
  6   ffff
  7   gggg
  8   hhhh
  9   iiii
  </code></pre>
  
  <p>How I can compare this tables with MySQL and adding unmatched rows from TABLE-2 in TABLE-1?</p>