gpt4 book ai didi

php - SQL Buddy,mySQL LOAD DATA LOCAL INFILE 错误

转载 作者:行者123 更新时间:2023-11-29 13:53:49 32 4
gpt4 key购买 nike

我正在尝试将 CSV 文件导入 mysql 数据库。但查询给出错误。查询是:

LOAD DATA LOCAL INFILE ‘/last.csv’ INTO TABLE punjab FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\r\n’ (newpoll, blockcode, halqa, pollnumber, pollstation, sex, area);

错误是

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘/last.csv’ INTO TABLE punjab FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘�' at line 1

有什么想法吗?谢谢

最佳答案

你可以使用http://www.whereismyballot.com ;) 顺便说一句,您不应该引用字段名称

关于php - SQL Buddy,mySQL LOAD DATA LOCAL INFILE 错误,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/16219889/

32 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com