中国省市数据库表sql
中国各省市sql
INSERT INTO City(CityID,Name,ProvinceID)VALUES('30','闵行区','2')
INSERT INTO City(CityID,Name,ProvinceID)VALUES('31','嘉定区','2')
INSERT INTO City(CityID,Name,ProvinceID)VALUES('111','宝坻区','3')
INSERT INTO City(CityID,Name,ProvinceID)VALUES('112','蓟 县','3')
INSERT INTO City(CityID,Name,ProvinceID)VALUES('113','宁河县','3')
INSERT INTO City(CityID,Name,ProvinceID)VALUES('124','渝北区','4')
INSERT INTO City(CityID,Name,ProvinceID)VALUES('125','巴南区','4')
INSERT INTO City(CityID,Name,ProvinceID)VALUES('126','长寿区','4')
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省市区三级表结构
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 selectid int NOT NULL ,cityID int NOT NULL,city varcharselect 200) NOT NULL,fatherID int NOT NULL,PRIMARY KEY select id))---- 导出表中的数据 city---- ------------------------------------------------------------ 表的结构 province--DROP TABLE province;CREATE TABLE province selectid int NOT NULL ,provinceID int NOT NULL,province varcharselect 200) NOT NULL,PRIMARY KEY select id))insert province(id,provinceID,province)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,'⼴西壮族⾃治区' unionselect 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,'青海省' unionINSERT city (id,cityID,city,fatherID)select 1,110100,'市辖区',110000 unionselect 2,110200,'县',110000 unionselect 3,120100,'市辖区',120000 unionselect 4,120200,'县',120000 unionselect 5,130100,'⽯家庄市',130000 unionselect 6,130200,'唐⼭市',130000 unionselect 7,130300,'秦皇岛市',130000 unionselect 8,130400,'邯郸市',130000 unionselect 9,130500,'邢台市',130000 unionselect 10,130600,'保定市',130000 unionselect 11,130700,'张家⼝市',130000 unionselect 12,130800,'承德市',130000 unionselect 13,130900,'沧州市',130000 unionselect 14,131000,'廊坊市',130000 unionselect 15,131100,'衡⽔市',130000 unionselect 16,140100,'太原市',140000 unionselect 17,140200,'⼤同市',140000 unionselect 18,140300,'阳泉市',140000 unionselect 19,140400,'长治市',140000 unionselect 20,140500,'晋城市',140000 unionselect 21,140600,'朔州市',140000 unionselect 22,140700,'晋中市',140000 unionselect 23,140800,'运城市',140000 unionselect 24,140900,'忻州市',140000 unionselect 25,141000,'临汾市',140000 unionselect 26,141100,'吕梁市',140000INSERT city (id,cityID,city,fatherID)select 27,150100,'呼和浩特市',150000 union select 28,150200,'包头市',150000 unionselect 29,150300,'乌海市',150000 unionselect 30,150400,'⾚峰市',150000 unionselect 31,150500,'通辽市',150000 unionselect 32,150600,'鄂尔多斯市',150000 union select 33,150700,'呼伦贝尔市',150000 union select 34,150800,'巴彦淖尔市',150000 union select 35,150900,'乌兰察布市',150000 union select 36,152200,'兴安盟',150000 unionselect 37,152500,'锡林郭勒盟',150000 union select 38,152900,'阿拉善盟',150000 unionselect 39,210100,'沈阳市',210000 unionselect 40,210200,'⼤连市',210000 unionselect 41,210300,'鞍⼭市',210000 unionselect 42,210400,'抚顺市',210000 unionselect 43,210500,'本溪市',210000 unionselect 44,210600,'丹东市',210000 unionselect 45,210700,'锦州市',210000 unionselect 46,210800,'营⼝市',210000 unionselect 47,210900,'⾩新市',210000 unionselect 48,211000,'辽阳市',210000 unionselect 49,211100,'盘锦市',210000 unionselect 50,211200,'铁岭市',210000 unionselect 51,211300,'朝阳市',210000 unionselect 52,211400,'葫芦岛市',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 74,232700,'⼤兴安岭地区',230000 union select 75,310100,'市辖区',310000 union select 76,310200,'县',310000 unionselect 77,320100,'南京市',320000 union select 78,320200,'⽆锡市',320000 union select 79,320300,'徐州市',320000 union select 80,320400,'常州市',320000 union select 81,320500,'苏州市',320000 union select 82,320600,'南通市',320000 union select 83,320700,'连云港市',320000 union select 84,320800,'淮安市',320000 union select 85,320900,'盐城市',320000 union select 86,321000,'扬州市',320000 union select 87,321100,'镇江市',320000 union select 88,321200,'泰州市',320000 union select 89,321300,'宿迁市',320000 union select 90,330100,'杭州市',330000 union select 91,330200,'宁波市',330000 union select 92,330300,'温州市',330000 union select 93,330400,'嘉兴市',330000 union select 94,330500,'湖州市',330000 union select 95,330600,'绍兴市',330000 union select 96,330700,'⾦华市',330000 union select 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 union select 138,370100,'济南市',370000 union select 139,370200,'青岛市',370000 unionselect 148,371100,'⽇照市',370000 unionselect 149,371200,'莱芜市',370000 unionselect 150,371300,'临沂市',370000 unionselect 151,371400,'德州市',370000 unionselect 152,371500,'聊城市',370000 unionselect 153,371600,'滨州市',370000 unionselect 154,371700,'荷泽市',370000 unionselect 155,410100,'郑州市',410000 unionselect 156,410200,'开封市',410000 unionselect 157,410300,'洛阳市',410000 unionselect 158,410400,'平顶⼭市',410000 unionselect 159,410500,'安阳市',410000 unionselect 160,410600,'鹤壁市',410000 unionselect 161,410700,'新乡市',410000 unionselect 162,410800,'焦作市',410000 unionselect 163,410900,'濮阳市',410000 unionselect 164,411000,'许昌市',410000 unionselect 165,411100,'漯河市',410000 unionselect 166,411200,'三门峡市',410000 unionselect 167,411300,'南阳市',410000 unionselect 168,411400,'商丘市',410000 unionselect 169,411500,'信阳市',410000 unionselect 170,411600,'周⼝市',410000 unionselect 171,411700,'驻马店市',410000INSERT city (id,cityID,city,fatherID)select 172,420100,'武汉市',420000 unionselect 173,420200,'黄⽯市',420000 unionselect 174,420300,'⼗堰市',420000 unionselect 175,420500,'宜昌市',420000 unionselect 176,420600,'襄樊市',420000 unionselect 177,420700,'鄂州市',420000 unionselect 178,420800,'荆门市',420000 unionselect 179,420900,'孝感市',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 220,445300,'云浮市',440000 unionselect 221,450100,'南宁市',450000 unionselect 222,450200,'柳州市',450000 unionselect 223,450300,'桂林市',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 unionselect 261,513400,'凉⼭彝族⾃治州',510000 unionselect 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 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 unionselect 345,659000,'省直辖⾏政单位',650000INSERT INTO area (id,areaID,area,fatherID)select 1,110101,'东城区',110100 unionselect 2,110102,'西城区',110100 unionselect 12,110113,'顺义区',110100 union select 13,110114,'昌平区',110100 union select 14,110115,'⼤兴区',110100 union select 15,110116,'怀柔区',110100 union select 16,110117,'平⾕区',110100 union select 17,110228,'密云县',110200 union select 18,110229,'延庆县',110200 union select 19,120101,'和平区',120100 union select 20,120102,'河东区',120100 union select 21,120103,'河西区',120100 union select 22,120104,'南开区',120100 union select 23,120105,'河北区',120100 union select 24,120106,'红桥区',120100 union select 25,120107,'塘沽区',120100 union select 26,120108,'汉沽区',120100 union select 27,120109,'⼤港区',120100 union select 28,120110,'东丽区',120100 union select 29,120111,'西青区',120100 union select 30,120112,'津南区',120100 union select 31,120113,'北⾠区',120100 union select 32,120114,'武清区',120100 union select 33,120115,'宝坻区',120100 union select 34,120221,'宁河县',120200 union select 35,120223,'静海县',120200 union select 36,120225,'蓟 县',120200 union select 37,130101,'市辖区',130100 union select 38,130102,'长安区',130100 union select 39,130103,'桥东区',130100 union select 40,130104,'桥西区',130100 union select 41,130105,'新华区',130100 union select 42,130107,'井陉矿区',130100 union select 43,130108,'裕华区',130100 union select 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 union select 74,130281,'遵化市',130200 union select 75,130283,'迁安市',130200 union select 76,130301,'市辖区',130300 union select 77,130302,'海港区',130300 unionselect 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 union select 126,130603,'北市区',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 unionselect 162,130728,'怀安县',130700 unionselect 163,130729,'万全县',130700 unionselect 164,130730,'怀来县',130700 unionselect 165,130731,'涿⿅县',130700 unionselect 166,130732,'⾚城县',130700 unionselect 167,130733,'崇礼县',130700 unionselect 168,130801,'市辖区',130800 unionselect 169,130802,'双桥区',130800 unionselect 170,130803,'双滦区',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 214,131125,'安平县',131100 unionselect 215,131126,'故城县',131100 unionselect 216,131127,'景 县',131100 unionselect 217,131128,'⾩城县',131100 unionselect 218,131181,'冀州市',131100 unionselect 219,131182,'深州市',131100 unionselect 220,140101,'市辖区',140100 unionselect 221,140105,'⼩店区',140100 unionselect 222,140106,'迎泽区',140100 unionselect 223,140107,'杏花岭区',140100 unionselect 224,140108,'尖草坪区',140100 unionselect 225,140109,'万柏林区',140100 unionselect 226,140110,'晋源区',140100 unionselect 227,140121,'清徐县',140100 unionselect 228,140122,'阳曲县',140100 unionselect 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 select 258,140428,'长⼦县',140400 union select 259,140429,'武乡县',140400 union select 260,140430,'沁 县',140400 union select 261,140431,'沁源县',140400 union select 262,140481,'潞城市',140400 union select 263,140501,'市辖区',140500 union select 264,140502,'城 区',140500 union select 265,140521,'沁⽔县',140500 union select 266,140522,'阳城县',140500 union select 267,140524,'陵川县',140500 union select 268,140525,'泽州县',140500 union select 269,140581,'⾼平市',140500 union select 270,140601,'市辖区',140600 union select 271,140602,'朔城区',140600 union select 272,140603,'平鲁区',140600 union select 273,140621,'⼭阴县',140600 union select 274,140622,'应 县',140600 union select 275,140623,'右⽟县',140600 union select 276,140624,'怀仁县',140600 union select 277,140701,'市辖区',140700 union select 278,140702,'榆次区',140700 union select 279,140721,'榆社县',140700 union select 280,140722,'左权县',140700 union select 281,140723,'和顺县',140700 union select 282,140724,'昔阳县',140700 union select 283,140725,'寿阳县',140700 union select 284,140726,'太⾕县',140700 union select 285,140727,'祁 县',140700 union select 286,140728,'平遥县',140700 union select 287,140729,'灵⽯县',140700 union select 288,140781,'介休市',140700 union select 289,140801,'市辖区',140800 union select 290,140802,'盐湖区',140800 union select 291,140821,'临猗县',140800 union select 292,140822,'万荣县',140800 union select 293,140823,'闻喜县',140800 union select 294,140824,'稷⼭县',140800 union select 295,140825,'新绛县',140800 union select 296,140826,'绛 县',140800 union select 297,140827,'垣曲县',140800 union select 298,140828,'夏 县',140800 union select 299,140829,'平陆县',140800 union select 300,140830,'芮城县',140800 union select 301,140881,'永济市',140800 union select 302,140882,'河津市',140800 union select 303,140901,'市辖区',140900 union。
各省市SQL语句
--创建DBPromary数据库create database DBPromaryuse DBPromarygo--创建promary表create table promary(proID int primary key,proName varchar(50) not null)insert into promary values(1,'北京市')insert into promary values(2,'天津市')insert into promary values(3,'上海市')insert into promary values(4,'重庆市')insert into promary values(5,'河北省')insert into promary values(6,'山西省')insert into promary values(7,'台湾省')insert into promary values(8,'辽宁省')insert into promary values(9,'吉林省')insert into promary values(10,'黑龙江省')insert into promary values(11,'江苏省')insert into promary values(12,'浙江省')insert into promary values(13,'安徽省')insert into promary values(14,'福建省')insert into promary values(15,'江西省')insert into promary values(16,'山东省')insert into promary values(17,'河南省')insert into promary values(18,'湖北省')insert into promary values(19,'湖南省')insert into promary values(20,'广东省')insert into promary values(21,'甘肃省')insert into promary values(22,'四川省')insert into promary values(23,'贵州省')insert into promary values(24,'海南省')insert into promary values(25,'云南省')insert into promary values(26,'青海省')insert into promary values(27,'陕西省')insert into promary values(28,'广西壮族自治区') insert into promary values(29,'西藏自治区') insert into promary values(30,'宁夏回族自治区') insert into promary values(31,'新疆维吾尔自治区') insert into promary values(32,'内蒙古自治区') insert into promary values(33,'澳门特别行政区')insert into promary values(34,'香港特别行政区')create table city(cityID int not null,cityName varchar(50) primary key,proID int foreign key references promary(proID))--插入各个省的城市数据--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)insert into city values(6,'朔州市',6)insert into city values(7,'晋中市',6)insert into city values(8,'运城市',6)insert into city values(9,'忻州市',6)insert into city values(10,'临汾市',6)insert into city values(11,'吕梁市',6)--7台湾省(台湾本岛和澎湖共设7市、16县，其中台北市和高雄市为“院辖市”，直属“行政院”，其余属台湾省；市下设区，县下设市（县辖市）、镇、乡，合称区市镇乡。
全国省份城市表（sql版）
全国省份城市表（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：。
quan中国省市区三级数据库表.sql
# MySQL-Front 5.1 (Build 2.7)/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;/*!40101 SET SQL_MODE='' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;/*!40103 SET SQL_NOTES='ON' */;# Host: localhost Database: iptohat_area# ------------------------------------------------------# Server version 5.0.26## Source for table hat_area#CREATE TABLE hat_area (id int(11) NOT NULL auto_increment,areaID varchar(50) default NULL,area varchar(60) default NULL,father varchar(6) default NULL,primary key(id)) ENGINE=MyISAM AUTO_INCREMENT=3145 DEFAULT CHARSET=utf8;## Dumping data for table hat_area#INSERT INTO hat_area VALUES (1,'110101','东城区','110100'); INSERT INTO hat_area VALUES (2,'110102','西城区','110100'); INSERT INTO hat_area VALUES (3,'110103','崇文区','110100'); INSERT INTO hat_area VALUES (4,'110104','宣武区','110100'); INSERT INTO hat_area VALUES (5,'110105','朝阳区','110100'); INSERT INTO hat_area VALUES (6,'110106','丰台区','110100'); INSERT INTO hat_area VALUES (7,'110107','石景山区','110100'); INSERT INTO hat_area VALUES (8,'110108','海淀区','110100'); INSERT INTO hat_area VALUES (9,'110109','门头沟区','110100'); INSERT INTO hat_area VALUES (10,'110111','房山区','110100'); INSERT INTO hat_area VALUES (11,'110112','通州区','110100'); INSERT INTO hat_area VALUES (12,'110113','顺义区','110100'); INSERT INTO hat_area VALUES (13,'110114','昌平区','110100'); INSERT INTO hat_area VALUES (14,'110115','大兴区','110100'); INSERT INTO hat_area VALUES (15,'110116','怀柔区','110100'); INSERT INTO hat_area VALUES (16,'110117','平谷区','110100');INSERT INTO hat_area VALUES (18,'110229','延庆县','110200'); INSERT INTO hat_area VALUES (19,'120101','和平区','120100'); INSERT INTO hat_area VALUES (20,'120102','河东区','120100'); INSERT INTO hat_area VALUES (21,'120103','河西区','120100'); INSERT INTO hat_area VALUES (22,'120104','南开区','120100'); INSERT INTO hat_area VALUES (23,'120105','河北区','120100'); INSERT INTO hat_area VALUES (24,'120106','红桥区','120100'); INSERT INTO hat_area VALUES (25,'120107','塘沽区','120100'); INSERT INTO hat_area VALUES (26,'120108','汉沽区','120100'); INSERT INTO hat_area VALUES (27,'120109','大港区','120100'); INSERT INTO hat_area VALUES (28,'120110','东丽区','120100'); INSERT INTO hat_area VALUES (29,'120111','西青区','120100'); INSERT INTO hat_area VALUES (30,'120112','津南区','120100'); INSERT INTO hat_area VALUES (31,'120113','北辰区','120100'); INSERT INTO hat_area VALUES (32,'120114','武清区','120100'); INSERT INTO hat_area VALUES (33,'120115','宝坻区','120100'); INSERT INTO hat_area VALUES (34,'120221','宁河县','120200'); INSERT INTO hat_area VALUES (35,'120223','静海县','120200'); INSERT INTO hat_area VALUES (36,'120225','蓟县','120200'); INSERT INTO hat_area VALUES (37,'130101','市辖区','130100'); INSERT INTO hat_area VALUES (38,'130102','长安区','130100'); INSERT INTO hat_area VALUES (39,'130103','桥东区','130100'); INSERT INTO hat_area VALUES (40,'130104','桥西区','130100'); INSERT INTO hat_area VALUES (41,'130105','新华区','130100'); INSERT INTO hat_area VALUES (42,'130107','井陉矿区','130100'); INSERT INTO hat_area VALUES (43,'130108','裕华区','130100'); INSERT INTO hat_area VALUES (44,'130121','井陉县','130100'); INSERT INTO hat_area VALUES (45,'130123','正定县','130100'); INSERT INTO hat_area VALUES (46,'130124','栾城县','130100'); INSERT INTO hat_area VALUES (47,'130125','行唐县','130100'); INSERT INTO hat_area VALUES (48,'130126','灵寿县','130100'); INSERT INTO hat_area VALUES (49,'130127','高邑县','130100'); INSERT INTO hat_area VALUES (50,'130128','深泽县','130100'); INSERT INTO hat_area VALUES (51,'130129','赞皇县','130100'); INSERT INTO hat_area VALUES (52,'130130','无极县','130100'); INSERT INTO hat_area VALUES (53,'130131','平山县','130100'); INSERT INTO hat_area VALUES (54,'130132','元氏县','130100'); INSERT INTO hat_area VALUES (55,'130133','赵县','130100'); INSERT INTO hat_area VALUES (56,'130181','辛集市','130100'); INSERT INTO hat_area VALUES (57,'130182','藁城市','130100'); INSERT INTO hat_area VALUES (58,'130183','晋州市','130100'); INSERT INTO hat_area VALUES (59,'130184','新乐市','130100'); INSERT INTO hat_area VALUES (60,'130185','鹿泉市','130100');INSERT INTO hat_area VALUES (62,'130202','路南区','130200'); INSERT INTO hat_area VALUES (63,'130203','路北区','130200'); INSERT INTO hat_area VALUES (64,'130204','古冶区','130200'); INSERT INTO hat_area VALUES (65,'130205','开平区','130200'); INSERT INTO hat_area VALUES (66,'130207','丰南区','130200'); INSERT INTO hat_area VALUES (67,'130208','丰润区','130200'); INSERT INTO hat_area VALUES (68,'130223','滦县','130200'); INSERT INTO hat_area VALUES (69,'130224','滦南县','130200'); INSERT INTO hat_area VALUES (70,'130225','乐亭县','130200'); INSERT INTO hat_area VALUES (71,'130227','迁西县','130200'); INSERT INTO hat_area VALUES (72,'130229','玉田县','130200'); INSERT INTO hat_area VALUES (73,'130230','唐海县','130200'); INSERT INTO hat_area VALUES (74,'130281','遵化市','130200'); INSERT INTO hat_area VALUES (75,'130283','迁安市','130200'); INSERT INTO hat_area VALUES (76,'130301','市辖区','130300'); INSERT INTO hat_area VALUES (77,'130302','海港区','130300'); INSERT INTO hat_area VALUES (78,'130303','山海关区','130300'); INSERT INTO hat_area VALUES (79,'130304','北戴河区','130300'); INSERT INTO hat_area VALUES (80,'130321','青龙满族自治县','130300'); INSERT INTO hat_area VALUES (81,'130322','昌黎县','130300'); INSERT INTO hat_area VALUES (82,'130323','抚宁县','130300'); INSERT INTO hat_area VALUES (83,'130324','卢龙县','130300'); INSERT INTO hat_area VALUES (84,'130401','市辖区','130400'); INSERT INTO hat_area VALUES (85,'130402','邯山区','130400'); INSERT INTO hat_area VALUES (86,'130403','丛台区','130400'); INSERT INTO hat_area VALUES (87,'130404','复兴区','130400'); INSERT INTO hat_area VALUES (88,'130406','峰峰矿区','130400'); INSERT INTO hat_area VALUES (89,'130421','邯郸县','130400'); INSERT INTO hat_area VALUES (90,'130423','临漳县','130400'); INSERT INTO hat_area VALUES (91,'130424','成安县','130400'); INSERT INTO hat_area VALUES (92,'130425','大名县','130400'); INSERT INTO hat_area VALUES (93,'130426','涉县','130400'); INSERT INTO hat_area VALUES (94,'130427','磁县','130400'); INSERT INTO hat_area VALUES (95,'130428','肥乡县','130400'); INSERT INTO hat_area VALUES (96,'130429','永年县','130400'); INSERT INTO hat_area VALUES (97,'130430','邱县','130400'); INSERT INTO hat_area VALUES (98,'130431','鸡泽县','130400'); INSERT INTO hat_area VALUES (99,'130432','广平县','130400'); INSERT INTO hat_area VALUES (100,'130433','馆陶县','130400'); INSERT INTO hat_area VALUES (101,'130434','魏县','130400'); INSERT INTO hat_area VALUES (102,'130435','曲周县','130400'); INSERT INTO hat_area VALUES (103,'130481','武安市','130400'); INSERT INTO hat_area VALUES (104,'130501','市辖区','130500');INSERT INTO hat_area VALUES (106,'130503','桥西区','130500'); INSERT INTO hat_area VALUES (107,'130521','邢台县','130500'); INSERT INTO hat_area VALUES (108,'130522','临城县','130500'); INSERT INTO hat_area VALUES (109,'130523','内丘县','130500'); INSERT INTO hat_area VALUES (110,'130524','柏乡县','130500'); INSERT INTO hat_area VALUES (111,'130525','隆尧县','130500'); INSERT INTO hat_area VALUES (112,'130526','任县','130500'); INSERT INTO hat_area VALUES (113,'130527','南和县','130500'); INSERT INTO hat_area VALUES (114,'130528','宁晋县','130500'); INSERT INTO hat_area VALUES (115,'130529','巨鹿县','130500'); INSERT INTO hat_area VALUES (116,'130530','新河县','130500'); INSERT INTO hat_area VALUES (117,'130531','广宗县','130500'); INSERT INTO hat_area VALUES (118,'130532','平乡县','130500'); INSERT INTO hat_area VALUES (119,'130533','威县','130500'); INSERT INTO hat_area VALUES (120,'130534','清河县','130500'); INSERT INTO hat_area VALUES (121,'130535','临西县','130500'); INSERT INTO hat_area VALUES (122,'130581','南宫市','130500'); INSERT INTO hat_area VALUES (123,'130582','沙河市','130500'); INSERT INTO hat_area VALUES (124,'130601','市辖区','130600'); INSERT INTO hat_area VALUES (125,'130602','新市区','130600'); INSERT INTO hat_area VALUES (126,'130603','北市区','130600'); INSERT INTO hat_area VALUES (127,'130604','南市区','130600'); INSERT INTO hat_area VALUES (128,'130621','满城县','130600'); INSERT INTO hat_area VALUES (129,'130622','清苑县','130600'); INSERT INTO hat_area VALUES (130,'130623','涞水县','130600'); INSERT INTO hat_area VALUES (131,'130624','阜平县','130600'); INSERT INTO hat_area VALUES (132,'130625','徐水县','130600'); INSERT INTO hat_area VALUES (133,'130626','定兴县','130600'); INSERT INTO hat_area VALUES (134,'130627','唐县','130600'); INSERT INTO hat_area VALUES (135,'130628','高阳县','130600'); INSERT INTO hat_area VALUES (136,'130629','容城县','130600'); INSERT INTO hat_area VALUES (137,'130630','涞源县','130600'); INSERT INTO hat_area VALUES (138,'130631','望都县','130600'); INSERT INTO hat_area VALUES (139,'130632','安新县','130600'); INSERT INTO hat_area VALUES (140,'130633','易县','130600'); INSERT INTO hat_area VALUES (141,'130634','曲阳县','130600'); INSERT INTO hat_area VALUES (142,'130635','蠡县','130600'); INSERT INTO hat_area VALUES (143,'130636','顺平县','130600'); INSERT INTO hat_area VALUES (144,'130637','博野县','130600'); INSERT INTO hat_area VALUES (145,'130638','雄县','130600'); INSERT INTO hat_area VALUES (146,'130681','涿州市','130600'); INSERT INTO hat_area VALUES (147,'130682','定州市','130600'); INSERT INTO hat_area VALUES (148,'130683','安国市','130600');INSERT INTO hat_area VALUES (150,'130701','市辖区','130700');INSERT INTO hat_area VALUES (151,'130702','桥东区','130700');INSERT INTO hat_area VALUES (152,'130703','桥西区','130700');INSERT INTO hat_area VALUES (153,'130705','宣化区','130700');INSERT INTO hat_area VALUES (154,'130706','下花园区','130700');INSERT INTO hat_area VALUES (155,'130721','宣化县','130700');INSERT INTO hat_area VALUES (156,'130722','张北县','130700');INSERT INTO hat_area VALUES (157,'130723','康保县','130700');INSERT INTO hat_area VALUES (158,'130724','沽源县','130700');INSERT INTO hat_area VALUES (159,'130725','尚义县','130700');INSERT INTO hat_area VALUES (160,'130726','蔚县','130700');INSERT INTO hat_area VALUES (161,'130727','阳原县','130700');INSERT INTO hat_area VALUES (162,'130728','怀安县','130700');INSERT INTO hat_area VALUES (163,'130729','万全县','130700');INSERT INTO hat_area VALUES (164,'130730','怀来县','130700');INSERT INTO hat_area VALUES (165,'130731','涿鹿县','130700');INSERT INTO hat_area VALUES (166,'130732','赤城县','130700');INSERT INTO hat_area VALUES (167,'130733','崇礼县','130700');INSERT INTO hat_area VALUES (168,'130801','市辖区','130800');INSERT INTO hat_area VALUES (169,'130802','双桥区','130800');INSERT INTO hat_area VALUES (170,'130803','双滦区','130800');INSERT INTO hat_area VALUES (171,'130804','鹰手营子矿区','130800'); INSERT INTO hat_area VALUES (172,'130821','承德县','130800');INSERT INTO hat_area VALUES (173,'130822','兴隆县','130800');INSERT INTO hat_area VALUES (174,'130823','平泉县','130800');INSERT INTO hat_area VALUES (175,'130824','滦平县','130800');INSERT INTO hat_area VALUES (176,'130825','隆化县','130800');INSERT INTO hat_area VALUES (177,'130826','丰宁满族自治县','130800'); INSERT INTO hat_area VALUES (178,'130827','宽城满族自治县','130800'); INSERT INTO hat_area VALUES (179,'130828','围场满族蒙古族自治县','130800'); INSERT INTO hat_area VALUES (180,'130901','市辖区','130900');INSERT INTO hat_area VALUES (181,'130902','新华区','130900');INSERT INTO hat_area VALUES (182,'130903','运河区','130900');INSERT INTO hat_area VALUES (183,'130921','沧县','130900');INSERT INTO hat_area VALUES (184,'130922','青县','130900');INSERT INTO hat_area VALUES (185,'130923','东光县','130900');INSERT INTO hat_area VALUES (186,'130924','海兴县','130900');INSERT INTO hat_area VALUES (187,'130925','盐山县','130900');INSERT INTO hat_area VALUES (188,'130926','肃宁县','130900');INSERT INTO hat_area VALUES (189,'130927','南皮县','130900');INSERT INTO hat_area VALUES (190,'130928','吴桥县','130900');INSERT INTO hat_area VALUES (191,'130929','献县','130900');INSERT INTO hat_area VALUES (192,'130930','孟村回族自治县','130900');INSERT INTO hat_area VALUES (194,'130982','任丘市','130900'); INSERT INTO hat_area VALUES (195,'130983','黄骅市','130900'); INSERT INTO hat_area VALUES (196,'130984','河间市','130900'); INSERT INTO hat_area VALUES (197,'131001','市辖区','131000'); INSERT INTO hat_area VALUES (198,'131002','安次区','131000'); INSERT INTO hat_area VALUES (199,'131003','广阳区','131000'); INSERT INTO hat_area VALUES (200,'131022','固安县','131000'); INSERT INTO hat_area VALUES (201,'131023','永清县','131000'); INSERT INTO hat_area VALUES (202,'131024','香河县','131000'); INSERT INTO hat_area VALUES (203,'131025','大城县','131000'); INSERT INTO hat_area VALUES (204,'131026','文安县','131000'); INSERT INTO hat_area VALUES (205,'131028','大厂回族自治县','131000'); INSERT INTO hat_area VALUES (206,'131081','霸州市','131000'); INSERT INTO hat_area VALUES (207,'131082','三河市','131000'); INSERT INTO hat_area VALUES (208,'131101','市辖区','131100'); INSERT INTO hat_area VALUES (209,'131102','桃城区','131100'); INSERT INTO hat_area VALUES (210,'131121','枣强县','131100'); INSERT INTO hat_area VALUES (211,'131122','武邑县','131100'); INSERT INTO hat_area VALUES (212,'131123','武强县','131100'); INSERT INTO hat_area VALUES (213,'131124','饶阳县','131100'); INSERT INTO hat_area VALUES (214,'131125','安平县','131100'); INSERT INTO hat_area VALUES (215,'131126','故城县','131100'); INSERT INTO hat_area VALUES (216,'131127','景县','131100'); INSERT INTO hat_area VALUES (217,'131128','阜城县','131100'); INSERT INTO hat_area VALUES (218,'131181','冀州市','131100'); INSERT INTO hat_area VALUES (219,'131182','深州市','131100'); INSERT INTO hat_area VALUES (220,'140101','市辖区','140100'); INSERT INTO hat_area VALUES (221,'140105','小店区','140100'); INSERT INTO hat_area VALUES (222,'140106','迎泽区','140100'); INSERT INTO hat_area VALUES (223,'140107','杏花岭区','140100'); INSERT INTO hat_area VALUES (224,'140108','尖草坪区','140100'); INSERT INTO hat_area VALUES (225,'140109','万柏林区','140100'); INSERT INTO hat_area VALUES (226,'140110','晋源区','140100'); INSERT INTO hat_area VALUES (227,'140121','清徐县','140100'); INSERT INTO hat_area VALUES (228,'140122','阳曲县','140100'); INSERT INTO hat_area VALUES (229,'140123','娄烦县','140100'); INSERT INTO hat_area VALUES (230,'140181','古交市','140100'); INSERT INTO hat_area VALUES (231,'140201','市辖区','140200'); INSERT INTO hat_area VALUES (232,'140202','城区','140200'); INSERT INTO hat_area VALUES (233,'140203','矿区','140200'); INSERT INTO hat_area VALUES (234,'140211','南郊区','140200'); INSERT INTO hat_area VALUES (235,'140212','新荣区','140200'); INSERT INTO hat_area VALUES (236,'140221','阳高县','140200');INSERT INTO hat_area VALUES (238,'140223','广灵县','140200'); INSERT INTO hat_area VALUES (239,'140224','灵丘县','140200'); INSERT INTO hat_area VALUES (240,'140225','浑源县','140200'); INSERT INTO hat_area VALUES (241,'140226','左云县','140200'); INSERT INTO hat_area VALUES (242,'140227','大同县','140200'); INSERT INTO hat_area VALUES (243,'140301','市辖区','140300'); INSERT INTO hat_area VALUES (244,'140302','城区','140300'); INSERT INTO hat_area VALUES (245,'140303','矿区','140300'); INSERT INTO hat_area VALUES (246,'140311','郊区','140300'); INSERT INTO hat_area VALUES (247,'140321','平定县','140300'); INSERT INTO hat_area VALUES (248,'140322','盂县','140300'); INSERT INTO hat_area VALUES (249,'140401','市辖区','140400'); INSERT INTO hat_area VALUES (250,'140402','城区','140400'); INSERT INTO hat_area VALUES (251,'140411','郊区','140400'); INSERT INTO hat_area VALUES (252,'140421','长治县','140400'); INSERT INTO hat_area VALUES (253,'140423','襄垣县','140400'); INSERT INTO hat_area VALUES (254,'140424','屯留县','140400'); INSERT INTO hat_area VALUES (255,'140425','平顺县','140400'); INSERT INTO hat_area VALUES (256,'140426','黎城县','140400'); INSERT INTO hat_area VALUES (257,'140427','壶关县','140400'); INSERT INTO hat_area VALUES (258,'140428','长子县','140400'); INSERT INTO hat_area VALUES (259,'140429','武乡县','140400'); INSERT INTO hat_area VALUES (260,'140430','沁县','140400'); INSERT INTO hat_area VALUES (261,'140431','沁源县','140400'); INSERT INTO hat_area VALUES (262,'140481','潞城市','140400'); INSERT INTO hat_area VALUES (263,'140501','市辖区','140500'); INSERT INTO hat_area VALUES (264,'140502','城区','140500'); INSERT INTO hat_area VALUES (265,'140521','沁水县','140500'); INSERT INTO hat_area VALUES (266,'140522','阳城县','140500'); INSERT INTO hat_area VALUES (267,'140524','陵川县','140500'); INSERT INTO hat_area VALUES (268,'140525','泽州县','140500'); INSERT INTO hat_area VALUES (269,'140581','高平市','140500'); INSERT INTO hat_area VALUES (270,'140601','市辖区','140600'); INSERT INTO hat_area VALUES (271,'140602','朔城区','140600'); INSERT INTO hat_area VALUES (272,'140603','平鲁区','140600'); INSERT INTO hat_area VALUES (273,'140621','山阴县','140600'); INSERT INTO hat_area VALUES (274,'140622','应县','140600'); INSERT INTO hat_area VALUES (275,'140623','右玉县','140600'); INSERT INTO hat_area VALUES (276,'140624','怀仁县','140600'); INSERT INTO hat_area VALUES (277,'140701','市辖区','140700'); INSERT INTO hat_area VALUES (278,'140702','榆次区','140700'); INSERT INTO hat_area VALUES (279,'140721','榆社县','140700'); INSERT INTO hat_area VALUES (280,'140722','左权县','140700');INSERT INTO hat_area VALUES (282,'140724','昔阳县','140700'); INSERT INTO hat_area VALUES (283,'140725','寿阳县','140700'); INSERT INTO hat_area VALUES (284,'140726','太谷县','140700'); INSERT INTO hat_area VALUES (285,'140727','祁县','140700'); INSERT INTO hat_area VALUES (286,'140728','平遥县','140700'); INSERT INTO hat_area VALUES (287,'140729','灵石县','140700'); INSERT INTO hat_area VALUES (288,'140781','介休市','140700'); INSERT INTO hat_area VALUES (289,'140801','市辖区','140800'); INSERT INTO hat_area VALUES (290,'140802','盐湖区','140800'); INSERT INTO hat_area VALUES (291,'140821','临猗县','140800'); INSERT INTO hat_area VALUES (292,'140822','万荣县','140800'); INSERT INTO hat_area VALUES (293,'140823','闻喜县','140800'); INSERT INTO hat_area VALUES (294,'140824','稷山县','140800'); INSERT INTO hat_area VALUES (295,'140825','新绛县','140800'); INSERT INTO hat_area VALUES (296,'140826','绛县','140800'); INSERT INTO hat_area VALUES (297,'140827','垣曲县','140800'); INSERT INTO hat_area VALUES (298,'140828','夏县','140800'); INSERT INTO hat_area VALUES (299,'140829','平陆县','140800'); INSERT INTO hat_area VALUES (300,'140830','芮城县','140800'); INSERT INTO hat_area VALUES (301,'140881','永济市','140800'); INSERT INTO hat_area VALUES (302,'140882','河津市','140800'); INSERT INTO hat_area VALUES (303,'140901','市辖区','140900'); INSERT INTO hat_area VALUES (304,'140902','忻府区','140900'); INSERT INTO hat_area VALUES (305,'140921','定襄县','140900'); INSERT INTO hat_area VALUES (306,'140922','五台县','140900'); INSERT INTO hat_area VALUES (307,'140923','代县','140900'); INSERT INTO hat_area VALUES (308,'140924','繁峙县','140900'); INSERT INTO hat_area VALUES (309,'140925','宁武县','140900'); INSERT INTO hat_area VALUES (310,'140926','静乐县','140900'); INSERT INTO hat_area VALUES (311,'140927','神池县','140900'); INSERT INTO hat_area VALUES (312,'140928','五寨县','140900'); INSERT INTO hat_area VALUES (313,'140929','岢岚县','140900'); INSERT INTO hat_area VALUES (314,'140930','河曲县','140900'); INSERT INTO hat_area VALUES (315,'140931','保德县','140900'); INSERT INTO hat_area VALUES (316,'140932','偏关县','140900'); INSERT INTO hat_area VALUES (317,'140981','原平市','140900'); INSERT INTO hat_area VALUES (318,'141001','市辖区','141000'); INSERT INTO hat_area VALUES (319,'141002','尧都区','141000'); INSERT INTO hat_area VALUES (320,'141021','曲沃县','141000'); INSERT INTO hat_area VALUES (321,'141022','翼城县','141000'); INSERT INTO hat_area VALUES (322,'141023','襄汾县','141000'); INSERT INTO hat_area VALUES (323,'141024','洪洞县','141000'); INSERT INTO hat_area VALUES (324,'141025','古县','141000');INSERT INTO hat_area VALUES (326,'141027','浮山县','141000'); INSERT INTO hat_area VALUES (327,'141028','吉县','141000'); INSERT INTO hat_area VALUES (328,'141029','乡宁县','141000'); INSERT INTO hat_area VALUES (329,'141030','大宁县','141000'); INSERT INTO hat_area VALUES (330,'141031','隰县','141000'); INSERT INTO hat_area VALUES (331,'141032','永和县','141000'); INSERT INTO hat_area VALUES (332,'141033','蒲县','141000'); INSERT INTO hat_area VALUES (333,'141034','汾西县','141000'); INSERT INTO hat_area VALUES (334,'141081','侯马市','141000'); INSERT INTO hat_area VALUES (335,'141082','霍州市','141000'); INSERT INTO hat_area VALUES (336,'141101','市辖区','141100'); INSERT INTO hat_area VALUES (337,'141102','离石区','141100'); INSERT INTO hat_area VALUES (338,'141121','文水县','141100'); INSERT INTO hat_area VALUES (339,'141122','交城县','141100'); INSERT INTO hat_area VALUES (340,'141123','兴县','141100'); INSERT INTO hat_area VALUES (341,'141124','临县','141100'); INSERT INTO hat_area VALUES (342,'141125','柳林县','141100'); INSERT INTO hat_area VALUES (343,'141126','石楼县','141100'); INSERT INTO hat_area VALUES (344,'141127','岚县','141100'); INSERT INTO hat_area VALUES (345,'141128','方山县','141100'); INSERT INTO hat_area VALUES (346,'141129','中阳县','141100'); INSERT INTO hat_area VALUES (347,'141130','交口县','141100'); INSERT INTO hat_area VALUES (348,'141181','孝义市','141100'); INSERT INTO hat_area VALUES (349,'141182','汾阳市','141100'); INSERT INTO hat_area VALUES (350,'150101','市辖区','150100'); INSERT INTO hat_area VALUES (351,'150102','新城区','150100'); INSERT INTO hat_area VALUES (352,'150103','回民区','150100'); INSERT INTO hat_area VALUES (353,'150104','玉泉区','150100'); INSERT INTO hat_area VALUES (354,'150105','赛罕区','150100'); INSERT INTO hat_area VALUES (355,'150121','土默特左旗','150100'); INSERT INTO hat_area VALUES (356,'150122','托克托县','150100'); INSERT INTO hat_area VALUES (357,'150123','和林格尔县','150100'); INSERT INTO hat_area VALUES (358,'150124','清水河县','150100'); INSERT INTO hat_area VALUES (359,'150125','武川县','150100'); INSERT INTO hat_area VALUES (360,'150201','市辖区','150200'); INSERT INTO hat_area VALUES (361,'150202','东河区','150200'); INSERT INTO hat_area VALUES (362,'150203','昆都仑区','150200'); INSERT INTO hat_area VALUES (363,'150204','青山区','150200'); INSERT INTO hat_area VALUES (364,'150205','石拐区','150200'); INSERT INTO hat_area VALUES (365,'150206','白云矿区','150200'); INSERT INTO hat_area VALUES (366,'150207','九原区','150200'); INSERT INTO hat_area VALUES (367,'150221','土默特右旗','150200'); INSERT INTO hat_area VALUES (368,'150222','固阳县','150200');。
全国行政区表 包括(省、市、县)SQL
CREATE TABLE [dbo].[AreaCode_T] ([AreaCode_Code] [int] NOT NULL ,[AreaCode_Name] [varchar] (32) COLLATE Chinese_PRC_CI_AS NOT NULL) ON [PRIMARY]GOinsert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110000,'北京市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110101,'东城区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110102,'西城区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110103,'崇文区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110104,'宣武区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110105,'朝阳区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110106,'丰台区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110107,'石景山区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110108,'海淀区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110109,'门头沟区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110111,'房山区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110112,'通州区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110113,'顺义区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110114,'昌平区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110115,'大兴区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110116,'怀柔区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110117,'平谷区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110228,'密云县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (110229,'延庆县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120000,'天津市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120101,'和平区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120102,'河东区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120103,'河西区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120104,'南开区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120105,'河北区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120106,'红桥区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120107,'塘沽区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120108,'汉沽区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120109,'大港区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120110,'东丽区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120111,'西青区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120112,'津南区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120113,'北辰区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120114,'武清区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120221,'宁河县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120223,'静海县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (120225,'蓟县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130000,'河北省'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130100,'石家庄市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130102,'长安区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130103,'桥东区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130104,'桥西区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130105,'新华区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130107,'井陉矿区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130108,'裕华区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130121,'井陉县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130123,'正定县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130124,'栾城县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130125,'行唐县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130126,'灵寿县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130127,'高邑县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130128,'深泽县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130129,'赞皇县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130130,'无极县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130131,'平山县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130132,'元氏县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130133,'赵县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130181,'辛集市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130182,'藁城市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130183,'晋州市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130184,'新乐市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130185,'鹿泉市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130200,'唐山市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130202,'路南区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130203,'路北区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130204,'古冶区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130205,'开平区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130207,'丰南区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130208,'丰润区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130223,'滦县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130224,'滦南县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130225,'乐亭县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130227,'迁西县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130229,'玉田县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130230,'唐海县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130281,'遵化市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130283,'迁安市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130302,'海港区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130303,'山海关区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130304,'北戴河区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130321,'青龙满族自治县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130322,'昌黎县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130323,'抚宁县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130324,'卢龙县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130400,'邯郸市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130402,'邯山区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130403,'丛台区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130404,'复兴区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130406,'峰峰矿区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130421,'邯郸县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130423,'临漳县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130424,'成安县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130425,'大名县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130426,'涉县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130427,'磁县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130428,'肥乡县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130429,'永年县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130430,'邱县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130431,'鸡泽县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130432,'广平县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130433,'馆陶县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130434,'魏县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130435,'曲周县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130481,'武安市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130500,'邢台市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130502,'桥东区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130503,'桥西区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130521,'邢台县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130522,'临城县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130523,'内丘县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130524,'柏乡县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130525,'隆尧县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130526,'任县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130527,'南和县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130528,'宁晋县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130529,'巨鹿县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130530,'新河县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130531,'广宗县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130532,'平乡县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130534,'清河县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130535,'临西县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130581,'南宫市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130582,'沙河市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130600,'保定市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130602,'新市区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130603,'北市区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130604,'南市区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130621,'满城县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130622,'清苑县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130623,'涞水县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130624,'阜平县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130625,'徐水县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130626,'定兴县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130627,'唐县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130628,'高阳县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130629,'容城县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130630,'涞源县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130631,'望都县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130632,'安新县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130633,'易县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130634,'曲阳县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130635,'蠡县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130636,'顺平县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130637,'博野县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130638,'雄县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130681,'涿州市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130682,'定州市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130683,'安国市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130684,'高碑店市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130700,'张家口市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130702,'桥东区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130703,'桥西区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130705,'宣化区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130706,'下花园区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130721,'宣化县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130722,'张北县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130723,'康保县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130724,'沽源县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130725,'尚义县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130726,'蔚县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130727,'阳原县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130728,'怀安县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130730,'怀来县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130731,'涿鹿县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130732,'赤城县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130733,'崇礼县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130800,'承德市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130802,'双桥区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130803,'双滦区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130804,'鹰手营子矿区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130821,'承德县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130822,'兴隆县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130823,'平泉县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130824,'滦平县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130825,'隆化县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130826,'丰宁满族自治县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130827,'宽城满族自治县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130828,'围场满族蒙古族自治县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130900,'沧州市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130902,'新华区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130903,'运河区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130921,'沧县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130922,'青县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130923,'东光县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130924,'海兴县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130925,'盐山县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130926,'肃宁县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130927,'南皮县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130928,'吴桥县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130929,'献县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130930,'孟村回族自治县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130981,'泊头市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130982,'任丘市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130983,'黄骅市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (130984,'河间市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131000,'廊坊市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131002,'安次区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131003,'广阳区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131022,'固安县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131023,'永清县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131025,'大城县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131026,'文安县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131028,'大厂回族自治县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131081,'霸州市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131082,'三河市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131100,'衡水市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131102,'桃城区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131121,'枣强县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131122,'武邑县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131123,'武强县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131124,'饶阳县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131125,'安平县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131126,'故城县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131127,'景县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131128,'阜城县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131181,'冀州市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (131182,'深州市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140000,'山西省');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140100,'太原市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140105,'小店区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140106,'迎泽区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140107,'杏花岭区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140108,'尖草坪区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140109,'万柏林区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140110,'晋源区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140121,'清徐县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140122,'阳曲县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140123,'娄烦县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140181,'古交市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140200,'大同市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140202,'城区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140203,'矿区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140211,'南郊区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140212,'新荣区');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140221,'阳高县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140222,'天镇县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140223,'广灵县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140224,'灵丘县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140225,'浑源县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140226,'左云县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140227,'大同县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140300,'阳泉市');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140303,'矿区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140311,'郊区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140321,'平定县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140322,'盂县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140400,'长治市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140402,'城区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140411,'郊区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140421,'长治县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140423,'襄垣县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140424,'屯留县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140425,'平顺县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140426,'黎城县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140427,'壶关县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140428,'长子县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140429,'武乡县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140430,'沁县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140431,'沁源县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140481,'潞城市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140500,'晋城市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140502,'城区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140521,'沁水县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140522,'阳城县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140524,'陵川县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140525,'泽州县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140581,'高平市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140600,'朔州市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140602,'朔城区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140603,'平鲁区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140621,'山阴县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140622,'应县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140623,'右玉县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140624,'怀仁县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140700,'晋中市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140702,'榆次区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140721,'榆社县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140722,'左权县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140723,'和顺县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140724,'昔阳县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140725,'寿阳县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140726,'太谷县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140727,'祁县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140728,'平遥县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140729,'灵石县');insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140800,'运城市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140802,'盐湖区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140821,'临猗县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140822,'万荣县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140823,'闻喜县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140824,'稷山县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140825,'新绛县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140826,'绛县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140827,'垣曲县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140828,'夏县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140829,'平陆县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140830,'芮城县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140881,'永济市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140882,'河津市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140900,'忻州市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140902,'忻府区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140921,'定襄县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140922,'五台县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140923,'代县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140924,'繁峙县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140925,'宁武县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140926,'静乐县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140927,'神池县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140928,'五寨县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140929,'岢岚县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140930,'河曲县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140931,'保德县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140932,'偏关县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (140981,'原平市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141000,'临汾市'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141002,'尧都区'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141021,'曲沃县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141022,'翼城县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141023,'襄汾县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141024,'洪洞县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141025,'古县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141026,'安泽县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141027,'浮山县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141028,'吉县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141029,'乡宁县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141030,'大宁县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141031,'隰县'); insert into AreaCode_T([AreaCode_Code],[AreaCode_Name]) values (141032,'永和县');。
MySql全国省市区SQL语句
MySql全国省市区SQL语句CREATE TABLE IF NOT EXISTS `province` (`id` int(11) NOT NULL auto_increment,`provinceID` int(11) NOT NULL,`province` varchar(20) NOT NULL,PRIMARY KEY (`id`)) ENGINE=INNODB CHARSET=UTF8;INSERT INTO `province` (`id`, `provinceID`, `province`) VALUES(1, 110000, '北京市'),(2, 120000, '天津市'),(3, 130000, '河北省'),(4, 140000, '⼭西省'),(5, 150000, '内蒙古⾃治区'),(6, 210000, '辽宁省'),(7, 220000, '吉林省'),(8, 230000, '⿊龙江省'),(9, 310000, '上海市'),(10, 320000, '江苏省'),(11, 330000, '浙江省'),(12, 340000, '安徽省'),(13, 350000, '福建省'),(14, 360000, '江西省'),(15, 370000, '⼭东省'),(16, 410000, '河南省'),(17, 420000, '湖北省'),(18, 430000, '湖南省'),(19, 440000, '⼴东省'),(20, 450000, '⼴西壮族⾃治区'),(21, 460000, '海南省'),(22, 500000, '重庆市'),(23, 510000, '四川省'),(24, 520000, '贵州省'),(25, 530000, '云南省'),(26, 540000, '西藏⾃治区'),(27, 610000, '陕西省'),(28, 620000, '⽢肃省'),(29, 630000, '青海省'),(30, 640000, '宁夏回族⾃治区'),(31, 650000, '新疆维吾尔⾃治区'),(32, 710000, '台湾省'),(33, 810000, '⾹港特别⾏政区'),(34, 820000, '澳门特别⾏政区');CREATE TABLE IF NOT EXISTS `city` (`id` int(11) NOT NULL auto_increment,`cityID` int(11) NOT NULL,`city` varchar(20) NOT NULL,`fatherID` int(11) NOT NULL,PRIMARY KEY (`id`)) ENGINE=INNODB CHARSET=UTF8;INSERT INTO `city` (`id`, `cityID`, `city`, `fatherID`) VALUES(1, 110100, '市辖区', 110000),(2, 110200, '县', 110000),(3, 120100, '市辖区', 120000),(4, 120200, '县', 120000),(5, 130100, '⽯家庄市', 130000),(6, 130200, '唐⼭市', 130000),(7, 130300, '秦皇岛市', 130000),(8, 130400, '邯郸市', 130000),(17, 140200, '⼤同市', 140000),(18, 140300, '阳泉市', 140000),(19, 140400, '长治市', 140000),(20, 140500, '晋城市', 140000),(21, 140600, '朔州市', 140000),(22, 140700, '晋中市', 140000),(23, 140800, '运城市', 140000),(24, 140900, '忻州市', 140000),(25, 141000, '临汾市', 140000),(26, 141100, '吕梁市', 140000),(27, 150100, '呼和浩特市', 150000), (28, 150200, '包头市', 150000),(29, 150300, '乌海市', 150000),(30, 150400, '⾚峰市', 150000),(31, 150500, '通辽市', 150000),(32, 150600, '鄂尔多斯市', 150000), (33, 150700, '呼伦贝尔市', 150000), (34, 150800, '巴彦淖尔市', 150000), (35, 150900, '乌兰察布市', 150000), (36, 152200, '兴安盟', 150000),(37, 152500, '锡林郭勒盟', 150000), (38, 152900, '阿拉善盟', 150000), (39, 210100, '沈阳市', 210000),(40, 210200, '⼤连市', 210000),(41, 210300, '鞍⼭市', 210000),(42, 210400, '抚顺市', 210000),(43, 210500, '本溪市', 210000),(44, 210600, '丹东市', 210000),(45, 210700, '锦州市', 210000),(46, 210800, '营⼝市', 210000),(47, 210900, '⾩新市', 210000),(48, 211000, '辽阳市', 210000),(49, 211100, '盘锦市', 210000),(50, 211200, '铁岭市', 210000),(51, 211300, '朝阳市', 210000),(52, 211400, '葫芦岛市', 210000), (53, 220100, '长春市', 220000),(54, 220200, '吉林市', 220000),(55, 220300, '四平市', 220000),(56, 220400, '辽源市', 220000),(57, 220500, '通化市', 220000),(58, 220600, '⽩⼭市', 220000),(59, 220700, '松原市', 220000),(60, 220800, '⽩城市', 220000),(61, 222400, '延边朝鲜族⾃治州', 220000), (62, 230100, '哈尔滨市', 230000), (63, 230200, '齐齐哈尔市', 230000), (64, 230300, '鸡西市', 230000),(65, 230400, '鹤岗市', 230000),(66, 230500, '双鸭⼭市', 230000), (67, 230600, '⼤庆市', 230000),(68, 230700, '伊春市', 230000),(69, 230800, '佳⽊斯市', 230000), (70, 230900, '七台河市', 230000), (71, 231000, '牡丹江市', 230000), (72, 231100, '⿊河市', 230000),(73, 231200, '绥化市', 230000),(74, 232700, '⼤兴安岭地区', 230000), (75, 310100, '市辖区', 310000),(76, 310200, '县', 310000),(85, 320900, '盐城市', 320000), (86, 321000, '扬州市', 320000), (87, 321100, '镇江市', 320000), (88, 321200, '泰州市', 320000), (89, 321300, '宿迁市', 320000), (90, 330100, '杭州市', 330000), (91, 330200, '宁波市', 330000), (92, 330300, '温州市', 330000), (93, 330400, '嘉兴市', 330000), (94, 330500, '湖州市', 330000), (95, 330600, '绍兴市', 330000), (96, 330700, '⾦华市', 330000), (97, 330800, '衢州市', 330000), (98, 330900, '⾈⼭市', 330000), (99, 331000, '台州市', 330000), (100, 331100, '丽⽔市', 330000), (101, 340100, '合肥市', 340000), (102, 340200, '芜湖市', 340000), (103, 340300, '蚌埠市', 340000), (104, 340400, '淮南市', 340000), (105, 340500, '马鞍⼭市', 340000), (106, 340600, '淮北市', 340000), (107, 340700, '铜陵市', 340000), (108, 340800, '安庆市', 340000), (109, 341000, '黄⼭市', 340000), (110, 341100, '滁州市', 340000), (111, 341200, '⾩阳市', 340000), (112, 341300, '宿州市', 340000), (113, 341400, '巢湖市', 340000), (114, 341500, '六安市', 340000), (115, 341600, '亳州市', 340000), (116, 341700, '池州市', 340000), (117, 341800, '宣城市', 340000), (118, 350100, '福州市', 350000), (119, 350200, '厦门市', 350000), (120, 350300, '莆⽥市', 350000), (121, 350400, '三明市', 350000), (122, 350500, '泉州市', 350000), (123, 350600, '漳州市', 350000), (124, 350700, '南平市', 350000), (125, 350800, '龙岩市', 350000), (126, 350900, '宁德市', 350000), (127, 360100, '南昌市', 360000), (128, 360200, '景德镇市', 360000), (129, 360300, '萍乡市', 360000), (130, 360400, '九江市', 360000), (131, 360500, '新余市', 360000), (132, 360600, '鹰潭市', 360000), (133, 360700, '赣州市', 360000), (134, 360800, '吉安市', 360000), (135, 360900, '宜春市', 360000), (136, 361000, '抚州市', 360000), (137, 361100, '上饶市', 360000), (138, 370100, '济南市', 370000), (139, 370200, '青岛市', 370000), (140, 370300, '淄博市', 370000), (141, 370400, '枣庄市', 370000), (142, 370500, '东营市', 370000), (143, 370600, '烟台市', 370000), (144, 370700, '潍坊市', 370000),(153, 371600, '滨州市', 370000),(154, 371700, '荷泽市', 370000),(155, 410100, '郑州市', 410000),(156, 410200, '开封市', 410000),(157, 410300, '洛阳市', 410000),(158, 410400, '平顶⼭市', 410000),(159, 410500, '安阳市', 410000),(160, 410600, '鹤壁市', 410000),(161, 410700, '新乡市', 410000),(162, 410800, '焦作市', 410000),(163, 410900, '濮阳市', 410000),(164, 411000, '许昌市', 410000),(165, 411100, '漯河市', 410000),(166, 411200, '三门峡市', 410000),(167, 411300, '南阳市', 410000),(168, 411400, '商丘市', 410000),(169, 411500, '信阳市', 410000),(170, 411600, '周⼝市', 410000),(171, 411700, '驻马店市', 410000),(172, 420100, '武汉市', 420000),(173, 420200, '黄⽯市', 420000),(174, 420300, '⼗堰市', 420000),(175, 420500, '宜昌市', 420000),(176, 420600, '襄樊市', 420000),(177, 420700, '鄂州市', 420000),(178, 420800, '荆门市', 420000),(179, 420900, '孝感市', 420000),(180, 421000, '荆州市', 420000),(181, 421100, '黄冈市', 420000),(182, 421200, '咸宁市', 420000),(183, 421300, '随州市', 420000),(184, 422800, '恩施⼟家族苗族⾃治州', 420000), (185, 429000, '省直辖⾏政单位', 420000), (186, 430100, '长沙市', 430000),(187, 430200, '株洲市', 430000),(188, 430300, '湘潭市', 430000),(189, 430400, '衡阳市', 430000),(190, 430500, '邵阳市', 430000),(191, 430600, '岳阳市', 430000),(192, 430700, '常德市', 430000),(193, 430800, '张家界市', 430000),(194, 430900, '益阳市', 430000),(195, 431000, '郴州市', 430000),(196, 431100, '永州市', 430000),(197, 431200, '怀化市', 430000),(198, 431300, '娄底市', 430000),(199, 433100, '湘西⼟家族苗族⾃治州', 430000), (200, 440100, '⼴州市', 440000),(201, 440200, '韶关市', 440000),(202, 440300, '深圳市', 440000),(203, 440400, '珠海市', 440000),(204, 440500, '汕头市', 440000),(205, 440600, '佛⼭市', 440000),(206, 440700, '江门市', 440000),(207, 440800, '湛江市', 440000),(208, 440900, '茂名市', 440000),(209, 441200, '肇庆市', 440000),(210, 441300, '惠州市', 440000),(211, 441400, '梅州市', 440000),(212, 441500, '汕尾市', 440000),(221, 450100, '南宁市', 450000),(222, 450200, '柳州市', 450000),(223, 450300, '桂林市', 450000),(224, 450400, '梧州市', 450000),(225, 450500, '北海市', 450000),(226, 450600, '防城港市', 450000),(227, 450700, '钦州市', 450000),(228, 450800, '贵港市', 450000),(229, 450900, '⽟林市', 450000),(230, 451000, '百⾊市', 450000),(231, 451100, '贺州市', 450000),(232, 451200, '河池市', 450000),(233, 451300, '来宾市', 450000),(234, 451400, '崇左市', 450000),(235, 460100, '海⼝市', 460000),(236, 460200, '三亚市', 460000),(237, 469000, '省直辖县级⾏政单位', 460000), (238, 500100, '市辖区', 500000),(239, 500200, '县', 500000),(240, 500300, '市', 500000),(241, 510100, '成都市', 510000),(242, 510300, '⾃贡市', 510000),(243, 510400, '攀枝花市', 510000),(244, 510500, '泸州市', 510000),(245, 510600, '德阳市', 510000),(246, 510700, '绵阳市', 510000),(247, 510800, '⼴元市', 510000),(248, 510900, '遂宁市', 510000),(249, 511000, '内江市', 510000),(250, 511100, '乐⼭市', 510000),(251, 511300, '南充市', 510000),(252, 511400, '眉⼭市', 510000),(253, 511500, '宜宾市', 510000),(254, 511600, '⼴安市', 510000),(255, 511700, '达州市', 510000),(256, 511800, '雅安市', 510000),(257, 511900, '巴中市', 510000),(258, 512000, '资阳市', 510000),(259, 513200, '阿坝藏族羌族⾃治州', 510000), (260, 513300, '⽢孜藏族⾃治州', 510000), (261, 513400, '凉⼭彝族⾃治州', 510000), (262, 520100, '贵阳市', 520000),(263, 520200, '六盘⽔市', 520000),(264, 520300, '遵义市', 520000),(265, 520400, '安顺市', 520000),(266, 522200, '铜仁地区', 520000),(267, 522300, '黔西南布依族苗族⾃治州', 520000), (268, 522400, '毕节地区', 520000),(269, 522600, '黔东南苗族侗族⾃治州', 520000), (270, 522700, '黔南布依族苗族⾃治州', 520000), (271, 530100, '昆明市', 530000),(272, 530300, '曲靖市', 530000),(273, 530400, '⽟溪市', 530000),(274, 530500, '保⼭市', 530000),(275, 530600, '昭通市', 530000),(276, 530700, '丽江市', 530000),(277, 530800, '思茅市', 530000),(278, 530900, '临沧市', 530000),(279, 532300, '楚雄彝族⾃治州', 530000), (280, 532500, '红河哈尼族彝族⾃治州', 530000),(285, 533300, '怒江傈僳族⾃治州', 530000), (286, 533400, '迪庆藏族⾃治州', 530000), (287, 540100, '拉萨市', 540000),(288, 542100, '昌都地区', 540000),(289, 542200, '⼭南地区', 540000),(290, 542300, '⽇喀则地区', 540000),(291, 542400, '那曲地区', 540000),(292, 542500, '阿⾥地区', 540000),(293, 542600, '林芝地区', 540000),(294, 610100, '西安市', 610000),(295, 610200, '铜川市', 610000),(296, 610300, '宝鸡市', 610000),(297, 610400, '咸阳市', 610000),(298, 610500, '渭南市', 610000),(299, 610600, '延安市', 610000),(300, 610700, '汉中市', 610000),(301, 610800, '榆林市', 610000),(302, 610900, '安康市', 610000),(303, 611000, '商洛市', 610000),(304, 620100, '兰州市', 620000),(305, 620200, '嘉峪关市', 620000),(306, 620300, '⾦昌市', 620000),(307, 620400, '⽩银市', 620000),(308, 620500, '天⽔市', 620000),(309, 620600, '武威市', 620000),(310, 620700, '张掖市', 620000),(311, 620800, '平凉市', 620000),(312, 620900, '酒泉市', 620000),(313, 621000, '庆阳市', 620000),(314, 621100, '定西市', 620000),(315, 621200, '陇南市', 620000),(316, 622900, '临夏回族⾃治州', 620000), (317, 623000, '⽢南藏族⾃治州', 620000), (318, 630100, '西宁市', 630000),(319, 632100, '海东地区', 630000),(320, 632200, '海北藏族⾃治州', 630000), (321, 632300, '黄南藏族⾃治州', 630000), (322, 632500, '海南藏族⾃治州', 630000), (323, 632600, '果洛藏族⾃治州', 630000), (324, 632700, '⽟树藏族⾃治州', 630000), (325, 632800, '海西蒙古族藏族⾃治州', 630000), (326, 640100, '银川市', 640000),(327, 640200, '⽯嘴⼭市', 640000),(328, 640300, '吴忠市', 640000),(329, 640400, '固原市', 640000),(330, 640500, '中卫市', 640000),(331, 650100, '乌鲁⽊齐市', 650000),(332, 650200, '克拉玛依市', 650000),(333, 652100, '吐鲁番地区', 650000),(334, 652200, '哈密地区', 650000),(335, 652300, '昌吉回族⾃治州', 650000), (336, 652700, '博尔塔拉蒙古⾃治州', 650000), (337, 652800, '巴⾳郭楞蒙古⾃治州', 650000), (338, 652900, '阿克苏地区', 650000),(339, 653000, '克孜勒苏柯尔克孜⾃治州', 650000), (340, 653100, '喀什地区', 650000),(341, 653200, '和⽥地区', 650000),(342, 654000, '伊犁哈萨克⾃治州', 650000), (343, 654200, '塔城地区', 650000),(344, 654300, '阿勒泰地区', 650000),(345, 659000, '省直辖⾏政单位', 650000); CREATE TABLE IF NOT EXISTS `area` (`id` int(11) NOT NULL auto_increment,) ENGINE=INNODB CHARSET=UTF8;INSERT INTO `area` (`id`, `areaID`, `area`, `fatherID`) VALUES (1, 110101, '东城区', 110100),(2, 110102, '西城区', 110100),(3, 110103, '崇⽂区', 110100),(4, 110104, '宣武区', 110100),(5, 110105, '朝阳区', 110100),(6, 110106, '丰台区', 110100),(7, 110107, '⽯景⼭区', 110100),(8, 110108, '海淀区', 110100),(9, 110109, '门头沟区', 110100),(10, 110111, '房⼭区', 110100),(11, 110112, '通州区', 110100),(12, 110113, '顺义区', 110100),(13, 110114, '昌平区', 110100),(14, 110115, '⼤兴区', 110100),(15, 110116, '怀柔区', 110100),(16, 110117, '平⾕区', 110100),(17, 110228, '密云县', 110200),(18, 110229, '延庆县', 110200),(19, 120101, '和平区', 120100),(20, 120102, '河东区', 120100),(21, 120103, '河西区', 120100),(22, 120104, '南开区', 120100),(23, 120105, '河北区', 120100),(24, 120106, '红桥区', 120100),(25, 120107, '塘沽区', 120100),(26, 120108, '汉沽区', 120100),(27, 120109, '⼤港区', 120100),(28, 120110, '东丽区', 120100),(29, 120111, '西青区', 120100),(30, 120112, '津南区', 120100),(31, 120113, '北⾠区', 120100),(32, 120114, '武清区', 120100),(33, 120115, '宝坻区', 120100),(34, 120221, '宁河县', 120200),(35, 120223, '静海县', 120200),(36, 120225, '蓟 县', 120200),(37, 130101, '市辖区', 130100),(38, 130102, '长安区', 130100),(39, 130103, '桥东区', 130100),(40, 130104, '桥西区', 130100),(41, 130105, '新华区', 130100),(42, 130107, '井陉矿区', 130100),(43, 130108, '裕华区', 130100),(44, 130121, '井陉县', 130100),(45, 130123, '正定县', 130100),(46, 130124, '栾城县', 130100),(47, 130125, '⾏唐县', 130100),(48, 130126, '灵寿县', 130100),(49, 130127, '⾼⾢县', 130100),(50, 130128, '深泽县', 130100),(51, 130129, '赞皇县', 130100),(52, 130130, '⽆极县', 130100),(53, 130131, '平⼭县', 130100),(54, 130132, '元⽒县', 130100),(55, 130133, '赵 县', 130100),(56, 130181, '⾟集市', 130100),(57, 130182, '藁城市', 130100),(58, 130183, '晋州市', 130100),(59, 130184, '新乐市', 130100),(60, 130185, '⿅泉市', 130100),(61, 130201, '市辖区', 130200),(70, 130225, '乐亭县', 130200), (71, 130227, '迁西县', 130200), (72, 130229, '⽟⽥县', 130200), (73, 130230, '唐海县', 130200), (74, 130281, '遵化市', 130200), (75, 130283, '迁安市', 130200), (76, 130301, '市辖区', 130300), (77, 130302, '海港区', 130300), (78, 130303, '⼭海关区', 130300), (79, 130304, '北戴河区', 130300), (80, 130321, '青龙满族⾃治县', 130300), (81, 130322, '昌黎县', 130300), (82, 130323, '抚宁县', 130300), (83, 130324, '卢龙县', 130300), (84, 130401, '市辖区', 130400), (85, 130402, '邯⼭区', 130400), (86, 130403, '丛台区', 130400), (87, 130404, '复兴区', 130400), (88, 130406, '峰峰矿区', 130400), (89, 130421, '邯郸县', 130400), (90, 130423, '临漳县', 130400), (91, 130424, '成安县', 130400), (92, 130425, '⼤名县', 130400), (93, 130426, '涉 县', 130400), (94, 130427, '磁 县', 130400), (95, 130428, '肥乡县', 130400), (96, 130429, '永年县', 130400), (97, 130430, '邱 县', 130400), (98, 130431, '鸡泽县', 130400), (99, 130432, '⼴平县', 130400), (100, 130433, '馆陶县', 130400), (101, 130434, '魏 县', 130400), (102, 130435, '曲周县', 130400), (103, 130481, '武安市', 130400), (104, 130501, '市辖区', 130500), (105, 130502, '桥东区', 130500), (106, 130503, '桥西区', 130500), (107, 130521, '邢台县', 130500), (108, 130522, '临城县', 130500), (109, 130523, '内丘县', 130500), (110, 130524, '柏乡县', 130500), (111, 130525, '隆尧县', 130500), (112, 130526, '任 县', 130500), (113, 130527, '南和县', 130500), (114, 130528, '宁晋县', 130500), (115, 130529, '巨⿅县', 130500), (116, 130530, '新河县', 130500), (117, 130531, '⼴宗县', 130500), (118, 130532, '平乡县', 130500), (119, 130533, '威 县', 130500), (120, 130534, '清河县', 130500), (121, 130535, '临西县', 130500), (122, 130581, '南宫市', 130500), (123, 130582, '沙河市', 130500), (124, 130601, '市辖区', 130600), (125, 130602, '新市区', 130600), (126, 130603, '北市区', 130600), (127, 130604, '南市区', 130600), (128, 130621, '满城县', 130600), (129, 130622, '清苑县', 130600),(138, 130631, '望都县', 130600),(139, 130632, '安新县', 130600),(140, 130633, '易 县', 130600),(141, 130634, '曲阳县', 130600),(142, 130635, '蠡 县', 130600),(143, 130636, '顺平县', 130600),(144, 130637, '博野县', 130600),(145, 130638, '雄 县', 130600),(146, 130681, '涿州市', 130600),(147, 130682, '定州市', 130600),(148, 130683, '安国市', 130600),(149, 130684, '⾼碑店市', 130600),(150, 130701, '市辖区', 130700),(151, 130702, '桥东区', 130700),(152, 130703, '桥西区', 130700),(153, 130705, '宣化区', 130700),(154, 130706, '下花园区', 130700),(155, 130721, '宣化县', 130700),(156, 130722, '张北县', 130700),(157, 130723, '康保县', 130700),(158, 130724, '沽源县', 130700),(159, 130725, '尚义县', 130700),(160, 130726, '蔚 县', 130700),(161, 130727, '阳原县', 130700),(162, 130728, '怀安县', 130700),(163, 130729, '万全县', 130700),(164, 130730, '怀来县', 130700),(165, 130731, '涿⿅县', 130700),(166, 130732, '⾚城县', 130700),(167, 130733, '崇礼县', 130700),(168, 130801, '市辖区', 130800),(169, 130802, '双桥区', 130800),(170, 130803, '双滦区', 130800),(171, 130804, '鹰⼿营⼦矿区', 130800), (172, 130821, '承德县', 130800),(173, 130822, '兴隆县', 130800),(174, 130823, '平泉县', 130800),(175, 130824, '滦平县', 130800),(176, 130825, '隆化县', 130800),(177, 130826, '丰宁满族⾃治县', 130800), (178, 130827, '宽城满族⾃治县', 130800), (179, 130828, '围场满族蒙古族⾃治县', 130800), (180, 130901, '市辖区', 130900),(181, 130902, '新华区', 130900),(182, 130903, '运河区', 130900),(183, 130921, '沧 县', 130900),(184, 130922, '青 县', 130900),(185, 130923, '东光县', 130900),(186, 130924, '海兴县', 130900),(187, 130925, '盐⼭县', 130900),(188, 130926, '肃宁县', 130900),(189, 130927, '南⽪县', 130900),(190, 130928, '吴桥县', 130900),(191, 130929, '献 县', 130900),(192, 130930, '孟村回族⾃治县', 130900), (193, 130981, '泊头市', 130900),(194, 130982, '任丘市', 130900),(195, 130983, '黄骅市', 130900),(196, 130984, '河间市', 130900),(197, 131001, '市辖区', 131000),(205, 131028, '⼤⼚回族⾃治县', 131000), (206, 131081, '霸州市', 131000), (207, 131082, '三河市', 131000), (208, 131101, '市辖区', 131100), (209, 131102, '桃城区', 131100), (210, 131121, '枣强县', 131100), (211, 131122, '武⾢县', 131100), (212, 131123, '武强县', 131100), (213, 131124, '饶阳县', 131100), (214, 131125, '安平县', 131100), (215, 131126, '故城县', 131100), (216, 131127, '景 县', 131100), (217, 131128, '⾩城县', 131100), (218, 131181, '冀州市', 131100), (219, 131182, '深州市', 131100), (220, 140101, '市辖区', 140100), (221, 140105, '⼩店区', 140100), (222, 140106, '迎泽区', 140100), (223, 140107, '杏花岭区', 140100), (224, 140108, '尖草坪区', 140100), (225, 140109, '万柏林区', 140100), (226, 140110, '晋源区', 140100), (227, 140121, '清徐县', 140100), (228, 140122, '阳曲县', 140100), (229, 140123, '娄烦县', 140100), (230, 140181, '古交市', 140100), (231, 140201, '市辖区', 140200), (232, 140202, '城 区', 140200), (233, 140203, '矿 区', 140200), (234, 140211, '南郊区', 140200), (235, 140212, '新荣区', 140200), (236, 140221, '阳⾼县', 140200), (237, 140222, '天镇县', 140200), (238, 140223, '⼴灵县', 140200), (239, 140224, '灵丘县', 140200), (240, 140225, '浑源县', 140200), (241, 140226, '左云县', 140200), (242, 140227, '⼤同县', 140200), (243, 140301, '市辖区', 140300), (244, 140302, '城 区', 140300), (245, 140303, '矿 区', 140300), (246, 140311, '郊 区', 140300), (247, 140321, '平定县', 140300), (248, 140322, '盂 县', 140300), (249, 140401, '市辖区', 140400), (250, 140402, '城 区', 140400), (251, 140411, '郊 区', 140400), (252, 140421, '长治县', 140400), (253, 140423, '襄垣县', 140400), (254, 140424, '屯留县', 140400), (255, 140425, '平顺县', 140400), (256, 140426, '黎城县', 140400), (257, 140427, '壶关县', 140400), (258, 140428, '长⼦县', 140400), (259, 140429, '武乡县', 140400), (260, 140430, '沁 县', 140400), (261, 140431, '沁源县', 140400), (262, 140481, '潞城市', 140400), (263, 140501, '市辖区', 140500), (264, 140502, '城 区', 140500), (265, 140521, '沁⽔县', 140500),(270, 140601, '市辖区', 140600), (271, 140602, '朔城区', 140600), (272, 140603, '平鲁区', 140600), (273, 140621, '⼭阴县', 140600), (274, 140622, '应 县', 140600), (275, 140623, '右⽟县', 140600), (276, 140624, '怀仁县', 140600), (277, 140701, '市辖区', 140700), (278, 140702, '榆次区', 140700), (279, 140721, '榆社县', 140700), (280, 140722, '左权县', 140700), (281, 140723, '和顺县', 140700), (282, 140724, '昔阳县', 140700), (283, 140725, '寿阳县', 140700), (284, 140726, '太⾕县', 140700), (285, 140727, '祁 县', 140700), (286, 140728, '平遥县', 140700), (287, 140729, '灵⽯县', 140700), (288, 140781, '介休市', 140700), (289, 140801, '市辖区', 140800), (290, 140802, '盐湖区', 140800), (291, 140821, '临猗县', 140800), (292, 140822, '万荣县', 140800), (293, 140823, '闻喜县', 140800), (294, 140824, '稷⼭县', 140800), (295, 140825, '新绛县', 140800), (296, 140826, '绛 县', 140800), (297, 140827, '垣曲县', 140800), (298, 140828, '夏 县', 140800), (299, 140829, '平陆县', 140800), (300, 140830, '芮城县', 140800), (301, 140881, '永济市', 140800), (302, 140882, '河津市', 140800), (303, 140901, '市辖区', 140900), (304, 140902, '忻府区', 140900), (305, 140921, '定襄县', 140900), (306, 140922, '五台县', 140900), (307, 140923, '代 县', 140900), (308, 140924, '繁峙县', 140900), (309, 140925, '宁武县', 140900), (310, 140926, '静乐县', 140900), (311, 140927, '神池县', 140900), (312, 140928, '五寨县', 140900), (313, 140929, '岢岚县', 140900), (314, 140930, '河曲县', 140900), (315, 140931, '保德县', 140900), (316, 140932, '偏关县', 140900), (317, 140981, '原平市', 140900), (318, 141001, '市辖区', 141000), (319, 141002, '尧都区', 141000), (320, 141021, '曲沃县', 141000), (321, 141022, '翼城县', 141000), (322, 141023, '襄汾县', 141000), (323, 141024, '洪洞县', 141000), (324, 141025, '古 县', 141000), (325, 141026, '安泽县', 141000), (326, 141027, '浮⼭县', 141000), (327, 141028, '吉 县', 141000), (328, 141029, '乡宁县', 141000), (329, 141030, '⼤宁县', 141000), (330, 141031, '隰 县', 141000), (331, 141032, '永和县', 141000), (332, 141033, '蒲 县', 141000), (333, 141034, '汾西县', 141000),(338, 141121, '⽂⽔县', 141100),(339, 141122, '交城县', 141100),(340, 141123, '兴 县', 141100),(341, 141124, '临 县', 141100),(342, 141125, '柳林县', 141100),(343, 141126, '⽯楼县', 141100),(344, 141127, '岚 县', 141100),(345, 141128, '⽅⼭县', 141100),(346, 141129, '中阳县', 141100),(347, 141130, '交⼝县', 141100),(348, 141181, '孝义市', 141100),(349, 141182, '汾阳市', 141100),(350, 150101, '市辖区', 150100),(351, 150102, '新城区', 150100),(352, 150103, '回民区', 150100),(353, 150104, '⽟泉区', 150100),(354, 150105, '赛罕区', 150100),(355, 150121, '⼟默特左旗', 150100), (356, 150122, '托克托县', 150100),(357, 150123, '和林格尔县', 150100), (358, 150124, '清⽔河县', 150100),(359, 150125, '武川县', 150100),(360, 150201, '市辖区', 150200),(361, 150202, '东河区', 150200),(362, 150203, '昆都仑区', 150200),(363, 150204, '青⼭区', 150200),(364, 150205, '⽯拐区', 150200),(365, 150206, '⽩云矿区', 150200),(366, 150207, '九原区', 150200),(367, 150221, '⼟默特右旗', 150200), (368, 150222, '固阳县', 150200),(369, 150223, '达尔罕茂明安联合旗', 150200), (370, 150301, '市辖区', 150300),(371, 150302, '海勃湾区', 150300),(372, 150303, '海南区', 150300),(373, 150304, '乌达区', 150300),(374, 150401, '市辖区', 150400),(375, 150402, '红⼭区', 150400),(376, 150403, '元宝⼭区', 150400),(377, 150404, '松⼭区', 150400),(378, 150421, '阿鲁科尔沁旗', 150400), (379, 150422, '巴林左旗', 150400),(380, 150423, '巴林右旗', 150400),(381, 150424, '林西县', 150400),(382, 150425, '克什克腾旗', 150400), (383, 150426, '翁⽜特旗', 150400),(384, 150428, '喀喇沁旗', 150400),(385, 150429, '宁城县', 150400),(386, 150430, '敖汉旗', 150400),(387, 150501, '市辖区', 150500),(388, 150502, '科尔沁区', 150500),(389, 150521, '科尔沁左翼中旗', 150500), (390, 150522, '科尔沁左翼后旗', 150500), (391, 150523, '开鲁县', 150500),(392, 150524, '库伦旗', 150500),(393, 150525, '奈曼旗', 150500),(394, 150526, '扎鲁特旗', 150500),(395, 150581, '霍林郭勒市', 150500), (396, 150602, '东胜区', 150600),(397, 150621, '达拉特旗', 150600),(398, 150622, '准格尔旗', 150600),(399, 150623, '鄂托克前旗', 150600), (400, 150624, '鄂托克旗', 150600),(401, 150625, '杭锦旗', 150600),。
全国省市县SQL数据库(大全)
全国省市县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');。
全国省市县SQL数据库(大全)
全国省市县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');。
sql_数据库__省市区_数据建表和数据
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,'南郊区。
全国省市区数据SQL-省市区
全国省市区数据SQL-省市区1 DROP TABLE IF EXISTS `provinces`;2 CREATE TABLE `provinces` (3 `id` int(11) NOT NULL auto_increment,4 `provinceid` varchar(20) NOT NULL,5 `province` varchar(50) NOT NULL,6 PRIMARY KEY (`id`)7 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='省份信息表';8910 insert into provinces(id,provinceid,province) values(1,'110000','北京市');11 insert into provinces(id,provinceid,province) values(2,'120000','天津市');12 insert into provinces(id,provinceid,province) values(3,'130000','河北省');13 insert into provinces(id,provinceid,province) values(4,'140000','⼭西省');14 insert into provinces(id,provinceid,province) values(5,'150000','内蒙古⾃治区');15 insert into provinces(id,provinceid,province) values(6,'210000','辽宁省');16 insert into provinces(id,provinceid,province) values(7,'220000','吉林省');17 insert into provinces(id,provinceid,province) values(8,'230000','⿊龙江省');18 insert into provinces(id,provinceid,province) values(9,'310000','上海市');19 insert into provinces(id,provinceid,province) values(10,'320000','江苏省');20 insert into provinces(id,provinceid,province) values(11,'330000','浙江省');21 insert into provinces(id,provinceid,province) values(12,'340000','安徽省');22 insert into provinces(id,provinceid,province) values(13,'350000','福建省');23 insert into provinces(id,provinceid,province) values(14,'360000','江西省');24 insert into provinces(id,provinceid,province) values(15,'370000','⼭东省');25 insert into provinces(id,provinceid,province) values(16,'410000','河南省');26 insert into provinces(id,provinceid,province) values(17,'420000','湖北省');27 insert into provinces(id,provinceid,province) values(18,'430000','湖南省');28 insert into provinces(id,provinceid,province) values(19,'440000','⼴东省');29 insert into provinces(id,provinceid,province) values(20,'450000','⼴西壮族⾃治区');30 insert into provinces(id,provinceid,province) values(21,'460000','海南省');31 insert into provinces(id,provinceid,province) values(22,'500000','重庆市');32 insert into provinces(id,provinceid,province) values(23,'510000','四川省');33 insert into provinces(id,provinceid,province) values(24,'520000','贵州省');34 insert into provinces(id,provinceid,province) values(25,'530000','云南省');35 insert into provinces(id,provinceid,province) values(26,'540000','西藏⾃治区');36 insert into provinces(id,provinceid,province) values(27,'610000','陕西省');37 insert into provinces(id,provinceid,province) values(28,'620000','⽢肃省');38 insert into provinces(id,provinceid,province) values(29,'630000','青海省');39 insert into provinces(id,provinceid,province) values(30,'640000','宁夏回族⾃治区');40 insert into provinces(id,provinceid,province) values(31,'650000','新疆维吾尔⾃治区');41 insert into provinces(id,provinceid,province) values(32,'710000','台湾省');42 insert into provinces(id,provinceid,province) values(33,'810000','⾹港特别⾏政区');43 insert into provinces(id,provinceid,province) values(34,'820000','澳门特别⾏政区');1 DROP TABLE IF EXISTS `cities`;2 CREATE TABLE `cities` (3 `id` int(11) NOT NULL auto_increment,4 `cityid` varchar(20) NOT NULL,5 `city` varchar(50) NOT NULL,6 `provinceid` varchar(20) NOT NULL,7 PRIMARY KEY (`id`)8 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='⾏政区域地州市信息表';910 insert into cities(id,cityid,city,provinceid) values(1,'110100','市辖区','110000');11 insert into cities(id,cityid,city,provinceid) values(2,'110200','县','110000');12 insert into cities(id,cityid,city,provinceid) values(3,'120100','市辖区','120000');13 insert into cities(id,cityid,city,provinceid) values(4,'120200','县','120000');14 insert into cities(id,cityid,city,provinceid) values(5,'130100','⽯家庄市','130000');15 insert into cities(id,cityid,city,provinceid) values(6,'130200','唐⼭市','130000');16 insert into cities(id,cityid,city,provinceid) values(7,'130300','秦皇岛市','130000');17 insert into cities(id,cityid,city,provinceid) values(8,'130400','邯郸市','130000');18 insert into cities(id,cityid,city,provinceid) values(9,'130500','邢台市','130000');19 insert into cities(id,cityid,city,provinceid) values(10,'130600','保定市','130000');20 insert into cities(id,cityid,city,provinceid) values(11,'130700','张家⼝市','130000');21 insert into cities(id,cityid,city,provinceid) values(12,'130800','承德市','130000');22 insert into cities(id,cityid,city,provinceid) values(13,'130900','沧州市','130000');23 insert into cities(id,cityid,city,provinceid) values(14,'131000','廊坊市','130000');24 insert into cities(id,cityid,city,provinceid) values(15,'131100','衡⽔市','130000');25 insert into cities(id,cityid,city,provinceid) values(16,'140100','太原市','140000');26 insert into cities(id,cityid,city,provinceid) values(17,'140200','⼤同市','140000');27 insert into cities(id,cityid,city,provinceid) values(18,'140300','阳泉市','140000');28 insert into cities(id,cityid,city,provinceid) values(19,'140400','长治市','140000');29 insert into cities(id,cityid,city,provinceid) values(20,'140500','晋城市','140000');30 insert into cities(id,cityid,city,provinceid) values(21,'140600','朔州市','140000');39 insert into cities(id,cityid,city,provinceid) values(30,'150400','⾚峰市','150000');40 insert into cities(id,cityid,city,provinceid) values(31,'150500','通辽市','150000');41 insert into cities(id,cityid,city,provinceid) values(32,'150600','鄂尔多斯市','150000');42 insert into cities(id,cityid,city,provinceid) values(33,'150700','呼伦贝尔市','150000');43 insert into cities(id,cityid,city,provinceid) values(34,'150800','巴彦淖尔市','150000');44 insert into cities(id,cityid,city,provinceid) values(35,'150900','乌兰察布市','150000');45 insert into cities(id,cityid,city,provinceid) values(36,'152200','兴安盟','150000');46 insert into cities(id,cityid,city,provinceid) values(37,'152500','锡林郭勒盟','150000');47 insert into cities(id,cityid,city,provinceid) values(38,'152900','阿拉善盟','150000');48 insert into cities(id,cityid,city,provinceid) values(39,'210100','沈阳市','210000');49 insert into cities(id,cityid,city,provinceid) values(40,'210200','⼤连市','210000');50 insert into cities(id,cityid,city,provinceid) values(41,'210300','鞍⼭市','210000');51 insert into cities(id,cityid,city,provinceid) values(42,'210400','抚顺市','210000');52 insert into cities(id,cityid,city,provinceid) values(43,'210500','本溪市','210000');53 insert into cities(id,cityid,city,provinceid) values(44,'210600','丹东市','210000');54 insert into cities(id,cityid,city,provinceid) values(45,'210700','锦州市','210000');55 insert into cities(id,cityid,city,provinceid) values(46,'210800','营⼝市','210000');56 insert into cities(id,cityid,city,provinceid) values(47,'210900','⾩新市','210000');57 insert into cities(id,cityid,city,provinceid) values(48,'211000','辽阳市','210000');58 insert into cities(id,cityid,city,provinceid) values(49,'211100','盘锦市','210000');59 insert into cities(id,cityid,city,provinceid) values(50,'211200','铁岭市','210000');60 insert into cities(id,cityid,city,provinceid) values(51,'211300','朝阳市','210000');61 insert into cities(id,cityid,city,provinceid) values(52,'211400','葫芦岛市','210000');62 insert into cities(id,cityid,city,provinceid) values(53,'220100','长春市','220000');63 insert into cities(id,cityid,city,provinceid) values(54,'220200','吉林市','220000');64 insert into cities(id,cityid,city,provinceid) values(55,'220300','四平市','220000');65 insert into cities(id,cityid,city,provinceid) values(56,'220400','辽源市','220000');66 insert into cities(id,cityid,city,provinceid) values(57,'220500','通化市','220000');67 insert into cities(id,cityid,city,provinceid) values(58,'220600','⽩⼭市','220000');68 insert into cities(id,cityid,city,provinceid) values(59,'220700','松原市','220000');69 insert into cities(id,cityid,city,provinceid) values(60,'220800','⽩城市','220000');70 insert into cities(id,cityid,city,provinceid) values(61,'222400','延边朝鲜族⾃治州','220000');71 insert into cities(id,cityid,city,provinceid) values(62,'230100','哈尔滨市','230000');72 insert into cities(id,cityid,city,provinceid) values(63,'230200','齐齐哈尔市','230000');73 insert into cities(id,cityid,city,provinceid) values(64,'230300','鸡西市','230000');74 insert into cities(id,cityid,city,provinceid) values(65,'230400','鹤岗市','230000');75 insert into cities(id,cityid,city,provinceid) values(66,'230500','双鸭⼭市','230000');76 insert into cities(id,cityid,city,provinceid) values(67,'230600','⼤庆市','230000');77 insert into cities(id,cityid,city,provinceid) values(68,'230700','伊春市','230000');78 insert into cities(id,cityid,city,provinceid) values(69,'230800','佳⽊斯市','230000');79 insert into cities(id,cityid,city,provinceid) values(70,'230900','七台河市','230000');80 insert into cities(id,cityid,city,provinceid) values(71,'231000','牡丹江市','230000');81 insert into cities(id,cityid,city,provinceid) values(72,'231100','⿊河市','230000');82 insert into cities(id,cityid,city,provinceid) values(73,'231200','绥化市','230000');83 insert into cities(id,cityid,city,provinceid) values(74,'232700','⼤兴安岭地区','230000');84 insert into cities(id,cityid,city,provinceid) values(75,'310100','市辖区','310000');85 insert into cities(id,cityid,city,provinceid) values(76,'310200','县','310000');86 insert into cities(id,cityid,city,provinceid) values(77,'320100','南京市','320000');87 insert into cities(id,cityid,city,provinceid) values(78,'320200','⽆锡市','320000');88 insert into cities(id,cityid,city,provinceid) values(79,'320300','徐州市','320000');89 insert into cities(id,cityid,city,provinceid) values(80,'320400','常州市','320000');90 insert into cities(id,cityid,city,provinceid) values(81,'320500','苏州市','320000');91 insert into cities(id,cityid,city,provinceid) values(82,'320600','南通市','320000');92 insert into cities(id,cityid,city,provinceid) values(83,'320700','连云港市','320000');93 insert into cities(id,cityid,city,provinceid) values(84,'320800','淮安市','320000');94 insert into cities(id,cityid,city,provinceid) values(85,'320900','盐城市','320000');95 insert into cities(id,cityid,city,provinceid) values(86,'321000','扬州市','320000');96 insert into cities(id,cityid,city,provinceid) values(87,'321100','镇江市','320000');97 insert into cities(id,cityid,city,provinceid) values(88,'321200','泰州市','320000');98 insert into cities(id,cityid,city,provinceid) values(89,'321300','宿迁市','320000');99 insert into cities(id,cityid,city,provinceid) values(90,'330100','杭州市','330000');100 insert into cities(id,cityid,city,provinceid) values(91,'330200','宁波市','330000');101 insert into cities(id,cityid,city,provinceid) values(92,'330300','温州市','330000');102 insert into cities(id,cityid,city,provinceid) values(93,'330400','嘉兴市','330000');103 insert into cities(id,cityid,city,provinceid) values(94,'330500','湖州市','330000');104 insert into cities(id,cityid,city,provinceid) values(95,'330600','绍兴市','330000');105 insert into cities(id,cityid,city,provinceid) values(96,'330700','⾦华市','330000');106 insert into cities(id,cityid,city,provinceid) values(97,'330800','衢州市','330000');107 insert into cities(id,cityid,city,provinceid) values(98,'330900','⾈⼭市','330000');108 insert into cities(id,cityid,city,provinceid) values(99,'331000','台州市','330000');109 insert into cities(id,cityid,city,provinceid) values(100,'331100','丽⽔市','330000');110 insert into cities(id,cityid,city,provinceid) values(101,'340100','合肥市','340000');111 insert into cities(id,cityid,city,provinceid) values(102,'340200','芜湖市','340000');112 insert into cities(id,cityid,city,provinceid) values(103,'340300','蚌埠市','340000');113 insert into cities(id,cityid,city,provinceid) values(104,'340400','淮南市','340000');114 insert into cities(id,cityid,city,provinceid) values(105,'340500','马鞍⼭市','340000');123 insert into cities(id,cityid,city,provinceid) values(114,'341500','六安市','340000');124 insert into cities(id,cityid,city,provinceid) values(115,'341600','亳州市','340000');125 insert into cities(id,cityid,city,provinceid) values(116,'341700','池州市','340000');126 insert into cities(id,cityid,city,provinceid) values(117,'341800','宣城市','340000');127 insert into cities(id,cityid,city,provinceid) values(118,'350100','福州市','350000');128 insert into cities(id,cityid,city,provinceid) values(119,'350200','厦门市','350000');129 insert into cities(id,cityid,city,provinceid) values(120,'350300','莆⽥市','350000');130 insert into cities(id,cityid,city,provinceid) values(121,'350400','三明市','350000');131 insert into cities(id,cityid,city,provinceid) values(122,'350500','泉州市','350000');132 insert into cities(id,cityid,city,provinceid) values(123,'350600','漳州市','350000');133 insert into cities(id,cityid,city,provinceid) values(124,'350700','南平市','350000');134 insert into cities(id,cityid,city,provinceid) values(125,'350800','龙岩市','350000');135 insert into cities(id,cityid,city,provinceid) values(126,'350900','宁德市','350000');136 insert into cities(id,cityid,city,provinceid) values(127,'360100','南昌市','360000');137 insert into cities(id,cityid,city,provinceid) values(128,'360200','景德镇市','360000');138 insert into cities(id,cityid,city,provinceid) values(129,'360300','萍乡市','360000');139 insert into cities(id,cityid,city,provinceid) values(130,'360400','九江市','360000');140 insert into cities(id,cityid,city,provinceid) values(131,'360500','新余市','360000');141 insert into cities(id,cityid,city,provinceid) values(132,'360600','鹰潭市','360000');142 insert into cities(id,cityid,city,provinceid) values(133,'360700','赣州市','360000');143 insert into cities(id,cityid,city,provinceid) values(134,'360800','吉安市','360000');144 insert into cities(id,cityid,city,provinceid) values(135,'360900','宜春市','360000');145 insert into cities(id,cityid,city,provinceid) values(136,'361000','抚州市','360000');146 insert into cities(id,cityid,city,provinceid) values(137,'361100','上饶市','360000');147 insert into cities(id,cityid,city,provinceid) values(138,'370100','济南市','370000');148 insert into cities(id,cityid,city,provinceid) values(139,'370200','青岛市','370000');149 insert into cities(id,cityid,city,provinceid) values(140,'370300','淄博市','370000');150 insert into cities(id,cityid,city,provinceid) values(141,'370400','枣庄市','370000');151 insert into cities(id,cityid,city,provinceid) values(142,'370500','东营市','370000');152 insert into cities(id,cityid,city,provinceid) values(143,'370600','烟台市','370000');153 insert into cities(id,cityid,city,provinceid) values(144,'370700','潍坊市','370000');154 insert into cities(id,cityid,city,provinceid) values(145,'370800','济宁市','370000');155 insert into cities(id,cityid,city,provinceid) values(146,'370900','泰安市','370000');156 insert into cities(id,cityid,city,provinceid) values(147,'371000','威海市','370000');157 insert into cities(id,cityid,city,provinceid) values(148,'371100','⽇照市','370000');158 insert into cities(id,cityid,city,provinceid) values(149,'371200','莱芜市','370000');159 insert into cities(id,cityid,city,provinceid) values(150,'371300','临沂市','370000');160 insert into cities(id,cityid,city,provinceid) values(151,'371400','德州市','370000');161 insert into cities(id,cityid,city,provinceid) values(152,'371500','聊城市','370000');162 insert into cities(id,cityid,city,provinceid) values(153,'371600','滨州市','370000');163 insert into cities(id,cityid,city,provinceid) values(154,'371700','荷泽市','370000');164 insert into cities(id,cityid,city,provinceid) values(155,'410100','郑州市','410000');165 insert into cities(id,cityid,city,provinceid) values(156,'410200','开封市','410000');166 insert into cities(id,cityid,city,provinceid) values(157,'410300','洛阳市','410000');167 insert into cities(id,cityid,city,provinceid) values(158,'410400','平顶⼭市','410000');168 insert into cities(id,cityid,city,provinceid) values(159,'410500','安阳市','410000');169 insert into cities(id,cityid,city,provinceid) values(160,'410600','鹤壁市','410000');170 insert into cities(id,cityid,city,provinceid) values(161,'410700','新乡市','410000');171 insert into cities(id,cityid,city,provinceid) values(162,'410800','焦作市','410000');172 insert into cities(id,cityid,city,provinceid) values(163,'410900','濮阳市','410000');173 insert into cities(id,cityid,city,provinceid) values(164,'411000','许昌市','410000');174 insert into cities(id,cityid,city,provinceid) values(165,'411100','漯河市','410000');175 insert into cities(id,cityid,city,provinceid) values(166,'411200','三门峡市','410000');176 insert into cities(id,cityid,city,provinceid) values(167,'411300','南阳市','410000');177 insert into cities(id,cityid,city,provinceid) values(168,'411400','商丘市','410000');178 insert into cities(id,cityid,city,provinceid) values(169,'411500','信阳市','410000');179 insert into cities(id,cityid,city,provinceid) values(170,'411600','周⼝市','410000');180 insert into cities(id,cityid,city,provinceid) values(171,'411700','驻马店市','410000');181 insert into cities(id,cityid,city,provinceid) values(172,'420100','武汉市','420000');182 insert into cities(id,cityid,city,provinceid) values(173,'420200','黄⽯市','420000');183 insert into cities(id,cityid,city,provinceid) values(174,'420300','⼗堰市','420000');184 insert into cities(id,cityid,city,provinceid) values(175,'420500','宜昌市','420000');185 insert into cities(id,cityid,city,provinceid) values(176,'420600','襄樊市','420000');186 insert into cities(id,cityid,city,provinceid) values(177,'420700','鄂州市','420000');187 insert into cities(id,cityid,city,provinceid) values(178,'420800','荆门市','420000');188 insert into cities(id,cityid,city,provinceid) values(179,'420900','孝感市','420000');189 insert into cities(id,cityid,city,provinceid) values(180,'421000','荆州市','420000');190 insert into cities(id,cityid,city,provinceid) values(181,'421100','黄冈市','420000');191 insert into cities(id,cityid,city,provinceid) values(182,'421200','咸宁市','420000');192 insert into cities(id,cityid,city,provinceid) values(183,'421300','随州市','420000');193 insert into cities(id,cityid,city,provinceid) values(184,'422800','恩施⼟家族苗族⾃治州','420000'); 194 insert into cities(id,cityid,city,provinceid) values(185,'429000','省直辖⾏政单位','420000');195 insert into cities(id,cityid,city,provinceid) values(186,'430100','长沙市','430000');196 insert into cities(id,cityid,city,provinceid) values(187,'430200','株洲市','430000');197 insert into cities(id,cityid,city,provinceid) values(188,'430300','湘潭市','430000');198 insert into cities(id,cityid,city,provinceid) values(189,'430400','衡阳市','430000');207 insert into cities(id,cityid,city,provinceid) values(198,'431300','娄底市','430000');208 insert into cities(id,cityid,city,provinceid) values(199,'433100','湘西⼟家族苗族⾃治州','430000'); 209 insert into cities(id,cityid,city,provinceid) values(200,'440100','⼴州市','440000');210 insert into cities(id,cityid,city,provinceid) values(201,'440200','韶关市','440000');211 insert into cities(id,cityid,city,provinceid) values(202,'440300','深圳市','440000');212 insert into cities(id,cityid,city,provinceid) values(203,'440400','珠海市','440000');213 insert into cities(id,cityid,city,provinceid) values(204,'440500','汕头市','440000');214 insert into cities(id,cityid,city,provinceid) values(205,'440600','佛⼭市','440000');215 insert into cities(id,cityid,city,provinceid) values(206,'440700','江门市','440000');216 insert into cities(id,cityid,city,provinceid) values(207,'440800','湛江市','440000');217 insert into cities(id,cityid,city,provinceid) values(208,'440900','茂名市','440000');218 insert into cities(id,cityid,city,provinceid) values(209,'441200','肇庆市','440000');219 insert into cities(id,cityid,city,provinceid) values(210,'441300','惠州市','440000');220 insert into cities(id,cityid,city,provinceid) values(211,'441400','梅州市','440000');221 insert into cities(id,cityid,city,provinceid) values(212,'441500','汕尾市','440000');222 insert into cities(id,cityid,city,provinceid) values(213,'441600','河源市','440000');223 insert into cities(id,cityid,city,provinceid) values(214,'441700','阳江市','440000');224 insert into cities(id,cityid,city,provinceid) values(215,'441800','清远市','440000');225 insert into cities(id,cityid,city,provinceid) values(216,'441900','东莞市','440000');226 insert into cities(id,cityid,city,provinceid) values(217,'442000','中⼭市','440000');227 insert into cities(id,cityid,city,provinceid) values(218,'445100','潮州市','440000');228 insert into cities(id,cityid,city,provinceid) values(219,'445200','揭阳市','440000');229 insert into cities(id,cityid,city,provinceid) values(220,'445300','云浮市','440000');230 insert into cities(id,cityid,city,provinceid) values(221,'450100','南宁市','450000');231 insert into cities(id,cityid,city,provinceid) values(222,'450200','柳州市','450000');232 insert into cities(id,cityid,city,provinceid) values(223,'450300','桂林市','450000');233 insert into cities(id,cityid,city,provinceid) values(224,'450400','梧州市','450000');234 insert into cities(id,cityid,city,provinceid) values(225,'450500','北海市','450000');235 insert into cities(id,cityid,city,provinceid) values(226,'450600','防城港市','450000');236 insert into cities(id,cityid,city,provinceid) values(227,'450700','钦州市','450000');237 insert into cities(id,cityid,city,provinceid) values(228,'450800','贵港市','450000');238 insert into cities(id,cityid,city,provinceid) values(229,'450900','⽟林市','450000');239 insert into cities(id,cityid,city,provinceid) values(230,'451000','百⾊市','450000');240 insert into cities(id,cityid,city,provinceid) values(231,'451100','贺州市','450000');241 insert into cities(id,cityid,city,provinceid) values(232,'451200','河池市','450000');242 insert into cities(id,cityid,city,provinceid) values(233,'451300','来宾市','450000');243 insert into cities(id,cityid,city,provinceid) values(234,'451400','崇左市','450000');244 insert into cities(id,cityid,city,provinceid) values(235,'460100','海⼝市','460000');245 insert into cities(id,cityid,city,provinceid) values(236,'460200','三亚市','460000');246 insert into cities(id,cityid,city,provinceid) values(237,'469000','省直辖县级⾏政单位','460000'); 247 insert into cities(id,cityid,city,provinceid) values(238,'500100','市辖区','500000');248 insert into cities(id,cityid,city,provinceid) values(239,'500200','县','500000');249 insert into cities(id,cityid,city,provinceid) values(240,'500300','市','500000');250 insert into cities(id,cityid,city,provinceid) values(241,'510100','成都市','510000');251 insert into cities(id,cityid,city,provinceid) values(242,'510300','⾃贡市','510000');252 insert into cities(id,cityid,city,provinceid) values(243,'510400','攀枝花市','510000');253 insert into cities(id,cityid,city,provinceid) values(244,'510500','泸州市','510000');254 insert into cities(id,cityid,city,provinceid) values(245,'510600','德阳市','510000');255 insert into cities(id,cityid,city,provinceid) values(246,'510700','绵阳市','510000');256 insert into cities(id,cityid,city,provinceid) values(247,'510800','⼴元市','510000');257 insert into cities(id,cityid,city,provinceid) values(248,'510900','遂宁市','510000');258 insert into cities(id,cityid,city,provinceid) values(249,'511000','内江市','510000');259 insert into cities(id,cityid,city,provinceid) values(250,'511100','乐⼭市','510000');260 insert into cities(id,cityid,city,provinceid) values(251,'511300','南充市','510000');261 insert into cities(id,cityid,city,provinceid) values(252,'511400','眉⼭市','510000');262 insert into cities(id,cityid,city,provinceid) values(253,'511500','宜宾市','510000');263 insert into cities(id,cityid,city,provinceid) values(254,'511600','⼴安市','510000');264 insert into cities(id,cityid,city,provinceid) values(255,'511700','达州市','510000');265 insert into cities(id,cityid,city,provinceid) values(256,'511800','雅安市','510000');266 insert into cities(id,cityid,city,provinceid) values(257,'511900','巴中市','510000');267 insert into cities(id,cityid,city,provinceid) values(258,'512000','资阳市','510000');268 insert into cities(id,cityid,city,provinceid) values(259,'513200','阿坝藏族羌族⾃治州','510000'); 269 insert into cities(id,cityid,city,provinceid) values(260,'513300','⽢孜藏族⾃治州','510000');270 insert into cities(id,cityid,city,provinceid) values(261,'513400','凉⼭彝族⾃治州','510000');271 insert into cities(id,cityid,city,provinceid) values(262,'520100','贵阳市','520000');272 insert into cities(id,cityid,city,provinceid) values(263,'520200','六盘⽔市','520000');273 insert into cities(id,cityid,city,provinceid) values(264,'520300','遵义市','520000');274 insert into cities(id,cityid,city,provinceid) values(265,'520400','安顺市','520000');275 insert into cities(id,cityid,city,provinceid) values(266,'522200','铜仁地区','520000');276 insert into cities(id,cityid,city,provinceid) values(267,'522300','黔西南布依族苗族⾃治州','520000'); 277 insert into cities(id,cityid,city,provinceid) values(268,'522400','毕节地区','520000');278 insert into cities(id,cityid,city,provinceid) values(269,'522600','黔东南苗族侗族⾃治州','520000'); 279 insert into cities(id,cityid,city,provinceid) values(270,'522700','黔南布依族苗族⾃治州','520000'); 280 insert into cities(id,cityid,city,provinceid) values(271,'530100','昆明市','530000');281 insert into cities(id,cityid,city,provinceid) values(272,'530300','曲靖市','530000');282 insert into cities(id,cityid,city,provinceid) values(273,'530400','⽟溪市','530000');。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
DROP TABLE IF EXISTS `province`;CREATE TABLE `province` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(50) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=gbk;-- ------------------------------ Records of province-- ----------------------------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', '香港特别行政区');本文档全是数据库脚本，结合本人上传的另一个类似文件可以完成省市县三级联动的数据库版本。
-- ------------------------------ Table structure for `city`-- ----------------------------DROP TABLE IF EXISTS `city`;CREATE TABLE `city` (`id` int(11) NOT NULL AUTO_INCREMENT,`city_index` int(11) NOT NULL,`province_id` int(11) NOT NULL,`name` varchar(100) NOT NULL DEFAULT '',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=392 DEFAULT CHARSET=gbk;-- ------------------------------ Records of city-- ----------------------------INSERT INTO `city` VALUES ('1', '1', '1', '北京市');INSERT INTO `city` VALUES ('2', '1', '2', '天津市');INSERT INTO `city` VALUES ('3', '1', '3', '上海市');INSERT INTO `city` VALUES ('4', '1', '4', '重庆市');INSERT INTO `city` VALUES ('5', '1', '5', '石家庄市');INSERT INTO `city` VALUES ('6', '2', '5', '唐山市');INSERT INTO `city` VALUES ('7', '3', '5', '秦皇岛市');INSERT INTO `city` VALUES ('8', '4', '5', '邯郸市');INSERT INTO `city` VALUES ('9', '5', '5', '邢台市');INSERT INTO `city` VALUES ('10', '6', '5', '保定市');INSERT INTO `city` VALUES ('11', '7', '5', '张家口市');INSERT INTO `city` VALUES ('12', '8', '5', '承德市');INSERT INTO `city` VALUES ('13', '9', '5', '沧州市');INSERT INTO `city` VALUES ('14', '10', '5', '廊坊市');INSERT INTO `city` VALUES ('15', '11', '5', '衡水市');INSERT INTO `city` VALUES ('16', '1', '6', '太原市');INSERT INTO `city` VALUES ('17', '2', '6', '大同市');INSERT INTO `city` VALUES ('18', '3', '6', '阳泉市');INSERT INTO `city` VALUES ('19', '4', '6', '长治市');INSERT INTO `city` VALUES ('20', '5', '6', '晋城市');INSERT INTO `city` VALUES ('21', '6', '6', '朔州市');INSERT INTO `city` VALUES ('22', '7', '6', '晋中市');INSERT INTO `city` VALUES ('23', '8', '6', '运城市');INSERT INTO `city` VALUES ('24', '9', '6', '忻州市');INSERT INTO `city` VALUES ('25', '10', '6', '临汾市');INSERT INTO `city` VALUES ('26', '11', '6', '吕梁市');INSERT INTO `city` VALUES ('27', '1', '7', '台北市');INSERT INTO `city` VALUES ('28', '2', '7', '高雄市'); INSERT INTO `city` VALUES ('29', '3', '7', '基隆市'); INSERT INTO `city` VALUES ('30', '4', '7', '台中市'); INSERT INTO `city` VALUES ('31', '5', '7', '台南市'); INSERT INTO `city` VALUES ('32', '6', '7', '新竹市'); INSERT INTO `city` VALUES ('33', '7', '7', '嘉义市'); INSERT INTO `city` VALUES ('34', '8', '7', '台北县'); INSERT INTO `city` VALUES ('35', '9', '7', '宜兰县'); INSERT INTO `city` VALUES ('36', '10', '7', '桃园县'); INSERT INTO `city` VALUES ('37', '11', '7', '新竹县'); INSERT INTO `city` VALUES ('38', '12', '7', '苗栗县'); INSERT INTO `city` VALUES ('39', '13', '7', '台中县'); INSERT INTO `city` VALUES ('40', '14', '7', '彰化县'); INSERT INTO `city` VALUES ('41', '15', '7', '南投县'); INSERT INTO `city` VALUES ('42', '16', '7', '云林县'); INSERT INTO `city` VALUES ('43', '17', '7', '嘉义县'); INSERT INTO `city` VALUES ('44', '18', '7', '台南县'); INSERT INTO `city` VALUES ('45', '19', '7', '高雄县'); INSERT INTO `city` VALUES ('46', '20', '7', '屏东县'); INSERT INTO `city` VALUES ('47', '21', '7', '澎湖县'); INSERT INTO `city` VALUES ('48', '22', '7', '台东县'); INSERT INTO `city` VALUES ('49', '23', '7', '花莲县'); INSERT INTO `city` VALUES ('50', '1', '8', '沈阳市'); INSERT INTO `city` VALUES ('51', '2', '8', '大连市'); INSERT INTO `city` VALUES ('52', '3', '8', '鞍山市'); INSERT INTO `city` VALUES ('53', '4', '8', '抚顺市'); INSERT INTO `city` VALUES ('54', '5', '8', '本溪市'); INSERT INTO `city` VALUES ('55', '6', '8', '丹东市'); INSERT INTO `city` VALUES ('56', '7', '8', '锦州市'); INSERT INTO `city` VALUES ('57', '8', '8', '营口市'); INSERT INTO `city` VALUES ('58', '9', '8', '阜新市'); INSERT INTO `city` VALUES ('59', '10', '8', '辽阳市'); INSERT INTO `city` VALUES ('60', '11', '8', '盘锦市'); INSERT INTO `city` VALUES ('61', '12', '8', '铁岭市'); INSERT INTO `city` VALUES ('62', '13', '8', '朝阳市'); INSERT INTO `city` VALUES ('63', '14', '8', '葫芦岛市'); INSERT INTO `city` VALUES ('64', '1', '9', '长春市'); INSERT INTO `city` VALUES ('65', '2', '9', '吉林市'); INSERT INTO `city` VALUES ('66', '3', '9', '四平市'); INSERT INTO `city` VALUES ('67', '4', '9', '辽源市'); INSERT INTO `city` VALUES ('68', '5', '9', '通化市'); INSERT INTO `city` VALUES ('69', '6', '9', '白山市'); INSERT INTO `city` VALUES ('70', '7', '9', '松原市'); INSERT INTO `city` VALUES ('71', '8', '9', '白城市');INSERT INTO `city` VALUES ('72', '9', '9', '延边朝鲜族自治州'); INSERT INTO `city` VALUES ('73', '1', '10', '哈尔滨市'); INSERT INTO `city` VALUES ('74', '2', '10', '齐齐哈尔市'); INSERT INTO `city` VALUES ('75', '3', '10', '鹤岗市'); INSERT INTO `city` VALUES ('76', '4', '10', '双鸭山市'); INSERT INTO `city` VALUES ('77', '5', '10', '鸡西市'); INSERT INTO `city` VALUES ('78', '6', '10', '大庆市'); INSERT INTO `city` VALUES ('79', '7', '10', '伊春市'); INSERT INTO `city` VALUES ('80', '8', '10', '牡丹江市'); INSERT INTO `city` VALUES ('81', '9', '10', '佳木斯市'); INSERT INTO `city` VALUES ('82', '10', '10', '七台河市'); INSERT INTO `city` VALUES ('83', '11', '10', '黑河市'); INSERT INTO `city` VALUES ('84', '12', '10', '绥化市'); INSERT INTO `city` VALUES ('85', '13', '10', '大兴安岭地区'); INSERT INTO `city` VALUES ('86', '1', '11', '南京市'); INSERT INTO `city` VALUES ('87', '2', '11', '无锡市'); INSERT INTO `city` VALUES ('88', '3', '11', '徐州市'); INSERT INTO `city` VALUES ('89', '4', '11', '常州市'); INSERT INTO `city` VALUES ('90', '5', '11', '苏州市'); INSERT INTO `city` VALUES ('91', '6', '11', '南通市'); INSERT INTO `city` VALUES ('92', '7', '11', '连云港市'); INSERT INTO `city` VALUES ('93', '8', '11', '淮安市'); INSERT INTO `city` VALUES ('94', '9', '11', '盐城市'); INSERT INTO `city` VALUES ('95', '10', '11', '扬州市'); INSERT INTO `city` VALUES ('96', '11', '11', '镇江市'); INSERT INTO `city` VALUES ('97', '12', '11', '泰州市'); INSERT INTO `city` VALUES ('98', '13', '11', '宿迁市'); INSERT INTO `city` VALUES ('99', '1', '12', '杭州市'); INSERT INTO `city` VALUES ('100', '2', '12', '宁波市'); INSERT INTO `city` VALUES ('101', '3', '12', '温州市'); INSERT INTO `city` VALUES ('102', '4', '12', '嘉兴市'); INSERT INTO `city` VALUES ('103', '5', '12', '湖州市'); INSERT INTO `city` VALUES ('104', '6', '12', '绍兴市'); INSERT INTO `city` VALUES ('105', '7', '12', '金华市'); INSERT INTO `city` VALUES ('106', '8', '12', '衢州市'); INSERT INTO `city` VALUES ('107', '9', '12', '舟山市'); INSERT INTO `city` VALUES ('108', '10', '12', '台州市'); INSERT INTO `city` VALUES ('109', '11', '12', '丽水市'); INSERT INTO `city` VALUES ('110', '1', '13', '合肥市'); INSERT INTO `city` VALUES ('111', '2', '13', '芜湖市'); INSERT INTO `city` VALUES ('112', '3', '13', '蚌埠市'); INSERT INTO `city` VALUES ('113', '4', '13', '淮南市'); INSERT INTO `city` VALUES ('114', '5', '13', '马鞍山市'); INSERT INTO `city` VALUES ('115', '6', '13', '淮北市');INSERT INTO `city` VALUES ('117', '8', '13', '安庆市'); INSERT INTO `city` VALUES ('118', '9', '13', '黄山市'); INSERT INTO `city` VALUES ('119', '10', '13', '滁州市'); INSERT INTO `city` VALUES ('120', '11', '13', '阜阳市'); INSERT INTO `city` VALUES ('121', '12', '13', '宿州市'); INSERT INTO `city` VALUES ('122', '13', '13', '巢湖市'); INSERT INTO `city` VALUES ('123', '14', '13', '六安市'); INSERT INTO `city` VALUES ('124', '15', '13', '亳州市'); INSERT INTO `city` VALUES ('125', '16', '13', '池州市'); INSERT INTO `city` VALUES ('126', '17', '13', '宣城市'); INSERT INTO `city` VALUES ('127', '1', '14', '福州市'); INSERT INTO `city` VALUES ('128', '2', '14', '厦门市'); INSERT INTO `city` VALUES ('129', '3', '14', '莆田市'); INSERT INTO `city` VALUES ('130', '4', '14', '三明市'); INSERT INTO `city` VALUES ('131', '5', '14', '泉州市'); INSERT INTO `city` VALUES ('132', '6', '14', '漳州市'); INSERT INTO `city` VALUES ('133', '7', '14', '南平市'); INSERT INTO `city` VALUES ('134', '8', '14', '龙岩市'); INSERT INTO `city` VALUES ('135', '9', '14', '宁德市'); INSERT INTO `city` VALUES ('136', '1', '15', '南昌市'); INSERT INTO `city` VALUES ('137', '2', '15', '景德镇市'); INSERT INTO `city` VALUES ('138', '3', '15', '萍乡市'); INSERT INTO `city` VALUES ('139', '4', '15', '九江市'); INSERT INTO `city` VALUES ('140', '5', '15', '新余市'); INSERT INTO `city` VALUES ('141', '6', '15', '鹰潭市'); INSERT INTO `city` VALUES ('142', '7', '15', '赣州市'); INSERT INTO `city` VALUES ('143', '8', '15', '吉安市'); INSERT INTO `city` VALUES ('144', '9', '15', '宜春市'); INSERT INTO `city` VALUES ('145', '10', '15', '抚州市'); INSERT INTO `city` VALUES ('146', '11', '15', '上饶市'); INSERT INTO `city` VALUES ('147', '1', '16', '济南市'); INSERT INTO `city` VALUES ('148', '2', '16', '青岛市'); INSERT INTO `city` VALUES ('149', '3', '16', '淄博市'); INSERT INTO `city` VALUES ('150', '4', '16', '枣庄市'); INSERT INTO `city` VALUES ('151', '5', '16', '东营市'); INSERT INTO `city` VALUES ('152', '6', '16', '烟台市'); INSERT INTO `city` VALUES ('153', '7', '16', '潍坊市'); INSERT INTO `city` VALUES ('154', '8', '16', '济宁市'); INSERT INTO `city` VALUES ('155', '9', '16', '泰安市'); INSERT INTO `city` VALUES ('156', '10', '16', '威海市'); INSERT INTO `city` VALUES ('157', '11', '16', '日照市'); INSERT INTO `city` VALUES ('158', '12', '16', '莱芜市'); INSERT INTO `city` VALUES ('159', '13', '16', '临沂市');INSERT INTO `city` VALUES ('161', '15', '16', '聊城市');INSERT INTO `city` VALUES ('162', '16', '16', '滨州市');INSERT INTO `city` VALUES ('163', '17', '16', '菏泽市');INSERT INTO `city` VALUES ('164', '1', '17', '郑州市');INSERT INTO `city` VALUES ('165', '2', '17', '开封市');INSERT INTO `city` VALUES ('166', '3', '17', '洛阳市');INSERT INTO `city` VALUES ('167', '4', '17', '平顶山市');INSERT INTO `city` VALUES ('168', '5', '17', '安阳市');INSERT INTO `city` VALUES ('169', '6', '17', '鹤壁市');INSERT INTO `city` VALUES ('170', '7', '17', '新乡市');INSERT INTO `city` VALUES ('171', '8', '17', '焦作市');INSERT INTO `city` VALUES ('172', '9', '17', '濮阳市');INSERT INTO `city` VALUES ('173', '10', '17', '许昌市');INSERT INTO `city` VALUES ('174', '11', '17', '漯河市');INSERT INTO `city` VALUES ('175', '12', '17', '三门峡市');INSERT INTO `city` VALUES ('176', '13', '17', '南阳市');INSERT INTO `city` VALUES ('177', '14', '17', '商丘市');INSERT INTO `city` VALUES ('178', '15', '17', '信阳市');INSERT INTO `city` VALUES ('179', '16', '17', '周口市');INSERT INTO `city` VALUES ('180', '17', '17', '驻马店市');INSERT INTO `city` VALUES ('181', '18', '17', '济源市');INSERT INTO `city` VALUES ('182', '1', '18', '武汉市');INSERT INTO `city` VALUES ('183', '2', '18', '黄石市');INSERT INTO `city` VALUES ('184', '3', '18', '十堰市');INSERT INTO `city` VALUES ('185', '4', '18', '荆州市');INSERT INTO `city` VALUES ('186', '5', '18', '宜昌市');INSERT INTO `city` VALUES ('187', '6', '18', '襄樊市');INSERT INTO `city` VALUES ('188', '7', '18', '鄂州市');INSERT INTO `city` VALUES ('189', '8', '18', '荆门市');INSERT INTO `city` VALUES ('190', '9', '18', '孝感市');INSERT INTO `city` VALUES ('191', '10', '18', '黄冈市');INSERT INTO `city` VALUES ('192', '11', '18', '咸宁市');INSERT INTO `city` VALUES ('193', '12', '18', '随州市');INSERT INTO `city` VALUES ('194', '13', '18', '仙桃市');INSERT INTO `city` VALUES ('195', '14', '18', '天门市');INSERT INTO `city` VALUES ('196', '15', '18', '潜江市');INSERT INTO `city` VALUES ('197', '16', '18', '神农架林区');INSERT INTO `city` VALUES ('198', '17', '18', '恩施土家族苗族自治州'); INSERT INTO `city` VALUES ('199', '1', '19', '长沙市');INSERT INTO `city` VALUES ('200', '2', '19', '株洲市');INSERT INTO `city` VALUES ('201', '3', '19', '湘潭市');INSERT INTO `city` VALUES ('202', '4', '19', '衡阳市');INSERT INTO `city` VALUES ('203', '5', '19', '邵阳市');INSERT INTO `city` VALUES ('205', '7', '19', '常德市');INSERT INTO `city` VALUES ('206', '8', '19', '张家界市');INSERT INTO `city` VALUES ('207', '9', '19', '益阳市');INSERT INTO `city` VALUES ('208', '10', '19', '郴州市');INSERT INTO `city` VALUES ('209', '11', '19', '永州市');INSERT INTO `city` VALUES ('210', '12', '19', '怀化市');INSERT INTO `city` VALUES ('211', '13', '19', '娄底市');INSERT INTO `city` VALUES ('212', '14', '19', '湘西土家族苗族自治州'); INSERT INTO `city` VALUES ('213', '1', '20', '广州市');INSERT INTO `city` VALUES ('214', '2', '20', '深圳市');INSERT INTO `city` VALUES ('215', '3', '20', '珠海市');INSERT INTO `city` VALUES ('216', '4', '20', '汕头市');INSERT INTO `city` VALUES ('217', '5', '20', '韶关市');INSERT INTO `city` VALUES ('218', '6', '20', '佛山市');INSERT INTO `city` VALUES ('219', '7', '20', '江门市');INSERT INTO `city` VALUES ('220', '8', '20', '湛江市');INSERT INTO `city` VALUES ('221', '9', '20', '茂名市');INSERT INTO `city` VALUES ('222', '10', '20', '肇庆市');INSERT INTO `city` VALUES ('223', '11', '20', '惠州市');INSERT INTO `city` VALUES ('224', '12', '20', '梅州市');INSERT INTO `city` VALUES ('225', '13', '20', '汕尾市');INSERT INTO `city` VALUES ('226', '14', '20', '河源市');INSERT INTO `city` VALUES ('227', '15', '20', '阳江市');INSERT INTO `city` VALUES ('228', '16', '20', '清远市');INSERT INTO `city` VALUES ('229', '17', '20', '东莞市');INSERT INTO `city` VALUES ('230', '18', '20', '中山市');INSERT INTO `city` VALUES ('231', '19', '20', '潮州市');INSERT INTO `city` VALUES ('232', '20', '20', '揭阳市');INSERT INTO `city` VALUES ('233', '21', '20', '云浮市');INSERT INTO `city` VALUES ('234', '1', '21', '兰州市');INSERT INTO `city` VALUES ('235', '2', '21', '金昌市');INSERT INTO `city` VALUES ('236', '3', '21', '白银市');INSERT INTO `city` VALUES ('237', '4', '21', '天水市');INSERT INTO `city` VALUES ('238', '5', '21', '嘉峪关市');INSERT INTO `city` VALUES ('239', '6', '21', '武威市');INSERT INTO `city` VALUES ('240', '7', '21', '张掖市');INSERT INTO `city` VALUES ('241', '8', '21', '平凉市');INSERT INTO `city` VALUES ('242', '9', '21', '酒泉市');INSERT INTO `city` VALUES ('243', '10', '21', '庆阳市');INSERT INTO `city` VALUES ('244', '11', '21', '定西市');INSERT INTO `city` VALUES ('245', '12', '21', '陇南市');INSERT INTO `city` VALUES ('246', '13', '21', '临夏回族自治州'); INSERT INTO `city` VALUES ('247', '14', '21', '甘南藏族自治州');INSERT INTO `city` VALUES ('249', '2', '22', '自贡市');INSERT INTO `city` VALUES ('250', '3', '22', '攀枝花市');INSERT INTO `city` VALUES ('251', '4', '22', '泸州市');INSERT INTO `city` VALUES ('252', '5', '22', '德阳市');INSERT INTO `city` VALUES ('253', '6', '22', '绵阳市');INSERT INTO `city` VALUES ('254', '7', '22', '广元市');INSERT INTO `city` VALUES ('255', '8', '22', '遂宁市');INSERT INTO `city` VALUES ('256', '9', '22', '内江市');INSERT INTO `city` VALUES ('257', '10', '22', '乐山市');INSERT INTO `city` VALUES ('258', '11', '22', '南充市');INSERT INTO `city` VALUES ('259', '12', '22', '眉山市');INSERT INTO `city` VALUES ('260', '13', '22', '宜宾市');INSERT INTO `city` VALUES ('261', '14', '22', '广安市');INSERT INTO `city` VALUES ('262', '15', '22', '达州市');INSERT INTO `city` VALUES ('263', '16', '22', '雅安市');INSERT INTO `city` VALUES ('264', '17', '22', '巴中市');INSERT INTO `city` VALUES ('265', '18', '22', '资阳市');INSERT INTO `city` VALUES ('266', '19', '22', '阿坝藏族羌族自治州'); INSERT INTO `city` VALUES ('267', '20', '22', '甘孜藏族自治州'); INSERT INTO `city` VALUES ('268', '21', '22', '凉山彝族自治州'); INSERT INTO `city` VALUES ('269', '1', '23', '贵阳市');INSERT INTO `city` VALUES ('270', '2', '23', '六盘水市');INSERT INTO `city` VALUES ('271', '3', '23', '遵义市');INSERT INTO `city` VALUES ('272', '4', '23', '安顺市');INSERT INTO `city` VALUES ('273', '5', '23', '铜仁地区');INSERT INTO `city` VALUES ('274', '6', '23', '毕节地区');INSERT INTO `city` VALUES ('275', '7', '23', '黔西南布依族苗族自治州'); INSERT INTO `city` VALUES ('276', '8', '23', '黔东南苗族侗族自治州'); INSERT INTO `city` VALUES ('277', '9', '23', '黔南布依族苗族自治州'); INSERT INTO `city` VALUES ('278', '1', '24', '海口市');INSERT INTO `city` VALUES ('279', '2', '24', '三亚市');INSERT INTO `city` VALUES ('280', '3', '24', '五指山市');INSERT INTO `city` VALUES ('281', '4', '24', '琼海市');INSERT INTO `city` VALUES ('282', '5', '24', '儋州市');INSERT INTO `city` VALUES ('283', '6', '24', '文昌市');INSERT INTO `city` VALUES ('284', '7', '24', '万宁市');INSERT INTO `city` VALUES ('285', '8', '24', '东方市');INSERT INTO `city` VALUES ('286', '9', '24', '澄迈县');INSERT INTO `city` VALUES ('287', '10', '24', '定安县');INSERT INTO `city` VALUES ('288', '11', '24', '屯昌县');INSERT INTO `city` VALUES ('289', '12', '24', '临高县');INSERT INTO `city` VALUES ('290', '13', '24', '白沙黎族自治县'); INSERT INTO `city` VALUES ('291', '14', '24', '昌江黎族自治县');INSERT INTO `city` VALUES ('292', '15', '24', '乐东黎族自治县'); INSERT INTO `city` VALUES ('293', '16', '24', '陵水黎族自治县'); INSERT INTO `city` VALUES ('294', '17', '24', '保亭黎族苗族自治县'); INSERT INTO `city` VALUES ('295', '18', '24', '琼中黎族苗族自治县'); INSERT INTO `city` VALUES ('296', '1', '25', '昆明市');INSERT INTO `city` VALUES ('297', '2', '25', '曲靖市');INSERT INTO `city` VALUES ('298', '3', '25', '玉溪市');INSERT INTO `city` VALUES ('299', '4', '25', '保山市');INSERT INTO `city` VALUES ('300', '5', '25', '昭通市');INSERT INTO `city` VALUES ('301', '6', '25', '丽江市');INSERT INTO `city` VALUES ('302', '7', '25', '思茅市');INSERT INTO `city` VALUES ('303', '8', '25', '临沧市');INSERT INTO `city` VALUES ('304', '9', '25', '文山壮族苗族自治州'); INSERT INTO `city` VALUES ('305', '10', '25', '红河哈尼族彝族自治州'); INSERT INTO `city` VALUES ('306', '11', '25', '西双版纳傣族自治州'); INSERT INTO `city` VALUES ('307', '12', '25', '楚雄彝族自治州'); INSERT INTO `city` VALUES ('308', '13', '25', '大理白族自治州'); INSERT INTO `city` VALUES ('309', '14', '25', '德宏傣族景颇族自治州'); INSERT INTO `city` VALUES ('310', '15', '25', '怒江傈傈族自治州'); INSERT INTO `city` VALUES ('311', '16', '25', '迪庆藏族自治州'); INSERT INTO `city` VALUES ('312', '1', '26', '西宁市');INSERT INTO `city` VALUES ('313', '2', '26', '海东地区');INSERT INTO `city` VALUES ('314', '3', '26', '海北藏族自治州'); INSERT INTO `city` VALUES ('315', '4', '26', '黄南藏族自治州'); INSERT INTO `city` VALUES ('316', '5', '26', '海南藏族自治州'); INSERT INTO `city` VALUES ('317', '6', '26', '果洛藏族自治州'); INSERT INTO `city` VALUES ('318', '7', '26', '玉树藏族自治州'); INSERT INTO `city` VALUES ('319', '8', '26', '海西蒙古族藏族自治州'); INSERT INTO `city` VALUES ('320', '1', '27', '西安市');INSERT INTO `city` VALUES ('321', '2', '27', '铜川市');INSERT INTO `city` VALUES ('322', '3', '27', '宝鸡市');INSERT INTO `city` VALUES ('323', '4', '27', '咸阳市');INSERT INTO `city` VALUES ('324', '5', '27', '渭南市');INSERT INTO `city` VALUES ('325', '6', '27', '延安市');INSERT INTO `city` VALUES ('326', '7', '27', '汉中市');INSERT INTO `city` VALUES ('327', '8', '27', '榆林市');INSERT INTO `city` VALUES ('328', '9', '27', '安康市');INSERT INTO `city` VALUES ('329', '10', '27', '商洛市');INSERT INTO `city` VALUES ('330', '1', '28', '南宁市');INSERT INTO `city` VALUES ('331', '2', '28', '柳州市');INSERT INTO `city` VALUES ('332', '3', '28', '桂林市');INSERT INTO `city` VALUES ('333', '4', '28', '梧州市');INSERT INTO `city` VALUES ('334', '5', '28', '北海市');INSERT INTO `city` VALUES ('335', '6', '28', '防城港市');。