MySQL世界数据库sql文件插入数据时出现语法错误

Question

我从 http://downloads.mysql.com/docs/world.sql.gz 下载世界数据库但是，当我将 sql 文件中的所有内容粘贴到 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 'The Valley','AIA','?,595)' at line 1

不知道为什么这可能是一个语法错误

INSERT INTO `City` VALUES (60,'Namibe','AGO','Namibe',118200);
INSERT INTO `City` VALUES (61,'South Hill','AIA','?,961);
INSERT INTO `City` VALUES (62,'The Valley','AIA','?,595);
INSERT INTO `City` VALUES (63,'Saint John磗','ATG','St John',24000);
INSERT INTO `City` VALUES (64,'Dubai','ARE','Dubai',669181);

以前有人遇到过这个问题吗？

Answer 1

尝试使用此 zip 文件来转储世界数据库

http://gyankosh.siplstudio.com/wp-content/uploads/2014/02/worlddump-1.sql_.zip