title: mysql load data local infile
body: <p>I'm trying to load data into a mysql table using LOAD DATA LOCAL INFILE using the code below.</p>
  
  <p>Mysql:</p>
  
  <pre><code>LOAD DATA INFILE '/var/www/vhosts/domain.com/httpdocs/test1.csv' INTO TABLE temp_table FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (recloc,client_acc)
  </code></pre>
  
  <p>Edit: changed LOAD DATA LOCAL INFILE to LOADA DATA INFILE, removed SET id=null, added IGNORE 1 LINES</p>
  
  <p>I'm getting no errors and no imported records.  I believe the issue is related to the column names but i'm having a hard time fully understanding what those names should be. Should they be the actual column names within the CSV? or the field names in the DB Table? I would also like the have an auto_incremented primary key (id).</p>
  
  <p>CSV:</p>
  
  <pre><code>recloc,client_acc
  "NLGSX3","CORPORATE"
  "7SC3BA","QUALITY ASSURANCE"
  "3B9OHF","90717-6710"
  </code></pre>
  
  <p>Any suggestions to what I may be doing wrong? thanks!</p>