title: conditionally ignore rows load data mysql
body: <p>I am loading a large data set (60 gigs) into a database. There are some records that can be skipped because they contain values that are missing.  How do I tell MySQL to skip rows that contain certain (missing in this case) values?  For example, my file looks like this</p>
  
  <pre><code>Value1, Value2
  1,2
  3,4
  ,5
  9,10
  </code></pre>
  
  <p>The third row can be skipped and not loaded. I know that I can load everything and then just delete it but processing a 60 gig file takes a long time so I want to save on the computing power.</p>
  
  <p>Thanks</p>