title: mySQL Command Line Import CSV Gives me NULL
body: <p>I am used to using PHPmyadmin to manage my mySQL databases but I am starting to use the command line a lot more.  I am trying to import a CSV file into a table called source_data that looks like this...</p>
  
  <pre><code>+-----------+-------------+------+-----+---------+----------------+
  | Field     | Type        | Null | Key | Default | Extra          |
  +-----------+-------------+------+-----+---------+----------------+
  | id        | int(11)     | NO   | PRI | NULL    | auto_increment |
  | code      | varchar(10) | YES  |     | NULL    |                |
  | result    | char(1)     | YES  |     | NULL    |                |
  | source    | char(1)     | YES  |     | NULL    |                |
  | timestamp | varchar(30) | YES  |     | NULL    |                |
  +-----------+-------------+------+-----+---------+----------------+
  </code></pre>
  
  <p>And my CSV file looks like this...</p>
  
  <pre><code>code,result,source,timestamp
  123 ABC,,,
  456 DEF,,,
  789 GHI,,,
  234 JKL,,,
  567 MNO,,,
  890 PQR,,,
  </code></pre>
  
  <p>I am using this command..</p>
  
  <pre><code>LOAD DATA INFILE '/home/user1/data.csv' INTO TABLE source_data FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 ROWS;
  </code></pre>
  
  <p>This inserts the correct number of rows but each one just says NULL, where am I going wrong?</p>