title: Merge 2 tables in MySQL with some duplicate data
body: <p>I need to merge 2 tables with the same structure, <code>table1</code> and <code>table2</code>. They have mostly different rows, but some rows are duplicates.</p>
  
  <p>Is there a way to merge <code>table2</code> into <code>table1</code> but leave out the duplicate records in 1 statement?</p>
  
  <p>I'm quite new to MySQL to any help would be greatly appreciated.</p>
  
  <p>EDIT: The query I have so far is just this:</p>
  
  <pre><code>INSERT INTO table1
  SELECT *
  FROM table2
  </code></pre>
  
  <p>So I don't know how to selectively leave out the duplicates.</p>