title: MySQL: LOAD DATA INFILE csv ignore primary field insertion
body: <p>I am trying to import a csv file into a table in mysql. The table has these fields:</p>
  
  <p>(<code>id</code>, <code>Submission ID</code>, <code>User ID</code>, <code>Submission Date and Time</code>,  <code>First Name</code>, <code>Last Name</code>, <code>Email</code>, <code>Participant's HQ / Agency</code>)</p>
  
  <p>But the csv file has every fields except <code>id</code>. <code>id</code> field is <code>Primary</code> and <code>Auto incremental</code>. I tried to use a variable in order to 'bypass' importing the first field so my code is this:</p>
  
  <pre><code>LOAD DATA INFILE 'C:\\Users\\user1\\Desktop\\imports\\tf\\output_csv.csv' INTO TABLE form_tf (@id, `Submission ID`, `User ID`, `Submission Date and Time`,  `First Name`, `Last Name`, `Email`, `Participant's HQ / Agency`)
  FIELDS TERMINATED BY ','
  IGNORE 1 ROWS;
  </code></pre>
  
  <p>But it is not inserting <code>Submission ID</code> so all fields are shifted to the left by 1.</p>