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');
    
50. INSERT INTO `uchome_city` VALUES ('东山', '', '', '');
    
51. INSERT INTO `uchome_city` VALUES ('都江堰', '', '', '');
    
52. INSERT INTO `uchome_city` VALUES ('俄罗斯', '61.524010', '105.318756', '6725337.500000');
    
53. INSERT INTO `uchome_city` VALUES ('峨眉山', '', '', '');
    
54. INSERT INTO `uchome_city` VALUES ('法国', '46.227638', '2.213749', '1061438.750000');
    
55. INSERT INTO `uchome_city` VALUES ('非洲', '', '', '');
    
56. INSERT INTO `uchome_city` VALUES ('奉化', '29.590681', '121.414633', '27447.125000');
    
57. INSERT INTO `uchome_city` VALUES ('涪陵', '29.685946', '107.287105', '32758.714844');
    
58. INSERT INTO `uchome_city` VALUES ('高雄', '', '', '');
    
59. INSERT INTO `uchome_city` VALUES ('个旧', '23.352962', '103.159203', '3086.122314');
    
60. INSERT INTO `uchome_city` VALUES ('广安', '30.455925', '106.633204', '10374.719727');
    
61. INSERT INTO `uchome_city` VALUES ('广元', '32.435432', '105.843358', '7358.422852');
    
62. INSERT INTO `uchome_city` VALUES ('哈密', '42.899146', '93.550204', '150850.968750');
    
63. INSERT INTO `uchome_city` VALUES ('海盐', '30.486162', '120.888459', '15654.437500');
    
64. INSERT INTO `uchome_city` VALUES ('韩国', '', '', '');
    
65. INSERT INTO `uchome_city` VALUES ('汉沽', '39.230292', '117.894416', '12599.111328');
    
66. INSERT INTO `uchome_city` VALUES ('杭州', '30.273977', '120.172974', '43578.664062');
    
67. INSERT INTO `uchome_city` VALUES ('和平', '', '', '');
    
68. INSERT INTO `uchome_city` VALUES ('和田', '37.229645', '79.764079', '122111.960938');
    
69. INSERT INTO `uchome_city` VALUES ('河北', '38.045128', '114.489777', '931192.312500');
    
70. INSERT INTO `uchome_city` VALUES ('河东', '39.121071', '117.256898', '613995.875000');
    
71. INSERT INTO `uchome_city` VALUES ('河西', '36.401849', '36.349810', '114224.578125');
    
72. INSERT INTO `uchome_city` VALUES ('荷兰', '52.132633', '5.291266', '283198.343750');
    
73. INSERT INTO `uchome_city` VALUES ('红挢', '', '', '');
    
74. INSERT INTO `uchome_city` VALUES ('湖州', '30.784502', '120.179004', '23890.658203');
    
75. INSERT INTO `uchome_city` VALUES ('花莲', '23.991073', '121.611195', '9045.188477');
    
76. INSERT INTO `uchome_city` VALUES ('黄岩', '', '', '');
    
77. INSERT INTO `uchome_city` VALUES ('基隆', '', '', '');
    
78. INSERT INTO `uchome_city` VALUES ('蓟县', '40.002660', '117.473706', '13233.404297');
    
79. INSERT INTO `uchome_city` VALUES ('加拿大', '56.130366', '-106.346771', '7305284.500000');
    
80. INSERT INTO `uchome_city` VALUES ('嘉兴', '30.753924', '120.758543', '19013.935547');
    
81. INSERT INTO `uchome_city` VALUES ('嘉义', '', '', '');
    
82. INSERT INTO `uchome_city` VALUES ('江山', '', '', '');
    
83. INSERT INTO `uchome_city` VALUES ('金华', '29.031360', '119.632380', '29223.599609');
    
84. INSERT INTO `uchome_city` VALUES ('金门', '', '', '');
    
85. INSERT INTO `uchome_city` VALUES ('津南', '', '', '');
    
86. INSERT INTO `uchome_city` VALUES ('景洪', '22.012682', '100.793556', '7797.113281');
    
87. INSERT INTO `uchome_city` VALUES ('静海', '38.826603', '116.977390', '11830.193359');
    
88. INSERT INTO `uchome_city` VALUES ('九寨沟', '33.261334', '104.235502', '2200.423340');
    
89. INSERT INTO `uchome_city` VALUES ('喀什', '39.465702', '75.999373', '57655.632812');
    
90. INSERT INTO `uchome_city` VALUES ('开远', '23.714286', '103.267858', '22864.613281');
    
91. INSERT INTO `uchome_city` VALUES ('康定', '30.052732', '101.957626', '1000.000000');
    
92. INSERT INTO `uchome_city` VALUES ('克拉玛依', '45.580421', '84.890403', '17509.330078');
    
