title: Import CSV to MySQL
body: <p>I have created a database and a table. I have also created all the fields I will be needing. I have created 46 fields including one that is my ID for the row. The CSV doesn't contain the ID field, nor does it contain the headers for the columns. I am new to all of this but have been trying to figure this out. I'm not on here being lazy asking for the answer, but looking for directions.</p>
  
  <p>I'm trying to figure out how to import the CSV but have it start importing data starting at the 2nd field, since I'm hoping the auto_increment will fill in the ID field, which is the first field I created. </p>
  
  <p>I tried these instructions with no luck. Can anyone offer some insight? </p>
  
  <ol>
  <li>The column names of your CSV file must match those of your table</li>
  <li>Browse to your required .csv file</li>
  <li>Select CSV using LOAD DATA options</li>
  <li>Check box 'ON' for <em>Replace table data with file</em></li>
  <li>In <em>Fields terminated by</em> box, type <code>,</code></li>
  <li>In <em>Fields enclosed by</em> box, <code>"</code></li>
  <li>In <em>Fields escaped by</em> box, <code>\</code></li>
  <li>In <em>Lines terminated by</em> box, <code>auto</code></li>
  <li>In <em>Column names</em> box, type column name separated by <code>,</code> like <code>column1,column2,column3</code></li>
  <li>Check box ON for <em>Use LOCAL keyword</em>.</li>
  </ol>
  
  <p>Edit:</p>
  
  <p>The CSV file is 32.4kb </p>
  
  <p>The first row of my CSV is:</p>
  
  <pre><code>Test Advertiser,23906032166,119938,287898,,585639051,287898 - Engager - 300x250,88793551,Running,295046551,301624551,2/1/2010,8/2/2010,Active,,Guaranteed,Publisher test,Maintainer test,example-site.com,,All,All,,Interest: Dental; custom geo zones: City,300x250,-,CPM,$37.49 ,"4,415","3,246",3,0,$165.52 ,$121.69 ,"2,895",805,0,0,$30.18 ,$37.49 ,0,$0.00 ,IMPRESSIONBASED,NA,USD
  </code></pre>