php - CSV LOAD DATA INFILE 中出现解析错误

Question

我正在尝试使用 PHP 脚本在数据库中上传 CSV 文件。我正在写的查询是

mysql_query("LOAD DATA LOCAL INFILE  'data.csv' INTO TABLE  `raw_data` FIELDS TERMINATED BY  ',' ENCLOSED BY  '"' ESCAPED BY  '\\' LINES TERMINATED BY '\n' ");

运行此脚本时遇到的错误是

Parse error: parse error in C:\wamp\www\price\godata.php on line 5

任何人都可以告诉我哪里做错了吗？

Answer 1

从外观上看，您在以双引号结尾的字符串内使用了双引号 "。您需要转义该字符，可以这样做:

mysql_query("LOAD DATA LOCAL INFILE  'data.csv' INTO TABLE  `raw_data` 
             FIELDS TERMINATED BY  ',' ENCLOSED BY  '\"' ESCAPED BY  '\\' 
             LINES TERMINATED BY '\n' ");         // ^ PHP Thought your command 
                                                  // ended at that point