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