title: Compare two MySQL tables and select distinct entries in second one
body: <p>I have two MySQL tables with one column in each. I want to select the entries in second table that does not exist in the first one. </p>
  
  <p>I tried the below query, but seems does not work </p>
  
  <pre><code>SELECT column_name FROM `table_name_1` 
  WHERE NOT EXISTS (SELECT column_name FROM `table_name_2`); 
  </code></pre>
  
  <p>For example:
  table_name_1 </p>
  
  <pre><code>column 
  111111111111
  222222222222
  333333333333
  444444444444
  </code></pre>
  
  <p>table_name_2 </p>
  
  <pre><code>column
  222222222222
  333333333333
  555555555555
  666666666666
  </code></pre>
  
  <p>Now, I want to get only 55555555555 and 66666666666 entries in table_name_2. </p>