全国行政区表 包括(省、市、县)SQL

-- 表的结构areaDROP TABLE area;CREATE TABLE area(id int NOT NULL,areaID int NOT NULL,area varchar(200)NOT NULL,fatherID int NOT NULL,PRIMARY KEY (id))DROP TABLE city;CREATE TABLE city(id int NOT NULL,cityID int NOT NULL,city varchar(200)NOT NULL,fatherID int NOT NULL,PRIMARY KEY (id))---- 导出表中的数据city---- ------------------------------------------------------------ 表的结构province--DROP TABLE province;CREATE TABLE province(id int NOT NULL,provinceID int NOT NULL,province varchar(200)NOT NULL,PRIMARY KEY (id))insert province(id,provinceID,province)select 1,110000,'北京市'unionselect 2,120000,'天津市'unionselect 3,130000,'河北省'unionselect 4,140000,'山西省'unionselect 5,150000,'内蒙古自治区'union select 6,210000,'辽宁省'unionselect 7,220000,'吉林省'unionselect 8,230000,'黑龙江省'unionselect 9,310000,'上海市'unionselect 10,320000,'江苏省'unionselect 11,330000,'浙江省'unionselect 12,340000,'安徽省'unionselect 13,350000,'福建省'unionselect 14,360000,'江西省'unionselect 15,370000,'山东省'unionselect 16,410000,'河南省'unionselect 17,420000,'湖北省'unionselect 18,430000,'湖南省'unionselect 19,440000,'广东省'unionselect 20,450000,'广西壮族自治区'union select 21,460000,'海南省'unionselect 22,500000,'重庆市'unionselect 23,510000,'四川省'unionselect 24,520000,'贵州省'unionselect 25,530000,'云南省'unionselect 26,540000,'西藏自治区'union select 27,610000,'陕西省'unionselect 28,620000,'甘肃省'unionselect 29,630000,'青海省'unionselect 30,640000,'宁夏回族自治区'union select 31,650000,'新疆维吾尔自治区'union select 32,710000,'台湾省'unionselect 33,810000,'香港特别行政区'union select 34,820000,'澳门特别行政区'INSERT city(id,cityID,city,fatherID) select 1,110100,'市辖区',110000 union select 2,110200,'县',110000 unionselect 3,120100,'市辖区',120000 union select 4,120200,'县',120000 unionselect 5,130100,'石家庄市',130000 union select 6,130200,'唐山市',130000 union select 7,130300,'秦皇岛市',130000 union select 8,130400,'邯郸市',130000 union select 9,130500,'邢台市',130000 union select 10,130600,'保定市',130000 unionselect 12,130800,'承德市',130000 union select 13,130900,'沧州市',130000 union select 14,131000,'廊坊市',130000 union select 15,131100,'衡水市',130000 union select 16,140100,'太原市',140000 union select 17,140200,'大同市',140000 union select 18,140300,'阳泉市',140000 union select 19,140400,'长治市',140000 union select 20,140500,'晋城市',140000 union select 21,140600,'朔州市',140000 union select 22,140700,'晋中市',140000 union select 23,140800,'运城市',140000 union select 24,140900,'忻州市',140000 union select 25,141000,'临汾市',140000 union select 26,141100,'吕梁市',140000INSERT city(id,cityID,city,fatherID) select 27,150100,'呼和浩特市',150000 union select 28,150200,'包头市',150000 union select 29,150300,'乌海市',150000 union select 30,150400,'赤峰市',150000 union select 31,150500,'通辽市',150000 union select 32,150600,'鄂尔多斯市',150000 union select 33,150700,'呼伦贝尔市',150000 union select 34,150800,'巴彦淖尔市',150000 union select 35,150900,'乌兰察布市',150000 union select 36,152200,'兴安盟',150000 union select 37,152500,'锡林郭勒盟',150000 union select 38,152900,'阿拉善盟',150000 union select 39,210100,'沈阳市',210000 union select 40,210200,'大连市',210000 union select 41,210300,'鞍山市',210000 union select 42,210400,'抚顺市',210000 union select 43,210500,'本溪市',210000 union select 44,210600,'丹东市',210000 union select 45,210700,'锦州市',210000 union select 46,210800,'营口市',210000 union select 47,210900,'阜新市',210000 union select 48,211000,'辽阳市',210000 union select 49,211100,'盘锦市',210000 union select 50,211200,'铁岭市',210000 union select 51,211300,'朝阳市',210000 unionselect 53,220100,'长春市',220000 unionselect 54,220200,'吉林市',220000 unionselect 55,220300,'四平市',220000 unionselect 56,220400,'辽源市',220000 unionselect 57,220500,'通化市',220000 unionselect 58,220600,'白山市',220000 unionselect 59,220700,'松原市',220000 unionselect 60,220800,'白城市',220000 unionselect 61,222400,'延边朝鲜族自治州',220000 union select 62,230100,'哈尔滨市',230000 unionselect 63,230200,'齐齐哈尔市',230000 union select 64,230300,'鸡西市',230000 unionselect 65,230400,'鹤岗市',230000 unionselect 66,230500,'双鸭山市',230000 unionselect 67,230600,'大庆市',230000 unionselect 68,230700,'伊春市',230000 unionselect 69,230800,'佳木斯市',230000 unionselect 70,230900,'七台河市',230000 unionselect 71,231000,'牡丹江市',230000 unionselect 72,231100,'黑河市',230000 unionselect 73,231200,'绥化市',230000 unionselect 74,232700,'大兴安岭地区',230000 union select 75,310100,'市辖区',310000 unionselect 76,310200,'县',310000 unionselect 77,320100,'南京市',320000 unionselect 78,320200,'无锡市',320000 unionselect 79,320300,'徐州市',320000 unionselect 80,320400,'常州市',320000 unionselect 81,320500,'苏州市',320000 unionselect 82,320600,'南通市',320000 unionselect 83,320700,'连云港市',320000 unionselect 84,320800,'淮安市',320000 unionselect 85,320900,'盐城市',320000 unionselect 86,321000,'扬州市',320000 unionselect 87,321100,'镇江市',320000 unionselect 88,321200,'泰州市',320000 unionselect 89,321300,'宿迁市',320000 unionselect 90,330100,'杭州市',330000 unionselect 91,330200,'宁波市',330000 unionselect 92,330300,'温州市',330000 unionselect 93,330400,'嘉兴市',330000 unionselect 94,330500,'湖州市',330000 unionselect 95,330600,'绍兴市',330000 unionselect 97,330800,'衢州市',330000 union select 98,330900,'舟山市',330000 union select 99,331000,'台州市',330000 union select 100,331100,'丽水市',330000 union select 101,340100,'合肥市',340000 union select 102,340200,'芜湖市',340000 union select 103,340300,'蚌埠市',340000 union select 104,340400,'淮南市',340000 union select 105,340500,'马鞍山市',340000 union select 106,340600,'淮北市',340000 union select 107,340700,'铜陵市',340000 union select 108,340800,'安庆市',340000 union select 109,341000,'黄山市',340000 union select 110,341100,'滁州市',340000 union select 111,341200,'阜阳市',340000 union select 112,341300,'宿州市',340000 union select 113,341400,'巢湖市',340000 union select 114,341500,'六安市',340000 union select 115,341600,'亳州市',340000 union select 116,341700,'池州市',340000 union select 117,341800,'宣城市',340000 union select 118,350100,'福州市',350000 union select 119,350200,'厦门市',350000 union select 120,350300,'莆田市',350000 union select 121,350400,'三明市',350000 union select 122,350500,'泉州市',350000 union select 123,350600,'漳州市',350000 union select 124,350700,'南平市',350000 union select 125,350800,'龙岩市',350000 union select 126,350900,'宁德市',350000INSERT city(id,cityID,city,fatherID) select 127,360100,'南昌市',360000 union select 128,360200,'景德镇市',360000 union select 129,360300,'萍乡市',360000 union select 130,360400,'九江市',360000 union select 131,360500,'新余市',360000 union select 132,360600,'鹰潭市',360000 union select 133,360700,'赣州市',360000 union select 134,360800,'吉安市',360000 union select 135,360900,'宜春市',360000 union select 136,361000,'抚州市',360000 union select 137,361100,'上饶市',360000 unionselect 139,370200,'青岛市',370000 union select 140,370300,'淄博市',370000 union select 141,370400,'枣庄市',370000 union select 142,370500,'东营市',370000 union select 143,370600,'烟台市',370000 union select 144,370700,'潍坊市',370000 union select 145,370800,'济宁市',370000 union select 146,370900,'泰安市',370000 union select 147,371000,'威海市',370000 union select 148,371100,'日照市',370000 union select 149,371200,'莱芜市',370000 union select 150,371300,'临沂市',370000 union select 151,371400,'德州市',370000 union select 152,371500,'聊城市',370000 union select 153,371600,'滨州市',370000 union select 154,371700,'荷泽市',370000 union select 155,410100,'郑州市',410000 union select 156,410200,'开封市',410000 union select 157,410300,'洛阳市',410000 union select 158,410400,'平顶山市',410000 union select 159,410500,'安阳市',410000 union select 160,410600,'鹤壁市',410000 union select 161,410700,'新乡市',410000 union select 162,410800,'焦作市',410000 union select 163,410900,'濮阳市',410000 union select 164,411000,'许昌市',410000 union select 165,411100,'漯河市',410000 union select 166,411200,'三门峡市',410000 union select 167,411300,'南阳市',410000 union select 168,411400,'商丘市',410000 union select 169,411500,'信阳市',410000 union select 170,411600,'周口市',410000 union select 171,411700,'驻马店市',410000INSERT city(id,cityID,city,fatherID) select 172,420100,'武汉市',420000 union select 173,420200,'黄石市',420000 union select 174,420300,'十堰市',420000 union select 175,420500,'宜昌市',420000 union select 176,420600,'襄樊市',420000 union select 177,420700,'鄂州市',420000 union select 178,420800,'荆门市',420000 unionselect 180,421000,'荆州市',420000 unionselect 181,421100,'黄冈市',420000 unionselect 182,421200,'咸宁市',420000 unionselect 183,421300,'随州市',420000 unionselect 184,422800,'恩施土家族苗族自治州',420000 union select 185,429000,'省直辖行政单位',420000 union select 186,430100,'长沙市',430000 unionselect 187,430200,'株洲市',430000 unionselect 188,430300,'湘潭市',430000 unionselect 189,430400,'衡阳市',430000 unionselect 190,430500,'邵阳市',430000 unionselect 191,430600,'岳阳市',430000 unionselect 192,430700,'常德市',430000 unionselect 193,430800,'张家界市',430000 unionselect 194,430900,'益阳市',430000 unionselect 195,431000,'郴州市',430000 unionselect 196,431100,'永州市',430000 unionselect 197,431200,'怀化市',430000 unionselect 198,431300,'娄底市',430000 unionselect 199,433100,'湘西土家族苗族自治州',430000 union select 200,440100,'广州市',440000 unionselect 201,440200,'韶关市',440000 unionselect 202,440300,'深圳市',440000 unionselect 203,440400,'珠海市',440000 unionselect 204,440500,'汕头市',440000 unionselect 205,440600,'佛山市',440000 unionselect 206,440700,'江门市',440000 unionselect 207,440800,'湛江市',440000 unionselect 208,440900,'茂名市',440000 unionselect 209,441200,'肇庆市',440000 unionselect 210,441300,'惠州市',440000 unionselect 211,441400,'梅州市',440000 unionselect 212,441500,'汕尾市',440000 unionselect 213,441600,'河源市',440000 unionselect 214,441700,'阳江市',440000 unionselect 215,441800,'清远市',440000 unionselect 216,441900,'东莞市',440000 unionselect 217,442000,'中山市',440000 unionselect 218,445100,'潮州市',440000 unionselect 219,445200,'揭阳市',440000 unionselect 220,445300,'云浮市',440000 unionselect 221,450100,'南宁市',450000 unionselect 222,450200,'柳州市',450000 unionselect 224,450400,'梧州市',450000 unionselect 225,450500,'北海市',450000INSERT city(id,cityID,city,fatherID)select 226,450600,'防城港市',450000 unionselect 227,450700,'钦州市',450000 unionselect 228,450800,'贵港市',450000 unionselect 229,450900,'玉林市',450000 unionselect 230,451000,'百色市',450000 unionselect 231,451100,'贺州市',450000 unionselect 232,451200,'河池市',450000 unionselect 233,451300,'来宾市',450000 unionselect 234,451400,'崇左市',450000 unionselect 235,460100,'海口市',460000 unionselect 236,460200,'三亚市',460000 unionselect 237,469000,'省直辖县级行政单位',460000 union select 238,500100,'市辖区',500000 unionselect 239,500200,'县',500000 unionselect 240,500300,'市',500000 unionselect 241,510100,'成都市',510000 unionselect 242,510300,'自贡市',510000 unionselect 243,510400,'攀枝花市',510000 unionselect 244,510500,'泸州市',510000 unionselect 245,510600,'德阳市',510000 unionselect 246,510700,'绵阳市',510000 unionselect 247,510800,'广元市',510000 unionselect 248,510900,'遂宁市',510000 unionselect 249,511000,'内江市',510000 unionselect 250,511100,'乐山市',510000 unionselect 251,511300,'南充市',510000 unionselect 252,511400,'眉山市',510000 unionselect 253,511500,'宜宾市',510000 unionselect 254,511600,'广安市',510000 unionselect 255,511700,'达州市',510000 unionselect 256,511800,'雅安市',510000 unionselect 257,511900,'巴中市',510000 unionselect 258,512000,'资阳市',510000 unionselect 259,513200,'阿坝藏族羌族自治州',510000 union select 260,513300,'甘孜藏族自治州',510000 union select 261,513400,'凉山彝族自治州',510000 union select 262,520100,'贵阳市',520000 unionselect 263,520200,'六盘水市',520000INSERT city(id,cityID,city,fatherID)select 264,520300,'遵义市',520000 unionselect 265,520400,'安顺市',520000 unionselect 266,522200,'铜仁地区',520000 unionselect 267,522300,'黔西南布依族苗族自治州',520000 union select 268,522400,'毕节地区',520000 unionselect 269,522600,'黔东南苗族侗族自治州',520000 union select 270,522700,'黔南布依族苗族自治州',520000 union select 271,530100,'昆明市',530000 unionselect 272,530300,'曲靖市',530000 unionselect 273,530400,'玉溪市',530000 unionselect 274,530500,'保山市',530000 unionselect 275,530600,'昭通市',530000 unionselect 276,530700,'丽江市',530000 unionselect 277,530800,'思茅市',530000 unionselect 278,530900,'临沧市',530000 unionselect 279,532300,'楚雄彝族自治州',530000 unionselect 280,532500,'红河哈尼族彝族自治州',530000 union select 281,532600,'文山壮族苗族自治州',530000 union select 282,532800,'西双版纳傣族自治州',530000 union select 283,532900,'大理白族自治州',530000 unionselect 284,533100,'德宏傣族景颇族自治州',530000 union select 285,533300,'怒江傈僳族自治州',530000 union select 286,533400,'迪庆藏族自治州',530000 unionselect 287,540100,'拉萨市',540000 unionselect 288,542100,'昌都地区',540000 unionselect 289,542200,'山南地区',540000 unionselect 290,542300,'日喀则地区',540000 unionselect 291,542400,'那曲地区',540000 unionselect 292,542500,'阿里地区',540000 unionselect 293,542600,'林芝地区',540000INSERT city(id,cityID,city,fatherID)select 294,610100,'西安市',610000 unionselect 295,610200,'铜川市',610000 unionselect 296,610300,'宝鸡市',610000 unionselect 297,610400,'咸阳市',610000 unionselect 298,610500,'渭南市',610000 unionselect 299,610600,'延安市',610000 unionselect 300,610700,'汉中市',610000 unionselect 301,610800,'榆林市',610000 unionselect 302,610900,'安康市',610000 unionselect 303,611000,'商洛市',610000 unionselect 304,620100,'兰州市',620000 unionselect 305,620200,'嘉峪关市',620000 unionselect 306,620300,'金昌市',620000 unionselect 307,620400,'白银市',620000 unionselect 308,620500,'天水市',620000 unionselect 309,620600,'武威市',620000 unionselect 310,620700,'张掖市',620000 unionselect 311,620800,'平凉市',620000 unionselect 312,620900,'酒泉市',620000 unionselect 313,621000,'庆阳市',620000 unionselect 314,621100,'定西市',620000 unionselect 315,621200,'陇南市',620000 unionselect 316,622900,'临夏回族自治州',620000 unionselect 317,623000,'甘南藏族自治州',620000 unionselect 318,630100,'西宁市',630000 unionselect 319,632100,'海东地区',630000 unionselect 320,632200,'海北藏族自治州',630000 unionselect 321,632300,'黄南藏族自治州',630000 unionselect 322,632500,'海南藏族自治州',630000 unionselect 323,632600,'果洛藏族自治州',630000 unionselect 324,632700,'玉树藏族自治州',630000INSERT city(id,cityID,city,fatherID)select 325,632800,'海西蒙古族藏族自治州',630000 union select 326,640100,'银川市',640000 unionselect 327,640200,'石嘴山市',640000 unionselect 328,640300,'吴忠市',640000 unionselect 329,640400,'固原市',640000 unionselect 330,640500,'中卫市',640000 unionselect 331,650100,'乌鲁木齐市',650000 unionselect 332,650200,'克拉玛依市',650000 unionselect 333,652100,'吐鲁番地区',650000 unionselect 334,652200,'哈密地区',650000 unionselect 335,652300,'昌吉回族自治州',650000 unionselect 336,652700,'博尔塔拉蒙古自治州',650000 union select 337,652800,'巴音郭楞蒙古自治州',650000 union select 338,652900,'阿克苏地区',650000INSERT city(id,cityID,city,fatherID)select 339,653000,'克孜勒苏柯尔克孜自治州',650000 union select 340,653100,'喀什地区',650000 unionselect 341,653200,'和田地区',650000 unionselect 342,654000,'伊犁哈萨克自治州',650000 union select 343,654200,'塔城地区',650000 unionselect 344,654300,'阿勒泰地区',650000 union select 345,659000,'省直辖行政单位',650000INSERT INTO area(id,areaID,area,fatherID)select 1,110101,'东城区',110100 unionselect 2,110102,'西城区',110100 unionselect 3,110103,'崇文区',110100 unionselect 4,110104,'宣武区',110100 unionselect 5,110105,'朝阳区',110100 unionselect 6,110106,'丰台区',110100 unionselect 7,110107,'石景山区',110100 unionselect 8,110108,'海淀区',110100 unionselect 9,110109,'门头沟区',110100 unionselect 10,110111,'房山区',110100 unionselect 11,110112,'通州区',110100 unionselect 12,110113,'顺义区',110100 unionselect 13,110114,'昌平区',110100 unionselect 14,110115,'大兴区',110100 unionselect 15,110116,'怀柔区',110100 unionselect 16,110117,'平谷区',110100 unionselect 17,110228,'密云县',110200 unionselect 18,110229,'延庆县',110200 unionselect 19,120101,'和平区',120100 unionselect 20,120102,'河东区',120100 unionselect 21,120103,'河西区',120100 unionselect 22,120104,'南开区',120100 unionselect 23,120105,'河北区',120100 unionselect 24,120106,'红桥区',120100 unionselect 25,120107,'塘沽区',120100 unionselect 26,120108,'汉沽区',120100 unionselect 27,120109,'大港区',120100 unionselect 28,120110,'东丽区',120100 unionselect 29,120111,'西青区',120100 unionselect 30,120112,'津南区',120100 unionselect 31,120113,'北辰区',120100 unionselect 32,120114,'武清区',120100 unionselect 33,120115,'宝坻区',120100 unionselect 34,120221,'宁河县',120200 unionselect 35,120223,'静海县',120200 unionselect 36,120225,'蓟县',120200 unionselect 37,130101,'市辖区',130100 unionselect 39,130103,'桥东区',130100 unionselect 40,130104,'桥西区',130100 unionselect 41,130105,'新华区',130100 unionselect 42,130107,'井陉矿区',130100 union select 43,130108,'裕华区',130100 unionselect 44,130121,'井陉县',130100 unionselect 45,130123,'正定县',130100 unionselect 46,130124,'栾城县',130100 unionselect 47,130125,'行唐县',130100 unionselect 48,130126,'灵寿县',130100 unionselect 49,130127,'高邑县',130100 unionselect 50,130128,'深泽县',130100 unionselect 51,130129,'赞皇县',130100 unionselect 52,130130,'无极县',130100 unionselect 53,130131,'平山县',130100 unionselect 54,130132,'元氏县',130100 unionselect 55,130133,'赵县',130100 unionselect 56,130181,'辛集市',130100 unionselect 57,130182,'藁城市',130100 unionselect 58,130183,'晋州市',130100 unionselect 59,130184,'新乐市',130100 unionselect 60,130185,'鹿泉市',130100 unionselect 61,130201,'市辖区',130200 unionselect 62,130202,'路南区',130200 unionselect 63,130203,'路北区',130200 unionselect 64,130204,'古冶区',130200 unionselect 65,130205,'开平区',130200 unionselect 66,130207,'丰南区',130200 unionselect 67,130208,'丰润区',130200 unionselect 68,130223,'滦县',130200 unionselect 69,130224,'滦南县',130200 unionselect 70,130225,'乐亭县',130200 unionselect 71,130227,'迁西县',130200 unionselect 72,130229,'玉田县',130200 unionselect 73,130230,'唐海县',130200 unionselect 74,130281,'遵化市',130200 unionselect 75,130283,'迁安市',130200 unionselect 76,130301,'市辖区',130300 unionselect 77,130302,'海港区',130300 unionselect 78,130303,'山海关区',130300 union select 79,130304,'北戴河区',130300 union select 80,130321,'青龙满族自治县',130300 union select 81,130322,'昌黎县',130300 unionselect 83,130324,'卢龙县',130300 union select 84,130401,'市辖区',130400 union select 85,130402,'邯山区',130400 union select 86,130403,'丛台区',130400 union select 87,130404,'复兴区',130400 union select 88,130406,'峰峰矿区',130400 union select 89,130421,'邯郸县',130400 union select 90,130423,'临漳县',130400 union select 91,130424,'成安县',130400 union select 92,130425,'大名县',130400 union select 93,130426,'涉县',130400 union select 94,130427,'磁县',130400 union select 95,130428,'肥乡县',130400 union select 96,130429,'永年县',130400 union select 97,130430,'邱县',130400 union select 98,130431,'鸡泽县',130400 union select 99,130432,'广平县',130400 union select 100,130433,'馆陶县',130400 union select 101,130434,'魏县',130400 union select 102,130435,'曲周县',130400 union select 103,130481,'武安市',130400 union select 104,130501,'市辖区',130500 union select 105,130502,'桥东区',130500 union select 106,130503,'桥西区',130500 union select 107,130521,'邢台县',130500 union select 108,130522,'临城县',130500 union select 109,130523,'内丘县',130500 union select 110,130524,'柏乡县',130500 union select 111,130525,'隆尧县',130500 union select 112,130526,'任县',130500 union select 113,130527,'南和县',130500 union select 114,130528,'宁晋县',130500 union select 115,130529,'巨鹿县',130500 union select 116,130530,'新河县',130500 union select 117,130531,'广宗县',130500 union select 118,130532,'平乡县',130500 union select 119,130533,'威县',130500 union select 120,130534,'清河县',130500 union select 121,130535,'临西县',130500 union select 122,130581,'南宫市',130500 union select 123,130582,'沙河市',130500 union select 124,130601,'市辖区',130600 union select 125,130602,'新市区',130600 unionselect 127,130604,'南市区',130600 union select 128,130621,'满城县',130600 union select 129,130622,'清苑县',130600 union select 130,130623,'涞水县',130600 union select 131,130624,'阜平县',130600 union select 132,130625,'徐水县',130600 union select 133,130626,'定兴县',130600 union select 134,130627,'唐县',130600 union select 135,130628,'高阳县',130600 union select 136,130629,'容城县',130600 union select 137,130630,'涞源县',130600 union select 138,130631,'望都县',130600 union select 139,130632,'安新县',130600 union select 140,130633,'易县',130600 union select 141,130634,'曲阳县',130600 union select 142,130635,'蠡县',130600 union select 143,130636,'顺平县',130600 union select 144,130637,'博野县',130600 union select 145,130638,'雄县',130600 union select 146,130681,'涿州市',130600 union select 147,130682,'定州市',130600 union select 148,130683,'安国市',130600 union select 149,130684,'高碑店市',130600 union select 150,130701,'市辖区',130700 union select 151,130702,'桥东区',130700 union select 152,130703,'桥西区',130700 union select 153,130705,'宣化区',130700 union select 154,130706,'下花园区',130700 union select 155,130721,'宣化县',130700 union select 156,130722,'张北县',130700 union select 157,130723,'康保县',130700 union select 158,130724,'沽源县',130700 union select 159,130725,'尚义县',130700 union select 160,130726,'蔚县',130700 union select 161,130727,'阳原县',130700 union select 162,130728,'怀安县',130700 union select 163,130729,'万全县',130700 union select 164,130730,'怀来县',130700 union select 165,130731,'涿鹿县',130700 union select 166,130732,'赤城县',130700 union select 167,130733,'崇礼县',130700 union select 168,130801,'市辖区',130800 union select 169,130802,'双桥区',130800 unionselect 171,130804,'鹰手营子矿区',130800 unionselect 172,130821,'承德县',130800 unionselect 173,130822,'兴隆县',130800 unionselect 174,130823,'平泉县',130800 unionselect 175,130824,'滦平县',130800 unionselect 176,130825,'隆化县',130800 unionselect 177,130826,'丰宁满族自治县',130800 union select 178,130827,'宽城满族自治县',130800 union select 179,130828,'围场满族蒙古族自治县',130800 union select 180,130901,'市辖区',130900 unionselect 181,130902,'新华区',130900 unionselect 182,130903,'运河区',130900 unionselect 183,130921,'沧县',130900 unionselect 184,130922,'青县',130900 unionselect 185,130923,'东光县',130900 unionselect 186,130924,'海兴县',130900 unionselect 187,130925,'盐山县',130900 unionselect 188,130926,'肃宁县',130900 unionselect 189,130927,'南皮县',130900 unionselect 190,130928,'吴桥县',130900 unionselect 191,130929,'献县',130900 unionselect 192,130930,'孟村回族自治县',130900 union select 193,130981,'泊头市',130900 unionselect 194,130982,'任丘市',130900 unionselect 195,130983,'黄骅市',130900 unionselect 196,130984,'河间市',130900 unionselect 197,131001,'市辖区',131000 unionselect 198,131002,'安次区',131000 unionselect 199,131003,'广阳区',131000 unionselect 200,131022,'固安县',131000 unionselect 201,131023,'永清县',131000 unionselect 202,131024,'香河县',131000 unionselect 203,131025,'大城县',131000 unionselect 204,131026,'文安县',131000 unionselect 205,131028,'大厂回族自治县',131000 union select 206,131081,'霸州市',131000 unionselect 207,131082,'三河市',131000 unionselect 208,131101,'市辖区',131100 unionselect 209,131102,'桃城区',131100 unionselect 210,131121,'枣强县',131100 unionselect 211,131122,'武邑县',131100 unionselect 212,131123,'武强县',131100 unionselect 213,131124,'饶阳县',131100 unionselect 215,131126,'故城县',131100 union select 216,131127,'景县',131100 union select 217,131128,'阜城县',131100 union select 218,131181,'冀州市',131100 union select 219,131182,'深州市',131100 union select 220,140101,'市辖区',140100 union select 221,140105,'小店区',140100 union select 222,140106,'迎泽区',140100 union select 223,140107,'杏花岭区',140100 union select 224,140108,'尖草坪区',140100 union select 225,140109,'万柏林区',140100 union select 226,140110,'晋源区',140100 union select 227,140121,'清徐县',140100 union select 228,140122,'阳曲县',140100 union select 229,140123,'娄烦县',140100 union select 230,140181,'古交市',140100 union select 231,140201,'市辖区',140200 union select 232,140202,'城区',140200 union select 233,140203,'矿区',140200 union select 234,140211,'南郊区',140200 union select 235,140212,'新荣区',140200 union select 236,140221,'阳高县',140200 union select 237,140222,'天镇县',140200 union select 238,140223,'广灵县',140200 union select 239,140224,'灵丘县',140200 union select 240,140225,'浑源县',140200 union select 241,140226,'左云县',140200 union select 242,140227,'大同县',140200 union select 243,140301,'市辖区',140300 union select 244,140302,'城区',140300 union select 245,140303,'矿区',140300 union select 246,140311,'郊区',140300 union select 247,140321,'平定县',140300 union select 248,140322,'盂县',140300 union select 249,140401,'市辖区',140400 union select 250,140402,'城区',140400 union select 251,140411,'郊区',140400 union select 252,140421,'长治县',140400 union select 253,140423,'襄垣县',140400 union select 254,140424,'屯留县',140400 union select 255,140425,'平顺县',140400 union select 256,140426,'黎城县',140400 union select 257,140427,'壶关县',140400 union。

