title: MySql error using OPTIONALLY ENCLOSED BY
body: <p>I am uploading huge csv file in a mysql database using LOAD DATA local INFILE command.</p>
  
  <p>The table has got single field(hids) only which is integer,primary and autoincrement.The query is </p>
  
  <pre><code>$insert_query = "LOAD DATA local INFILE '".$target_path."' INTO table master_huts(hids) OPTIONALLY ENCLOSED BY  '\"'   IGNORE 1 LINES  ";
  </code></pre>
  
  <p>The csv file contains,</p>
  
  <pre><code>ID
  "343"
  "454"
  "777"
  </code></pre>
  
  <p>If I remove the double quotes from csv file then it works fine. How can I tell MySql to ignore double quotes from csv file.</p>