title: Load Data Infile on MySQL Syntax Error
body: <p>I have a "load data" command that executes just fine, but I need to modify it to remove most of the fields from a CSV.  I believe I've put it together correctly, but form some reason MySQL says that the syntax is not correct.</p>
  
  <pre><code>LOAD DATA INFILE '/path/file' INTO TABLE cdr_records (@dummy,
  @dummy,
  @dummy,
  @dummy,
  dateTimeOrigination, 
  @dummy,
  @dummy,
  @dummy,
  callingPartyNumber, 
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  originalCalledPartyNumber, 
  finalCalledPartyNumber, 
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  pkid,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  duration, 
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy,
  @dummy) FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 2 LINES;
  </code></pre>
  
  <p>I get;</p>
  
  <pre><code>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 2 LIN' at line 104
  </code></pre>