csv - 向mysql中插入数据时出错

Question

我正在尝试使用 BigDump 将数据从 csv 文件插入到 mysql。

它在第 2 行停止，并出现错误:

"Query: INSERT INTO location VALUES (1,"O1","","","",0.0000,0.0000,, );

MySQL: 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 ' )' at line 1"

如果我从 phpmyadmin 运行语句，它会说:

"#1064 - 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 ' )' at line 1"

我该怎么做才能让数据进入数据库？

谢谢。

Answer 1

没有值的逗号在我看来很粗略。

INSERT INTO location VALUES (1,"O1","","","",0.0000,0.0000,, );

应该是

INSERT INTO location VALUES (1,"O1","","","",0.0000,0.0000,NULL,

空)；