全国省市区sql

时间:2021-08-11 11:39:06
  1. 转载内容,日后备用

  2. DROP TABLE IF EXISTS `provinces`;  
  3. CREATE TABLE `provinces` (  
  4.   `id` int(11) NOT NULL auto_increment,  
  5.   `provinceid` varchar(20) NOT NULL,  
  6.   `province` varchar(50) NOT NULL,  
  7.   PRIMARY KEY  (`id`)  
  8. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='省份信息表' AUTO_INCREMENT=35 ;  
  9.   
  10. insert into provinces(id,provinceid,province) values(1,'110000','北京市');  
  11. insert into provinces(id,provinceid,province) values(2,'120000','天津市');  
  12. insert into provinces(id,provinceid,province) values(3,'130000','河北省');  
  13. insert into provinces(id,provinceid,province) values(4,'140000','山西省');  
  14. insert into provinces(id,provinceid,province) values(5,'150000','内蒙古自治区');  
  15. insert into provinces(id,provinceid,province) values(6,'210000','辽宁省');  
  16. insert into provinces(id,provinceid,province) values(7,'220000','吉林省');  
  17. insert into provinces(id,provinceid,province) values(8,'230000','黑龙江省');  
  18. insert into provinces(id,provinceid,province) values(9,'310000','上海市');  
  19. insert into provinces(id,provinceid,province) values(10,'320000','江苏省');  
  20. insert into provinces(id,provinceid,province) values(11,'330000','浙江省');  
  21. insert into provinces(id,provinceid,province) values(12,'340000','安徽省');  
  22. insert into provinces(id,provinceid,province) values(13,'350000','福建省');  
  23. insert into provinces(id,provinceid,province) values(14,'360000','江西省');  
  24. insert into provinces(id,provinceid,province) values(15,'370000','山东省');  
  25. insert into provinces(id,provinceid,province) values(16,'410000','河南省');  
  26. insert into provinces(id,provinceid,province) values(17,'420000','湖北省');  
  27. insert into provinces(id,provinceid,province) values(18,'430000','湖南省');  
  28. insert into provinces(id,provinceid,province) values(19,'440000','广东省');  
  29. insert into provinces(id,provinceid,province) values(20,'450000','广西壮族自治区');  
  30. insert into provinces(id,provinceid,province) values(21,'460000','海南省');  
  31. insert into provinces(id,provinceid,province) values(22,'500000','重庆市');  
  32. insert into provinces(id,provinceid,province) values(23,'510000','四川省');  
  33. insert into provinces(id,provinceid,province) values(24,'520000','贵州省');  
  34. insert into provinces(id,provinceid,province) values(25,'530000','云南省');  
  35. insert into provinces(id,provinceid,province) values(26,'540000','*自治区');  
  36. insert into provinces(id,provinceid,province) values(27,'610000','陕西省');  
  37. insert into provinces(id,provinceid,province) values(28,'620000','甘肃省');  
  38. insert into provinces(id,provinceid,province) values(29,'630000','青海省');  
  39. insert into provinces(id,provinceid,province) values(30,'640000','宁夏回族自治区');  
  40. insert into provinces(id,provinceid,province) values(31,'650000','**自治区');  
  41. insert into provinces(id,provinceid,province) values(32,'710000','*省');  
  42. insert into provinces(id,provinceid,province) values(33,'810000','香港特别行政区');  
  43. insert into provinces(id,provinceid,province) values(34,'820000','澳门特别行政区'); 


  1. DROP TABLE IF EXISTS `cities`;  
  2. CREATE TABLE `cities` (  
  3.   `id` int(11) NOT NULL auto_increment,  
  4.   `cityid` varchar(20) NOT NULL,  
  5.   `city` varchar(50) NOT NULL,  
  6.   `provinceid` varchar(20) NOT NULL,  
  7.   PRIMARY KEY  (`id`)  
  8. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='行政区域地州市信息表' AUTO_INCREMENT=346 ;  
  9.   
  10. insert into cities(id,cityid,city,provinceid) values(1,'110100','市辖区','110000');  
  11. insert into cities(id,cityid,city,provinceid) values(2,'110200','县','110000');  
  12. insert into cities(id,cityid,city,provinceid) values(3,'120100','市辖区','120000');  
  13. insert into cities(id,cityid,city,provinceid) values(4,'120200','县','120000');  
  14. insert into cities(id,cityid,city,provinceid) values(5,'130100','石家庄市','130000');  
  15. insert into cities(id,cityid,city,provinceid) values(6,'130200','唐山市','130000');  
  16. insert into cities(id,cityid,city,provinceid) values(7,'130300','秦皇岛市','130000');  
  17. insert into cities(id,cityid,city,provinceid) values(8,'130400','邯郸市','130000');  
  18. insert into cities(id,cityid,city,provinceid) values(9,'130500','邢台市','130000');  
  19. insert into cities(id,cityid,city,provinceid) values(10,'130600','保定市','130000');  
  20. insert into cities(id,cityid,city,provinceid) values(11,'130700','张家口市','130000');  
  21. insert into cities(id,cityid,city,provinceid) values(12,'130800','承德市','130000');  
  22. insert into cities(id,cityid,city,provinceid) values(13,'130900','沧州市','130000');  
  23. insert into cities(id,cityid,city,provinceid) values(14,'131000','廊坊市','130000');  
  24. insert into cities(id,cityid,city,provinceid) values(15,'131100','衡水市','130000');  
  25. insert into cities(id,cityid,city,provinceid) values(16,'140100','太原市','140000');  
  26. insert into cities(id,cityid,city,provinceid) values(17,'140200','大同市','140000');  
  27. insert into cities(id,cityid,city,provinceid) values(18,'140300','阳泉市','140000');  
  28. insert into cities(id,cityid,city,provinceid) values(19,'140400','长治市','140000');  
  29. insert into cities(id,cityid,city,provinceid) values(20,'140500','晋城市','140000');  
  30. insert into cities(id,cityid,city,provinceid) values(21,'140600','朔州市','140000');  
  31. insert into cities(id,cityid,city,provinceid) values(22,'140700','晋中市','140000');  
  32. insert into cities(id,cityid,city,provinceid) values(23,'140800','运城市','140000');  
  33. insert into cities(id,cityid,city,provinceid) values(24,'140900','忻州市','140000');  
  34. insert into cities(id,cityid,city,provinceid) values(25,'141000','临汾市','140000');  
  35. insert into cities(id,cityid,city,provinceid) values(26,'141100','吕梁市','140000');  
  36. insert into cities(id,cityid,city,provinceid) values(27,'150100','呼和浩特市','150000');  
  37. insert into cities(id,cityid,city,provinceid) values(28,'150200','包头市','150000');  
  38. insert into cities(id,cityid,city,provinceid) values(29,'150300','乌海市','150000');  
  39. insert into cities(id,cityid,city,provinceid) values(30,'150400','赤峰市','150000');  
  40. insert into cities(id,cityid,city,provinceid) values(31,'150500','通辽市','150000');  
  41. insert into cities(id,cityid,city,provinceid) values(32,'150600','鄂尔多斯市','150000');  
  42. insert into cities(id,cityid,city,provinceid) values(33,'150700','呼伦贝尔市','150000');  
  43. insert into cities(id,cityid,city,provinceid) values(34,'150800','巴彦淖尔市','150000');  
  44. insert into cities(id,cityid,city,provinceid) values(35,'150900','乌兰察布市','150000');  
  45. insert into cities(id,cityid,city,provinceid) values(36,'152200','兴安盟','150000');  
  46. insert into cities(id,cityid,city,provinceid) values(37,'152500','锡林郭勒盟','150000');  
  47. insert into cities(id,cityid,city,provinceid) values(38,'152900','阿拉善盟','150000');  
  48. insert into cities(id,cityid,city,provinceid) values(39,'210100','沈阳市','210000');  
  49. insert into cities(id,cityid,city,provinceid) values(40,'210200','大连市','210000');  
  50. insert into cities(id,cityid,city,provinceid) values(41,'210300','鞍山市','210000');  
  51. insert into cities(id,cityid,city,provinceid) values(42,'210400','抚顺市','210000');  
  52. insert into cities(id,cityid,city,provinceid) values(43,'210500','本溪市','210000');  
  53. insert into cities(id,cityid,city,provinceid) values(44,'210600','丹东市','210000');  
  54. insert into cities(id,cityid,city,provinceid) values(45,'210700','锦州市','210000');  
  55. insert into cities(id,cityid,city,provinceid) values(46,'210800','营口市','210000');  
  56. insert into cities(id,cityid,city,provinceid) values(47,'210900','阜新市','210000');  
  57. insert into cities(id,cityid,city,provinceid) values(48,'211000','辽阳市','210000');  
  58. insert into cities(id,cityid,city,provinceid) values(49,'211100','盘锦市','210000');  
  59. insert into cities(id,cityid,city,provinceid) values(50,'211200','铁岭市','210000');  
  60. insert into cities(id,cityid,city,provinceid) values(51,'211300','朝阳市','210000');  
  61. insert into cities(id,cityid,city,provinceid) values(52,'211400','葫芦岛市','210000');  
  62. insert into cities(id,cityid,city,provinceid) values(53,'220100','长春市','220000');  
  63. insert into cities(id,cityid,city,provinceid) values(54,'220200','吉林市','220000');  
  64. insert into cities(id,cityid,city,provinceid) values(55,'220300','四平市','220000');  
  65. insert into cities(id,cityid,city,provinceid) values(56,'220400','辽源市','220000');  
  66. insert into cities(id,cityid,city,provinceid) values(57,'220500','通化市','220000');  
  67. insert into cities(id,cityid,city,provinceid) values(58,'220600','白山市','220000');  
  68. insert into cities(id,cityid,city,provinceid) values(59,'220700','*市','220000');  
  69. insert into cities(id,cityid,city,provinceid) values(60,'220800','白城市','220000');  
  70. insert into cities(id,cityid,city,provinceid) values(61,'222400','延边朝鲜族自治州','220000');  
  71. insert into cities(id,cityid,city,provinceid) values(62,'230100','哈尔滨市','230000');  
  72. insert into cities(id,cityid,city,provinceid) values(63,'230200','齐齐哈尔市','230000');  
  73. insert into cities(id,cityid,city,provinceid) values(64,'230300','鸡西市','230000');  
  74. insert into cities(id,cityid,city,provinceid) values(65,'230400','鹤岗市','230000');  
  75. insert into cities(id,cityid,city,provinceid) values(66,'230500','双鸭山市','230000');  
  76. insert into cities(id,cityid,city,provinceid) values(67,'230600','大庆市','230000');  
  77. insert into cities(id,cityid,city,provinceid) values(68,'230700','伊春市','230000');  
  78. insert into cities(id,cityid,city,provinceid) values(69,'230800','佳木斯市','230000');  
  79. insert into cities(id,cityid,city,provinceid) values(70,'230900','七台河市','230000');  
  80. insert into cities(id,cityid,city,provinceid) values(71,'231000','牡丹江市','230000');  
  81. insert into cities(id,cityid,city,provinceid) values(72,'231100','黑河市','230000');  
  82. insert into cities(id,cityid,city,provinceid) values(73,'231200','绥化市','230000');  
  83. insert into cities(id,cityid,city,provinceid) values(74,'232700','大兴安岭地区','230000');  
  84. insert into cities(id,cityid,city,provinceid) values(75,'310100','市辖区','310000');  
  85. insert into cities(id,cityid,city,provinceid) values(76,'310200','县','310000');  
  86. insert into cities(id,cityid,city,provinceid) values(77,'320100','南京市','320000');  
  87. insert into cities(id,cityid,city,provinceid) values(78,'320200','无锡市','320000');  
  88. insert into cities(id,cityid,city,provinceid) values(79,'320300','徐州市','320000');  
  89. insert into cities(id,cityid,city,provinceid) values(80,'320400','常州市','320000');  
  90. insert into cities(id,cityid,city,provinceid) values(81,'320500','苏州市','320000');  
  91. insert into cities(id,cityid,city,provinceid) values(82,'320600','南通市','320000');  
  92. insert into cities(id,cityid,city,provinceid) values(83,'320700','连云港市','320000');  
  93. insert into cities(id,cityid,city,provinceid) values(84,'320800','淮安市','320000');  
  94. insert into cities(id,cityid,city,provinceid) values(85,'320900','盐城市','320000');  
  95. insert into cities(id,cityid,city,provinceid) values(86,'321000','扬州市','320000');  
  96. insert into cities(id,cityid,city,provinceid) values(87,'321100','镇江市','320000');  
  97. insert into cities(id,cityid,city,provinceid) values(88,'321200','泰州市','320000');  
  98. insert into cities(id,cityid,city,provinceid) values(89,'321300','宿迁市','320000');  
  99. insert into cities(id,cityid,city,provinceid) values(90,'330100','杭州市','330000');  
  100. insert into cities(id,cityid,city,provinceid) values(91,'330200','宁波市','330000');  
  101. insert into cities(id,cityid,city,provinceid) values(92,'330300','温州市','330000');  
  102. insert into cities(id,cityid,city,provinceid) values(93,'330400','嘉兴市','330000');  
  103. insert into cities(id,cityid,city,provinceid) values(94,'330500','湖州市','330000');  
  104. insert into cities(id,cityid,city,provinceid) values(95,'330600','绍兴市','330000');  
  105. insert into cities(id,cityid,city,provinceid) values(96,'330700','金华市','330000');  
  106. insert into cities(id,cityid,city,provinceid) values(97,'330800','衢州市','330000');  
  107. insert into cities(id,cityid,city,provinceid) values(98,'330900','舟山市','330000');  
  108. insert into cities(id,cityid,city,provinceid) values(99,'331000','台州市','330000');  
  109. insert into cities(id,cityid,city,provinceid) values(100,'331100','丽水市','330000');  
  110. insert into cities(id,cityid,city,provinceid) values(101,'340100','合肥市','340000');  
  111. insert into cities(id,cityid,city,provinceid) values(102,'340200','芜湖市','340000');  
  112. insert into cities(id,cityid,city,provinceid) values(103,'340300','蚌埠市','340000');  
  113. insert into cities(id,cityid,city,provinceid) values(104,'340400','淮南市','340000');  
  114. insert into cities(id,cityid,city,provinceid) values(105,'340500','马鞍山市','340000');  
  115. insert into cities(id,cityid,city,provinceid) values(106,'340600','淮北市','340000');  
  116. insert into cities(id,cityid,city,provinceid) values(107,'340700','铜陵市','340000');  
  117. insert into cities(id,cityid,city,provinceid) values(108,'340800','安庆市','340000');  
  118. insert into cities(id,cityid,city,provinceid) values(109,'341000','黄山市','340000');  
  119. insert into cities(id,cityid,city,provinceid) values(110,'341100','滁州市','340000');  
  120. insert into cities(id,cityid,city,provinceid) values(111,'341200','阜阳市','340000');  
  121. insert into cities(id,cityid,city,provinceid) values(112,'341300','宿州市','340000');  
  122. insert into cities(id,cityid,city,provinceid) values(113,'341400','巢湖市','340000');  
  123. insert into cities(id,cityid,city,provinceid) values(114,'341500','六安市','340000');  
  124. insert into cities(id,cityid,city,provinceid) values(115,'341600','亳州市','340000');  
  125. insert into cities(id,cityid,city,provinceid) values(116,'341700','池州市','340000');  
  126. insert into cities(id,cityid,city,provinceid) values(117,'341800','宣城市','340000');  
  127. insert into cities(id,cityid,city,provinceid) values(118,'350100','福州市','350000');  
  128. insert into cities(id,cityid,city,provinceid) values(119,'350200','厦门市','350000');  
  129. insert into cities(id,cityid,city,provinceid) values(120,'350300','莆田市','350000');  
  130. insert into cities(id,cityid,city,provinceid) values(121,'350400','三明市','350000');  
  131. insert into cities(id,cityid,city,provinceid) values(122,'350500','泉州市','350000');  
  132. insert into cities(id,cityid,city,provinceid) values(123,'350600','漳州市','350000');  
  133. insert into cities(id,cityid,city,provinceid) values(124,'350700','南平市','350000');  
  134. insert into cities(id,cityid,city,provinceid) values(125,'350800','龙岩市','350000');  
  135. insert into cities(id,cityid,city,provinceid) values(126,'350900','宁德市','350000');  
  136. insert into cities(id,cityid,city,provinceid) values(127,'360100','南昌市','360000');  
  137. insert into cities(id,cityid,city,provinceid) values(128,'360200','景德镇市','360000');  
  138. insert into cities(id,cityid,city,provinceid) values(129,'360300','萍乡市','360000');  
  139. insert into cities(id,cityid,city,provinceid) values(130,'360400','九江市','360000');  
  140. insert into cities(id,cityid,city,provinceid) values(131,'360500','新余市','360000');  
  141. insert into cities(id,cityid,city,provinceid) values(132,'360600','鹰潭市','360000');  
  142. insert into cities(id,cityid,city,provinceid) values(133,'360700','赣州市','360000');  
  143. insert into cities(id,cityid,city,provinceid) values(134,'360800','吉安市','360000');  
  144. insert into cities(id,cityid,city,provinceid) values(135,'360900','宜春市','360000');  
  145. insert into cities(id,cityid,city,provinceid) values(136,'361000','抚州市','360000');  
  146. insert into cities(id,cityid,city,provinceid) values(137,'361100','上饶市','360000');  
  147. insert into cities(id,cityid,city,provinceid) values(138,'370100','济南市','370000');  
  148. insert into cities(id,cityid,city,provinceid) values(139,'370200','青岛市','370000');  
  149. insert into cities(id,cityid,city,provinceid) values(140,'370300','淄博市','370000');  
  150. insert into cities(id,cityid,city,provinceid) values(141,'370400','枣庄市','370000');  
  151. insert into cities(id,cityid,city,provinceid) values(142,'370500','东营市','370000');  
  152. insert into cities(id,cityid,city,provinceid) values(143,'370600','烟台市','370000');  
  153. insert into cities(id,cityid,city,provinceid) values(144,'370700','潍坊市','370000');  
  154. insert into cities(id,cityid,city,provinceid) values(145,'370800','济宁市','370000');  
  155. insert into cities(id,cityid,city,provinceid) values(146,'370900','泰安市','370000');  
  156. insert into cities(id,cityid,city,provinceid) values(147,'371000','威海市','370000');  
  157. insert into cities(id,cityid,city,provinceid) values(148,'371100','日照市','370000');  
  158. insert into cities(id,cityid,city,provinceid) values(149,'371200','莱芜市','370000');  
  159. insert into cities(id,cityid,city,provinceid) values(150,'371300','临沂市','370000');  
  160. insert into cities(id,cityid,city,provinceid) values(151,'371400','德州市','370000');  
  161. insert into cities(id,cityid,city,provinceid) values(152,'371500','聊城市','370000');  
  162. insert into cities(id,cityid,city,provinceid) values(153,'371600','滨州市','370000');  
  163. insert into cities(id,cityid,city,provinceid) values(154,'371700','荷泽市','370000');  
  164. insert into cities(id,cityid,city,provinceid) values(155,'410100','郑州市','410000');  
  165. insert into cities(id,cityid,city,provinceid) values(156,'410200','开封市','410000');  
  166. insert into cities(id,cityid,city,provinceid) values(157,'410300','洛阳市','410000');  
  167. insert into cities(id,cityid,city,provinceid) values(158,'410400','平顶山市','410000');  
  168. insert into cities(id,cityid,city,provinceid) values(159,'410500','安阳市','410000');  
  169. insert into cities(id,cityid,city,provinceid) values(160,'410600','鹤壁市','410000');  
  170. insert into cities(id,cityid,city,provinceid) values(161,'410700','新乡市','410000');  
  171. insert into cities(id,cityid,city,provinceid) values(162,'410800','焦作市','410000');  
  172. insert into cities(id,cityid,city,provinceid) values(163,'410900','濮阳市','410000');  
  173. insert into cities(id,cityid,city,provinceid) values(164,'411000','许昌市','410000');  
  174. insert into cities(id,cityid,city,provinceid) values(165,'411100','漯河市','410000');  
  175. insert into cities(id,cityid,city,provinceid) values(166,'411200','三门峡市','410000');  
  176. insert into cities(id,cityid,city,provinceid) values(167,'411300','南阳市','410000');  
  177. insert into cities(id,cityid,city,provinceid) values(168,'411400','商丘市','410000');  
  178. insert into cities(id,cityid,city,provinceid) values(169,'411500','信阳市','410000');  
  179. insert into cities(id,cityid,city,provinceid) values(170,'411600','周口市','410000');  
  180. insert into cities(id,cityid,city,provinceid) values(171,'411700','驻马店市','410000');  
  181. insert into cities(id,cityid,city,provinceid) values(172,'420100','武汉市','420000');  
  182. insert into cities(id,cityid,city,provinceid) values(173,'420200','黄石市','420000');  
  183. insert into cities(id,cityid,city,provinceid) values(174,'420300','十堰市','420000');  
  184. insert into cities(id,cityid,city,provinceid) values(175,'420500','宜昌市','420000');  
  185. insert into cities(id,cityid,city,provinceid) values(176,'420600','襄樊市','420000');  
  186. insert into cities(id,cityid,city,provinceid) values(177,'420700','鄂州市','420000');  
  187. insert into cities(id,cityid,city,provinceid) values(178,'420800','荆门市','420000');  
  188. insert into cities(id,cityid,city,provinceid) values(179,'420900','孝感市','420000');  
  189. insert into cities(id,cityid,city,provinceid) values(180,'421000','荆州市','420000');  
  190. insert into cities(id,cityid,city,provinceid) values(181,'421100','黄冈市','420000');  
  191. insert into cities(id,cityid,city,provinceid) values(182,'421200','咸宁市','420000');  
  192. insert into cities(id,cityid,city,provinceid) values(183,'421300','随州市','420000');  
  193. insert into cities(id,cityid,city,provinceid) values(184,'422800','恩施土家族苗族自治州','420000');  
  194. insert into cities(id,cityid,city,provinceid) values(185,'429000','省直辖行政单位','420000');  
  195. insert into cities(id,cityid,city,provinceid) values(186,'430100','长沙市','430000');  
  196. insert into cities(id,cityid,city,provinceid) values(187,'430200','株洲市','430000');  
  197. insert into cities(id,cityid,city,provinceid) values(188,'430300','湘潭市','430000');  
  198. insert into cities(id,cityid,city,provinceid) values(189,'430400','衡阳市','430000');  
  199. insert into cities(id,cityid,city,provinceid) values(190,'430500','邵阳市','430000');  
  200. insert into cities(id,cityid,city,provinceid) values(191,'430600','岳阳市','430000');  
  201. insert into cities(id,cityid,city,provinceid) values(192,'430700','常德市','430000');  
  202. insert into cities(id,cityid,city,provinceid) values(193,'430800','张家界市','430000');  
  203. insert into cities(id,cityid,city,provinceid) values(194,'430900','益阳市','430000');  
  204. insert into cities(id,cityid,city,provinceid) values(195,'431000','郴州市','430000');  
  205. insert into cities(id,cityid,city,provinceid) values(196,'431100','永州市','430000');  
  206. insert into cities(id,cityid,city,provinceid) values(197,'431200','怀化市','430000');  
  207. insert into cities(id,cityid,city,provinceid) values(198,'431300','娄底市','430000');  
  208. insert into cities(id,cityid,city,provinceid) values(199,'433100','湘西土家族苗族自治州','430000');  
  209. insert into cities(id,cityid,city,provinceid) values(200,'440100','广州市','440000');  
  210. insert into cities(id,cityid,city,provinceid) values(201,'440200','韶关市','440000');  
  211. insert into cities(id,cityid,city,provinceid) values(202,'440300','深圳市','440000');  
  212. insert into cities(id,cityid,city,provinceid) values(203,'440400','珠海市','440000');  
  213. insert into cities(id,cityid,city,provinceid) values(204,'440500','汕头市','440000');  
  214. insert into cities(id,cityid,city,provinceid) values(205,'440600','佛山市','440000');  
  215. insert into cities(id,cityid,city,provinceid) values(206,'440700','江门市','440000');  
  216. insert into cities(id,cityid,city,provinceid) values(207,'440800','湛江市','440000');  
  217. insert into cities(id,cityid,city,provinceid) values(208,'440900','茂名市','440000');  
  218. insert into cities(id,cityid,city,provinceid) values(209,'441200','肇庆市','440000');  
  219. insert into cities(id,cityid,city,provinceid) values(210,'441300','惠州市','440000');  
  220. insert into cities(id,cityid,city,provinceid) values(211,'441400','梅州市','440000');  
  221. insert into cities(id,cityid,city,provinceid) values(212,'441500','汕尾市','440000');  
  222. insert into cities(id,cityid,city,provinceid) values(213,'441600','河源市','440000');  
  223. insert into cities(id,cityid,city,provinceid) values(214,'441700','阳江市','440000');  
  224. insert into cities(id,cityid,city,provinceid) values(215,'441800','清远市','440000');  
  225. insert into cities(id,cityid,city,provinceid) values(216,'441900','东莞市','440000');  
  226. insert into cities(id,cityid,city,provinceid) values(217,'442000','中山市','440000');  
  227. insert into cities(id,cityid,city,provinceid) values(218,'445100','潮州市','440000');  
  228. insert into cities(id,cityid,city,provinceid) values(219,'445200','揭阳市','440000');  
  229. insert into cities(id,cityid,city,provinceid) values(220,'445300','云浮市','440000');  
  230. insert into cities(id,cityid,city,provinceid) values(221,'450100','南宁市','450000');  
  231. insert into cities(id,cityid,city,provinceid) values(222,'450200','柳州市','450000');  
  232. insert into cities(id,cityid,city,provinceid) values(223,'450300','桂林市','450000');  
  233. insert into cities(id,cityid,city,provinceid) values(224,'450400','梧州市','450000');  
  234. insert into cities(id,cityid,city,provinceid) values(225,'450500','北海市','450000');  
  235. insert into cities(id,cityid,city,provinceid) values(226,'450600','防城港市','450000');  
  236. insert into cities(id,cityid,city,provinceid) values(227,'450700','钦州市','450000');  
  237. insert into cities(id,cityid,city,provinceid) values(228,'450800','贵港市','450000');  
  238. insert into cities(id,cityid,city,provinceid) values(229,'450900','玉林市','450000');  
  239. insert into cities(id,cityid,city,provinceid) values(230,'451000','百色市','450000');  
  240. insert into cities(id,cityid,city,provinceid) values(231,'451100','贺州市','450000');  
  241. insert into cities(id,cityid,city,provinceid) values(232,'451200','河池市','450000');  
  242. insert into cities(id,cityid,city,provinceid) values(233,'451300','来宾市','450000');  
  243. insert into cities(id,cityid,city,provinceid) values(234,'451400','崇左市','450000');  
  244. insert into cities(id,cityid,city,provinceid) values(235,'460100','海口市','460000');  
  245. insert into cities(id,cityid,city,provinceid) values(236,'460200','三亚市','460000');  
  246. insert into cities(id,cityid,city,provinceid) values(237,'469000','省直辖县级行政单位','460000');  
  247. insert into cities(id,cityid,city,provinceid) values(238,'500100','市辖区','500000');  
  248. insert into cities(id,cityid,city,provinceid) values(239,'500200','县','500000');  
  249. insert into cities(id,cityid,city,provinceid) values(240,'500300','市','500000');  
  250. insert into cities(id,cityid,city,provinceid) values(241,'510100','成都市','510000');  
  251. insert into cities(id,cityid,city,provinceid) values(242,'510300','自贡市','510000');  
  252. insert into cities(id,cityid,city,provinceid) values(243,'510400','攀枝花市','510000');  
  253. insert into cities(id,cityid,city,provinceid) values(244,'510500','泸州市','510000');  
  254. insert into cities(id,cityid,city,provinceid) values(245,'510600','德阳市','510000');  
  255. insert into cities(id,cityid,city,provinceid) values(246,'510700','绵阳市','510000');  
  256. insert into cities(id,cityid,city,provinceid) values(247,'510800','广元市','510000');  
  257. insert into cities(id,cityid,city,provinceid) values(248,'510900','遂宁市','510000');  
  258. insert into cities(id,cityid,city,provinceid) values(249,'511000','内江市','510000');  
  259. insert into cities(id,cityid,city,provinceid) values(250,'511100','乐山市','510000');  
  260. insert into cities(id,cityid,city,provinceid) values(251,'511300','南充市','510000');  
  261. insert into cities(id,cityid,city,provinceid) values(252,'511400','眉山市','510000');  
  262. insert into cities(id,cityid,city,provinceid) values(253,'511500','宜宾市','510000');  
  263. insert into cities(id,cityid,city,provinceid) values(254,'511600','广安市','510000');  
  264. insert into cities(id,cityid,city,provinceid) values(255,'511700','达州市','510000');  
  265. insert into cities(id,cityid,city,provinceid) values(256,'511800','雅安市','510000');  
  266. insert into cities(id,cityid,city,provinceid) values(257,'511900','巴中市','510000');  
  267. insert into cities(id,cityid,city,provinceid) values(258,'512000','资阳市','510000');  
  268. insert into cities(id,cityid,city,provinceid) values(259,'513200','阿坝藏族羌族自治州','510000');  
  269. insert into cities(id,cityid,city,provinceid) values(260,'513300','甘孜藏族自治州','510000');  
  270. insert into cities(id,cityid,city,provinceid) values(261,'513400','凉山彝族自治州','510000');  
  271. insert into cities(id,cityid,city,provinceid) values(262,'520100','贵阳市','520000');  
  272. insert into cities(id,cityid,city,provinceid) values(263,'520200','六盘水市','520000');  
  273. insert into cities(id,cityid,city,provinceid) values(264,'520300','遵义市','520000');  
  274. insert into cities(id,cityid,city,provinceid) values(265,'520400','安顺市','520000');  
  275. insert into cities(id,cityid,city,provinceid) values(266,'522200','铜仁地区','520000');  
  276. insert into cities(id,cityid,city,provinceid) values(267,'522300','黔西南布依族苗族自治州','520000');  
  277. insert into cities(id,cityid,city,provinceid) values(268,'522400','毕节地区','520000');  
  278. insert into cities(id,cityid,city,provinceid) values(269,'522600','黔东南苗族侗族自治州','520000');  
  279. insert into cities(id,cityid,city,provinceid) values(270,'522700','黔南布依族苗族自治州','520000');  
  280. insert into cities(id,cityid,city,provinceid) values(271,'530100','昆明市','530000');  
  281. insert into cities(id,cityid,city,provinceid) values(272,'530300','曲靖市','530000');  
  282. insert into cities(id,cityid,city,provinceid) values(273,'530400','玉溪市','530000');  
  283. insert into cities(id,cityid,city,provinceid) values(274,'530500','保山市','530000');  
  284. insert into cities(id,cityid,city,provinceid) values(275,'530600','昭通市','530000');  
  285. insert into cities(id,cityid,city,provinceid) values(276,'530700','丽江市','530000');  
  286. insert into cities(id,cityid,city,provinceid) values(277,'530800','思茅市','530000');  
  287. insert into cities(id,cityid,city,provinceid) values(278,'530900','临沧市','530000');  
  288. insert into cities(id,cityid,city,provinceid) values(279,'532300','楚雄彝族自治州','530000');  
  289. insert into cities(id,cityid,city,provinceid) values(280,'532500','红河哈尼族彝族自治州','530000');  
  290. insert into cities(id,cityid,city,provinceid) values(281,'532600','文山壮族苗族自治州','530000');  
  291. insert into cities(id,cityid,city,provinceid) values(282,'532800','西双版纳傣族自治州','530000');  
  292. insert into cities(id,cityid,city,provinceid) values(283,'532900','大理白族自治州','530000');  
  293. insert into cities(id,cityid,city,provinceid) values(284,'533100','德宏傣族景颇族自治州','530000');  
  294. insert into cities(id,cityid,city,provinceid) values(285,'533300','怒江傈僳族自治州','530000');  
  295. insert into cities(id,cityid,city,provinceid) values(286,'533400','迪庆藏族自治州','530000');  
  296. insert into cities(id,cityid,city,provinceid) values(287,'540100','拉萨市','540000');  
  297. insert into cities(id,cityid,city,provinceid) values(288,'542100','昌都地区','540000');  
  298. insert into cities(id,cityid,city,provinceid) values(289,'542200','山南地区','540000');  
  299. insert into cities(id,cityid,city,provinceid) values(290,'542300','日喀则地区','540000');  
  300. insert into cities(id,cityid,city,provinceid) values(291,'542400','那曲地区','540000');  
  301. insert into cities(id,cityid,city,provinceid) values(292,'542500','阿里地区','540000');  
  302. insert into cities(id,cityid,city,provinceid) values(293,'542600','林芝地区','540000');  
  303. insert into cities(id,cityid,city,provinceid) values(294,'610100','西安市','610000');  
  304. insert into cities(id,cityid,city,provinceid) values(295,'610200','铜川市','610000');  
  305. insert into cities(id,cityid,city,provinceid) values(296,'610300','宝鸡市','610000');  
  306. insert into cities(id,cityid,city,provinceid) values(297,'610400','咸阳市','610000');  
  307. insert into cities(id,cityid,city,provinceid) values(298,'610500','渭南市','610000');  
  308. insert into cities(id,cityid,city,provinceid) values(299,'610600','延安市','610000');  
  309. insert into cities(id,cityid,city,provinceid) values(300,'610700','汉中市','610000');  
  310. insert into cities(id,cityid,city,provinceid) values(301,'610800','榆林市','610000');  
  311. insert into cities(id,cityid,city,provinceid) values(302,'610900','安康市','610000');  
  312. insert into cities(id,cityid,city,provinceid) values(303,'611000','商洛市','610000');  
  313. insert into cities(id,cityid,city,provinceid) values(304,'620100','兰州市','620000');  
  314. insert into cities(id,cityid,city,provinceid) values(305,'620200','嘉峪关市','620000');  
  315. insert into cities(id,cityid,city,provinceid) values(306,'620300','金昌市','620000');  
  316. insert into cities(id,cityid,city,provinceid) values(307,'620400','白银市','620000');  
  317. insert into cities(id,cityid,city,provinceid) values(308,'620500','天水市','620000');  
  318. insert into cities(id,cityid,city,provinceid) values(309,'620600','武威市','620000');  
  319. insert into cities(id,cityid,city,provinceid) values(310,'620700','张掖市','620000');  
  320. insert into cities(id,cityid,city,provinceid) values(311,'620800','平凉市','620000');  
  321. insert into cities(id,cityid,city,provinceid) values(312,'620900','酒泉市','620000');  
  322. insert into cities(id,cityid,city,provinceid) values(313,'621000','庆阳市','620000');  
  323. insert into cities(id,cityid,city,provinceid) values(314,'621100','定西市','620000');  
  324. insert into cities(id,cityid,city,provinceid) values(315,'621200','陇南市','620000');  
  325. insert into cities(id,cityid,city,provinceid) values(316,'622900','临夏回族自治州','620000');  
  326. insert into cities(id,cityid,city,provinceid) values(317,'623000','甘南藏族自治州','620000');  
  327. insert into cities(id,cityid,city,provinceid) values(318,'630100','西宁市','630000');  
  328. insert into cities(id,cityid,city,provinceid) values(319,'632100','海东地区','630000');  
  329. insert into cities(id,cityid,city,provinceid) values(320,'632200','海北藏族自治州','630000');  
  330. insert into cities(id,cityid,city,provinceid) values(321,'632300','黄南藏族自治州','630000');  
  331. insert into cities(id,cityid,city,provinceid) values(322,'632500','海南藏族自治州','630000');  
  332. insert into cities(id,cityid,city,provinceid) values(323,'632600','果洛藏族自治州','630000');  
  333. insert into cities(id,cityid,city,provinceid) values(324,'632700','玉树藏族自治州','630000');  
  334. insert into cities(id,cityid,city,provinceid) values(325,'632800','海西蒙古族藏族自治州','630000');  
  335. insert into cities(id,cityid,city,provinceid) values(326,'640100','银川市','640000');  
  336. insert into cities(id,cityid,city,provinceid) values(327,'640200','石嘴山市','640000');  
  337. insert into cities(id,cityid,city,provinceid) values(328,'640300','吴忠市','640000');  
  338. insert into cities(id,cityid,city,provinceid) values(329,'640400','固原市','640000');  
  339. insert into cities(id,cityid,city,provinceid) values(330,'640500','中卫市','640000');  
  340. insert into cities(id,cityid,city,provinceid) values(331,'650100','乌鲁木齐市','650000');  
  341. insert into cities(id,cityid,city,provinceid) values(332,'650200','克拉玛依市','650000');  
  342. insert into cities(id,cityid,city,provinceid) values(333,'652100','吐鲁番地区','650000');  
  343. insert into cities(id,cityid,city,provinceid) values(334,'652200','哈密地区','650000');  
  344. insert into cities(id,cityid,city,provinceid) values(335,'652300','昌吉回族自治州','650000');  
  345. insert into cities(id,cityid,city,provinceid) values(336,'652700','博尔塔拉蒙古自治州','650000');  
  346. insert into cities(id,cityid,city,provinceid) values(337,'652800','巴音郭楞蒙古自治州','650000');  
  347. insert into cities(id,cityid,city,provinceid) values(338,'652900','阿克苏地区','650000');  
  348. insert into cities(id,cityid,city,provinceid) values(339,'653000','克孜勒苏柯尔克孜自治州','650000');  
  349. insert into cities(id,cityid,city,provinceid) values(340,'653100','喀什地区','650000');  
  350. insert into cities(id,cityid,city,provinceid) values(341,'653200','和田地区','650000');  
  351. insert into cities(id,cityid,city,provinceid) values(342,'654000','伊犁哈萨克自治州','650000');  
  352. insert into cities(id,cityid,city,provinceid) values(343,'654200','塔城地区','650000');  
  353. insert into cities(id,cityid,city,provinceid) values(344,'654300','阿勒泰地区','650000');  
  354. insert into cities(id,cityid,city,provinceid) values(345,'659000','省直辖行政单位','650000');