使用OPTIONALLY ENCLOSED BY的MySql错误

I am uploading huge csv file in a mysql database using LOAD DATA local INFILE command.

The table has got single field(hids) only which is integer,primary and autoincrement.The query is

$insert_query = "LOAD DATA local INFILE '".$target_path."' INTO table master_huts(hids) OPTIONALLY ENCLOSED BY  '\"'   IGNORE 1 LINES  ";

The csv file contains,

ID
"343"
"454"
"777"

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.

Try this:

$insert_query = "LOAD DATA local INFILE '".$target_path."' INTO table master_huts(hids) FIELDS ENCLOSED BY '”' LINES TERMINATED BY ' ' IGNORE 1 LINES;