93. INSERT INTO `uchome_city` VALUES ('库车', '', '', '');
    
94. INSERT INTO `uchome_city` VALUES ('库尔勒', '41.759884', '86.134705', '1000.000000');
    
95. INSERT INTO `uchome_city` VALUES ('奎屯', '44.433887', '84.918534', '17042.238281');
    
96. INSERT INTO `uchome_city` VALUES ('昆明', '25.012526', '102.700013', '154465.875000');
    
97. INSERT INTO `uchome_city` VALUES ('拉萨', '29.656843', '91.125101', '21388.656250');
    
98. INSERT INTO `uchome_city` VALUES ('乐山', '29.470370', '103.701217', '69789.070312');
    
99. INSERT INTO `uchome_city` VALUES ('丽江', '26.876096', '100.229945', '12207.924805');
    
100. INSERT INTO `uchome_city` VALUES ('丽水', '28.451836', '119.916426', '7807.973145');
     
101. INSERT INTO `uchome_city` VALUES ('林芝', '29.635210', '94.408318', '72775.757812');
     
102. INSERT INTO `uchome_city` VALUES ('临安', '30.273977', '120.172974', '43578.664062');
     
103. INSERT INTO `uchome_city` VALUES ('临沧', '23.880344', '100.092756', '7416.863770');
     
104. INSERT INTO `uchome_city` VALUES ('临海', '28.848892', '121.118446', '2481.425537');
     
105. INSERT INTO `uchome_city` VALUES ('六库', '', '', '');
     
106. INSERT INTO `uchome_city` VALUES ('泸州', '28.763596', '105.408626', '28745.238281');
     
107. INSERT INTO `uchome_city` VALUES ('潞西', '24.442421', '98.589989', '1000.000000');
     
108. INSERT INTO `uchome_city` VALUES ('马尔康', '31.908346', '102.232460', '1000.000000');
     
109. INSERT INTO `uchome_city` VALUES ('马祖', '', '', '');
     
110. INSERT INTO `uchome_city` VALUES ('眉山', '30.101484', '103.844297', '17431.992188');
     
111. INSERT INTO `uchome_city` VALUES ('美国', '37.090240', '-95.712891', '12000000.000000');
     
112. INSERT INTO `uchome_city` VALUES ('绵阳', '31.461477', '104.743084', '21328.037109');
     
113. INSERT INTO `uchome_city` VALUES ('苗栗', '24.489269', '120.941737', '57560.355469');
     
114. INSERT INTO `uchome_city` VALUES ('内江', '29.634054', '105.127423', '24685.429688');
     
115. INSERT INTO `uchome_city` VALUES ('那曲', '31.452426', '92.059293', '91973.164062');
     
116. INSERT INTO `uchome_city` VALUES ('南充', '30.791258', '106.082997', '18184.498047');
     
117. INSERT INTO `uchome_city` VALUES ('南开', '39.107128', '117.153268', '2089.664062');
     
118. INSERT INTO `uchome_city` VALUES ('南美', '', '', '');
     
119. INSERT INTO `uchome_city` VALUES ('南投', '23.838760', '120.987632', '79152.609375');
     
120. INSERT INTO `uchome_city` VALUES ('宁波', '29.868336', '121.543990', '28136.667969');
     
121. INSERT INTO `uchome_city` VALUES ('宁河', '', '', '');
     
122. INSERT INTO `uchome_city` VALUES ('欧洲', '', '', '');
     
123. INSERT INTO `uchome_city` VALUES ('瓯海', '', '', '');
     
124. INSERT INTO `uchome_city` VALUES ('攀枝花', '26.583778', '101.718914', '29616.455078');
     
125. INSERT INTO `uchome_city` VALUES ('澎湖', '23.565479', '119.615143', '69847.804688');
     
126. INSERT INTO `uchome_city` VALUES ('平湖', '30.717240', '121.108464', '27721.142578');
     
127. INSERT INTO `uchome_city` VALUES ('屏东', '22.655844', '120.470326', '11785.491211');
     
128. INSERT INTO `uchome_city` VALUES ('千岛湖', '', '', '');
     
129. INSERT INTO `uchome_city` VALUES ('曲靖', '25.496016', '103.801478', '13765.323242');
     
130. INSERT INTO `uchome_city` VALUES ('衢州', '28.977144', '118.925543', '24131.015625');
     
131. INSERT INTO `uchome_city` VALUES ('日本', '36.204824', '138.252924', '2629578.250000');
     
132. INSERT INTO `uchome_city` VALUES ('日喀则', '29.271716', '88.888385', '46204.023438');
     
133. INSERT INTO `uchome_city` VALUES ('瑞安', '27.827976', '120.475795', '67140.906250');
     
