title: CSV into MySQL using load data
body: <p>I'm hoping to insert the contents of a CSV into my table using MySQL loadfile, however, everytime I do so with the following command a number of rows are dropped</p>
  
  <pre><code>LOAD DATA INFILE 'new.csv' INTO TABLE Example
  FIELDS TERMINATED BY ','
  ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  IGNORE 1 LINES;
  </code></pre>
  
  <p>The CSV data I am hoping to insert is the Free Company Product Data supplied by Companies House (<a href="http://download.companieshouse.gov.uk/en_output.html" rel="nofollow noreferrer">http://download.companieshouse.gov.uk/en_output.html</a>)</p>
  
  <p>I'd greatly appreciate any help.
  Thanks!</p>