我从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);
有人遇到过这个问题吗?
尝试使用此zip文件进行转储世界数据库
http://gyankosh.siplstudio.com/wp-content/uploads/2014/02/worlddump-1.sql_.zip
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句