2020中国城市等级划分（一二三四五线城市及排名）excel表格及sql文件

/* Navicat Premium Data Transfer Source Server : 亚布力prod Source Server Type : MySQL Source Server Version : 50726 Source Host : rm-2zezui708o9q64o3i.mysql.rds.aliyuncs.com:3306 Source Schema : youngmaker_website Target Server Type : MySQL Target Server Version : 50726 File Encoding : 65001 Date: 30/07/2020 13:51:08 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for city_grade -- ---------------------------- DROP TABLE IF EXISTS `city_grade`; CREATE TABLE `city_grade` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '城市名称', `grade` int(5) NOT NULL COMMENT '城市等级', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 342 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of city_grade -- ---------------------------- INSERT INTO `city_grade` VALUES (1, '北京', 1); INSERT INTO `city_grade` VALUES (2, '上海', 1); INSERT INTO `city_grade` VALUES (3, '广州', 1); INSERT INTO `city_grade` VALUES (4, '深圳', 1); INSERT INTO `city_grade` VALUES (5, '成都', 1); INSERT INTO `city_grade` VALUES (6, '重庆', 1); INSERT INTO `city_grade` VALUES (7, '杭州', 1); INSERT INTO `city_grade` VALUES (8, '武汉', 1); INSERT INTO `city_grade` VALUES (9, '西安', 1); INSERT INTO `city_grade` VALUES (10, '天津', 1); INSERT INTO `city_grade` VALUES (11, '苏州', 1); INSERT INTO `city_grade` VALUES (12, '南京', 1); INSERT INTO `city_grade` VALUES (13, '郑州', 1); INSERT INTO `city_grade` VALUES (14, '长沙', 1); INSERT INTO `city_grade` VALUES (15, '东莞', 1); INSERT INTO `city_grade` VALUES (16, '沈阳', 1); INSERT INTO `city_grade` VALUES (17, '青岛', 1); INSERT INTO `city_grade` VALUES (18, '合肥', 1); INSERT INTO `city_grade` VALUES (19, '佛山', 1); INSERT INTO `city_grade` VALUES (20, '宁波', 2); INSERT INTO `city_grade` VALUES (21, '昆明', 2); INSERT INTO `city_grade` VALUES (22, '福州', 2); INSERT INTO `city_grade` VALUES (23, '无锡', 2); INSERT INTO `city_grade` VALUES (24, '厦门', 2); INSERT INTO `city_grade` VALUES (25, '济南', 2); INSERT INTO `city_grade` VALUES (26, '大连', 2); INSERT INTO `city_grade` VALUES (27, '哈尔滨', 2); INSERT INTO `city_grade` VALUES (28, '温州', 2); INSERT INTO `city_grade` VALUES (29, '石家庄', 2); INSERT INTO `city_grade` VALUES (30, '泉州', 2); INSERT INTO `city_grade` VALUES (31, '南宁', 2); INSERT INTO `city_grade` VALUES (32, '长春', 2); INSERT INTO `city_grade` VALUES (33, '南昌', 2); INSERT INTO `city_grade` VALUES (34, '贵阳', 2); INSERT INTO `city_grade` VALUES (35, '金华', 2); INSERT INTO `city_grade` VALUES (36, '常州', 2); INSERT INTO `city_grade` VALUES (37, '惠州', 2); INSERT INTO `city_grade` VALUES (38, '嘉兴', 2); INSERT INTO `city_grade` VALUES (39, '南通', 2); INSERT INTO `city_grade` VALUES (40, '徐州', 2); INSERT INTO `city_grade` VALUES (41, '太原', 2); INSERT INTO `city_grade` VALUES (42, '珠海', 2); INSERT INTO `city_grade` VALUES (43, '中山', 2); INSERT INTO `city_grade` VALUES (44, '保定', 2); INSERT INTO `city_grade` VALUES (45, '兰州', 2); INSERT INTO `city_grade` VALUES (46, '台州', 2); INSERT INTO `city_grade` VALUES (47, '绍兴', 2); INSERT INTO `city_grade` VALUES (48, '烟台', 2); INSERT INTO `city_grade` VALUES (49, '廊坊', 2); INSERT INTO `city_grade` VALUES (50, '潍坊', 3); INSERT INTO `city_grade` VALUES (51, '扬州', 3); INSERT INTO `city_grade` VALUES (52, '海口', 3); INSERT INTO `city_grade` VALUES (53, '汕头', 3); INSERT INTO `city_grade` VALUES (54, '洛阳', 3); INSERT INTO `city_grade` VALUES (55, '乌鲁木齐', 3); INSERT INTO `city_grade` VALUES (56, '临沂', 3); INSERT INTO `city_grade` VALUES (57, '唐山', 3); INSERT INTO `city_grade` VALUES (58, '镇江', 3); INSERT INTO `city_grade` VALUES (59, '盐城', 3); INSERT INTO `city_grade` VALUES (60, '湖州', 3); INSERT INTO `city_grade` VALUES (61, '赣州', 3); INSERT INTO `city_grade` VALUES (62, '泰州', 3); INSERT INTO `city_grade` VALUES (63, '济宁', 3); INSERT INTO `city_grade` VALUES (64, '呼和浩特', 3); INSERT INTO `city_grade` VALUES (65, '咸阳', 3); INSERT INTO `city_grade` VALUES (66, '漳州', 3); INSERT INTO `city_grade` VALUES (67, '揭阳', 3); INSERT INTO `city_grade` VALUES (68, '江门', 3); INSERT INTO `city_grade` VALUES (69, '桂林', 3); INSERT INTO `city_grade` VALUES (70, '邯郸', 3); INSERT INTO `city_grade` VALUES (71, '芜湖', 3); INSERT INTO `city_grade` VALUES (72, '三亚', 3); INSERT INTO `city_grade` VALUES (73, '阜阳', 3); INSERT INTO `city_grade` VALUES (74, '淮安', 3); INSERT INTO `city_grade` VALUES (75, '遵义', 3); INSERT INTO `city_grade` VALUES (76, '银川', 3); INSERT INTO `city_grade` VALUES (77, '衡阳', 3); INSERT INTO `city_grade` VALUES (78, '上饶', 3); INSERT INTO `city_grade` VALUES (79, '柳州', 3); INSERT INTO `city_grade` VALUES (80, '淄博', 3); INSERT INTO `city_grade` VALUES (81, '莆田', 3); INSERT INTO `city_grade` VALUES (82, '绵阳', 3); INSERT INTO `city_grade` VALUES (83, '湛江', 3); INSERT INTO `city_grade` VALUES (84, '商丘', 3); INSERT INTO `city_grade` VALUES (85, '宜昌', 3); INSERT INTO `city_grade` VALUES (86, '沧州', 3); INSERT INTO `city_grade` VALUES (87, '连云港', 3); INSERT INTO `city_grade` VALUES (88, '南阳', 3); INSERT INTO `city_grade` VALUES (89, '九江', 3); INSERT INTO `city_grade` VALUES (90, '新乡', 3); INSERT INTO `city_grade` VALUES (91, '信阳', 3); INSERT INTO `city_grade` VALUES (92, '襄阳', 3); INSERT INTO `city_grade` VALUES (93, '岳阳', 3); INSERT INTO `city_grade` VALUES (94, '蚌埠', 3); INSERT INTO `city_grade` VALUES (95, '驻马店', 3); INSERT INTO `city_grade` VALUES (96, '滁州', 3); INSERT INTO `city_grade` VALUES (97, '威海', 3); INSERT INTO `city_grade` VALUES (98, '宿迁', 3); INSERT INTO `city_grade` VALUES (99, '株洲', 3); INSERT INTO `city_grade` VALUES (100, '宁德', 3); INSERT INTO `city_grade` VALUES (101, '邢台', 3); INSERT INTO `city_grade` VALUES (102, '潮州', 3); INSERT INTO `city_grade` VALUES (103, '秦皇岛', 3); INSERT INTO `city_grade` VALUES (104, '肇庆', 3); INSERT INTO `city_grade` VALUES (105, '荆州', 3); INSERT INTO `city_grade` VALUES (106, '周口', 3); INSERT INTO `city_grade` VALUES (107, '马鞍山', 3); INSERT INTO `city_grade` VALUES (108, '清远', 3); INSERT INTO `city_grade` VALUES (109, '宿州', 3); INSERT INTO `city_grade` VALUES (110, '鞍山', 3); INSERT INTO `city_grade` VALUES (111, '安庆', 3); INSERT INTO `city_grade` VALUES (112, '菏泽', 3); INSERT INTO `city_grade` VALUES (113, '宜春', 3); INSERT INTO `city_grade` VALUES (114, '黄冈', 3); INSERT INTO `city_grade` VALUES (115, '泰安', 3); INSERT INTO `city_grade` VALUES (116, '南充', 3); INSERT INTO `city_grade` VALUES (117, '六安', 3); INSERT INTO `city_grade` VALUES (118, '大庆', 3); INSERT INTO `city_grade` VALUES (119, '舟山', 3); INSERT INTO `city_grade` VALUES (120, '常德', 4); INSERT INTO `city_grade` VALUES (121, '渭南', 4); INSERT INTO `city_grade` VALUES (122, '孝感', 4); INSERT INTO `city_grade` VALUES (123, '丽水', 4); INSERT INTO `city_grade` VALUES (124, '运城', 4); INSERT INTO `city_grade` VALUES (125, '德州', 4); INSERT INTO `city_grade` VALUES (126, '许昌', 4); INSERT INTO `city_grade` VALUES (127, '湘潭', 4); INSERT INTO `city_grade` VALUES (128, '晋中', 4); INSERT INTO `city_grade` VALUES (129, '安阳', 4); INSERT INTO `city_grade` VALUES (130, '三明', 4); INSERT INTO `city_grade` VALUES (131, '开封', 4); INSERT INTO `city_grade` VALUES (132, '郴州', 4); INSERT INTO `city_grade` VALUE