全国省市级联SQL导入

本文介绍了一个包含中国各省市及下属地区的详细数据库构建方案。通过SQL语句填充了包括省份、直辖市、自治区及其下辖城市的地区信息。这些数据可用于地理信息系统、物流配送系统等多种应用场景。


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

 

 

areaid地区ID
areaname地区名称
parentid上级ID
arrparentid上级地区所有ID
child是否有子地区
arrchildid子地区所有ID
listorder排序

 

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值