title: load data infile syntax in mysql
body: <p>I am using LOAD DATA local INFILE command to upload big csv file in mysql db. The field is an integer in the mysql table and so it will accept only integer.</p>
  
  <p>Now if the csv file contains numbers like below then the sql doesn't work.The format of my csv file is </p>
  
  <pre><code>ID
  "322"
  "445"
  "211"
  </code></pre>
  
  <p>So it is inserting 0 in the table. But if the csv file contains no double quotes then it's fine.</p>
  
  <p>How can I tell "load data infile" command to ignore double quotes( as sometimes it is too difficult to remove double quotes from csv file which has got about 1 million records).My Sql is</p>
  
  <pre><code>$insert_query = "LOAD DATA local INFILE '".$target_path."'
                  INTO table master_huts
                  IGNORE 1 LINES
                  (hids)
                  ";
  </code></pre>