134. INSERT INTO `uchome_city` VALUES ('瑞士', '46.818188', '8.227512', '276649.562500');
     
135. INSERT INTO `uchome_city` VALUES ('山南', '29.240668', '91.804955', '100592.062500');
     
136. INSERT INTO `uchome_city` VALUES ('绍兴', '29.995762', '120.586109', '10732.008789');
     
137. INSERT INTO `uchome_city` VALUES ('嵊州', '29.579084', '120.786374', '28370.732422');
     
138. INSERT INTO `uchome_city` VALUES ('石河子', '44.305056', '86.052636', '13971.884766');
     
139. INSERT INTO `uchome_city` VALUES ('思茅', '22.795481', '100.975212', '391868.968750');
     
140. INSERT INTO `uchome_city` VALUES ('遂宁', '30.427593', '105.536932', '29077.025391');
     
141. INSERT INTO `uchome_city` VALUES ('塔城', '46.752263', '83.014787', '27005.357422');
     
142. INSERT INTO `uchome_city` VALUES ('台北', '25.091075', '121.559834', '24172.746094');
     
143. INSERT INTO `uchome_city` VALUES ('台东', '22.754601', '121.113754', '15974.809570');
     
144. INSERT INTO `uchome_city` VALUES ('台南', '', '', '');
     
145. INSERT INTO `uchome_city` VALUES ('台中', '24.150187', '120.642999', '24040.681641');
     
146. INSERT INTO `uchome_city` VALUES ('台州', '28.627021', '121.213617', '61943.945312');
     
147. INSERT INTO `uchome_city` VALUES ('泰国', '15.870032', '100.992541', '1643062.375000');
     
148. INSERT INTO `uchome_city` VALUES ('塘沽', '38.991612', '117.653672', '9525.818359');
     
149. INSERT INTO `uchome_city` VALUES ('桃园', '', '', '');
     
150. INSERT INTO `uchome_city` VALUES ('天津', '39.103856', '117.252381', '37022.117188');
     
151. INSERT INTO `uchome_city` VALUES ('吐鲁番', '43.006962', '89.210690', '37482.648438');
     
152. INSERT INTO `uchome_city` VALUES ('温岭', '28.384925', '121.418999', '27281.929688');
     
153. INSERT INTO `uchome_city` VALUES ('温州', '27.987040', '120.654859', '24610.591797');
     
154. INSERT INTO `uchome_city` VALUES ('文山', '23.380294', '104.254632', '49441.257812');
     
155. INSERT INTO `uchome_city` VALUES ('汶川', '31.476768', '103.590249', '7155.814453');
     
156. INSERT INTO `uchome_city` VALUES ('乌鲁木齐', '43.810314', '87.605163', '4561058.500000');
     
157. INSERT INTO `uchome_city` VALUES ('武清', '39.422354', '117.067255', '6587.355469');
     
158. INSERT INTO `uchome_city` VALUES ('西班牙', '40.463667', '-3.749220', '2548438.750000');
     
159. INSERT INTO `uchome_city` VALUES ('西昌', '27.897245', '102.265266', '1000.000000');
     
160. INSERT INTO `uchome_city` VALUES ('西青', '39.000234', '117.121789', '9181.713867');
     
161. INSERT INTO `uchome_city` VALUES ('西双版纳', '22.010889', '100.799260', '52011.125000');
     
162. INSERT INTO `uchome_city` VALUES ('新加坡', '1.289407', '103.849962', '28286.369141');
     
163. INSERT INTO `uchome_city` VALUES ('新西兰', '-40.900557', '174.885971', '1591907.875000');
     
164. INSERT INTO `uchome_city` VALUES ('新竹', '', '', '');
     
165. INSERT INTO `uchome_city` VALUES ('雅安', '29.980513', '103.013166', '11848.736328');
     
166. INSERT INTO `uchome_city` VALUES ('亚洲', '', '', '');
     
167. INSERT INTO `uchome_city` VALUES ('伊宁', '43.910881', '81.318657', '1773.050537');
     
168. INSERT INTO `uchome_city` VALUES ('宜宾', '28.770528', '104.621279', '13712.583008');
     
169. INSERT INTO `uchome_city` VALUES ('宜兰', '', '', '');
     
170. INSERT INTO `uchome_city` VALUES ('意大利', '41.871940', '12.567380', '1161729.250000');
     
171. INSERT INTO `uchome_city` VALUES ('印度', '20.593684', '78.962880', '3376958.250000');
     
172. INSERT INTO `uchome_city` VALUES ('英国', '55.378051', '-3.435973', '1030196.062500');
     

复制代码

代码由于不能复制完。只截取了上半部分，下半部分都是地区和经纬度了！

以上是需要执行的代码！！2楼是错误提示！