title: Delete rows from table when the result are not in a csv file
body: <p>I have this code to insert values from a csv file. Some values are updated when the row already exist at the database. Just how I want it to be.     </p>
  
  <pre><code>INSERT INTO test_table (`id`,`order_id`,`quantity`,`price`,`order_date`,`shipping_date`)
                      VALUES ('$orderId', '$quantity', '$price', '$orderDate', '$shippingDate')
                      ON DUPLICATE KEY UPDATE `order_date` = '$orderDate', `shipping_date` = '$shippingDate'"
  </code></pre>
  
  <p>But when the row is not at the csv it must be deleted from the database.
  For example:</p>
  
  <p>csv file:</p>
  
  <pre><code>order_id  quantity price order_date shipping_date
  1          10      1.00  2016-10-5  2016-10-6
  </code></pre>
  
  <p>I run the script and the result from the csv is added to the database. But my next csv contains this:</p>
  
  <pre><code>order_id  quantity price order_date shipping_date
  2         120      2.00  2016-10-8  2016-10-10
  </code></pre>
  
  <p>A new row must be added. No problem, my query is fine. But the row with order_id 1 is gone at the csv. That row must be deleted from the database. How can I do this? Is this possible to do with my query? Or do I need another one?</p>