title: Skip error lines while loading data to mysql table from delimited file
body: <p>I am loading data from text file to mysql table using following query:</p>
  
  <pre><code>LOAD DATA INFILE "myFile.csv"
  INTO TABLE some_table
  COLUMNS TERMINATED BY ','
  OPTIONALLY ENCLOSED BY '"'
  ESCAPED BY '\\'
  LINES TERMINATED BY '\n' (admin,consumer);
  </code></pre>
  
  <p>But when my file contains some error lines it is not able skip that line and the whole process stops at that place. I mean if my file format like :</p>
  
  <pre>
  ----------
  sankr : kumar
  ----------
  ramesh:rao
  ----------
  new users add here
  ----------
  sri : vennla
  ----------
  anu : bhavya
  ----------
  </pre>
  
  <p>I have to load by skipping the line "new users add here". How can do this?</p>