mySQL Command Line Import CSV Gives me NULL
<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>