在 csv 加载数据文件中获取解析错误 - Getting Parse error in CSV LOAD DATA INFILE

Getting Parse error in CSV LOAD DATA INFILE

我正在尝试使用 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

any1可以告诉我我做错了哪里吗？

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

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

将转义'字符放在"即将 ENCLOSED BY '"' 替换为 ENCLOSED BY '''"'