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

以下是需要执行的代码，由于复制不完，只能复制了上半部分，，下半部分也全是经纬度和地区了。
uchome 谷歌地图插件在phpmyadmin中执行出错。

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

复制代码

下面是错误提示：


phpmyadmin错误提示代码：
错误
SQL 查询:CREATETABLE`uchome_city`(
`city`varchar(15)NOTNULL,
`lat`varchar(20)NOTNULL,
`lng`varchar(20)NOTNULL,
`grange`varchar(20)NOTNULL,
PRIMARYKEY(`city`))ENGINE=MYISAMDEFAULTCHARSET=gbk

MySQL 返回： #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 'DEFAULT CHARSET=gbk' at line

云天一 大哥，还有 玻璃女孩 大姐 ，来给小弟看一下吧！

云天一 大哥，还有 玻璃女孩 大姐 ，来给小弟看一下吧！

云天一 大哥，还有 玻璃女孩 大姐 ，来给小弟看一下吧！

可能原因是字符集不符造成的

建议把执行的sql语句里的

1. DEFAULT CHARSET=gbk

复制代码

去了再执行

去掉了 执行 后 也有错误 提示如下：

SQL 查询:

INSERT INTO `uchome_city`
VALUES (

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

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

去掉了 执行 后 也有错误 提示如下：

SQL 查询:

INSERT INTO `uchome_city`
VALUES (

'嵊州',  ...
zisetian 发表于 2009-11-11 09:15

说明这个值已经存在
如果你是新安装的话建议手动把 uchome_city表删了 再执行

'嵊州'  这个语句没执行啊

晕了 没找到~~~ uchome_city 这个

给个 删除uchome_city 的命令吧，，，我找了 找不到 谢谢 云大哥