title: How to LOAD DATA INFILE in mysql with first col being Auto Increment?
body: <p>Currently, We have a table similar to this:</p>
  
  <pre><code>---------------------
  ID | AField | BField|
  ---------------------
  </code></pre>
  
  <p>The ID is Auto Increment</p>
  
  <p>How do I create a CSV that can let the database auto populate the ID field with auto increment number?</p>
  
  <p>We've tried the following CSV but it doesn't work:</p>
  
  <pre><code>afieldvalue, bfieldvalue (With Column definition but still doesn't work)
  0,afieldvalue,bfieldvalue 
  NULL,afieldvalue,bfieldvalue
  </code></pre>