title: Under what conditions does MySQL skip rows?
body: <p>I'm reading a data.csv file into MySQL via the LOAD SQL command. My SQL code goes like this:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'C:/DATA FILES/foo.csv' INTO TABLE foo FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
  </code></pre>
  
  <p>This works fine, but out of the 366,000 odd lines, it skips 138 of them. There are no duplicate entries or anything, it just skips them out of the blue. When I try to manually input the row into the table, it works fine. But I can't identify all 138 of the lines, so I'm wondering how exactly to pinpoint the possible reasons mySQL would skip these lines of data.</p>
  
  <p>Any ideas?</p>