云天一 大哥，玻璃女孩 姐姐~来给小弟看一下吧!

你还是先执行drop和create语句 进行重建表

然后再执行insert语句

第二个sql报错是执你插入了一个重复的键值

没懂 能给下详细的步骤+需要执行的语言吗？

你给的语句前半段就是建表的
后半段就是写入值的

能帮助我一下吗？？？我把 phpmyadmin的给您。

直接在pma中执行试试

1. DROP TABLE IF EXISTS `uchome_city`;
   
2. 
   
3. CREATE TABLE `uchome_city` (
   
4. 
   
5.   `city` varchar(15) NOT NULL,
   
6. 
   
7.   `lat` varchar(20) NOT NULL,
   
8. 
   
9.   `lng` varchar(20) NOT NULL,
   
10. 
    
11.   `grange` varchar(20) NOT NULL,
    
12. 
    
13.   PRIMARY KEY  (`city`)
    
14. 
    
15. ) ENGINE=MyISAM;
    
16. INSERT INTO `uchome_city` VALUES ('阿克苏', '41.123922', '80.244527', '84628.710938');
    
17. 
    
18. INSERT INTO `uchome_city` VALUES ('阿勒泰', '47.810049', '88.069013', '48500.683594');
    
19. 
    
20. INSERT INTO `uchome_city` VALUES ('阿里', '32.551697', '80.102745', '174029.625000');
    
21. 
    
22. INSERT INTO `uchome_city` VALUES ('阿图什', '39.717335', '76.169235', '1465.301392');
    
23. 
    
24. INSERT INTO `uchome_city` VALUES ('安吉', '30.623252', '119.569434', '27195.955078');
    
25. 
    
26. INSERT INTO `uchome_city` VALUES ('奥地利', '47.516231', '14.550072', '556243.125000');
    
27. 
    
28. INSERT INTO `uchome_city` VALUES ('澳洲', '-25.274398', '133.775136', '4519526.500000');
    
29. 
    
30. INSERT INTO `uchome_city` VALUES ('宝坻', '39.596173', '117.424257', '24358.705078');
    
31. 
    
32. INSERT INTO `uchome_city` VALUES ('保山', '25.116213', '99.162598', '7054.911621');
    
33. 
    
34. INSERT INTO `uchome_city` VALUES ('北辰', '39.256731', '117.176657', '9168.316406');
    
35. 
    
36. INSERT INTO `uchome_city` VALUES ('北美', '', '', '');
    
37. 
    
38. INSERT INTO `uchome_city` VALUES ('博乐', '44.903530', '82.074425', '1000.000000');
    
39. 
    
40. INSERT INTO `uchome_city` VALUES ('昌都', '31.181562', '97.150265', '81039.875000');
    
41. 
    
42. INSERT INTO `uchome_city` VALUES ('昌吉', '44.004430', '87.988225', '53466.902344');
    
43. 
    
44. INSERT INTO `uchome_city` VALUES ('楚雄', '25.054929', '101.544721', '50013.976562');
    
45. 
    
46. INSERT INTO `uchome_city` VALUES ('慈溪', '30.182640', '121.341999', '20437.722656');
    
47. 
    
48. INSERT INTO `uchome_city` VALUES ('大港', '38.762366', '117.368231', '19921.648438');
    
49. 
    
50. INSERT INTO `uchome_city` VALUES ('大理', '25.584234', '100.222124', '30861.056641');
    
51. 
    
52. INSERT INTO `uchome_city` VALUES ('大洋洲', '', '', '');
    
53. 
    
54. INSERT INTO `uchome_city` VALUES ('德国', '51.165691', '10.451526', '727195.937500');
    
55. 
    
56. INSERT INTO `uchome_city` VALUES ('德阳', '31.127538', '104.397808', '17255.566406');
    
57. 
    
58. INSERT INTO `uchome_city` VALUES ('定海', '26.273550', '119.798183', '1000.000000');
    
59. 
    
60. INSERT INTO `uchome_city` VALUES ('东川', '26.092665', '103.181221', '1147.673096');
    
61. 
    
62. INSERT INTO `uchome_city` VALUES ('东丽', '39.120480', '117.401673', '34238.382812');

复制代码

玻璃姐姐，，，我试了。而且是从新装的数据库~
还是那个错误提示

SQL 查询:

INSERT INTO `uchome_city`
VALUES (

'嵊州', '29.579084', '120.786374', '28370.732422'
)
MySQL 返回：

#1062 - Duplicate entry '嵊州' for key 1

这个错误提示

拜托了，来看下吧!

你的mysql是4.0.*版本的

这个版本很多汉字是无法区别的
所以在写入值时被认为重复写入同一个值