title: Import CSV file into MySQL table, only the first row imported
body: <p>I try to import a csv file into MySQL database.
  <strong>CSV file</strong> : have some email addresses separated with comma(file name is "email.csv")
  <strong>MySQL database</strong> : (database name is "test") have two column (id, email) <em>id</em> is INT, primary key and auto incremented, <em>email</em> is VARCHAR
  <strong>OS</strong> : Microsoft windows XP
  when I try to use the following command :</p>
  
  <pre><code>LOAD DATA LOCAL INFILE "C:\email.csv" INTO TABLE test.email FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' (id,email);
  </code></pre>
  
  <p>but only 1 row inserted (The result is shown below):</p>
  
  <pre><code>Query OK, 1 row affected, 1 warning (0.06 sec)
  Records: 1  Deleted: 0  Skipped: 0  Warnings: 1
  </code></pre>
  
  <p>What should I do to </p>