返回

提问 添加收藏

mysql workbench 导入数据出现错误

maomaolover 发布于 2018年04月16日 (共有6个回帖)

用workbench导入csv数据出现如下错误,用padnote重新编码了也还是不行,望有人指点。。

 

09:59:56 Restoring E:\study\Data analysis\DataAnalyst3.csv
Running: mysql.exe --defaults-file="c:\users\maomao\appdata\local\temp\tmptivwsi.cnf"  --protocol=tcp --host=localhost --user=maomaolover --port=3306 --default-character-set=utf8 --comments --database=newschema  < "E:\\study\\Data analysis\\DataAnalyst3.csv"
ERROR 1064 (42000) at line 1: 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 'city,companyFullName,companyId,companyLabelList,companyLabelList,companyLabelLis' at line 1

Operation failed with exitcode 1
09:59:56 Import of E:\study\Data analysis\DataAnalyst3.csv has finished with 1 errors

MySQL
文明上网,理性发言
客户端 Android iPhone WP7