全国省市的数据库sql语句--创建省级表Create Table Province(ProID int primary key not null,ProName nvarchar(50) not null)Go--中国34个省级⾏政单位 23个省 5个⾃治区 4个直辖市 2特别⾏政区insert into Province values(1,'北京市')insert into Province values(2,'天津市')insert into Province values(3,'上海市')insert into Province values(4,'重庆市')insert into Province values(5,'河北省')insert into Province values(6,'⼭西省')insert into Province values(7,'台湾省')insert into Province values(8,'辽宁省')insert into Province values(9,'吉林省')insert into Province values(10,'⿊龙江省')insert into Province values(11,'江苏省')insert into Province values(12,'浙江省')insert into Province values(13,'安徽省')insert into Province values(14,'福建省')insert into Province values(15,'江西省')insert into Province values(16,'⼭东省')insert into Province values(17,'河南省')insert into Province values(18,'湖北省')insert into Province values(19,'湖南省')insert into Province values(20,'⼴东省')insert into Province values(21,'⽢肃省')insert into Province values(22,'四川省')--insert into Province values(23,'⼭东省')insert into Province values(24,'贵州省')insert into Province values(25,'海南省')insert into Province values(26,'云南省')insert into Province values(27,'青海省')insert into Province values(28,'陕西省')insert into Province values(29,'⼴西壮族⾃治区')insert into Province values(30,'西藏⾃治区')insert into Province values(31,'宁夏回族⾃治区')insert into Province values(32,'新疆维吾尔⾃治区')insert into Province values(33,'内蒙古⾃治区')insert into Province values(34,'澳门特别⾏政区')insert into Province values(35,'⾹港特别⾏政区')Go--创建市级表Create Table City(CityID int not null,CityName nvarchar(50) primary key not null,ProID int)go--插⼊各个省的城市数据--4个直辖市insert into city values(1,'北京市',1)insert into city values(1,'天津市',2)insert into city values(1,'上海市',3)insert into city values(1,'重庆市',4)--5河北省(2005年辖：11个地级市，36个市辖区、22个县级市、108个县、6个⾃治县)insert into city values(1,'⽯家庄市',5)insert into city values(2,'唐⼭市',5)insert into city values(3,'秦皇岛市',5)insert into city values(4,'邯郸市',5)insert into city values(5,'邢台市',5)insert into city values(6,'保定市',5)insert into city values(7,'张家⼝市',5)insert into city values(8,'承德市',5)insert into city values(9,'沧州市',5)insert into city values(10,'廊坊市',5)insert into city values(11,'衡⽔市',5)--6⼭西省11个城市insert into city values(1,'太原市',6)insert into city values(2,'⼤同市',6)insert into city values(3,'阳泉市',6)insert into city values(4,'长治市',6)insert into city values(5,'晋城市',6)--7台湾省(台湾本岛和澎湖共设7市、16县，其中台北市和⾼雄市为“院辖市”，直属“⾏政院”，其余属台湾省；市下设区，县下设市（县辖市）、镇、乡，合称区市镇乡。

一、介绍全国行政区域划分是指将我国国土按照行政管理区域划分为若干个省、自治区、直辖市、特别行政区和县级行政区域。

这一划分有助于国家的行政管理和资源配置，对于各级政府的管理和公共服务的提供具有重要意义。

在数据库管理系统中，我们可以使用SQLServer来管理全国行政区域划分表。

二、创建全国行政区域划分表1. 创建数据库在SQLServer中，首先需要创建一个数据库来存储全国行政区域划分表。

可以使用如下SQL语句来创建一个名为"区域划分"的数据库：CREATE DATABASE 区域划分;2. 创建表格在创建了数据库之后，我们需要创建一个表格来存储全国行政区域划分的数据。

可以使用如下SQL语句来创建一个名为"行政区域"的表格：CREATE TABLE 行政区域(省份名称 NVARCHAR(50),城市名称 NVARCHAR(50),区县名称 NVARCHAR(50));三、插入数据1. 插入省份数据为了方便管理和查询，我们可以先插入全国的省份数据。

可以使用如下SQL语句来插入一些省份的数据：INSERT INTO 行政区域 (省份名称) VALUES ('北京');INSERT INTO 行政区域 (省份名称) VALUES ('上海');INSERT INTO 行政区域 (省份名称) VALUES ('天津');INSERT INTO 行政区域 (省份名称) VALUES ('重庆');...（其他省份数据省略）2. 插入城市数据同样的方法，我们可以插入各个省份的城市数据：INSERT INTO 行政区域 (省份名称, 城市名称) VALUES ('北京', '东城区');INSERT INTO 行政区域 (省份名称, 城市名称) VALUES ('北京', '西城区');INSERT INTO 行政区域 (省份名称, 城市名称) VALUES ('北京', '朝阳区');INSERT INTO 行政区域 (省份名称, 城市名称) VALUES ('北京', '海淀区');...（其他城市数据省略）3. 插入区县数据我们可以插入各个城市的区县数据：INSERT INTO 行政区域 (省份名称, 城市名称, 区县名称) VALUES ('北京', '东城区', '东城街道');INSERT INTO 行政区域 (省份名称, 城市名称, 区县名称) VALUES ('北京', '东城区', '景山街道');INSERT INTO 行政区域 (省份名称, 城市名称, 区县名称) VALUES ('北京', '东城区', '交道口街道');INSERT INTO 行政区域 (省份名称, 城市名称, 区县名称) VALUES ('北京', '东城区', '永定门外街道');...（其他区县数据省略）四、查询数据为了验证数据的插入是否成功，我们可以使用如下的SQL语句来查询某个省份的所有城市和区县数据：SELECT 城市名称, 区县名称 FROM 行政区域 WHERE 省份名称 = '北京';这样就可以查询出北京市的所有城市和区县数据了。

全国省份城市表（sql版）
前段时间感觉现在正在⽤的全国省份/城市表不是太好，于是想换⼀个新的，没想到上⽹找了好久都没有找到合适的，于是上国家统计局⽹站上拷了⼀份最新的有关区域名称的本⽂回来，最后花半天时间整理了⼀下，终于改为⾃⼰想要的格式了，想到还有许多朋友想要⼀份这样的数据表，故现公布如下：
国家统计局的⽹址：
数据库表结构：
if exists (select*from dbo.sysobjects where id =object_id(N'[dbo].[Area]') and OBJECTPROPERTY(id, N'IsUserTable') =1)
drop table[dbo].[Area]
GO
CREATE TABLE[dbo].[Area] (
[AreaID][int]IDENTITY (1, 1) NOT NULL ,
[Name][nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ParentID][int]NULL
) ON[PRIMARY]
GO
ALTER TABLE[dbo].[Area]ADD
CONSTRAINT[PK_aa]PRIMARY KEY CLUSTERED
(
[AreaID]
) ON[PRIMARY]
GO
数据内容我已导出成txt格式，因为数据库⽂件太⼤了，默认的就有1M。

只要把下载的⽂件导⼊到前⾯建好的表中即可！
放⼀幅图出来look⼀look：。

MySQL中国省市区SQL表数据1.查省SELECT * FROM china WHERE china.Pid=02.查市SELECT * FROM chinaWHERE china.Pid=3300003.查区SELECT * FROM china WHERE china.Pid = 3301004.Mysql脚本DROP TABLE IF EXISTS `china`;CREATE TABLE `china` (`Id` INT(11) NOT NULL,`Name` VARCHAR(40) DEFAULT NULL,`Pid` INT(11) DEFAULT NULL,PRIMARY KEY (`Id`),KEY `FK_CHINA_REFERENCE_CHINA` (`Pid`),CONSTRAINT `FK_CHINA_REFERENCE_CHINA` FOREIGN KEY (`Pid`) REFERENCES `china` (`Id`)) ENGINE=INNODB DEFAULT CHARSET=utf8;-- ------------------------------ Records of china-- ----------------------------INSERT INTO `china` VALUES ('0', '中国', '0');INSERT INTO `china` VALUES ('110000', '北京市', '0');INSERT INTO `china` VALUES ('110100', '东城区', '110000');INSERT INTO `china` VALUES ('110200', '西城区', '110000');INSERT INTO `china` VALUES ('110500', '朝阳区', '110000');INSERT INTO `china` VALUES ('110600', '丰台区', '110000');INSERT INTO `china` VALUES ('110700', '⽯景⼭区', '110000');INSERT INTO `china` VALUES ('110800', '海淀区', '110000');INSERT INTO `china` VALUES ('110900', '门头沟区', '110000');INSERT INTO `china` VALUES ('111100', '房⼭区', '110000');INSERT INTO `china` VALUES ('111200', '通州区', '110000');INSERT INTO `china` VALUES ('111300', '顺义区', '110000');INSERT INTO `china` VALUES ('111400', '昌平区', '110000');INSERT INTO `china` VALUES ('111500', '⼤兴区', '110000');INSERT INTO `china` VALUES ('111600', '怀柔区', '110000');INSERT INTO `china` VALUES ('111700', '平⾕区', '110000');INSERT INTO `china` VALUES ('112800', '密云县', '110000');INSERT INTO `china` VALUES ('112900', '延庆县', '110000');INSERT INTO `china` VALUES ('120000', '天津市', '0');INSERT INTO `china` VALUES ('120100', '和平区', '120000');INSERT INTO `china` VALUES ('120200', '河东区', '120000');INSERT INTO `china` VALUES ('120300', '河西区', '120000');INSERT INTO `china` VALUES ('120400', '南开区', '120000');INSERT INTO `china` VALUES ('120500', '河北区', '120000');INSERT INTO `china` VALUES ('120600', '红桥区', '120000');INSERT INTO `china` VALUES ('120900', '滨海新区', '120000');INSERT INTO `china` VALUES ('121000', '东丽区', '120000');INSERT INTO `china` VALUES ('121100', '西青区', '120000');INSERT INTO `china` VALUES ('121200', '津南区', '120000');INSERT INTO `china` VALUES ('121300', '北⾠区', '120000');INSERT INTO `china` VALUES ('121400', '武清区', '120000');INSERT INTO `china` VALUES ('121500', '宝坻区', '120000');INSERT INTO `china` VALUES ('122100', '宁河县', '120000');INSERT INTO `china` VALUES ('122300', '静海县', '120000');INSERT INTO `china` VALUES ('122500', '蓟县', '120000');INSERT INTO `china` VALUES ('130000', '河北省', '0');INSERT INTO `china` VALUES ('130100', '⽯家庄市', '130000');INSERT INTO `china` VALUES ('130101', '市辖区', '130100');INSERT INTO `china` VALUES ('130102', '长安区', '130101');INSERT INTO `china` VALUES ('130126', '灵寿县', '130100'); INSERT INTO `china` VALUES ('130127', '⾼⾢县', '130100'); INSERT INTO `china` VALUES ('130128', '深泽县', '130100'); INSERT INTO `china` VALUES ('130129', '赞皇县', '130100'); INSERT INTO `china` VALUES ('130130', '⽆极县', '130100'); INSERT INTO `china` VALUES ('130131', '平⼭县', '130100'); INSERT INTO `china` VALUES ('130132', '元⽒县', '130100'); INSERT INTO `china` VALUES ('130133', '赵县', '130100'); INSERT INTO `china` VALUES ('130181', '⾟集市', '130100'); INSERT INTO `china` VALUES ('130182', '藁城市', '130100'); INSERT INTO `china` VALUES ('130183', '晋州市', '130100'); INSERT INTO `china` VALUES ('130184', '新乐市', '130100'); INSERT INTO `china` VALUES ('130185', '⿅泉市', '130100'); INSERT INTO `china` VALUES ('130200', '唐⼭市', '130000'); INSERT INTO `china` VALUES ('130201', '市辖区', '130200'); INSERT INTO `china` VALUES ('130202', '路南区', '130201'); INSERT INTO `china` VALUES ('130203', '路北区', '130201'); INSERT INTO `china` VALUES ('130204', '古冶区', '130201'); INSERT INTO `china` VALUES ('130205', '开平区', '130201'); INSERT INTO `china` VALUES ('130207', '丰南区', '130201'); INSERT INTO `china` VALUES ('130208', '丰润区', '130201'); INSERT INTO `china` VALUES ('130223', '滦县', '130200'); INSERT INTO `china` VALUES ('130224', '滦南县', '130200'); INSERT INTO `china` VALUES ('130225', '乐亭县', '130200'); INSERT INTO `china` VALUES ('130227', '迁西县', '130200'); INSERT INTO `china` VALUES ('130229', '⽟⽥县', '130200'); INSERT INTO `china` VALUES ('130230', '唐海县', '130200'); INSERT INTO `china` VALUES ('130281', '遵化市', '130200'); INSERT INTO `china` VALUES ('130283', '迁安市', '130200'); INSERT INTO `china` VALUES ('130300', '秦皇岛市', '130000'); INSERT INTO `china` VALUES ('130301', '海港区', '130300'); INSERT INTO `china` VALUES ('130303', '⼭海关区', '130300'); INSERT INTO `china` VALUES ('130304', '北戴河区', '130300'); INSERT INTO `china` VALUES ('130321', '青龙满族⾃治县', '130300'); INSERT INTO `china` VALUES ('130322', '昌黎县', '130300'); INSERT INTO `china` VALUES ('130323', '抚宁县', '130300'); INSERT INTO `china` VALUES ('130324', '卢龙县', '130300'); INSERT INTO `china` VALUES ('130400', '邯郸市', '130000'); INSERT INTO `china` VALUES ('130401', '市辖区', '130400'); INSERT INTO `china` VALUES ('130402', '邯⼭区', '130401'); INSERT INTO `china` VALUES ('130403', '丛台区', '130401'); INSERT INTO `china` VALUES ('130404', '复兴区', '130401'); INSERT INTO `china` VALUES ('130406', '峰峰矿区', '130401'); INSERT INTO `china` VALUES ('130421', '邯郸县', '130400'); INSERT INTO `china` VALUES ('130423', '临漳县', '130400'); INSERT INTO `china` VALUES ('130424', '成安县', '130400'); INSERT INTO `china` VALUES ('130425', '⼤名县', '130400'); INSERT INTO `china` VALUES ('130426', '涉县', '130400'); INSERT INTO `china` VALUES ('130427', '磁县', '130400'); INSERT INTO `china` VALUES ('130428', '肥乡县', '130400'); INSERT INTO `china` VALUES ('130429', '永年县', '130400'); INSERT INTO `china` VALUES ('130430', '邱县', '130400'); INSERT INTO `china` VALUES ('130431', '鸡泽县', '130400'); INSERT INTO `china` VALUES ('130432', '⼴平县', '130400'); INSERT INTO `china` VALUES ('130433', '馆陶县', '130400'); INSERT INTO `china` VALUES ('130434', '魏县', '130400'); INSERT INTO `china` VALUES ('130435', '曲周县', '130400'); INSERT INTO `china` VALUES ('130481', '武安市', '130400'); INSERT INTO `china` VALUES ('130500', '邢台市', '130000'); INSERT INTO `china` VALUES ('130501', '市辖区', '130500'); INSERT INTO `china` VALUES ('130502', '桥东区', '130501'); INSERT INTO `china` VALUES ('130503', '桥西区', '130501'); INSERT INTO `china` VALUES ('130521', '邢台县', '130500');INSERT INTO `china` VALUES ('130530', '新河县', '130500'); INSERT INTO `china` VALUES ('130531', '⼴宗县', '130500'); INSERT INTO `china` VALUES ('130532', '平乡县', '130500'); INSERT INTO `china` VALUES ('130533', '威县', '130500'); INSERT INTO `china` VALUES ('130534', '清河县', '130500'); INSERT INTO `china` VALUES ('130535', '临西县', '130500'); INSERT INTO `china` VALUES ('130581', '南宫市', '130500'); INSERT INTO `china` VALUES ('130582', '沙河市', '130500'); INSERT INTO `china` VALUES ('130600', '保定市', '130000'); INSERT INTO `china` VALUES ('130601', '新市区', '130600'); INSERT INTO `china` VALUES ('130603', '北市区', '130600'); INSERT INTO `china` VALUES ('130604', '南市区', '130600'); INSERT INTO `china` VALUES ('130621', '满城县', '130600'); INSERT INTO `china` VALUES ('130622', '清苑县', '130600'); INSERT INTO `china` VALUES ('130623', '涞⽔县', '130600'); INSERT INTO `china` VALUES ('130624', '⾩平县', '130600'); INSERT INTO `china` VALUES ('130625', '徐⽔县', '130600'); INSERT INTO `china` VALUES ('130626', '定兴县', '130600'); INSERT INTO `china` VALUES ('130627', '唐县', '130600'); INSERT INTO `china` VALUES ('130628', '⾼阳县', '130600'); INSERT INTO `china` VALUES ('130629', '容城县', '130600'); INSERT INTO `china` VALUES ('130630', '涞源县', '130600'); INSERT INTO `china` VALUES ('130631', '望都县', '130600'); INSERT INTO `china` VALUES ('130632', '安新县', '130600'); INSERT INTO `china` VALUES ('130633', '易县', '130600'); INSERT INTO `china` VALUES ('130634', '曲阳县', '130600'); INSERT INTO `china` VALUES ('130635', '蠡县', '130600'); INSERT INTO `china` VALUES ('130636', '顺平县', '130600'); INSERT INTO `china` VALUES ('130637', '博野县', '130600'); INSERT INTO `china` VALUES ('130638', '雄县', '130600'); INSERT INTO `china` VALUES ('130681', '涿州市', '130600'); INSERT INTO `china` VALUES ('130682', '定州市', '130600'); INSERT INTO `china` VALUES ('130683', '安国市', '130600'); INSERT INTO `china` VALUES ('130684', '⾼碑店市', '130600'); INSERT INTO `china` VALUES ('130685', '⽩沟新城县', '130600'); INSERT INTO `china` VALUES ('130700', '张家⼝市', '130000'); INSERT INTO `china` VALUES ('130701', '市辖区', '130700'); INSERT INTO `china` VALUES ('130702', '桥东区', '130701'); INSERT INTO `china` VALUES ('130703', '桥西区', '130701'); INSERT INTO `china` VALUES ('130705', '宣化区', '130701'); INSERT INTO `china` VALUES ('130706', '下花园区', '130701'); INSERT INTO `china` VALUES ('130721', '宣化县', '130700'); INSERT INTO `china` VALUES ('130722', '张北县', '130700'); INSERT INTO `china` VALUES ('130723', '康保县', '130700'); INSERT INTO `china` VALUES ('130724', '沽源县', '130700'); INSERT INTO `china` VALUES ('130725', '尚义县', '130700'); INSERT INTO `china` VALUES ('130726', '蔚县', '130700'); INSERT INTO `china` VALUES ('130727', '阳原县', '130700'); INSERT INTO `china` VALUES ('130728', '怀安县', '130700'); INSERT INTO `china` VALUES ('130729', '万全县', '130700'); INSERT INTO `china` VALUES ('130730', '怀来县', '130700'); INSERT INTO `china` VALUES ('130731', '涿⿅县', '130700'); INSERT INTO `china` VALUES ('130732', '⾚城县', '130700'); INSERT INTO `china` VALUES ('130733', '崇礼县', '130700'); INSERT INTO `china` VALUES ('130800', '承德市', '130000'); INSERT INTO `china` VALUES ('130801', '市辖区', '130800'); INSERT INTO `china` VALUES ('130802', '双桥区', '130801'); INSERT INTO `china` VALUES ('130803', '双滦区', '130801'); INSERT INTO `china` VALUES ('130804', '鹰⼿营⼦矿区', '130801'); INSERT INTO `china` VALUES ('130821', '承德县', '130800'); INSERT INTO `china` VALUES ('130822', '兴隆县', '130800'); INSERT INTO `china` VALUES ('130823', '平泉县', '130800'); INSERT INTO `china` VALUES ('130824', '滦平县', '130800');INSERT INTO `china` VALUES ('130921', '沧县', '130900'); INSERT INTO `china` VALUES ('130922', '青县', '130900'); INSERT INTO `china` VALUES ('130923', '东光县', '130900'); INSERT INTO `china` VALUES ('130924', '海兴县', '130900'); INSERT INTO `china` VALUES ('130925', '盐⼭县', '130900'); INSERT INTO `china` VALUES ('130926', '肃宁县', '130900'); INSERT INTO `china` VALUES ('130927', '南⽪县', '130900'); INSERT INTO `china` VALUES ('130928', '吴桥县', '130900'); INSERT INTO `china` VALUES ('130929', '献县', '130900'); INSERT INTO `china` VALUES ('130930', '孟村回族⾃治县', '130900'); INSERT INTO `china` VALUES ('130981', '泊头市', '130900'); INSERT INTO `china` VALUES ('130982', '任丘市', '130900'); INSERT INTO `china` VALUES ('130983', '黄骅市', '130900'); INSERT INTO `china` VALUES ('130984', '河间市', '130900'); INSERT INTO `china` VALUES ('131000', '廊坊市', '130000'); INSERT INTO `china` VALUES ('131001', '市辖区', '131000'); INSERT INTO `china` VALUES ('131002', '安次区', '131001'); INSERT INTO `china` VALUES ('131003', '⼴阳区', '131001'); INSERT INTO `china` VALUES ('131022', '固安县', '131000'); INSERT INTO `china` VALUES ('131023', '永清县', '131000'); INSERT INTO `china` VALUES ('131024', '⾹河县', '131000'); INSERT INTO `china` VALUES ('131025', '⼤城县', '131000'); INSERT INTO `china` VALUES ('131026', '⽂安县', '131000'); INSERT INTO `china` VALUES ('131028', '⼤⼚回族⾃治县', '131000'); INSERT INTO `china` VALUES ('131081', '霸州市', '131000'); INSERT INTO `china` VALUES ('131082', '三河市', '131000'); INSERT INTO `china` VALUES ('131100', '衡⽔市', '130000'); INSERT INTO `china` VALUES ('131101', '市辖区', '131100'); INSERT INTO `china` VALUES ('131102', '桃城区', '131101'); INSERT INTO `china` VALUES ('131121', '枣强县', '131100'); INSERT INTO `china` VALUES ('131122', '武⾢县', '131100'); INSERT INTO `china` VALUES ('131123', '武强县', '131100'); INSERT INTO `china` VALUES ('131124', '饶阳县', '131100'); INSERT INTO `china` VALUES ('131125', '安平县', '131100'); INSERT INTO `china` VALUES ('131126', '故城县', '131100'); INSERT INTO `china` VALUES ('131127', '景县', '131100'); INSERT INTO `china` VALUES ('131128', '⾩城县', '131100'); INSERT INTO `china` VALUES ('131181', '冀州市', '131100'); INSERT INTO `china` VALUES ('131182', '深州市', '131100'); INSERT INTO `china` VALUES ('140000', '⼭西省', '0');INSERT INTO `china` VALUES ('140100', '太原市', '140000'); INSERT INTO `china` VALUES ('140101', '市辖区', '140100'); INSERT INTO `china` VALUES ('140105', '⼩店区', '140101'); INSERT INTO `china` VALUES ('140106', '迎泽区', '140101'); INSERT INTO `china` VALUES ('140107', '杏花岭区', '140101'); INSERT INTO `china` VALUES ('140108', '尖草坪区', '140101'); INSERT INTO `china` VALUES ('140109', '万柏林区', '140101'); INSERT INTO `china` VALUES ('140110', '晋源区', '140101'); INSERT INTO `china` VALUES ('140121', '清徐县', '140100'); INSERT INTO `china` VALUES ('140122', '阳曲县', '140100'); INSERT INTO `china` VALUES ('140123', '娄烦县', '140100'); INSERT INTO `china` VALUES ('140181', '古交市', '140100'); INSERT INTO `china` VALUES ('140200', '⼤同市', '140000'); INSERT INTO `china` VALUES ('140201', '市辖区', '140200'); INSERT INTO `china` VALUES ('140202', '城区', '140201'); INSERT INTO `china` VALUES ('140203', '矿区', '140201'); INSERT INTO `china` VALUES ('140211', '南郊区', '140201'); INSERT INTO `china` VALUES ('140212', '新荣区', '140201'); INSERT INTO `china` VALUES ('140221', '阳⾼县', '140200'); INSERT INTO `china` VALUES ('140222', '天镇县', '140200'); INSERT INTO `china` VALUES ('140223', '⼴灵县', '140200'); INSERT INTO `china` VALUES ('140224', '灵丘县', '140200'); INSERT INTO `china` VALUES ('140225', '浑源县', '140200');INSERT INTO `china` VALUES ('140322', '盂县', '140300'); INSERT INTO `china` VALUES ('140400', '长治市', '140000'); INSERT INTO `china` VALUES ('140401', '市辖区', '140400'); INSERT INTO `china` VALUES ('140402', '城区', '140401'); INSERT INTO `china` VALUES ('140411', '郊区', '140401'); INSERT INTO `china` VALUES ('140421', '长治县', '140400'); INSERT INTO `china` VALUES ('140423', '襄垣县', '140400'); INSERT INTO `china` VALUES ('140424', '屯留县', '140400'); INSERT INTO `china` VALUES ('140425', '平顺县', '140400'); INSERT INTO `china` VALUES ('140426', '黎城县', '140400'); INSERT INTO `china` VALUES ('140427', '壶关县', '140400'); INSERT INTO `china` VALUES ('140428', '长⼦县', '140400'); INSERT INTO `china` VALUES ('140429', '武乡县', '140400'); INSERT INTO `china` VALUES ('140430', '沁县', '140400'); INSERT INTO `china` VALUES ('140431', '沁源县', '140400'); INSERT INTO `china` VALUES ('140481', '潞城市', '140400'); INSERT INTO `china` VALUES ('140500', '晋城市', '140000'); INSERT INTO `china` VALUES ('140501', '市辖区', '140500'); INSERT INTO `china` VALUES ('140502', '城区', '140501'); INSERT INTO `china` VALUES ('140521', '沁⽔县', '140500'); INSERT INTO `china` VALUES ('140522', '阳城县', '140500'); INSERT INTO `china` VALUES ('140524', '陵川县', '140500'); INSERT INTO `china` VALUES ('140525', '泽州县', '140500'); INSERT INTO `china` VALUES ('140581', '⾼平市', '140500'); INSERT INTO `china` VALUES ('140600', '朔州市', '140000'); INSERT INTO `china` VALUES ('140601', '市辖区', '140600'); INSERT INTO `china` VALUES ('140602', '朔城区', '140601'); INSERT INTO `china` VALUES ('140603', '平鲁区', '140601'); INSERT INTO `china` VALUES ('140621', '⼭阴县', '140600'); INSERT INTO `china` VALUES ('140622', '应县', '140600'); INSERT INTO `china` VALUES ('140623', '右⽟县', '140600'); INSERT INTO `china` VALUES ('140624', '怀仁县', '140600'); INSERT INTO `china` VALUES ('140700', '晋中市', '140000'); INSERT INTO `china` VALUES ('140701', '市辖区', '140700'); INSERT INTO `china` VALUES ('140702', '榆次区', '140701'); INSERT INTO `china` VALUES ('140721', '榆社县', '140700'); INSERT INTO `china` VALUES ('140722', '左权县', '140700'); INSERT INTO `china` VALUES ('140723', '和顺县', '140700'); INSERT INTO `china` VALUES ('140724', '昔阳县', '140700'); INSERT INTO `china` VALUES ('140725', '寿阳县', '140700'); INSERT INTO `china` VALUES ('140726', '太⾕县', '140700'); INSERT INTO `china` VALUES ('140727', '祁县', '140700'); INSERT INTO `china` VALUES ('140728', '平遥县', '140700'); INSERT INTO `china` VALUES ('140729', '灵⽯县', '140700'); INSERT INTO `china` VALUES ('140781', '介休市', '140700'); INSERT INTO `china` VALUES ('140800', '运城市', '140000'); INSERT INTO `china` VALUES ('140801', '市辖区', '140800'); INSERT INTO `china` VALUES ('140802', '盐湖区', '140801'); INSERT INTO `china` VALUES ('140821', '临猗县', '140800'); INSERT INTO `china` VALUES ('140822', '万荣县', '140800'); INSERT INTO `china` VALUES ('140823', '闻喜县', '140800'); INSERT INTO `china` VALUES ('140824', '稷⼭县', '140800'); INSERT INTO `china` VALUES ('140825', '新绛县', '140800'); INSERT INTO `china` VALUES ('140826', '绛县', '140800'); INSERT INTO `china` VALUES ('140827', '垣曲县', '140800'); INSERT INTO `china` VALUES ('140828', '夏县', '140800'); INSERT INTO `china` VALUES ('140829', '平陆县', '140800'); INSERT INTO `china` VALUES ('140830', '芮城县', '140800'); INSERT INTO `china` VALUES ('140881', '永济市', '140800'); INSERT INTO `china` VALUES ('140882', '河津市', '140800'); INSERT INTO `china` VALUES ('140900', '忻州市', '140000'); INSERT INTO `china` VALUES ('140901', '忻府区', '140900'); INSERT INTO `china` VALUES ('140921', '定襄县', '140900');INSERT INTO `china` VALUES ('140930', '河曲县', '140900');INSERT INTO `china` VALUES ('140931', '保德县', '140900');INSERT INTO `china` VALUES ('140932', '偏关县', '140900');INSERT INTO `china` VALUES ('140981', '原平市', '140900');INSERT INTO `china` VALUES ('141000', '临汾市', '140000');INSERT INTO `china` VALUES ('141001', '市辖区', '141000');INSERT INTO `china` VALUES ('141002', '尧都区', '141000');INSERT INTO `china` VALUES ('141021', '曲沃县', '141000');INSERT INTO `china` VALUES ('141022', '翼城县', '141000');INSERT INTO `china` VALUES ('141023', '襄汾县', '141000');INSERT INTO `china` VALUES ('141024', '洪洞县', '141000');INSERT INTO `china` VALUES ('141025', '古县', '141000');INSERT INTO `china` VALUES ('141026', '安泽县', '141000');INSERT INTO `china` VALUES ('141027', '浮⼭县', '141000');INSERT INTO `china` VALUES ('141028', '吉县', '141000');INSERT INTO `china` VALUES ('141029', '乡宁县', '141000');INSERT INTO `china` VALUES ('141030', '⼤宁县', '141000');INSERT INTO `china` VALUES ('141031', '隰县', '141000');INSERT INTO `china` VALUES ('141032', '永和县', '141000');INSERT INTO `china` VALUES ('141033', '蒲县', '141000');INSERT INTO `china` VALUES ('141034', '汾西县', '141000');INSERT INTO `china` VALUES ('141081', '侯马市', '141000');INSERT INTO `china` VALUES ('141082', '霍州市', '141000');INSERT INTO `china` VALUES ('141100', '吕梁市', '140000');INSERT INTO `china` VALUES ('141101', '市辖区', '141100');INSERT INTO `china` VALUES ('141102', '离⽯区', '141101');INSERT INTO `china` VALUES ('141121', '⽂⽔县', '141100');INSERT INTO `china` VALUES ('141122', '交城县', '141100');INSERT INTO `china` VALUES ('141123', '兴县', '141100');INSERT INTO `china` VALUES ('141124', '临县', '141100');INSERT INTO `china` VALUES ('141125', '柳林县', '141100');INSERT INTO `china` VALUES ('141126', '⽯楼县', '141100');INSERT INTO `china` VALUES ('141127', '岚县', '141100');INSERT INTO `china` VALUES ('141128', '⽅⼭县', '141100');INSERT INTO `china` VALUES ('141129', '中阳县', '141100');INSERT INTO `china` VALUES ('141130', '交⼝县', '141100');INSERT INTO `china` VALUES ('141181', '孝义市', '141100');INSERT INTO `china` VALUES ('141182', '汾阳市', '141100');INSERT INTO `china` VALUES ('150000', '内蒙古⾃治区', '0');INSERT INTO `china` VALUES ('150100', '呼和浩特市', '150000'); INSERT INTO `china` VALUES ('150101', '市辖区', '150100');INSERT INTO `china` VALUES ('150102', '新城区', '150101');INSERT INTO `china` VALUES ('150103', '回民区', '150101');INSERT INTO `china` VALUES ('150104', '⽟泉区', '150101');INSERT INTO `china` VALUES ('150105', '赛罕区', '150101');INSERT INTO `china` VALUES ('150121', '⼟默特左旗', '150100'); INSERT INTO `china` VALUES ('150122', '托克托县', '150100'); INSERT INTO `china` VALUES ('150123', '和林格尔县', '150100'); INSERT INTO `china` VALUES ('150124', '清⽔河县', '150100'); INSERT INTO `china` VALUES ('150125', '武川县', '150100');INSERT INTO `china` VALUES ('150200', '包头市', '150000');INSERT INTO `china` VALUES ('150201', '市辖区', '150200');INSERT INTO `china` VALUES ('150202', '东河区', '150201');INSERT INTO `china` VALUES ('150203', '昆都仑区', '150201'); INSERT INTO `china` VALUES ('150204', '青⼭区', '150201');INSERT INTO `china` VALUES ('150205', '⽯拐区', '150201');INSERT INTO `china` VALUES ('150206', '⽩云矿区', '150201'); INSERT INTO `china` VALUES ('150207', '九原区', '150201');INSERT INTO `china` VALUES ('150221', '⼟默特右旗', '150200'); INSERT INTO `china` VALUES ('150222', '固阳县', '150200');INSERT INTO `china` VALUES ('150223', '达尔罕茂明安联合旗', '150200'); INSERT INTO `china` VALUES ('150300', '乌海市', '150000');INSERT INTO `china` VALUES ('150301', '市辖区', '150300');。

中华⼈民共和国⾏政区划：省级（省份直辖市⾃治区）、地级（城市）、县级（区县）、乡级（乡镇街。

zoning
中华⼈民共和国⾏政区划：省级、地级、县级、乡级和村级
来源
国家统计局 - 统计⽤区划和城乡划分代码
统计数据截⽌2020-06-30 于 2020-11-06发布
使⽤
打开页⾯
打开浏览器控制台（推荐Chrome、Firefox，请不要⽤IE系列，谢谢）
拷贝脚本zoning.js的内容粘贴到控制台运⾏
⾸次抓取会出现⼤量失败请求，再次抓取会从浏览器缓存获取，⾮常快
Chrome⽐较快，会出现⼏个链接抓取失败
Firefox⽐较稳定，抓取有保障，内存占⽤⾼（推荐，测试版本：61.0.2 64-bit）
build.html⽤于导出的JSON⽂件⽣成SQLite和CSV
CSV导出编码为utf-8，Excel打开中⽂会乱码，需要转换编码为ANSI或指定BOM
、、
发布
⽀持的格式有：JSON⽂件、SQLite数据库、CSV⽂件、SQL脚本
zoning-*.json所有数据，zoning-*.db SQLite数据库，zoning-*.csv CSV⽂件，zoning-*.sql SQL脚本
dist/zoning-5五级
dist/zoning-4四级
dist/zoning-3三级
npm，npm install zoningjs，。

/*Navicat MySQL Data TransferSource Server : benjiSource Server Version : 50718Source Host : localhost:3306Source Database : haiyanTarget Server Type : MYSQLTarget Server Version : 50718File Encoding : 65001Date: 2019-12-09 14:01:12*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for `tb_city_codes`-- ----------------------------DROP TABLE IF EXISTS `tb_city_codes`;CREATE TABLE `tb_city_codes` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(50) DEFAULT NULL,`code` int(11) DEFAULT NULL,`level` int(11) DEFAULT NULL,`pid` int(11) DEFAULT NULL,`pid_name` varchar(50) DEFAULT NULL,`parent_id` int(11) DEFAULT NULL,`parent_name` varchar(50) DEFAULT NULL,`create_time` varchar(500) DEFAULT NULL,`status` int(11) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=418 DEFAULT CHARSET=utf8;-- ------------------------------ Records of tb_city_codes-- ----------------------------INSERT INTO `tb_city_codes` VALUES ('1', '北京', '110000', '1', '0', '北京', '110000', '北京', '20 INSERT INTO `tb_city_codes` VALUES ('2', '北京市', '110000', '2', '110000', '北京', '110000', '北京INSERT INTO `tb_city_codes` VALUES ('3', '天津', '120000', '1', '0', '天津', '120000', '天津', '20 INSERT INTO `tb_city_codes` VALUES ('4', '天津市', '120000', '2', '120000', '天津', '120000', '天津INSERT INTO `tb_city_codes` VALUES ('5', '河北省', '130000', '1', '0', '河北省', '130000', '河北省INSERT INTO `tb_city_codes` VALUES ('6', '石家庄市', '130100', '2', '130000', '河北省', '130000', INSERT INTO `tb_city_codes` VALUES ('7', '唐山市', '130200', '2', '130000', '河北省', '130000', '河INSERT INTO `tb_city_codes` VALUES ('8', '秦皇岛市', '130300', '2', '130000', '河北省', '130000', INSERT INTO `tb_city_codes` VALUES ('9', '邯郸市', '130400', '2', '130000', '河北省', '130000', '河INSERT INTO `tb_city_codes` VALUES ('10', '邢台市', '130500', '2', '130000', '河北省', '130000', ' INSERT INTO `tb_city_codes` VALUES ('11', '保定市', '130600', '2', '130000', '河北省', '130000', ' INSERT INTO `tb_city_codes` VALUES ('12', '张家口市', '130700', '2', '130000', '河北省', '130000', INSERT INTO `tb_city_codes` VALUES ('13', '承德市', '130800', '2', '130000', '河北省', '130000', 'INSERT INTO `tb_city_codes` VALUES ('15', '廊坊市', '131000', '2', '130000', '河北省', '130000', ' INSERT INTO `tb_city_codes` VALUES ('16', '衡水市', '131100', '2', '130000', '河北省', '130000', ' INSERT INTO `tb_city_codes` VALUES ('17', '山西省', '140000', '1', '0', '山西省', '140000', '山西省INSERT INTO `tb_city_codes` VALUES ('18', '太原市', '140100', '2', '140000', '山西省', '140000', ' INSERT INTO `tb_city_codes` VALUES ('19', '大同市', '140200', '2', '140000', '山西省', '140000', ' INSERT INTO `tb_city_codes` VALUES ('20', '阳泉市', '140300', '2', '140000', '山西省', '140000', ' INSERT INTO `tb_city_codes` VALUES ('21', '长治市', '140400', '2', '140000', '山西省', '140000', ' INSERT INTO `tb_city_codes` VALUES ('22', '晋城市', '140500', '2', '140000', '山西省', '140000', ' INSERT INTO `tb_city_codes` VALUES ('23', '朔州市', '140600', '2', '140000', '山西省', '140000', ' INSERT INTO `tb_city_codes` VALUES ('24', '晋中市', '140700', '2', '140000', '山西省', '140000', ' INSERT INTO `tb_city_codes` VALUES ('25', '运城市', '140800', '2', '140000', '山西省', '140000', ' INSERT INTO `tb_city_codes` VALUES ('26', '忻州市', '140900', '2', '140000', '山西省', '140000', ' INSERT INTO `tb_city_codes` VALUES ('27', '临汾市', '141000', '2', '140000', '山西省', '140000', ' INSERT INTO `tb_city_codes` VALUES ('28', '吕梁市', '141100', '2', '140000', '山西省', '140000', ' INSERT INTO `tb_city_codes` VALUES ('29', '内蒙古自治区', '150000', '1', '0', '内蒙古自治区', '150 INSERT INTO `tb_city_codes` VALUES ('30', '呼和浩特市', '150100', '2', '150000', '内蒙古自治区', ' INSERT INTO `tb_city_codes` VALUES ('31', '包头市', '150200', '2', '150000', '内蒙古自治区', '1500 INSERT INTO `tb_city_codes` VALUES ('32', '乌海市', '150300', '2', '150000', '内蒙古自治区', '1500 INSERT INTO `tb_city_codes` VALUES ('33', '赤峰市', '150400', '2', '150000', '内蒙古自治区', '1500 INSERT INTO `tb_city_codes` VALUES ('34', '通辽市', '150500', '2', '150000', '内蒙古自治区', '1500 INSERT INTO `tb_city_codes` VALUES ('35', '鄂尔多斯市', '150600', '2', '150000', '内蒙古自治区', ' INSERT INTO `tb_city_codes` VALUES ('36', '呼伦贝尔市', '150700', '2', '150000', '内蒙古自治区', ' INSERT INTO `tb_city_codes` VALUES ('37', '巴彦淖尔市', '150800', '2', '150000', '内蒙古自治区', ' INSERT INTO `tb_city_codes` VALUES ('38', '乌兰察布市', '150900', '2', '150000', '内蒙古自治区', ' INSERT INTO `tb_city_codes` VALUES ('39', '兴安盟', '152200', '2', '150000', '内蒙古自治区', '1500 INSERT INTO `tb_city_codes` VALUES ('40', '锡林郭勒盟', '152500', '2', '150000', '内蒙古自治区', ' INSERT INTO `tb_city_codes` VALUES ('41', '阿拉善盟', '152900', '2', '150000', '内蒙古自治区', '15 INSERT INTO `tb_city_codes` VALUES ('42', '辽宁省', '210000', '1', '0', '辽宁省', '210000', '辽宁省INSERT INTO `tb_city_codes` VALUES ('43', '沈阳市', '210100', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('44', '大连市', '210200', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('45', '鞍山市', '210300', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('46', '抚顺市', '210400', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('47', '本溪市', '210500', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('48', '丹东市', '210600', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('49', '锦州市', '210700', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('50', '营口市', '210800', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('51', '阜新市', '210900', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('52', '辽阳市', '211000', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('53', '盘锦市', '211100', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('54', '铁岭市', '211200', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('55', '朝阳市', '211300', '2', '210000', '辽宁省', '210000', ' INSERT INTO `tb_city_codes` VALUES ('56', '葫芦岛市', '211400', '2', '210000', '辽宁省', '210000', INSERT INTO `tb_city_codes` VALUES ('57', '吉林省', '220000', '1', '0', '吉林省', '220000', '吉林省INSERT INTO `tb_city_codes` VALUES ('58', '长春市', '220100', '2', '220000', '吉林省', '220000', ' INSERT INTO `tb_city_codes` VALUES ('59', '吉林市', '220200', '2', '220000', '吉林省', '220000', ' INSERT INTO `tb_city_codes` VALUES ('60', '四平市', '220300', '2', '220000', '吉林省', '220000', ' INSERT INTO `tb_city_codes` VALUES ('61', '辽源市', '220400', '2', '220000', '吉林省', '220000', ' INSERT INTO `tb_city_codes` VALUES ('62', '通化市', '220500', '2', '220000', '吉林省', '220000', ' INSERT INTO `tb_city_codes` VALUES ('63', '白山市', '220600', '2', '220000', '吉林省', '220000', ' INSERT INTO `tb_city_codes` VALUES ('64', '松原市', '220700', '2', '220000', '吉林省', '220000', 'INSERT INTO `tb_city_codes` VALUES ('66', '延边朝鲜族自治州', '222400', '2', '220000', '吉林省', ' INSERT INTO `tb_city_codes` VALUES ('67', '黑龙江省', '230000', '1', '0', '黑龙江省', '230000', '黑INSERT INTO `tb_city_codes` VALUES ('68', '哈尔滨市', '230100', '2', '230000', '黑龙江省', '230000 INSERT INTO `tb_city_codes` VALUES ('69', '齐齐哈尔市', '230200', '2', '230000', '黑龙江省', '2300 INSERT INTO `tb_city_codes` VALUES ('70', '鸡西市', '230300', '2', '230000', '黑龙江省', '230000', INSERT INTO `tb_city_codes` VALUES ('71', '鹤岗市', '230400', '2', '230000', '黑龙江省', '230000', INSERT INTO `tb_city_codes` VALUES ('72', '双鸭山市', '230500', '2', '230000', '黑龙江省', '230000 INSERT INTO `tb_city_codes` VALUES ('73', '大庆市', '230600', '2', '230000', '黑龙江省', '230000', INSERT INTO `tb_city_codes` VALUES ('74', '伊春市', '230700', '2', '230000', '黑龙江省', '230000', INSERT INTO `tb_city_codes` VALUES ('75', '佳木斯市', '230800', '2', '230000', '黑龙江省', '230000 INSERT INTO `tb_city_codes` VALUES ('76', '七台河市', '230900', '2', '230000', '黑龙江省', '230000 INSERT INTO `tb_city_codes` VALUES ('77', '牡丹江市', '231000', '2', '230000', '黑龙江省', '230000 INSERT INTO `tb_city_codes` VALUES ('78', '黑河市', '231100', '2', '230000', '黑龙江省', '230000', INSERT INTO `tb_city_codes` VALUES ('79', '绥化市', '231200', '2', '230000', '黑龙江省', '230000', INSERT INTO `tb_city_codes` VALUES ('80', '大兴安岭地区', '232700', '2', '230000', '黑龙江省', '23 INSERT INTO `tb_city_codes` VALUES ('81', '上海', '310000', '1', '0', '上海', '310000', '上海', '2 INSERT INTO `tb_city_codes` VALUES ('82', '上海市', '310000', '2', '310000', '上海', '310000', '上INSERT INTO `tb_city_codes` VALUES ('83', '江苏省', '320000', '1', '0', '江苏省', '320000', '江苏省INSERT INTO `tb_city_codes` VALUES ('84', '南京市', '320100', '2', '320000', '江苏省', '320000', ' INSERT INTO `tb_city_codes` VALUES ('85', '无锡市', '320200', '2', '320000', '江苏省', '320000', ' INSERT INTO `tb_city_codes` VALUES ('86', '徐州市', '320300', '2', '320000', '江苏省', '320000', ' INSERT INTO `tb_city_codes` VALUES ('87', '常州市', '320400', '2', '320000', '江苏省', '320000', ' INSERT INTO `tb_city_codes` VALUES ('88', '苏州市', '320500', '2', '320000', '江苏省', '320000', ' INSERT INTO `tb_city_codes` VALUES ('89', '南通市', '320600', '2', '320000', '江苏省', '320000', ' INSERT INTO `tb_city_codes` VALUES ('90', '连云港市', '320700', '2', '320000', '江苏省', '320000', INSERT INTO `tb_city_codes` VALUES ('91', '淮安市', '320800', '2', '320000', '江苏省', '320000', ' INSERT INTO `tb_city_codes` VALUES ('92', '盐城市', '320900', '2', '320000', '江苏省', '320000', ' INSERT INTO `tb_city_codes` VALUES ('93', '扬州市', '321000', '2', '320000', '江苏省', '320000', ' INSERT INTO `tb_city_codes` VALUES ('94', '镇江市', '321100', '2', '320000', '江苏省', '320000', ' INSERT INTO `tb_city_codes` VALUES ('95', '泰州市', '321200', '2', '320000', '江苏省', '320000', ' INSERT INTO `tb_city_codes` VALUES ('96', '宿迁市', '321300', '2', '320000', '江苏省', '320000', ' INSERT INTO `tb_city_codes` VALUES ('97', '浙江省', '330000', '1', '0', '浙江省', '330000', '浙江省INSERT INTO `tb_city_codes` VALUES ('98', '杭州市', '330100', '2', '330000', '浙江省', '330000', ' INSERT INTO `tb_city_codes` VALUES ('99', '宁波市', '330200', '2', '330000', '浙江省', '330000', ' INSERT INTO `tb_city_codes` VALUES ('100', '温州市', '330300', '2', '330000', '浙江省', '330000', INSERT INTO `tb_city_codes` VALUES ('101', '嘉兴市', '330400', '2', '330000', '浙江省', '330000', INSERT INTO `tb_city_codes` VALUES ('102', '湖州市', '330500', '2', '330000', '浙江省', '330000', INSERT INTO `tb_city_codes` VALUES ('103', '绍兴市', '330600', '2', '330000', '浙江省', '330000', INSERT INTO `tb_city_codes` VALUES ('104', '金华市', '330700', '2', '330000', '浙江省', '330000', INSERT INTO `tb_city_codes` VALUES ('105', '衢州市', '330800', '2', '330000', '浙江省', '330000', INSERT INTO `tb_city_codes` VALUES ('106', '舟山市', '330900', '2', '330000', '浙江省', '330000', INSERT INTO `tb_city_codes` VALUES ('107', '台州市', '331000', '2', '330000', '浙江省', '330000', INSERT INTO `tb_city_codes` VALUES ('108', '丽水市', '331100', '2', '330000', '浙江省', '330000', INSERT INTO `tb_city_codes` VALUES ('109', '安徽省', '340000', '1', '0', '安徽省', '340000', '安徽INSERT INTO `tb_city_codes` VALUES ('110', '合肥市', '340100', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('111', '芜湖市', '340200', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('112', '蚌埠市', '340300', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('113', '淮南市', '340400', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('114', '马鞍山市', '340500', '2', '340000', '安徽省', '340000' INSERT INTO `tb_city_codes` VALUES ('115', '淮北市', '340600', '2', '340000', '安徽省', '340000',INSERT INTO `tb_city_codes` VALUES ('117', '安庆市', '340800', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('118', '黄山市', '341000', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('119', '滁州市', '341100', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('120', '阜阳市', '341200', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('121', '宿州市', '341300', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('122', '六安市', '341500', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('123', '亳州市', '341600', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('124', '池州市', '341700', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('125', '宣城市', '341800', '2', '340000', '安徽省', '340000', INSERT INTO `tb_city_codes` VALUES ('126', '福建省', '350000', '1', '0', '福建省', '350000', '福建INSERT INTO `tb_city_codes` VALUES ('127', '福州市', '350100', '2', '350000', '福建省', '350000', INSERT INTO `tb_city_codes` VALUES ('128', '厦门市', '350200', '2', '350000', '福建省', '350000', INSERT INTO `tb_city_codes` VALUES ('129', '莆田市', '350300', '2', '350000', '福建省', '350000', INSERT INTO `tb_city_codes` VALUES ('130', '三明市', '350400', '2', '350000', '福建省', '350000', INSERT INTO `tb_city_codes` VALUES ('131', '泉州市', '350500', '2', '350000', '福建省', '350000', INSERT INTO `tb_city_codes` VALUES ('132', '漳州市', '350600', '2', '350000', '福建省', '350000', INSERT INTO `tb_city_codes` VALUES ('133', '南平市', '350700', '2', '350000', '福建省', '350000', INSERT INTO `tb_city_codes` VALUES ('134', '龙岩市', '350800', '2', '350000', '福建省', '350000', INSERT INTO `tb_city_codes` VALUES ('135', '宁德市', '350900', '2', '350000', '福建省', '350000', INSERT INTO `tb_city_codes` VALUES ('136', '江西省', '360000', '1', '0', '江西省', '360000', '江西INSERT INTO `tb_city_codes` VALUES ('137', '南昌市', '360100', '2', '360000', '江西省', '360000', INSERT INTO `tb_city_codes` VALUES ('138', '景德镇市', '360200', '2', '360000', '江西省', '360000' INSERT INTO `tb_city_codes` VALUES ('139', '萍乡市', '360300', '2', '360000', '江西省', '360000', INSERT INTO `tb_city_codes` VALUES ('140', '九江市', '360400', '2', '360000', '江西省', '360000', INSERT INTO `tb_city_codes` VALUES ('141', '新余市', '360500', '2', '360000', '江西省', '360000', INSERT INTO `tb_city_codes` VALUES ('142', '鹰潭市', '360600', '2', '360000', '江西省', '360000', INSERT INTO `tb_city_codes` VALUES ('143', '赣州市', '360700', '2', '360000', '江西省', '360000', INSERT INTO `tb_city_codes` VALUES ('144', '吉安市', '360800', '2', '360000', '江西省', '360000', INSERT INTO `tb_city_codes` VALUES ('145', '宜春市', '360900', '2', '360000', '江西省', '360000', INSERT INTO `tb_city_codes` VALUES ('146', '抚州市', '361000', '2', '360000', '江西省', '360000', INSERT INTO `tb_city_codes` VALUES ('147', '上饶市', '361100', '2', '360000', '江西省', '360000', INSERT INTO `tb_city_codes` VALUES ('148', '山东省', '370000', '1', '0', '山东省', '370000', '山东INSERT INTO `tb_city_codes` VALUES ('149', '济南市', '370100', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('150', '青岛市', '370200', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('151', '淄博市', '370300', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('152', '枣庄市', '370400', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('153', '东营市', '370500', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('154', '烟台市', '370600', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('155', '潍坊市', '370700', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('156', '济宁市', '370800', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('157', '泰安市', '370900', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('158', '威海市', '371000', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('159', '日照市', '371100', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('160', '莱芜市', '371200', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('161', '临沂市', '371300', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('162', '德州市', '371400', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('163', '聊城市', '371500', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('164', '滨州市', '371600', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('165', '菏泽市', '371700', '2', '370000', '山东省', '370000', INSERT INTO `tb_city_codes` VALUES ('166', '河南省', '410000', '1', '0', '河南省', '410000', '河南INSERT INTO `tb_city_codes` VALUES ('168', '开封市', '410200', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('169', '洛阳市', '410300', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('170', '平顶山市', '410400', '2', '410000', '河南省', '410000' INSERT INTO `tb_city_codes` VALUES ('171', '安阳市', '410500', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('172', '鹤壁市', '410600', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('173', '新乡市', '410700', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('174', '焦作市', '410800', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('175', '濮阳市', '410900', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('176', '许昌市', '411000', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('177', '漯河市', '411100', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('178', '三门峡市', '411200', '2', '410000', '河南省', '410000' INSERT INTO `tb_city_codes` VALUES ('179', '南阳市', '411300', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('180', '商丘市', '411400', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('181', '信阳市', '411500', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('182', '周口市', '411600', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('183', '驻马店市', '411700', '2', '410000', '河南省', '410000' INSERT INTO `tb_city_codes` VALUES ('184', '济源市', '419001', '2', '410000', '河南省', '410000', INSERT INTO `tb_city_codes` VALUES ('185', '湖北省', '420000', '1', '0', '湖北省', '420000', '湖北INSERT INTO `tb_city_codes` VALUES ('186', '武汉市', '420100', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('187', '黄石市', '420200', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('188', '十堰市', '420300', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('189', '宜昌市', '420500', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('190', '襄阳市', '420600', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('191', '鄂州市', '420700', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('192', '荆门市', '420800', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('193', '孝感市', '420900', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('194', '荆州市', '421000', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('195', '黄冈市', '421100', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('196', '咸宁市', '421200', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('197', '随州市', '421300', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('198', '恩施土家族苗族自治州', '422800', '2', '420000', '湖北省INSERT INTO `tb_city_codes` VALUES ('199', '仙桃市', '429004', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('200', '潜江市', '429005', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('201', '天门市', '429006', '2', '420000', '湖北省', '420000', INSERT INTO `tb_city_codes` VALUES ('202', '神农架林区', '429021', '2', '420000', '湖北省', '42000 INSERT INTO `tb_city_codes` VALUES ('203', '湖南省', '430000', '1', '0', '湖南省', '430000', '湖南INSERT INTO `tb_city_codes` VALUES ('204', '长沙市', '430100', '2', '430000', '湖南省', '430000', INSERT INTO `tb_city_codes` VALUES ('205', '株洲市', '430200', '2', '430000', '湖南省', '430000', INSERT INTO `tb_city_codes` VALUES ('206', '湘潭市', '430300', '2', '430000', '湖南省', '430000', INSERT INTO `tb_city_codes` VALUES ('207', '衡阳市', '430400', '2', '430000', '湖南省', '430000', INSERT INTO `tb_city_codes` VALUES ('208', '邵阳市', '430500', '2', '430000', '湖南省', '430000', INSERT INTO `tb_city_codes` VALUES ('209', '岳阳市', '430600', '2', '430000', '湖南省', '430000', INSERT INTO `tb_city_codes` VALUES ('210', '常德市', '430700', '2', '430000', '湖南省', '430000', INSERT INTO `tb_city_codes` VALUES ('211', '张家界市', '430800', '2', '430000', '湖南省', '430000' INSERT INTO `tb_city_codes` VALUES ('212', '益阳市', '430900', '2', '430000', '湖南省', '430000', INSERT INTO `tb_city_codes` VALUES ('213', '郴州市', '431000', '2', '430000', '湖南省', '430000', INSERT INTO `tb_city_codes` VALUES ('214', '永州市', '431100', '2', '430000', '湖南省', '430000', INSERT INTO `tb_city_codes` VALUES ('215', '怀化市', '431200', '2', '430000', '湖南省', '430000', INSERT INTO `tb_city_codes` VALUES ('216', '娄底市', '431300', '2', '430000', '湖南省', '430000', INSERT INTO `tb_city_codes` VALUES ('217', '湘西土家族苗族自治州', '433100', '2', '430000', '湖南省。

sql_数据库__省市区_数据建表和数据预览说明:预览图片所展示的格式为文档的源格式展示,下载源文件没有水印,内容可编辑和复制-- 表的结构areaDROP TABLE Area;CREATE TABLE Area(ID int NOT NULL,AreaID int NOT NULL,AreaName varchar(200)NOT NULL,FatherID int NOT NULL,PRIMARY KEY (ID))DROP TABLE City;CREATE TABLE City(ID int NOT NULL,CityID int NOT NULL,CityName varchar(200)NOT NULL,FatherID int NOT NULL,PRIMARY KEY (ID))---- 导出表中的数据city---- ------------------------------------------------------------ 表的结构province--DROP TABLE Province;CREATE TABLE Province(ID int NOT NULL,ProvinceID int NOT NULL,ProvinceName varchar(200)NOT NULL,PRIMARY KEY (ID))insert Province(ID,ProvinceID,ProvinceName)select 1,110000,'北京市'unionselect 2,120000,'天津市'unionselect 3,130000,'河北省'unionselect 4,140000,'山西省'unionselect 5,150000,'内蒙古自治区'unionselect 6,210000,'辽宁省'unionselect 7,220000,'吉林省'unionselect 8,230000,'黑龙江省'unionselect 9,310000,'上海市'unionselect 10,320000,'江苏省'unionselect 11,330000,'浙江省'unionselect 12,340000,'安徽省'unionselect 13,350000,'福建省'unionselect 14,360000,'江西省'unionselect 15,370000,'山东省'unionselect 16,410000,'河南省'unionselect 17,420000,'湖北省'unionselect 18,430000,'湖南省'unionselect 19,440000,'广东省'unionselect 20,450000,'广西壮族自治区'union select 21,460000,'海南省'unionselect 22,500000,'重庆市'unionselect 23,510000,'四川省'unionselect 24,520000,'贵州省'unionselect 25,530000,'云南省'unionselect 26,540000,'西藏自治区'unionselect 27,610000,'陕西省'unionselect 28,620000,'甘肃省'unionselect 29,630000,'青海省'unionselect 30,640000,'宁夏回族自治区'union select 31,650000,'新疆维吾尔自治区'union select 32,710000,'台湾省'unionselect 33,810000,'香港特别行政区'union select 34,820000,'澳门特别行政区'INSERT City(ID,CityID,CityName,FatherID) select 1,110100,'市辖区',110000 union select 2,110200,'县',110000 union select 3,120100,'市辖区',120000 union select 4,120200,'县',120000 unionselect 5,130100,'石家庄市',130000 union select 6,130200,'唐山市',130000 union select 7,130300,'秦皇岛市',130000 union select 8,130400,'邯郸市',130000 union select 9,130500,'邢台市',130000 union select 10,130600,'保定市',130000 unionselect 12,130800,'承德市',130000 union select 13,130900,'沧州市',130000 union select 14,131000,'廊坊市',130000 union select 15,131100,'衡水市',130000 union select 16,140100,'太原市',140000 union select 17,140200,'大同市',140000 union select 18,140300,'阳泉市',140000 union select 19,140400,'长治市',140000 union select 20,140500,'晋城市',140000 union select 21,140600,'朔州市',140000 union select 22,140700,'晋中市',140000 union select 23,140800,'运城市',140000 union select 24,140900,'忻州市',140000 union select 25,141000,'临汾市',140000 union select 26,141100,'吕梁市',140000INSERT City (ID,CityID,CityName,FatherID) select 27,150100,'呼和浩特市',150000 union select 28,150200,'包头市',150000 union select 29,150300,'乌海市',150000 union select 30,150400,'赤峰市',150000 union select 31,150500,'通辽市',150000 union select 32,150600,'鄂尔多斯市',150000 union select 33,150700,'呼伦贝尔市',150000 union select 34,150800,'巴彦淖尔市',150000 union select 35,150900,'乌兰察布市',150000 union select 36,152200,'兴安盟',150000 union select 37,152500,'锡林郭勒盟',150000 union select 38,152900,'阿拉善盟',150000 union select 39,210100,'沈阳市',210000 union select 40,210200,'大连市',210000 union select 41,210300,'鞍山市',210000 union select 42,210400,'抚顺市',210000 union select 43,210500,'本溪市',210000 union select 44,210600,'丹东市',210000 union select 45,210700,'锦州市',210000 union select 46,210800,'营口市',210000 union select 47,210900,'阜新市',210000 union select 48,211000,'辽阳市',210000 union select 49,211100,'盘锦市',210000 union select 50,211200,'铁岭市',210000 union select 51,211300,'朝阳市',210000 unionselect 53,220100,'长春市',220000 unionselect 54,220200,'吉林市',220000 unionselect 55,220300,'四平市',220000 unionselect 56,220400,'辽源市',220000 unionselect 57,220500,'通化市',220000 unionselect 58,220600,'白山市',220000 unionselect 59,220700,'松原市',220000 unionselect 60,220800,'白城市',220000 unionselect 61,222400,'延边朝鲜族自治州',220000 union select 62,230100,'哈尔滨市',230000 unionselect 63,230200,'齐齐哈尔市',230000 union select 64,230300,'鸡西市',230000 unionselect 65,230400,'鹤岗市',230000 unionselect 66,230500,'双鸭山市',230000 unionselect 67,230600,'大庆市',230000 unionselect 68,230700,'伊春市',230000 unionselect 69,230800,'佳木斯市',230000 unionselect 70,230900,'七台河市',230000 unionselect 71,231000,'牡丹江市',230000 unionselect 72,231100,'黑河市',230000 unionselect 73,231200,'绥化市',230000 unionselect 74,232700,'大兴安岭地区',230000 union select 75,310100,'市辖区',310000 unionselect 76,310200,'县',310000 unionselect 77,320100,'南京市',320000 unionselect 78,320200,'无锡市',320000 unionselect 79,320300,'徐州市',320000 unionselect 80,320400,'常州市',320000 unionselect 81,320500,'苏州市',320000 unionselect 82,320600,'南通市',320000 unionselect 83,320700,'连云港市',320000 unionselect 84,320800,'淮安市',320000 unionselect 85,320900,'盐城市',320000 unionselect 86,321000,'扬州市',320000 unionselect 87,321100,'镇江市',320000 unionselect 88,321200,'泰州市',320000 unionselect 89,321300,'宿迁市',320000 unionselect 90,330100,'杭州市',330000 unionselect 91,330200,'宁波市',330000 unionselect 92,330300,'温州市',330000 unionselect 93,330400,'嘉兴市',330000 unionselect 94,330500,'湖州市',330000 unionselect 95,330600,'绍兴市',330000 unionselect 97,330800,'衢州市',330000 union select 98,330900,'舟山市',330000 union select 99,331000,'台州市',330000 union select 100,331100,'丽水市',330000 union select 101,340100,'合肥市',340000 union select 102,340200,'芜湖市',340000 union select 103,340300,'蚌埠市',340000 union select 104,340400,'淮南市',340000 union select 105,340500,'马鞍山市',340000 union select 106,340600,'淮北市',340000 union select 107,340700,'铜陵市',340000 union select 108,340800,'安庆市',340000 union select 109,341000,'黄山市',340000 union select 110,341100,'滁州市',340000 union select 111,341200,'阜阳市',340000 union select 112,341300,'宿州市',340000 union select 113,341400,'巢湖市',340000 union select 114,341500,'六安市',340000 union select 115,341600,'亳州市',340000 union select 116,341700,'池州市',340000 union select 117,341800,'宣城市',340000 union select 118,350100,'福州市',350000 union select 119,350200,'厦门市',350000 union select 120,350300,'莆田市',350000 union select 121,350400,'三明市',350000 union select 122,350500,'泉州市',350000 union select 123,350600,'漳州市',350000 union select 124,350700,'南平市',350000 union select 125,350800,'龙岩市',350000 union select 126,350900,'宁德市',350000INSERT City (ID,CityID,CityName,FatherID) select 127,360100,'南昌市',360000 union select 128,360200,'景德镇市',360000 union select 129,360300,'萍乡市',360000 union select 130,360400,'九江市',360000 union select 131,360500,'新余市',360000 union select 132,360600,'鹰潭市',360000 union select 133,360700,'赣州市',360000 union select 134,360800,'吉安市',360000 union select 135,360900,'宜春市',360000 union select 136,361000,'抚州市',360000 union select 137,361100,'上饶市',360000 unionselect 139,370200,'青岛市',370000 union select 140,370300,'淄博市',370000 union select 141,370400,'枣庄市',370000 union select 142,370500,'东营市',370000 union select 143,370600,'烟台市',370000 union select 144,370700,'潍坊市',370000 union select 145,370800,'济宁市',370000 union select 146,370900,'泰安市',370000 union select 147,371000,'威海市',370000 union select 148,371100,'日照市',370000 union select 149,371200,'莱芜市',370000 union select 150,371300,'临沂市',370000 union select 151,371400,'德州市',370000 union select 152,371500,'聊城市',370000 union select 153,371600,'滨州市',370000 union select 154,371700,'荷泽市',370000 union select 155,410100,'郑州市',410000 union select 156,410200,'开封市',410000 union select 157,410300,'洛阳市',410000 union select 158,410400,'平顶山市',410000 union select 159,410500,'安阳市',410000 union select 160,410600,'鹤壁市',410000 union select 161,410700,'新乡市',410000 union select 162,410800,'焦作市',410000 union select 163,410900,'濮阳市',410000 union select 164,411000,'许昌市',410000 union select 165,411100,'漯河市',410000 union select 166,411200,'三门峡市',410000 union select 167,411300,'南阳市',410000 union select 168,411400,'商丘市',410000 union select 169,411500,'信阳市',410000 union select 170,411600,'周口市',410000 union select 171,411700,'驻马店市',410000INSERT City (ID,CityID,CityName,FatherID) select 172,420100,'武汉市',420000 union select 173,420200,'黄石市',420000 union select 174,420300,'十堰市',420000 union select 175,420500,'宜昌市',420000 union select 176,420600,'襄樊市',420000 union select 177,420700,'鄂州市',420000 union select 178,420800,'荆门市',420000 unionselect 180,421000,'荆州市',420000 unionselect 181,421100,'黄冈市',420000 unionselect 182,421200,'咸宁市',420000 unionselect 183,421300,'随州市',420000 unionselect 184,422800,'恩施土家族苗族自治州',420000 union select 185,429000,'省直辖行政单位',420000 union select 186,430100,'长沙市',430000 unionselect 187,430200,'株洲市',430000 unionselect 188,430300,'湘潭市',430000 unionselect 189,430400,'衡阳市',430000 unionselect 190,430500,'邵阳市',430000 unionselect 191,430600,'岳阳市',430000 unionselect 192,430700,'常德市',430000 unionselect 193,430800,'张家界市',430000 unionselect 194,430900,'益阳市',430000 unionselect 195,431000,'郴州市',430000 unionselect 196,431100,'永州市',430000 unionselect 197,431200,'怀化市',430000 unionselect 198,431300,'娄底市',430000 unionselect 199,433100,'湘西土家族苗族自治州',430000 union select 200,440100,'广州市',440000 unionselect 201,440200,'韶关市',440000 unionselect 202,440300,'深圳市',440000 unionselect 203,440400,'珠海市',440000 unionselect 204,440500,'汕头市',440000 unionselect 205,440600,'佛山市',440000 unionselect 206,440700,'江门市',440000 unionselect 207,440800,'湛江市',440000 unionselect 208,440900,'茂名市',440000 unionselect 209,441200,'肇庆市',440000 unionselect 210,441300,'惠州市',440000 unionselect 211,441400,'梅州市',440000 unionselect 212,441500,'汕尾市',440000 unionselect 213,441600,'河源市',440000 unionselect 214,441700,'阳江市',440000 unionselect 215,441800,'清远市',440000 unionselect 216,441900,'东莞市',440000 unionselect 217,442000,'中山市',440000 unionselect 218,445100,'潮州市',440000 unionselect 219,445200,'揭阳市',440000 unionselect 220,445300,'云浮市',440000 unionselect 221,450100,'南宁市',450000 unionselect 222,450200,'柳州市',450000 unionselect 224,450400,'梧州市',450000 unionselect 225,450500,'北海市',450000INSERT City (ID,CityID,CityName,FatherID)select 226,450600,'防城港市',450000 unionselect 227,450700,'钦州市',450000 unionselect 228,450800,'贵港市',450000 unionselect 229,450900,'玉林市',450000 unionselect 230,451000,'百色市',450000 unionselect 231,451100,'贺州市',450000 unionselect 232,451200,'河池市',450000 unionselect 233,451300,'来宾市',450000 unionselect 234,451400,'崇左市',450000 unionselect 235,460100,'海口市',460000 unionselect 236,460200,'三亚市',460000 unionselect 237,469000,'省直辖县级行政单位',460000 union select 238,500100,'市辖区',500000 unionselect 239,500200,'县',500000 unionselect 240,500300,'市',500000 unionselect 241,510100,'成都市',510000 unionselect 242,510300,'自贡市',510000 unionselect 243,510400,'攀枝花市',510000 unionselect 244,510500,'泸州市',510000 unionselect 245,510600,'德阳市',510000 unionselect 246,510700,'绵阳市',510000 unionselect 247,510800,'广元市',510000 unionselect 248,510900,'遂宁市',510000 unionselect 249,511000,'内江市',510000 unionselect 250,511100,'乐山市',510000 unionselect 251,511300,'南充市',510000 unionselect 252,511400,'眉山市',510000 unionselect 253,511500,'宜宾市',510000 unionselect 254,511600,'广安市',510000 unionselect 255,511700,'达州市',510000 unionselect 256,511800,'雅安市',510000 unionselect 257,511900,'巴中市',510000 unionselect 258,512000,'资阳市',510000 unionselect 259,513200,'阿坝藏族羌族自治州',510000 union select 260,513300,'甘孜藏族自治州',510000 union select 261,513400,'凉山彝族自治州',510000 union select 262,520100,'贵阳市',520000 unionselect 263,520200,'六盘水市',520000INSERT City (ID,CityID,CityName,FatherID)select 264,520300,'遵义市',520000 unionselect 265,520400,'安顺市',520000 unionselect 266,522200,'铜仁地区',520000 unionselect 267,522300,'黔西南布依族苗族自治州',520000 union select 268,522400,'毕节地区',520000 unionselect 269,522600,'黔东南苗族侗族自治州',520000 union select 270,522700,'黔南布依族苗族自治州',520000 union select 271,530100,'昆明市',530000 unionselect 272,530300,'曲靖市',530000 unionselect 273,530400,'玉溪市',530000 unionselect 274,530500,'保山市',530000 unionselect 275,530600,'昭通市',530000 unionselect 276,530700,'丽江市',530000 unionselect 277,530800,'思茅市',530000 unionselect 278,530900,'临沧市',530000 unionselect 279,532300,'楚雄彝族自治州',530000 unionselect 280,532500,'红河哈尼族彝族自治州',530000 union select 281,532600,'文山壮族苗族自治州',530000 union select 282,532800,'西双版纳傣族自治州',530000 union select 283,532900,'大理白族自治州',530000 unionselect 284,533100,'德宏傣族景颇族自治州',530000 union select 285,533300,'怒江傈僳族自治州',530000 union select 286,533400,'迪庆藏族自治州',530000 unionselect 287,540100,'拉萨市',540000 unionselect 288,542100,'昌都地区',540000 unionselect 289,542200,'山南地区',540000 unionselect 290,542300,'日喀则地区',540000 unionselect 291,542400,'那曲地区',540000 unionselect 292,542500,'阿里地区',540000 unionselect 293,542600,'林芝地区',540000INSERT City (ID,CityID,CityName,FatherID)select 294,610100,'西安市',610000 unionselect 295,610200,'铜川市',610000 unionselect 296,610300,'宝鸡市',610000 unionselect 297,610400,'咸阳市',610000 unionselect 298,610500,'渭南市',610000 unionselect 299,610600,'延安市',610000 unionselect 300,610700,'汉中市',610000 unionselect 301,610800,'榆林市',610000 unionselect 302,610900,'安康市',610000 unionselect 303,611000,'商洛市',610000 unionselect 304,620100,'兰州市',620000 unionselect 305,620200,'嘉峪关市',620000 unionselect 306,620300,'金昌市',620000 unionselect 307,620400,'白银市',620000 unionselect 308,620500,'天水市',620000 unionselect 309,620600,'武威市',620000 unionselect 310,620700,'张掖市',620000 unionselect 311,620800,'平凉市',620000 unionselect 312,620900,'酒泉市',620000 unionselect 313,621000,'庆阳市',620000 unionselect 314,621100,'定西市',620000 unionselect 315,621200,'陇南市',620000 unionselect 316,622900,'临夏回族自治州',620000 unionselect 317,623000,'甘南藏族自治州',620000 unionselect 318,630100,'西宁市',630000 unionselect 319,632100,'海东地区',630000 unionselect 320,632200,'海北藏族自治州',630000 unionselect 321,632300,'黄南藏族自治州',630000 unionselect 322,632500,'海南藏族自治州',630000 unionselect 323,632600,'果洛藏族自治州',630000 unionselect 324,632700,'玉树藏族自治州',630000INSERT City (ID,CityID,CityName,FatherID)select 325,632800,'海西蒙古族藏族自治州',630000 union select 326,640100,'银川市',640000 unionselect 327,640200,'石嘴山市',640000 unionselect 328,640300,'吴忠市',640000 unionselect 329,640400,'固原市',640000 unionselect 330,640500,'中卫市',640000 unionselect 331,650100,'乌鲁木齐市',650000 unionselect 332,650200,'克拉玛依市',650000 unionselect 333,652100,'吐鲁番地区',650000 unionselect 334,652200,'哈密地区',650000 unionselect 335,652300,'昌吉回族自治州',650000 unionselect 336,652700,'博尔塔拉蒙古自治州',650000 union select 337,652800,'巴音郭楞蒙古自治州',650000 union select 338,652900,'阿克苏地区',650000INSERT City (ID,CityID,CityName,FatherID)select 339,653000,'克孜勒苏柯尔克孜自治州',650000 union select 340,653100,'喀什地区',650000 unionselect 341,653200,'和田地区',650000 unionselect 342,654000,'伊犁哈萨克自治州',650000 union select 343,654200,'塔城地区',650000 unionselect 344,654300,'阿勒泰地区',650000 union select 345,659000,'省直辖行政单位',650000INSERT INTO Area (ID,AreaID,AreaName,FatherID) select 1,110101,'东城区',110100 unionselect 2,110102,'西城区',110100 unionselect 3,110103,'崇文区',110100 unionselect 4,110104,'宣武区',110100 unionselect 5,110105,'朝阳区',110100 unionselect 6,110106,'丰台区',110100 unionselect 7,110107,'石景山区',110100 unionselect 8,110108,'海淀区',110100 unionselect 9,110109,'门头沟区',110100 unionselect 10,110111,'房山区',110100 unionselect 11,110112,'通州区',110100 unionselect 12,110113,'顺义区',110100 unionselect 13,110114,'昌平区',110100 unionselect 14,110115,'大兴区',110100 unionselect 15,110116,'怀柔区',110100 unionselect 16,110117,'平谷区',110100 unionselect 17,110228,'密云县',110200 unionselect 18,110229,'延庆县',110200 unionselect 19,120101,'和平区',120100 unionselect 20,120102,'河东区',120100 unionselect 21,120103,'河西区',120100 unionselect 22,120104,'南开区',120100 unionselect 23,120105,'河北区',120100 unionselect 24,120106,'红桥区',120100 unionselect 25,120107,'塘沽区',120100 unionselect 26,120108,'汉沽区',120100 unionselect 27,120109,'大港区',120100 unionselect 28,120110,'东丽区',120100 unionselect 29,120111,'西青区',120100 unionselect 30,120112,'津南区',120100 unionselect 31,120113,'北辰区',120100 unionselect 32,120114,'武清区',120100 unionselect 33,120115,'宝坻区',120100 unionselect 34,120221,'宁河县',120200 unionselect 35,120223,'静海县',120200 unionselect 36,120225,'蓟县',120200 unionselect 37,130101,'市辖区',130100 unionselect 39,130103,'桥东区',130100 unionselect 40,130104,'桥西区',130100 unionselect 41,130105,'新华区',130100 unionselect 42,130107,'井陉矿区',130100 union select 43,130108,'裕华区',130100 unionselect 44,130121,'井陉县',130100 union select 45,130123,'正定县',130100 union select 46,130124,'栾城县',130100 union select 47,130125,'行唐县',130100 union select 48,130126,'灵寿县',130100 union select 49,130127,'高邑县',130100 union select 50,130128,'深泽县',130100 union select 51,130129,'赞皇县',130100 union select 52,130130,'无极县',130100 union select 53,130131,'平山县',130100 union select 54,130132,'元氏县',130100 union select 55,130133,'赵县',130100 union select 56,130181,'辛集市',130100 union select 57,130182,'藁城市',130100 union select 58,130183,'晋州市',130100 union select 59,130184,'新乐市',130100 union select 60,130185,'鹿泉市',130100 union select 61,130201,'市辖区',130200 union select 62,130202,'路南区',130200 union select 63,130203,'路北区',130200 union select 64,130204,'古冶区',130200 union select 65,130205,'开平区',130200 union select 66,130207,'丰南区',130200 union select 67,130208,'丰润区',130200 union select 68,130223,'滦县',130200 union select 69,130224,'滦南县',130200 union select 70,130225,'乐亭县',130200 union select 71,130227,'迁西县',130200 union select 72,130229,'玉田县',130200 union select 73,130230,'唐海县',130200 unionselect 74,130281,'遵化市',130200 unionselect 75,130283,'迁安市',130200 unionselect 76,130301,'市辖区',130300 unionselect 77,130302,'海港区',130300 unionselect 78,130303,'山海关区',130300 union select 79,130304,'北戴河区',130300 union select 80,130321,'青龙满族自治县',130300 union select 81,130322,'昌黎县',130300 unionselect 83,130324,'卢龙县',130300 union select 84,130401,'市辖区',130400 union select 85,130402,'邯山区',130400 union select 86,130403,'丛台区',130400 union select 87,130404,'复兴区',130400 union select 88,130406,'峰峰矿区',130400 union select 89,130421,'邯郸县',130400 union select 90,130423,'临漳县',130400 union select 91,130424,'成安县',130400 union select 92,130425,'大名县',130400 union select 93,130426,'涉县',130400 union select 94,130427,'磁县',130400 union select 95,130428,'肥乡县',130400 union select 96,130429,'永年县',130400 union select 97,130430,'邱县',130400 union select 98,130431,'鸡泽县',130400 union select 99,130432,'广平县',130400 union select 100,130433,'馆陶县',130400 union select 101,130434,'魏县',130400 union select 102,130435,'曲周县',130400 union select 103,130481,'武安市',130400 union select 104,130501,'市辖区',130500 union select 105,130502,'桥东区',130500 union select 106,130503,'桥西区',130500 union select 107,130521,'邢台县',130500 union select 108,130522,'临城县',130500 union select 109,130523,'内丘县',130500 union select 110,130524,'柏乡县',130500 union select 111,130525,'隆尧县',130500 union select 112,130526,'任县',130500 union select 113,130527,'南和县',130500 union select 114,130528,'宁晋县',130500 union select 115,130529,'巨鹿县',130500 union select 116,130530,'新河县',130500 union select 117,130531,'广宗县',130500 union select 118,130532,'平乡县120,130534,'清河县',130500 union select 121,130535,'临西县',130500 union select 122,130581,'南宫市',130500 union select 123,130582,'沙河市',130500 union select 124,130601,'市辖区',130600 union select 125,130602,'新市区',130600 union select 127,130604,'南市区',130600 union select 128,130621,'满城县',130600 union select 129,130622,'清苑县',130600 union select 130,130623,'涞水县',130600 union select 131,130624,'阜平县',130600 union select 132,130625,'徐水县',130600 union select 133,130626,'定兴县',130600 union select 134,130627,'唐县',130600 union select 135,130628,'高阳县',130600 union select 136,130629,'容城县',130600 union select 137,130630,'涞源县',130600 union select 138,130631,'望都县',130600 union select 139,130632,'安新县',130600 union select 140,130633,'易县',130600 union select 141,130634,'曲阳县',130600 union select 142,130635,'蠡县',130600 union select 143,130636,'顺平县',130600 union select 144,130637,'博野县',130600 union select 145,130638,'雄县',130600 union select 146,130681,'涿州市',130600 union select 147,130682,'定州市',130600 union select 148,130683,'安国市',130600 union select 149,130684,'高碑店市',130600 union select 150,130701,'市辖区',130700 union select 151,130702,'桥东区',130700 union select 152,130703,'桥西区',130700 union select 153,130705,'宣化区',130700 union select 154,130706,'下花园区',130700 union select 155,130721,'宣化县',130700 union select 156,130722,'张北县',130700 union select 157,130723,'康保县',130700 union select 158,130724,'沽源县',130700 union select 159,130725,'尚义县',130700 union select 160,130726,'蔚县',130700 union select 161,130727,'阳原县',130700 union select 162,130728,'怀安县',130700 union select 163,130729,'万全县',130700 union select 164,130730,'怀来县166,130732,'赤城县',130700 union select 167,130733,'崇礼县',130700 union select 168,130801,'市辖区',130800 union select 169,130802,'双桥区',130800 unionselect 171,130804,'鹰手营子矿区',130800 unionselect 172,130821,'承德县',130800 unionselect 173,130822,'兴隆县',130800 unionselect 174,130823,'平泉县',130800 unionselect 175,130824,'滦平县',130800 unionselect 176,130825,'隆化县',130800 unionselect 177,130826,'丰宁满族自治县',130800 union select 178,130827,'宽城满族自治县',130800 union select 179,130828,'围场满族蒙古族自治县',130800 union select 180,130901,'市辖区',130900 unionselect 181,130902,'新华区',130900 unionselect 182,130903,'运河区',130900 unionselect 183,130921,'沧县',130900 unionselect 184,130922,'青县',130900 unionselect 185,130923,'东光县',130900 unionselect 186,130924,'海兴县',130900 unionselect 187,130925,'盐山县',130900 unionselect 188,130926,'肃宁县',130900 unionselect 189,130927,'南皮县',130900 unionselect 190,130928,'吴桥县',130900 unionselect 191,130929,'献县',130900 unionselect 192,130930,'孟村回族自治县',130900 union select 193,130981,'泊头市',130900 unionselect 194,130982,'任丘市',130900 unionselect 195,130983,'黄骅市',130900 unionselect 196,130984,'河间市',130900 unionselect 197,131001,'市辖区',131000 unionselect 198,131002,'安次区',131000 unionselect 199,131003,'广阳区',131000 unionselect 200,131022,'固安县',131000 unionselect 201,131023,'永清县',131000 unionselect 202,131024,'香河县',131000 unionselect 203,131025,'大城县',131000 unionselect 204,131026,'文安县',131000 unionselect 205,131028,'大厂回族自治县',131000 union select 206,131081,'霸州市',131000 unionselect 207,131082,'三河市',131000 unionselect 208,131101,'市辖区',131100 unionselect 209,131102,'桃城区',131100 unionselect 210,131121,'枣强县',131100 unionselect 211,131122,'武邑县',131100 unionselect 212,131123,'武强县',131100 unionselect 213,131124,'饶阳县',131100 unionselect 215,131126,'故城县',131100 union select 216,131127,'景县',131100 union select 217,131128,'阜城县',131100 union select 218,131181,'冀州市',131100 union select 219,131182,'深州市',131100 union select 220,140101,'市辖区',140100 union select 221,140105,'小店区',140100 union select 222,140106,'迎泽区',140100 union select 223,140107,'杏花岭区',140100 union select 224,140108,'尖草坪区',140100 union select 225,140109,'万柏林区',140100 union select 226,140110,'晋源区',140100 union select 227,140121,'清徐县',140100 union select 228,140122,'阳曲县',140100 union select 229,140123,'娄烦县',140100 union select 230,140181,'古交市',140100 union select 231,140201,'市辖区',140200 union select 232,140202,'城区',140200 union select 233,140203,'矿区',140200 union select 234,140211,'南郊区。

全国行政区域划分表excel全国行政区域划分表Excel是一个包含中国全国各个行政区域划分信息的表格文件。

根据中国的行政区域划分体系，全国被划分为省级行政区、地级行政区和县级行政区三个层级。

首先是省级行政区划。

中国共有34个省级行政区，其中包括23个省、5个自治区、4个直辖市和2个特别行政区。

省级行政区主要负责该省的行政管理和发展规划。

例如，北京市、上海市、天津市和重庆市都是直辖市，直辖市的地位相当于省级行政区。

其次是地级行政区划。

地级行政区是省级行政区的下一级，共有333个地级行政区。

地级行政区包括地级市、地区和自治州。

地级行政区主要负责该地区的行政管理、经济发展和社会建设等事务。

例如，广东省下面有21个地级行政区，包括广州市、深圳市、汕头市等地级市。

最后是县级行政区划。

县级行政区是地级行政区的下一级，通常称为县。

中国共有2850个县级行政区。

县级行政区是中国最基层的行政单位，主要负责乡镇的行政管理和公共服务。

例如，河南省下面有159个县级行政区，包括郑州市下面的中原区、金水区等县级行政区。

这些行政区域划分信息可以通过Excel表格来进行整理和管理。

在Excel表格中，可以创建多个工作表来表示不同的行政区域划分层级，每个工作表包含相应的行政区域划分信息。

可以设置不同的列来表示行政区域划分的名称、所属级别、上级行政区域等信息，方便用户进行查找和筛选。

在Excel表格中，还可以使用各种功能和公式来进行数据计算和分析。

例如，可以使用排序功能对行政区域进行按照拼音字母或所属级别的升序或降序排列。

同时，也可以使用筛选功能根据特定的条件来显示符合条件的行政区域划分信息。

总的来说，全国行政区域划分表Excel提供了一个方便的方式来整理和管理中国全国各级行政区域划分信息。

通过Excel的强大功能，用户可以轻松地对行政区域划分信息进行查找、筛选和分析，提高工作效率和数据管理的准确性。

全国省市县SQL数据库（大全）创建表reate table city(id int(11) primary key not null default 0pid int(11) default nullcityname varchar(255) default nulltype int(11) default null);插入数据INSERT INTO `city` VALUES ('1' '0' '中国' '0'); INSERT INTO `city` VALUES ('2' '1' '北京' '1'); INSERT INTO `city` VALUES ('3' '1' '安徽' '1'); INSERT INTO `city` VALUES ('4' '1' '福建' '1'); INSERT INTO `city` VALUES ('5' '1' '甘肃' '1'); INSERT INTO `city` VALUES ('6' '1' '广东' '1'); INSERT INTO `city` VALUES ('7' '1' '广西' '1'); INSERT INTO `city` VALUES ('8' '1' '贵州' '1'); INSERT INTO `city` VALUES ('9' '1' '海南' '1'); INSERT INTO `city` VALUES ('10' '1' '河北' '1'); INSERT INTO `city` VALUES ('11' '1' '河南' '1'); INSERT INTO `city` VALUES ('12' '1' '黑龙江' '1'); INSERT INTO `city` VALUES ('13' '1' '湖北' '1'); INSERT INTO `city` VALUES ('14' '1' '湖南' '1'); INSERT INTO `city` VALUES ('15' '1' '吉林' '1'); INSERT INTO `city` VALUES ('16' '1' '江苏' '1'); INSERT INTO `city` VALUES ('17' '1' '江西' '1'); INSERT INTO `city` VALUES ('18' '1' '辽宁' '1'); INSERT INTO `city` VALUES ('19' '1' '内蒙古' '1'); INSERT INTO `city` VALUES ('20' '1' '宁夏' '1'); INSERT INTO `city` VALUES ('21' '1' '青海' '1'); INSERT INTO `city` VALUES ('22' '1' '山东' '1'); INSERT INTO `city` VALUES ('23' '1' '山西' '1'); INSERT INTO `city` VALUES ('24' '1' '陕西' '1'); INSERT INTO `city` VALUES ('25' '1' '上海' '1'); INSERT INTO `city` VALUES ('26' '1' '四川' '1'); INSERT INTO `city` VALUES ('27' '1' '天津' '1'); INSERT INTO `city` VALUES ('28' '1' '西藏' '1'); INSERT INTO `city` VALUES ('29' '1' '新疆' '1'); INSERT INTO `city` VALUES ('30' '1' '云南' '1'); INSERT INTO `city` VALUES ('31' '1' '浙江' '1'); INSERT INTO `city` VALUES ('32' '1' '重庆' '1');INSERT INTO `city` VALUES ('34' '1' '澳门' '1'); INSERT INTO `city` VALUES ('35' '1' '台湾' '1'); INSERT INTO `city` VALUES ('36' '3' '安庆' '2'); INSERT INTO `city` VALUES ('37' '3' '蚌埠' '2'); INSERT INTO `city` VALUES ('38' '3' '巢湖' '2'); INSERT INTO `city` VALUES ('39' '3' '池州' '2'); INSERT INTO `city` VALUES ('40' '3' '滁州' '2'); INSERT INTO `city` VALUES ('41' '3' '阜阳' '2'); INSERT INTO `city` VALUES ('42' '3' '淮北' '2'); INSERT INTO `city` VALUES ('43' '3' '淮南' '2'); INSERT INTO `city` VALUES ('44' '3' '黄山' '2'); INSERT INTO `city` VALUES ('45' '3' '六安' '2'); INSERT INTO `city` VALUES ('46' '3' '马鞍山' '2'); INSERT INTO `city` VALUES ('47' '3' '宿州' '2'); INSERT INTO `city` VALUES ('48' '3' '铜陵' '2'); INSERT INTO `city` VALUES ('49' '3' '芜湖' '2'); INSERT INTO `city` VALUES ('50' '3' '宣城' '2'); INSERT INTO `city` VALUES ('51' '3' '亳州' '2'); INSERT INTO `city` VALUES ('52' '2' '市辖区' '2'); INSERT INTO `city` VALUES ('53' '4' '福州' '2'); INSERT INTO `city` VALUES ('54' '4' '龙岩' '2'); INSERT INTO `city` VALUES ('55' '4' '南平' '2'); INSERT INTO `city` VALUES ('56' '4' '宁德' '2'); INSERT INTO `city` VALUES ('57' '4' '莆田' '2'); INSERT INTO `city` VALUES ('58' '4' '泉州' '2'); INSERT INTO `city` VALUES ('59' '4' '三明' '2'); INSERT INTO `city` VALUES ('60' '4' '厦门' '2'); INSERT INTO `city` VALUES ('61' '4' '漳州' '2'); INSERT INTO `city` VALUES ('62' '5' '兰州' '2'); INSERT INTO `city` VALUES ('63' '5' '白银' '2'); INSERT INTO `city` VALUES ('64' '5' '定西' '2'); INSERT INTO `city` VALUES ('65' '5' '甘南' '2'); INSERT INTO `city` VALUES ('66' '5' '嘉峪关' '2'); INSERT INTO `city` VALUES ('67' '5' '金昌' '2'); INSERT INTO `city` VALUES ('68' '5' '酒泉' '2'); INSERT INTO `city` VALUES ('69' '5' '临夏' '2'); INSERT INTO `city` VALUES ('70' '5' '陇南' '2'); INSERT INTO `city` VALUES ('71' '5' '平凉' '2'); INSERT INTO `city` VALUES ('72' '5' '庆阳' '2');INSERT INTO `city` VALUES ('74' '5' '武威' '2'); INSERT INTO `city` VALUES ('75' '5' '张掖' '2'); INSERT INTO `city` VALUES ('76' '6' '广州' '2'); INSERT INTO `city` VALUES ('77' '6' '深圳' '2'); INSERT INTO `city` VALUES ('78' '6' '潮州' '2'); INSERT INTO `city` VALUES ('79' '6' '东莞' '2'); INSERT INTO `city` VALUES ('80' '6' '佛山' '2'); INSERT INTO `city` VALUES ('81' '6' '河源' '2'); INSERT INTO `city` VALUES ('82' '6' '惠州' '2'); INSERT INTO `city` VALUES ('83' '6' '江门' '2'); INSERT INTO `city` VALUES ('84' '6' '揭阳' '2'); INSERT INTO `city` VALUES ('85' '6' '茂名' '2'); INSERT INTO `city` VALUES ('86' '6' '梅州' '2'); INSERT INTO `city` VALUES ('87' '6' '清远' '2'); INSERT INTO `city` VALUES ('88' '6' '汕头' '2'); INSERT INTO `city` VALUES ('89' '6' '汕尾' '2'); INSERT INTO `city` VALUES ('90' '6' '韶关' '2'); INSERT INTO `city` VALUES ('91' '6' '阳江' '2'); INSERT INTO `city` VALUES ('92' '6' '云浮' '2'); INSERT INTO `city` VALUES ('93' '6' '湛江' '2'); INSERT INTO `city` VALUES ('94' '6' '肇庆' '2'); INSERT INTO `city` VALUES ('95' '6' '中山' '2'); INSERT INTO `city` VALUES ('96' '6' '珠海' '2'); INSERT INTO `city` VALUES ('97' '7' '南宁' '2'); INSERT INTO `city` VALUES ('98' '7' '桂林' '2'); INSERT INTO `city` VALUES ('99' '7' '百色' '2'); INSERT INTO `city` VALUES ('100' '7' '北海' '2'); INSERT INTO `city` VALUES ('101' '7' '崇左' '2'); INSERT INTO `city` VALUES ('102' '7' '防城港' '2'); INSERT INTO `city` VALUES ('103' '7' '贵港' '2'); INSERT INTO `city` VALUES ('104' '7' '河池' '2'); INSERT INTO `city` VALUES ('105' '7' '贺州' '2'); INSERT INTO `city` VALUES ('106' '7' '来宾' '2'); INSERT INTO `city` VALUES ('107' '7' '柳州' '2'); INSERT INTO `city` VALUES ('108' '7' '钦州' '2'); INSERT INTO `city` VALUES ('109' '7' '梧州' '2'); INSERT INTO `city` VALUES ('110' '7' '玉林' '2'); INSERT INTO `city` VALUES ('111' '8' '贵阳' '2'); INSERT INTO `city` VALUES ('112' '8' '安顺' '2');INSERT INTO `city` VALUES ('114' '8' '六盘水' '2'); INSERT INTO `city` VALUES ('115' '8' '黔东南' '2'); INSERT INTO `city` VALUES ('116' '8' '黔南' '2'); INSERT INTO `city` VALUES ('117' '8' '黔西南' '2'); INSERT INTO `city` VALUES ('118' '8' '铜仁' '2'); INSERT INTO `city` VALUES ('119' '8' '遵义' '2'); INSERT INTO `city` VALUES ('120' '9' '海口' '2'); INSERT INTO `city` VALUES ('121' '9' '三亚' '2'); INSERT INTO `city` VALUES ('122' '9' '白沙' '2'); INSERT INTO `city` VALUES ('123' '9' '保亭' '2'); INSERT INTO `city` VALUES ('124' '9' '昌江' '2'); INSERT INTO `city` VALUES ('125' '9' '澄迈县' '2'); INSERT INTO `city` VALUES ('126' '9' '定安县' '2'); INSERT INTO `city` VALUES ('127' '9' '东方' '2'); INSERT INTO `city` VALUES ('128' '9' '乐东' '2'); INSERT INTO `city` VALUES ('129' '9' '临高县' '2'); INSERT INTO `city` VALUES ('130' '9' '陵水' '2'); INSERT INTO `city` VALUES ('131' '9' '琼海' '2'); INSERT INTO `city` VALUES ('132' '9' '琼中' '2'); INSERT INTO `city` VALUES ('133' '9' '屯昌县' '2'); INSERT INTO `city` VALUES ('134' '9' '万宁' '2'); INSERT INTO `city` VALUES ('135' '9' '文昌' '2'); INSERT INTO `city` VALUES ('136' '9' '五指山' '2'); INSERT INTO `city` VALUES ('137' '9' '儋州' '2'); INSERT INTO `city` VALUES ('138' '10' '石家庄' '2'); INSERT INTO `city` VALUES ('139' '10' '保定' '2'); INSERT INTO `city` VALUES ('140' '10' '沧州' '2'); INSERT INTO `city` VALUES ('141' '10' '承德' '2'); INSERT INTO `city` VALUES ('142' '10' '邯郸' '2'); INSERT INTO `city` VALUES ('143' '10' '衡水' '2'); INSERT INTO `city` VALUES ('144' '10' '廊坊' '2'); INSERT INTO `city` VALUES ('145' '10' '秦皇岛' '2'); INSERT INTO `city` VALUES ('146' '10' '唐山' '2'); INSERT INTO `city` VALUES ('147' '10' '邢台' '2'); INSERT INTO `city` VALUES ('148' '10' '张家口' '2'); INSERT INTO `city` VALUES ('149' '11' '郑州' '2'); INSERT INTO `city` VALUES ('150' '11' '洛阳' '2'); INSERT INTO `city` VALUES ('151' '11' '开封' '2'); INSERT INTO `city` VALUES ('152' '11' '安阳' '2');INSERT INTO `city` VALUES ('154' '11' '济源' '2'); INSERT INTO `city` VALUES ('155' '11' '焦作' '2'); INSERT INTO `city` VALUES ('156' '11' '南阳' '2'); INSERT INTO `city` VALUES ('157' '11' '平顶山' '2'); INSERT INTO `city` VALUES ('158' '11' '三门峡' '2'); INSERT INTO `city` VALUES ('159' '11' '商丘' '2'); INSERT INTO `city` VALUES ('160' '11' '新乡' '2'); INSERT INTO `city` VALUES ('161' '11' '信阳' '2'); INSERT INTO `city` VALUES ('162' '11' '许昌' '2'); INSERT INTO `city` VALUES ('163' '11' '周口' '2'); INSERT INTO `city` VALUES ('164' '11' '驻马店' '2'); INSERT INTO `city` VALUES ('165' '11' '漯河' '2'); INSERT INTO `city` VALUES ('166' '11' '濮阳' '2'); INSERT INTO `city` VALUES ('167' '12' '哈尔滨' '2'); INSERT INTO `city` VALUES ('168' '12' '大庆' '2'); INSERT INTO `city` VALUES ('169' '12' '大兴安岭' '2'); INSERT INTO `city` VALUES ('170' '12' '鹤岗' '2'); INSERT INTO `city` VALUES ('171' '12' '黑河' '2'); INSERT INTO `city` VALUES ('172' '12' '鸡西' '2'); INSERT INTO `city` VALUES ('173' '12' '佳木斯' '2'); INSERT INTO `city` VALUES ('174' '12' '牡丹江' '2'); INSERT INTO `city` VALUES ('175' '12' '七台河' '2'); INSERT INTO `city` VALUES ('176' '12' '齐齐哈尔' '2'); INSERT INTO `city` VALUES ('177' '12' '双鸭山' '2'); INSERT INTO `city` VALUES ('178' '12' '绥化' '2'); INSERT INTO `city` VALUES ('179' '12' '伊春' '2'); INSERT INTO `city` VALUES ('180' '13' '武汉' '2'); INSERT INTO `city` VALUES ('181' '13' '仙桃' '2'); INSERT INTO `city` VALUES ('182' '13' '鄂州' '2'); INSERT INTO `city` VALUES ('183' '13' '黄冈' '2'); INSERT INTO `city` VALUES ('184' '13' '黄石' '2'); INSERT INTO `city` VALUES ('185' '13' '荆门' '2'); INSERT INTO `city` VALUES ('186' '13' '荆州' '2'); INSERT INTO `city` VALUES ('187' '13' '潜江' '2'); INSERT INTO `city` VALUES ('188' '13' '神农架林区' '2'); INSERT INTO `city` VALUES ('189' '13' '十堰' '2'); INSERT INTO `city` VALUES ('190' '13' '随州' '2'); INSERT INTO `city` VALUES ('191' '13' '天门' '2'); INSERT INTO `city` VALUES ('192' '13' '咸宁' '2');INSERT INTO `city` VALUES ('194' '13' '孝感' '2'); INSERT INTO `city` VALUES ('195' '13' '宜昌' '2'); INSERT INTO `city` VALUES ('196' '13' '恩施' '2'); INSERT INTO `city` VALUES ('197' '14' '长沙' '2'); INSERT INTO `city` VALUES ('198' '14' '张家界' '2'); INSERT INTO `city` VALUES ('199' '14' '常德' '2'); INSERT INTO `city` VALUES ('200' '14' '郴州' '2'); INSERT INTO `city` VALUES ('201' '14' '衡阳' '2'); INSERT INTO `city` VALUES ('202' '14' '怀化' '2'); INSERT INTO `city` VALUES ('203' '14' '娄底' '2'); INSERT INTO `city` VALUES ('204' '14' '邵阳' '2'); INSERT INTO `city` VALUES ('205' '14' '湘潭' '2'); INSERT INTO `city` VALUES ('206' '14' '湘西' '2'); INSERT INTO `city` VALUES ('207' '14' '益阳' '2'); INSERT INTO `city` VALUES ('208' '14' '永州' '2'); INSERT INTO `city` VALUES ('209' '14' '岳阳' '2'); INSERT INTO `city` VALUES ('210' '14' '株洲' '2'); INSERT INTO `city` VALUES ('211' '15' '长春' '2'); INSERT INTO `city` VALUES ('212' '15' '吉林' '2'); INSERT INTO `city` VALUES ('213' '15' '白城' '2'); INSERT INTO `city` VALUES ('214' '15' '白山' '2'); INSERT INTO `city` VALUES ('215' '15' '辽源' '2'); INSERT INTO `city` VALUES ('216' '15' '四平' '2'); INSERT INTO `city` VALUES ('217' '15' '松原' '2'); INSERT INTO `city` VALUES ('218' '15' '通化' '2'); INSERT INTO `city` VALUES ('219' '15' '延边' '2'); INSERT INTO `city` VALUES ('220' '16' '南京' '2'); INSERT INTO `city` VALUES ('221' '16' '苏州' '2'); INSERT INTO `city` VALUES ('222' '16' '无锡' '2'); INSERT INTO `city` VALUES ('223' '16' '常州' '2'); INSERT INTO `city` VALUES ('224' '16' '淮安' '2'); INSERT INTO `city` VALUES ('225' '16' '连云港' '2'); INSERT INTO `city` VALUES ('226' '16' '南通' '2'); INSERT INTO `city` VALUES ('227' '16' '宿迁' '2'); INSERT INTO `city` VALUES ('228' '16' '泰州' '2'); INSERT INTO `city` VALUES ('229' '16' '徐州' '2'); INSERT INTO `city` VALUES ('230' '16' '盐城' '2'); INSERT INTO `city` VALUES ('231' '16' '扬州' '2'); INSERT INTO `city` VALUES ('232' '16' '镇江' '2');INSERT INTO `city` VALUES ('234' '17' '抚州' '2'); INSERT INTO `city` VALUES ('235' '17' '赣州' '2'); INSERT INTO `city` VALUES ('236' '17' '吉安' '2'); INSERT INTO `city` VALUES ('237' '17' '景德镇' '2'); INSERT INTO `city` VALUES ('238' '17' '九江' '2'); INSERT INTO `city` VALUES ('239' '17' '萍乡' '2'); INSERT INTO `city` VALUES ('240' '17' '上饶' '2'); INSERT INTO `city` VALUES ('241' '17' '新余' '2'); INSERT INTO `city` VALUES ('242' '17' '宜春' '2'); INSERT INTO `city` VALUES ('243' '17' '鹰潭' '2'); INSERT INTO `city` VALUES ('244' '18' '沈阳' '2'); INSERT INTO `city` VALUES ('245' '18' '大连' '2'); INSERT INTO `city` VALUES ('246' '18' '鞍山' '2'); INSERT INTO `city` VALUES ('247' '18' '本溪' '2'); INSERT INTO `city` VALUES ('248' '18' '朝阳' '2'); INSERT INTO `city` VALUES ('249' '18' '丹东' '2'); INSERT INTO `city` VALUES ('250' '18' '抚顺' '2'); INSERT INTO `city` VALUES ('251' '18' '阜新' '2'); INSERT INTO `city` VALUES ('252' '18' '葫芦岛' '2'); INSERT INTO `city` VALUES ('253' '18' '锦州' '2'); INSERT INTO `city` VALUES ('254' '18' '辽阳' '2'); INSERT INTO `city` VALUES ('255' '18' '盘锦' '2'); INSERT INTO `city` VALUES ('256' '18' '铁岭' '2'); INSERT INTO `city` VALUES ('257' '18' '营口' '2'); INSERT INTO `city` VALUES ('258' '19' '呼和浩特' '2'); INSERT INTO `city` VALUES ('259' '19' '阿拉善盟' '2'); INSERT INTO `city` VALUES ('260' '19' '巴彦淖尔盟' '2'); INSERT INTO `city` VALUES ('261' '19' '包头' '2'); INSERT INTO `city` VALUES ('262' '19' '赤峰' '2'); INSERT INTO `city` VALUES ('263' '19' '鄂尔多斯' '2'); INSERT INTO `city` VALUES ('264' '19' '呼伦贝尔' '2'); INSERT INTO `city` VALUES ('265' '19' '通辽' '2'); INSERT INTO `city` VALUES ('266' '19' '乌海' '2'); INSERT INTO `city` VALUES ('267' '19' '乌兰察布市' '2'); INSERT INTO `city` VALUES ('268' '19' '锡林郭勒盟' '2'); INSERT INTO `city` VALUES ('269' '19' '兴安盟' '2'); INSERT INTO `city` VALUES ('270' '20' '银川' '2'); INSERT INTO `city` VALUES ('271' '20' '固原' '2'); INSERT INTO `city` VALUES ('272' '20' '石嘴山' '2');INSERT INTO `city` VALUES ('274' '20' '中卫' '2'); INSERT INTO `city` VALUES ('275' '21' '西宁' '2'); INSERT INTO `city` VALUES ('276' '21' '果洛' '2'); INSERT INTO `city` VALUES ('277' '21' '海北' '2'); INSERT INTO `city` VALUES ('278' '21' '海东' '2'); INSERT INTO `city` VALUES ('279' '21' '海南' '2'); INSERT INTO `city` VALUES ('280' '21' '海西' '2'); INSERT INTO `city` VALUES ('281' '21' '黄南' '2'); INSERT INTO `city` VALUES ('282' '21' '玉树' '2'); INSERT INTO `city` VALUES ('283' '22' '济南' '2'); INSERT INTO `city` VALUES ('284' '22' '青岛' '2'); INSERT INTO `city` VALUES ('285' '22' '滨州' '2'); INSERT INTO `city` VALUES ('286' '22' '德州' '2'); INSERT INTO `city` VALUES ('287' '22' '东营' '2'); INSERT INTO `city` VALUES ('288' '22' '菏泽' '2'); INSERT INTO `city` VALUES ('289' '22' '济宁' '2'); INSERT INTO `city` VALUES ('290' '22' '莱芜' '2'); INSERT INTO `city` VALUES ('291' '22' '聊城' '2'); INSERT INTO `city` VALUES ('292' '22' '临沂' '2'); INSERT INTO `city` VALUES ('293' '22' '日照' '2'); INSERT INTO `city` VALUES ('294' '22' '泰安' '2'); INSERT INTO `city` VALUES ('295' '22' '威海' '2'); INSERT INTO `city` VALUES ('296' '22' '潍坊' '2'); INSERT INTO `city` VALUES ('297' '22' '烟台' '2'); INSERT INTO `city` VALUES ('298' '22' '枣庄' '2'); INSERT INTO `city` VALUES ('299' '22' '淄博' '2'); INSERT INTO `city` VALUES ('300' '23' '太原' '2'); INSERT INTO `city` VALUES ('301' '23' '长治' '2'); INSERT INTO `city` VALUES ('302' '23' '大同' '2'); INSERT INTO `city` VALUES ('303' '23' '晋城' '2'); INSERT INTO `city` VALUES ('304' '23' '晋中' '2'); INSERT INTO `city` VALUES ('305' '23' '临汾' '2'); INSERT INTO `city` VALUES ('306' '23' '吕梁' '2'); INSERT INTO `city` VALUES ('307' '23' '朔州' '2'); INSERT INTO `city` VALUES ('308' '23' '忻州' '2'); INSERT INTO `city` VALUES ('309' '23' '阳泉' '2'); INSERT INTO `city` VALUES ('310' '23' '运城' '2'); INSERT INTO `city` VALUES ('311' '24' '西安' '2'); INSERT INTO `city` VALUES ('312' '24' '安康' '2');INSERT INTO `city` VALUES ('314' '24' '汉中' '2'); INSERT INTO `city` VALUES ('315' '24' '商洛' '2'); INSERT INTO `city` VALUES ('316' '24' '铜川' '2'); INSERT INTO `city` VALUES ('317' '24' '渭南' '2'); INSERT INTO `city` VALUES ('318' '24' '咸阳' '2'); INSERT INTO `city` VALUES ('319' '24' '延安' '2'); INSERT INTO `city` VALUES ('320' '24' '榆林' '2'); INSERT INTO `city` VALUES ('321' '25' '上海' '2'); INSERT INTO `city` VALUES ('322' '26' '成都' '2'); INSERT INTO `city` VALUES ('323' '26' '绵阳' '2'); INSERT INTO `city` VALUES ('324' '26' '阿坝' '2'); INSERT INTO `city` VALUES ('325' '26' '巴中' '2'); INSERT INTO `city` VALUES ('326' '26' '达州' '2'); INSERT INTO `city` VALUES ('327' '26' '德阳' '2'); INSERT INTO `city` VALUES ('328' '26' '甘孜' '2'); INSERT INTO `city` VALUES ('329' '26' '广安' '2'); INSERT INTO `city` VALUES ('330' '26' '广元' '2'); INSERT INTO `city` VALUES ('331' '26' '乐山' '2'); INSERT INTO `city` VALUES ('332' '26' '凉山' '2'); INSERT INTO `city` VALUES ('333' '26' '眉山' '2'); INSERT INTO `city` VALUES ('334' '26' '南充' '2'); INSERT INTO `city` VALUES ('335' '26' '内江' '2'); INSERT INTO `city` VALUES ('336' '26' '攀枝花' '2'); INSERT INTO `city` VALUES ('337' '26' '遂宁' '2'); INSERT INTO `city` VALUES ('338' '26' '雅安' '2'); INSERT INTO `city` VALUES ('339' '26' '宜宾' '2'); INSERT INTO `city` VALUES ('340' '26' '资阳' '2'); INSERT INTO `city` VALUES ('341' '26' '自贡' '2'); INSERT INTO `city` VALUES ('342' '26' '泸州' '2'); INSERT INTO `city` VALUES ('343' '27' '天津' '2'); INSERT INTO `city` VALUES ('344' '28' '拉萨' '2'); INSERT INTO `city` VALUES ('345' '28' '阿里' '2'); INSERT INTO `city` VALUES ('346' '28' '昌都' '2'); INSERT INTO `city` VALUES ('347' '28' '林芝' '2'); INSERT INTO `city` VALUES ('348' '28' '那曲' '2'); INSERT INTO `city` VALUES ('349' '28' '日喀则' '2'); INSERT INTO `city` VALUES ('350' '28' '山南' '2'); INSERT INTO `city` VALUES ('351' '29' '乌鲁木齐' '2'); INSERT INTO `city` VALUES ('352' '29' '阿克苏' '2');INSERT INTO `city` VALUES ('354' '29' '巴音郭楞' '2'); INSERT INTO `city` VALUES ('355' '29' '博尔塔拉' '2'); INSERT INTO `city` VALUES ('356' '29' '昌吉' '2'); INSERT INTO `city` VALUES ('357' '29' '哈密' '2'); INSERT INTO `city` VALUES ('358' '29' '和田' '2'); INSERT INTO `city` VALUES ('359' '29' '喀什' '2'); INSERT INTO `city` VALUES ('360' '29' '克拉玛依' '2'); INSERT INTO `city` VALUES ('361' '29' '克孜勒苏' '2'); INSERT INTO `city` VALUES ('362' '29' '石河子' '2'); INSERT INTO `city` VALUES ('363' '29' '图木舒克' '2'); INSERT INTO `city` VALUES ('364' '29' '吐鲁番' '2'); INSERT INTO `city` VALUES ('365' '29' '五家渠' '2'); INSERT INTO `city` VALUES ('366' '29' '伊犁' '2'); INSERT INTO `city` VALUES ('367' '30' '昆明' '2'); INSERT INTO `city` VALUES ('368' '30' '怒江' '2'); INSERT INTO `city` VALUES ('369' '30' '普洱' '2'); INSERT INTO `city` VALUES ('370' '30' '丽江' '2'); INSERT INTO `city` VALUES ('371' '30' '保山' '2'); INSERT INTO `city` VALUES ('372' '30' '楚雄' '2'); INSERT INTO `city` VALUES ('373' '30' '大理' '2'); INSERT INTO `city` VALUES ('374' '30' '德宏' '2'); INSERT INTO `city` VALUES ('375' '30' '迪庆' '2'); INSERT INTO `city` VALUES ('376' '30' '红河' '2'); INSERT INTO `city` VALUES ('377' '30' '临沧' '2'); INSERT INTO `city` VALUES ('378' '30' '曲靖' '2'); INSERT INTO `city` VALUES ('379' '30' '文山' '2'); INSERT INTO `city` VALUES ('380' '30' '西双版纳' '2'); INSERT INTO `city` VALUES ('381' '30' '玉溪' '2'); INSERT INTO `city` VALUES ('382' '30' '昭通' '2'); INSERT INTO `city` VALUES ('383' '31' '杭州' '2'); INSERT INTO `city` VALUES ('384' '31' '湖州' '2'); INSERT INTO `city` VALUES ('385' '31' '嘉兴' '2'); INSERT INTO `city` VALUES ('386' '31' '金华' '2'); INSERT INTO `city` VALUES ('387' '31' '丽水' '2'); INSERT INTO `city` VALUES ('388' '31' '宁波' '2'); INSERT INTO `city` VALUES ('389' '31' '绍兴' '2'); INSERT INTO `city` VALUES ('390' '31' '台州' '2'); INSERT INTO `city` VALUES ('391' '31' '温州' '2'); INSERT INTO `city` VALUES ('392' '31' '舟山' '2');。