当前位置:Gxlcms > 数据库问题 > 市县区三级数据库设计

市县区三级数据库设计

时间:2021-07-01 10:21:17 帮助过:7人阅读

CREATE TABLE city (
  id int(11) NOT NULL DEFAULT ‘0‘,
  pid int(11) DEFAULT NULL,
  cityname varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  type  int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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 (‘33‘, ‘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 (‘73‘, ‘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 (‘113‘, ‘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 (‘153‘, ‘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 (‘193‘, ‘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 (‘233‘, ‘17‘, ‘南昌‘, ‘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 (‘273‘, ‘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 (‘313‘, ‘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 (‘353‘, ‘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‘);
INSERT INTO `city` VALUES (‘393‘, ‘31‘, ‘衢州‘, ‘2‘);
INSERT INTO `city` VALUES (‘394‘, ‘32‘, ‘重庆‘, ‘2‘);
INSERT INTO `city` VALUES (‘395‘, ‘33‘, ‘香港‘, ‘2‘);
INSERT INTO `city` VALUES (‘396‘, ‘34‘, ‘澳门‘, ‘2‘);
INSERT INTO `city` VALUES (‘397‘, ‘35‘, ‘台湾‘, ‘2‘);
INSERT INTO `city` VALUES (‘398‘, ‘36‘, ‘迎江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘399‘, ‘36‘, ‘大观区‘, ‘3‘);
INSERT INTO `city` VALUES (‘400‘, ‘36‘, ‘宜秀区‘, ‘3‘);
INSERT INTO `city` VALUES (‘401‘, ‘36‘, ‘桐城市‘, ‘3‘);
INSERT INTO `city` VALUES (‘402‘, ‘36‘, ‘怀宁县‘, ‘3‘);
INSERT INTO `city` VALUES (‘403‘, ‘36‘, ‘枞阳县‘, ‘3‘);
INSERT INTO `city` VALUES (‘404‘, ‘36‘, ‘潜山县‘, ‘3‘);
INSERT INTO `city` VALUES (‘405‘, ‘36‘, ‘太湖县‘, ‘3‘);
INSERT INTO `city` VALUES (‘406‘, ‘36‘, ‘宿松县‘, ‘3‘);
INSERT INTO `city` VALUES (‘407‘, ‘36‘, ‘望江县‘, ‘3‘);
INSERT INTO `city` VALUES (‘408‘, ‘36‘, ‘岳西县‘, ‘3‘);
INSERT INTO `city` VALUES (‘409‘, ‘37‘, ‘中市区‘, ‘3‘);
INSERT INTO `city` VALUES (‘410‘, ‘37‘, ‘东市区‘, ‘3‘);
INSERT INTO `city` VALUES (‘411‘, ‘37‘, ‘西市区‘, ‘3‘);
INSERT INTO `city` VALUES (‘412‘, ‘37‘, ‘郊区‘, ‘3‘);
INSERT INTO `city` VALUES (‘413‘, ‘37‘, ‘怀远县‘, ‘3‘);
INSERT INTO `city` VALUES (‘414‘, ‘37‘, ‘五河县‘, ‘3‘);
INSERT INTO `city` VALUES (‘415‘, ‘37‘, ‘固镇县‘, ‘3‘);
INSERT INTO `city` VALUES (‘416‘, ‘38‘, ‘居巢区‘, ‘3‘);
INSERT INTO `city` VALUES (‘417‘, ‘38‘, ‘庐江县‘, ‘3‘);
INSERT INTO `city` VALUES (‘418‘, ‘38‘, ‘无为县‘, ‘3‘);
INSERT INTO `city` VALUES (‘419‘, ‘38‘, ‘含山县‘, ‘3‘);
INSERT INTO `city` VALUES (‘420‘, ‘38‘, ‘和县‘, ‘3‘);
INSERT INTO `city` VALUES (‘421‘, ‘39‘, ‘贵池区‘, ‘3‘);
INSERT INTO `city` VALUES (‘422‘, ‘39‘, ‘东至县‘, ‘3‘);
INSERT INTO `city` VALUES (‘423‘, ‘39‘, ‘石台县‘, ‘3‘);
INSERT INTO `city` VALUES (‘424‘, ‘39‘, ‘青阳县‘, ‘3‘);
INSERT INTO `city` VALUES (‘425‘, ‘40‘, ‘琅琊区‘, ‘3‘);
INSERT INTO `city` VALUES (‘426‘, ‘40‘, ‘南谯区‘, ‘3‘);
INSERT INTO `city` VALUES (‘427‘, ‘40‘, ‘天长市‘, ‘3‘);
INSERT INTO `city` VALUES (‘428‘, ‘40‘, ‘明光市‘, ‘3‘);
INSERT INTO `city` VALUES (‘429‘, ‘40‘, ‘来安县‘, ‘3‘);
INSERT INTO `city` VALUES (‘430‘, ‘40‘, ‘全椒县‘, ‘3‘);
INSERT INTO `city` VALUES (‘431‘, ‘40‘, ‘定远县‘, ‘3‘);
INSERT INTO `city` VALUES (‘432‘, ‘40‘, ‘凤阳县‘, ‘3‘);
INSERT INTO `city` VALUES (‘433‘, ‘41‘, ‘蚌山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘434‘, ‘41‘, ‘龙子湖区‘, ‘3‘);
INSERT INTO `city` VALUES (‘435‘, ‘41‘, ‘禹会区‘, ‘3‘);
INSERT INTO `city` VALUES (‘436‘, ‘41‘, ‘淮上区‘, ‘3‘);
INSERT INTO `city` VALUES (‘437‘, ‘41‘, ‘颍州区‘, ‘3‘);
INSERT INTO `city` VALUES (‘438‘, ‘41‘, ‘颍东区‘, ‘3‘);
INSERT INTO `city` VALUES (‘439‘, ‘41‘, ‘颍泉区‘, ‘3‘);
INSERT INTO `city` VALUES (‘440‘, ‘41‘, ‘界首市‘, ‘3‘);
INSERT INTO `city` VALUES (‘441‘, ‘41‘, ‘临泉县‘, ‘3‘);
INSERT INTO `city` VALUES (‘442‘, ‘41‘, ‘太和县‘, ‘3‘);
INSERT INTO `city` VALUES (‘443‘, ‘41‘, ‘阜南县‘, ‘3‘);
INSERT INTO `city` VALUES (‘444‘, ‘41‘, ‘颖上县‘, ‘3‘);
INSERT INTO `city` VALUES (‘445‘, ‘42‘, ‘相山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘446‘, ‘42‘, ‘杜集区‘, ‘3‘);
INSERT INTO `city` VALUES (‘447‘, ‘42‘, ‘烈山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘448‘, ‘42‘, ‘濉溪县‘, ‘3‘);
INSERT INTO `city` VALUES (‘449‘, ‘43‘, ‘田家庵区‘, ‘3‘);
INSERT INTO `city` VALUES (‘450‘, ‘43‘, ‘大通区‘, ‘3‘);
INSERT INTO `city` VALUES (‘451‘, ‘43‘, ‘谢家集区‘, ‘3‘);
INSERT INTO `city` VALUES (‘452‘, ‘43‘, ‘八公山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘453‘, ‘43‘, ‘潘集区‘, ‘3‘);
INSERT INTO `city` VALUES (‘454‘, ‘43‘, ‘凤台县‘, ‘3‘);
INSERT INTO `city` VALUES (‘455‘, ‘44‘, ‘屯溪区‘, ‘3‘);
INSERT INTO `city` VALUES (‘456‘, ‘44‘, ‘黄山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘457‘, ‘44‘, ‘徽州区‘, ‘3‘);
INSERT INTO `city` VALUES (‘458‘, ‘44‘, ‘歙县‘, ‘3‘);
INSERT INTO `city` VALUES (‘459‘, ‘44‘, ‘休宁县‘, ‘3‘);
INSERT INTO `city` VALUES (‘460‘, ‘44‘, ‘黟县‘, ‘3‘);
INSERT INTO `city` VALUES (‘461‘, ‘44‘, ‘祁门县‘, ‘3‘);
INSERT INTO `city` VALUES (‘462‘, ‘45‘, ‘金安区‘, ‘3‘);
INSERT INTO `city` VALUES (‘463‘, ‘45‘, ‘裕安区‘, ‘3‘);
INSERT INTO `city` VALUES (‘464‘, ‘45‘, ‘寿县‘, ‘3‘);
INSERT INTO `city` VALUES (‘465‘, ‘45‘, ‘霍邱县‘, ‘3‘);
INSERT INTO `city` VALUES (‘466‘, ‘45‘, ‘舒城县‘, ‘3‘);
INSERT INTO `city` VALUES (‘467‘, ‘45‘, ‘金寨县‘, ‘3‘);
INSERT INTO `city` VALUES (‘468‘, ‘45‘, ‘霍山县‘, ‘3‘);
INSERT INTO `city` VALUES (‘469‘, ‘46‘, ‘雨山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘470‘, ‘46‘, ‘花山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘471‘, ‘46‘, ‘金家庄区‘, ‘3‘);
INSERT INTO `city` VALUES (‘472‘, ‘46‘, ‘当涂县‘, ‘3‘);
INSERT INTO `city` VALUES (‘473‘, ‘47‘, ‘埇桥区‘, ‘3‘);
INSERT INTO `city` VALUES (‘474‘, ‘47‘, ‘砀山县‘, ‘3‘);
INSERT INTO `city` VALUES (‘475‘, ‘47‘, ‘萧县‘, ‘3‘);
INSERT INTO `city` VALUES (‘476‘, ‘47‘, ‘灵璧县‘, ‘3‘);
INSERT INTO `city` VALUES (‘477‘, ‘47‘, ‘泗县‘, ‘3‘);
INSERT INTO `city` VALUES (‘478‘, ‘48‘, ‘铜官山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘479‘, ‘48‘, ‘狮子山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘480‘, ‘48‘, ‘郊区‘, ‘3‘);
INSERT INTO `city` VALUES (‘481‘, ‘48‘, ‘铜陵县‘, ‘3‘);
INSERT INTO `city` VALUES (‘482‘, ‘49‘, ‘镜湖区‘, ‘3‘);
INSERT INTO `city` VALUES (‘483‘, ‘49‘, ‘弋江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘484‘, ‘49‘, ‘鸠江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘485‘, ‘49‘, ‘三山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘486‘, ‘49‘, ‘芜湖县‘, ‘3‘);
INSERT INTO `city` VALUES (‘487‘, ‘49‘, ‘繁昌县‘, ‘3‘);
INSERT INTO `city` VALUES (‘488‘, ‘49‘, ‘南陵县‘, ‘3‘);
INSERT INTO `city` VALUES (‘489‘, ‘50‘, ‘宣州区‘, ‘3‘);
INSERT INTO `city` VALUES (‘490‘, ‘50‘, ‘宁国市‘, ‘3‘);
INSERT INTO `city` VALUES (‘491‘, ‘50‘, ‘郎溪县‘, ‘3‘);
INSERT INTO `city` VALUES (‘492‘, ‘50‘, ‘广德县‘, ‘3‘);
INSERT INTO `city` VALUES (‘493‘, ‘50‘, ‘泾县‘, ‘3‘);
INSERT INTO `city` VALUES (‘494‘, ‘50‘, ‘绩溪县‘, ‘3‘);
INSERT INTO `city` VALUES (‘495‘, ‘50‘, ‘旌德县‘, ‘3‘);
INSERT INTO `city` VALUES (‘496‘, ‘51‘, ‘涡阳县‘, ‘3‘);
INSERT INTO `city` VALUES (‘497‘, ‘51‘, ‘蒙城县‘, ‘3‘);
INSERT INTO `city` VALUES (‘498‘, ‘51‘, ‘利辛县‘, ‘3‘);
INSERT INTO `city` VALUES (‘499‘, ‘51‘, ‘谯城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘500‘, ‘52‘, ‘东城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘501‘, ‘52‘, ‘西城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘502‘, ‘52‘, ‘海淀区‘, ‘3‘);
INSERT INTO `city` VALUES (‘503‘, ‘52‘, ‘朝阳区‘, ‘3‘);
INSERT INTO `city` VALUES (‘504‘, ‘52‘, ‘崇文区‘, ‘3‘);
INSERT INTO `city` VALUES (‘505‘, ‘52‘, ‘宣武区‘, ‘3‘);
INSERT INTO `city` VALUES (‘506‘, ‘52‘, ‘丰台区‘, ‘3‘);
INSERT INTO `city` VALUES (‘507‘, ‘52‘, ‘石景山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘508‘, ‘52‘, ‘房山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘509‘, ‘52‘, ‘门头沟区‘, ‘3‘);
INSERT INTO `city` VALUES (‘510‘, ‘52‘, ‘通州区‘, ‘3‘);
INSERT INTO `city` VALUES (‘511‘, ‘52‘, ‘顺义区‘, ‘3‘);
INSERT INTO `city` VALUES (‘512‘, ‘52‘, ‘昌平区‘, ‘3‘);
INSERT INTO `city` VALUES (‘513‘, ‘52‘, ‘怀柔区‘, ‘3‘);
INSERT INTO `city` VALUES (‘514‘, ‘52‘, ‘平谷区‘, ‘3‘);
INSERT INTO `city` VALUES (‘515‘, ‘52‘, ‘大兴区‘, ‘3‘);
INSERT INTO `city` VALUES (‘516‘, ‘52‘, ‘密云县‘, ‘3‘);
INSERT INTO `city` VALUES (‘517‘, ‘52‘, ‘延庆县‘, ‘3‘);
INSERT INTO `city` VALUES (‘518‘, ‘53‘, ‘鼓楼区‘, ‘3‘);
INSERT INTO `city` VALUES (‘519‘, ‘53‘, ‘台江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘520‘, ‘53‘, ‘仓山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘521‘, ‘53‘, ‘马尾区‘, ‘3‘);
INSERT INTO `city` VALUES (‘522‘, ‘53‘, ‘晋安区‘, ‘3‘);
INSERT INTO `city` VALUES (‘523‘, ‘53‘, ‘福清市‘, ‘3‘);
INSERT INTO `city` VALUES (‘524‘, ‘53‘, ‘长乐市‘, ‘3‘);
INSERT INTO `city` VALUES (‘525‘, ‘53‘, ‘闽侯县‘, ‘3‘);
INSERT INTO `city` VALUES (‘526‘, ‘53‘, ‘连江县‘, ‘3‘);
INSERT INTO `city` VALUES (‘527‘, ‘53‘, ‘罗源县‘, ‘3‘);
INSERT INTO `city` VALUES (‘528‘, ‘53‘, ‘闽清县‘, ‘3‘);
INSERT INTO `city` VALUES (‘529‘, ‘53‘, ‘永泰县‘, ‘3‘);
INSERT INTO `city` VALUES (‘530‘, ‘53‘, ‘平潭县‘, ‘3‘);
INSERT INTO `city` VALUES (‘531‘, ‘54‘, ‘新罗区‘, ‘3‘);
INSERT INTO `city` VALUES (‘532‘, ‘54‘, ‘漳平市‘, ‘3‘);
INSERT INTO `city` VALUES (‘533‘, ‘54‘, ‘长汀县‘, ‘3‘);
INSERT INTO `city` VALUES (‘534‘, ‘54‘, ‘永定县‘, ‘3‘);
INSERT INTO `city` VALUES (‘535‘, ‘54‘, ‘上杭县‘, ‘3‘);
INSERT INTO `city` VALUES (‘536‘, ‘54‘, ‘武平县‘, ‘3‘);
INSERT INTO `city` VALUES (‘537‘, ‘54‘, ‘连城县‘, ‘3‘);
INSERT INTO `city` VALUES (‘538‘, ‘55‘, ‘延平区‘, ‘3‘);
INSERT INTO `city` VALUES (‘539‘, ‘55‘, ‘邵武市‘, ‘3‘);
INSERT INTO `city` VALUES (‘540‘, ‘55‘, ‘武夷山市‘, ‘3‘);
INSERT INTO `city` VALUES (‘541‘, ‘55‘, ‘建瓯市‘, ‘3‘);
INSERT INTO `city` VALUES (‘542‘, ‘55‘, ‘建阳市‘, ‘3‘);
INSERT INTO `city` VALUES (‘543‘, ‘55‘, ‘顺昌县‘, ‘3‘);
INSERT INTO `city` VALUES (‘544‘, ‘55‘, ‘浦城县‘, ‘3‘);
INSERT INTO `city` VALUES (‘545‘, ‘55‘, ‘光泽县‘, ‘3‘);
INSERT INTO `city` VALUES (‘546‘, ‘55‘, ‘松溪县‘, ‘3‘);
INSERT INTO `city` VALUES (‘547‘, ‘55‘, ‘政和县‘, ‘3‘);
INSERT INTO `city` VALUES (‘548‘, ‘56‘, ‘蕉城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘549‘, ‘56‘, ‘福安市‘, ‘3‘);
INSERT INTO `city` VALUES (‘550‘, ‘56‘, ‘福鼎市‘, ‘3‘);
INSERT INTO `city` VALUES (‘551‘, ‘56‘, ‘霞浦县‘, ‘3‘);
INSERT INTO `city` VALUES (‘552‘, ‘56‘, ‘古田县‘, ‘3‘);
INSERT INTO `city` VALUES (‘553‘, ‘56‘, ‘屏南县‘, ‘3‘);
INSERT INTO `city` VALUES (‘554‘, ‘56‘, ‘寿宁县‘, ‘3‘);
INSERT INTO `city` VALUES (‘555‘, ‘56‘, ‘周宁县‘, ‘3‘);
INSERT INTO `city` VALUES (‘556‘, ‘56‘, ‘柘荣县‘, ‘3‘);
INSERT INTO `city` VALUES (‘557‘, ‘57‘, ‘城厢区‘, ‘3‘);
INSERT INTO `city` VALUES (‘558‘, ‘57‘, ‘涵江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘559‘, ‘57‘, ‘荔城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘560‘, ‘57‘, ‘秀屿区‘, ‘3‘);
INSERT INTO `city` VALUES (‘561‘, ‘57‘, ‘仙游县‘, ‘3‘);
INSERT INTO `city` VALUES (‘562‘, ‘58‘, ‘鲤城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘563‘, ‘58‘, ‘丰泽区‘, ‘3‘);
INSERT INTO `city` VALUES (‘564‘, ‘58‘, ‘洛江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘565‘, ‘58‘, ‘清濛开发区‘, ‘3‘);
INSERT INTO `city` VALUES (‘566‘, ‘58‘, ‘泉港区‘, ‘3‘);
INSERT INTO `city` VALUES (‘567‘, ‘58‘, ‘石狮市‘, ‘3‘);
INSERT INTO `city` VALUES (‘568‘, ‘58‘, ‘晋江市‘, ‘3‘);
INSERT INTO `city` VALUES (‘569‘, ‘58‘, ‘南安市‘, ‘3‘);
INSERT INTO `city` VALUES (‘570‘, ‘58‘, ‘惠安县‘, ‘3‘);
INSERT INTO `city` VALUES (‘571‘, ‘58‘, ‘安溪县‘, ‘3‘);
INSERT INTO `city` VALUES (‘572‘, ‘58‘, ‘永春县‘, ‘3‘);
INSERT INTO `city` VALUES (‘573‘, ‘58‘, ‘德化县‘, ‘3‘);
INSERT INTO `city` VALUES (‘574‘, ‘58‘, ‘金门县‘, ‘3‘);
INSERT INTO `city` VALUES (‘575‘, ‘59‘, ‘梅列区‘, ‘3‘);
INSERT INTO `city` VALUES (‘576‘, ‘59‘, ‘三元区‘, ‘3‘);
INSERT INTO `city` VALUES (‘577‘, ‘59‘, ‘永安市‘, ‘3‘);
INSERT INTO `city` VALUES (‘578‘, ‘59‘, ‘明溪县‘, ‘3‘);
INSERT INTO `city` VALUES (‘579‘, ‘59‘, ‘清流县‘, ‘3‘);
INSERT INTO `city` VALUES (‘580‘, ‘59‘, ‘宁化县‘, ‘3‘);
INSERT INTO `city` VALUES (‘581‘, ‘59‘, ‘大田县‘, ‘3‘);
INSERT INTO `city` VALUES (‘582‘, ‘59‘, ‘尤溪县‘, ‘3‘);
INSERT INTO `city` VALUES (‘583‘, ‘59‘, ‘沙县‘, ‘3‘);
INSERT INTO `city` VALUES (‘584‘, ‘59‘, ‘将乐县‘, ‘3‘);
INSERT INTO `city` VALUES (‘585‘, ‘59‘, ‘泰宁县‘, ‘3‘);
INSERT INTO `city` VALUES (‘586‘, ‘59‘, ‘建宁县‘, ‘3‘);
INSERT INTO `city` VALUES (‘587‘, ‘60‘, ‘思明区‘, ‘3‘);
INSERT INTO `city` VALUES (‘588‘, ‘60‘, ‘海沧区‘, ‘3‘);
INSERT INTO `city` VALUES (‘589‘, ‘60‘, ‘湖里区‘, ‘3‘);
INSERT INTO `city` VALUES (‘590‘, ‘60‘, ‘集美区‘, ‘3‘);
INSERT INTO `city` VALUES (‘591‘, ‘60‘, ‘同安区‘, ‘3‘);
INSERT INTO `city` VALUES (‘592‘, ‘60‘, ‘翔安区‘, ‘3‘);
INSERT INTO `city` VALUES (‘593‘, ‘61‘, ‘芗城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘594‘, ‘61‘, ‘龙文区‘, ‘3‘);
INSERT INTO `city` VALUES (‘595‘, ‘61‘, ‘龙海市‘, ‘3‘);
INSERT INTO `city` VALUES (‘596‘, ‘61‘, ‘云霄县‘, ‘3‘);
INSERT INTO `city` VALUES (‘597‘, ‘61‘, ‘漳浦县‘, ‘3‘);
INSERT INTO `city` VALUES (‘598‘, ‘61‘, ‘诏安县‘, ‘3‘);
INSERT INTO `city` VALUES (‘599‘, ‘61‘, ‘长泰县‘, ‘3‘);
INSERT INTO `city` VALUES (‘600‘, ‘61‘, ‘东山县‘, ‘3‘);
INSERT INTO `city` VALUES (‘601‘, ‘61‘, ‘南靖县‘, ‘3‘);
INSERT INTO `city` VALUES (‘602‘, ‘61‘, ‘平和县‘, ‘3‘);
INSERT INTO `city` VALUES (‘603‘, ‘61‘, ‘华安县‘, ‘3‘);
INSERT INTO `city` VALUES (‘604‘, ‘62‘, ‘皋兰县‘, ‘3‘);
INSERT INTO `city` VALUES (‘605‘, ‘62‘, ‘城关区‘, ‘3‘);
INSERT INTO `city` VALUES (‘606‘, ‘62‘, ‘七里河区‘, ‘3‘);
INSERT INTO `city` VALUES (‘607‘, ‘62‘, ‘西固区‘, ‘3‘);
INSERT INTO `city` VALUES (‘608‘, ‘62‘, ‘安宁区‘, ‘3‘);
INSERT INTO `city` VALUES (‘609‘, ‘62‘, ‘红古区‘, ‘3‘);
INSERT INTO `city` VALUES (‘610‘, ‘62‘, ‘永登县‘, ‘3‘);
INSERT INTO `city` VALUES (‘611‘, ‘62‘, ‘榆中县‘, ‘3‘);
INSERT INTO `city` VALUES (‘612‘, ‘63‘, ‘白银区‘, ‘3‘);
INSERT INTO `city` VALUES (‘613‘, ‘63‘, ‘平川区‘, ‘3‘);
INSERT INTO `city` VALUES (‘614‘, ‘63‘, ‘会宁县‘, ‘3‘);
INSERT INTO `city` VALUES (‘615‘, ‘63‘, ‘景泰县‘, ‘3‘);
INSERT INTO `city` VALUES (‘616‘, ‘63‘, ‘靖远县‘, ‘3‘);
INSERT INTO `city` VALUES (‘617‘, ‘64‘, ‘临洮县‘, ‘3‘);
INSERT INTO `city` VALUES (‘618‘, ‘64‘, ‘陇西县‘, ‘3‘);
INSERT INTO `city` VALUES (‘619‘, ‘64‘, ‘通渭县‘, ‘3‘);
INSERT INTO `city` VALUES (‘620‘, ‘64‘, ‘渭源县‘, ‘3‘);
INSERT INTO `city` VALUES (‘621‘, ‘64‘, ‘漳县‘, ‘3‘);
INSERT INTO `city` VALUES (‘622‘, ‘64‘, ‘岷县‘, ‘3‘);
INSERT INTO `city` VALUES (‘623‘, ‘64‘, ‘安定区‘, ‘3‘);
INSERT INTO `city` VALUES (‘624‘, ‘64‘, ‘安定区‘, ‘3‘);
INSERT INTO `city` VALUES (‘625‘, ‘65‘, ‘合作市‘, ‘3‘);
INSERT INTO `city` VALUES (‘626‘, ‘65‘, ‘临潭县‘, ‘3‘);
INSERT INTO `city` VALUES (‘627‘, ‘65‘, ‘卓尼县‘, ‘3‘);
INSERT INTO `city` VALUES (‘628‘, ‘65‘, ‘舟曲县‘, ‘3‘);
INSERT INTO `city` VALUES (‘629‘, ‘65‘, ‘迭部县‘, ‘3‘);
INSERT INTO `city` VALUES (‘630‘, ‘65‘, ‘玛曲县‘, ‘3‘);
INSERT INTO `city` VALUES (‘631‘, ‘65‘, ‘碌曲县‘, ‘3‘);
INSERT INTO `city` VALUES (‘632‘, ‘65‘, ‘夏河县‘, ‘3‘);
INSERT INTO `city` VALUES (‘633‘, ‘66‘, ‘嘉峪关市‘, ‘3‘);
INSERT INTO `city` VALUES (‘634‘, ‘67‘, ‘金川区‘, ‘3‘);
INSERT INTO `city` VALUES (‘635‘, ‘67‘, ‘永昌县‘, ‘3‘);
INSERT INTO `city` VALUES (‘636‘, ‘68‘, ‘肃州区‘, ‘3‘);
INSERT INTO `city` VALUES (‘637‘, ‘68‘, ‘玉门市‘, ‘3‘);
INSERT INTO `city` VALUES (‘638‘, ‘68‘, ‘敦煌市‘, ‘3‘);
INSERT INTO `city` VALUES (‘639‘, ‘68‘, ‘金塔县‘, ‘3‘);
INSERT INTO `city` VALUES (‘640‘, ‘68‘, ‘瓜州县‘, ‘3‘);
INSERT INTO `city` VALUES (‘641‘, ‘68‘, ‘肃北‘, ‘3‘);
INSERT INTO `city` VALUES (‘642‘, ‘68‘, ‘阿克塞‘, ‘3‘);
INSERT INTO `city` VALUES (‘643‘, ‘69‘, ‘临夏市‘, ‘3‘);
INSERT INTO `city` VALUES (‘644‘, ‘69‘, ‘临夏县‘, ‘3‘);
INSERT INTO `city` VALUES (‘645‘, ‘69‘, ‘康乐县‘, ‘3‘);
INSERT INTO `city` VALUES (‘646‘, ‘69‘, ‘永靖县‘, ‘3‘);
INSERT INTO `city` VALUES (‘647‘, ‘69‘, ‘广河县‘, ‘3‘);
INSERT INTO `city` VALUES (‘648‘, ‘69‘, ‘和政县‘, ‘3‘);
INSERT INTO `city` VALUES (‘649‘, ‘69‘, ‘东乡族自治县‘, ‘3‘);
INSERT INTO `city` VALUES (‘650‘, ‘69‘, ‘积石山‘, ‘3‘);
INSERT INTO `city` VALUES (‘651‘, ‘70‘, ‘成县‘, ‘3‘);
INSERT INTO `city` VALUES (‘652‘, ‘70‘, ‘徽县‘, ‘3‘);
INSERT INTO `city` VALUES (‘653‘, ‘70‘, ‘康县‘, ‘3‘);
INSERT INTO `city` VALUES (‘654‘, ‘70‘, ‘礼县‘, ‘3‘);
INSERT INTO `city` VALUES (‘655‘, ‘70‘, ‘两当县‘, ‘3‘);
INSERT INTO `city` VALUES (‘656‘, ‘70‘, ‘文县‘, ‘3‘);
INSERT INTO `city` VALUES (‘657‘, ‘70‘, ‘西和县‘, ‘3‘);
INSERT INTO `city` VALUES (‘658‘, ‘70‘, ‘宕昌县‘, ‘3‘);
INSERT INTO `city` VALUES (‘659‘, ‘70‘, ‘武都区‘, ‘3‘);
INSERT INTO `city` VALUES (‘660‘, ‘71‘, ‘崇信县‘, ‘3‘);
INSERT INTO `city` VALUES (‘661‘, ‘71‘, ‘华亭县‘, ‘3‘);
INSERT INTO `city` VALUES (‘662‘, ‘71‘, ‘静宁县‘, ‘3‘);
INSERT INTO `city` VALUES (‘663‘, ‘71‘, ‘灵台县‘, ‘3‘);
INSERT INTO `city` VALUES (‘664‘, ‘71‘, ‘崆峒区‘, ‘3‘);
INSERT INTO `city` VALUES (‘665‘, ‘71‘, ‘庄浪县‘, ‘3‘);
INSERT INTO `city` VALUES (‘666‘, ‘71‘, ‘泾川县‘, ‘3‘);
INSERT INTO `city` VALUES (‘667‘, ‘72‘, ‘合水县‘, ‘3‘);
INSERT INTO `city` VALUES (‘668‘, ‘72‘, ‘华池县‘, ‘3‘);
INSERT INTO `city` VALUES (‘669‘, ‘72‘, ‘环县‘, ‘3‘);
INSERT INTO `city` VALUES (‘670‘, ‘72‘, ‘宁县‘, ‘3‘);
INSERT INTO `city` VALUES (‘671‘, ‘72‘, ‘庆城县‘, ‘3‘);
INSERT INTO `city` VALUES (‘672‘, ‘72‘, ‘西峰区‘, ‘3‘);
INSERT INTO `city` VALUES (‘673‘, ‘72‘, ‘镇原县‘, ‘3‘);
INSERT INTO `city` VALUES (‘674‘, ‘72‘, ‘正宁县‘, ‘3‘);
INSERT INTO `city` VALUES (‘675‘, ‘73‘, ‘甘谷县‘, ‘3‘);
INSERT INTO `city` VALUES (‘676‘, ‘73‘, ‘秦安县‘, ‘3‘);
INSERT INTO `city` VALUES (‘677‘, ‘73‘, ‘清水县‘, ‘3‘);
INSERT INTO `city` VALUES (‘678‘, ‘73‘, ‘秦州区‘, ‘3‘);
INSERT INTO `city` VALUES (‘679‘, ‘73‘, ‘麦积区‘, ‘3‘);
INSERT INTO `city` VALUES (‘680‘, ‘73‘, ‘武山县‘, ‘3‘);
INSERT INTO `city` VALUES (‘681‘, ‘73‘, ‘张家川‘, ‘3‘);
INSERT INTO `city` VALUES (‘682‘, ‘74‘, ‘古浪县‘, ‘3‘);
INSERT INTO `city` VALUES (‘683‘, ‘74‘, ‘民勤县‘, ‘3‘);
INSERT INTO `city` VALUES (‘684‘, ‘74‘, ‘天祝‘, ‘3‘);
INSERT INTO `city` VALUES (‘685‘, ‘74‘, ‘凉州区‘, ‘3‘);
INSERT INTO `city` VALUES (‘686‘, ‘75‘, ‘高台县‘, ‘3‘);
INSERT INTO `city` VALUES (‘687‘, ‘75‘, ‘临泽县‘, ‘3‘);
INSERT INTO `city` VALUES (‘688‘, ‘75‘, ‘民乐县‘, ‘3‘);
INSERT INTO `city` VALUES (‘689‘, ‘75‘, ‘山丹县‘, ‘3‘);
INSERT INTO `city` VALUES (‘690‘, ‘75‘, ‘肃南‘, ‘3‘);
INSERT INTO `city` VALUES (‘691‘, ‘75‘, ‘甘州区‘, ‘3‘);
INSERT INTO `city` VALUES (‘692‘, ‘76‘, ‘从化市‘, ‘3‘);
INSERT INTO `city` VALUES (‘693‘, ‘76‘, ‘天河区‘, ‘3‘);
INSERT INTO `city` VALUES (‘694‘, ‘76‘, ‘东山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘695‘, ‘76‘, ‘白云区‘, ‘3‘);
INSERT INTO `city` VALUES (‘696‘, ‘76‘, ‘海珠区‘, ‘3‘);
INSERT INTO `city` VALUES (‘697‘, ‘76‘, ‘荔湾区‘, ‘3‘);
INSERT INTO `city` VALUES (‘698‘, ‘76‘, ‘越秀区‘, ‘3‘);
INSERT INTO `city` VALUES (‘699‘, ‘76‘, ‘黄埔区‘, ‘3‘);
INSERT INTO `city` VALUES (‘700‘, ‘76‘, ‘番禺区‘, ‘3‘);
INSERT INTO `city` VALUES (‘701‘, ‘76‘, ‘花都区‘, ‘3‘);
INSERT INTO `city` VALUES (‘702‘, ‘76‘, ‘增城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘703‘, ‘76‘, ‘从化区‘, ‘3‘);
INSERT INTO `city` VALUES (‘704‘, ‘76‘, ‘市郊‘, ‘3‘);
INSERT INTO `city` VALUES (‘705‘, ‘77‘, ‘福田区‘, ‘3‘);
INSERT INTO `city` VALUES (‘706‘, ‘77‘, ‘罗湖区‘, ‘3‘);
INSERT INTO `city` VALUES (‘707‘, ‘77‘, ‘南山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘708‘, ‘77‘, ‘宝安区‘, ‘3‘);
INSERT INTO `city` VALUES (‘709‘, ‘77‘, ‘龙岗区‘, ‘3‘);
INSERT INTO `city` VALUES (‘710‘, ‘77‘, ‘盐田区‘, ‘3‘);
INSERT INTO `city` VALUES (‘711‘, ‘78‘, ‘湘桥区‘, ‘3‘);
INSERT INTO `city` VALUES (‘712‘, ‘78‘, ‘潮安县‘, ‘3‘);
INSERT INTO `city` VALUES (‘713‘, ‘78‘, ‘饶平县‘, ‘3‘);
INSERT INTO `city` VALUES (‘714‘, ‘79‘, ‘南城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘715‘, ‘79‘, ‘东城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘716‘, ‘79‘, ‘万江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘717‘, ‘79‘, ‘莞城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘718‘, ‘79‘, ‘石龙镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘719‘, ‘79‘, ‘虎门镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘720‘, ‘79‘, ‘麻涌镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘721‘, ‘79‘, ‘道滘镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘722‘, ‘79‘, ‘石碣镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘723‘, ‘79‘, ‘沙田镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘724‘, ‘79‘, ‘望牛墩镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘725‘, ‘79‘, ‘洪梅镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘726‘, ‘79‘, ‘茶山镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘727‘, ‘79‘, ‘寮步镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘728‘, ‘79‘, ‘大岭山镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘729‘, ‘79‘, ‘大朗镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘730‘, ‘79‘, ‘黄江镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘731‘, ‘79‘, ‘樟木头‘, ‘3‘);
INSERT INTO `city` VALUES (‘732‘, ‘79‘, ‘凤岗镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘733‘, ‘79‘, ‘塘厦镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘734‘, ‘79‘, ‘谢岗镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘735‘, ‘79‘, ‘厚街镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘736‘, ‘79‘, ‘清溪镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘737‘, ‘79‘, ‘常平镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘738‘, ‘79‘, ‘桥头镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘739‘, ‘79‘, ‘横沥镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘740‘, ‘79‘, ‘东坑镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘741‘, ‘79‘, ‘企石镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘742‘, ‘79‘, ‘石排镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘743‘, ‘79‘, ‘长安镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘744‘, ‘79‘, ‘中堂镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘745‘, ‘79‘, ‘高埗镇‘, ‘3‘);
INSERT INTO `city` VALUES (‘746‘, ‘80‘, ‘禅城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘747‘, ‘80‘, ‘南海区‘, ‘3‘);
INSERT INTO `city` VALUES (‘748‘, ‘80‘, ‘顺德区‘, ‘3‘);
INSERT INTO `city` VALUES (‘749‘, ‘80‘, ‘三水区‘, ‘3‘);
INSERT INTO `city` VALUES (‘750‘, ‘80‘, ‘高明区‘, ‘3‘);
INSERT INTO `city` VALUES (‘751‘, ‘81‘, ‘东源县‘, ‘3‘);
INSERT INTO `city` VALUES (‘752‘, ‘81‘, ‘和平县‘, ‘3‘);
INSERT INTO `city` VALUES (‘753‘, ‘81‘, ‘源城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘754‘, ‘81‘, ‘连平县‘, ‘3‘);
INSERT INTO `city` VALUES (‘755‘, ‘81‘, ‘龙川县‘, ‘3‘);
INSERT INTO `city` VALUES (‘756‘, ‘81‘, ‘紫金县‘, ‘3‘);
INSERT INTO `city` VALUES (‘757‘, ‘82‘, ‘惠阳区‘, ‘3‘);
INSERT INTO `city` VALUES (‘758‘, ‘82‘, ‘惠城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘759‘, ‘82‘, ‘大亚湾‘, ‘3‘);
INSERT INTO `city` VALUES (‘760‘, ‘82‘, ‘博罗县‘, ‘3‘);
INSERT INTO `city` VALUES (‘761‘, ‘82‘, ‘惠东县‘, ‘3‘);
INSERT INTO `city` VALUES (‘762‘, ‘82‘, ‘龙门县‘, ‘3‘);
INSERT INTO `city` VALUES (‘763‘, ‘83‘, ‘江海区‘, ‘3‘);
INSERT INTO `city` VALUES (‘764‘, ‘83‘, ‘蓬江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘765‘, ‘83‘, ‘新会区‘, ‘3‘);
INSERT INTO `city` VALUES (‘766‘, ‘83‘, ‘台山市‘, ‘3‘);
INSERT INTO `city` VALUES (‘767‘, ‘83‘, ‘开平市‘, ‘3‘);
INSERT INTO `city` VALUES (‘768‘, ‘83‘, ‘鹤山市‘, ‘3‘);
INSERT INTO `city` VALUES (‘769‘, ‘83‘, ‘恩平市‘, ‘3‘);
INSERT INTO `city` VALUES (‘770‘, ‘84‘, ‘榕城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘771‘, ‘84‘, ‘普宁市‘, ‘3‘);
INSERT INTO `city` VALUES (‘772‘, ‘84‘, ‘揭东县‘, ‘3‘);
INSERT INTO `city` VALUES (‘773‘, ‘84‘, ‘揭西县‘, ‘3‘);
INSERT INTO `city` VALUES (‘774‘, ‘84‘, ‘惠来县‘, ‘3‘);
INSERT INTO `city` VALUES (‘775‘, ‘85‘, ‘茂南区‘, ‘3‘);
INSERT INTO `city` VALUES (‘776‘, ‘85‘, ‘茂港区‘, ‘3‘);
INSERT INTO `city` VALUES (‘777‘, ‘85‘, ‘高州市‘, ‘3‘);
INSERT INTO `city` VALUES (‘778‘, ‘85‘, ‘化州市‘, ‘3‘);
INSERT INTO `city` VALUES (‘779‘, ‘85‘, ‘信宜市‘, ‘3‘);
INSERT INTO `city` VALUES (‘780‘, ‘85‘, ‘电白县‘, ‘3‘);
INSERT INTO `city` VALUES (‘781‘, ‘86‘, ‘梅县‘, ‘3‘);
INSERT INTO `city` VALUES (‘782‘, ‘86‘, ‘梅江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘783‘, ‘86‘, ‘兴宁市‘, ‘3‘);
INSERT INTO `city` VALUES (‘784‘, ‘86‘, ‘大埔县‘, ‘3‘);
INSERT INTO `city` VALUES (‘785‘, ‘86‘, ‘丰顺县‘, ‘3‘);
INSERT INTO `city` VALUES (‘786‘, ‘86‘, ‘五华县‘, ‘3‘);
INSERT INTO `city` VALUES (‘787‘, ‘86‘, ‘平远县‘, ‘3‘);
INSERT INTO `city` VALUES (‘788‘, ‘86‘, ‘蕉岭县‘, ‘3‘);
INSERT INTO `city` VALUES (‘789‘, ‘87‘, ‘清城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘790‘, ‘87‘, ‘英德市‘, ‘3‘);
INSERT INTO `city` VALUES (‘791‘, ‘87‘, ‘连州市‘, ‘3‘);
INSERT INTO `city` VALUES (‘792‘, ‘87‘, ‘佛冈县‘, ‘3‘);
INSERT INTO `city` VALUES (‘793‘, ‘87‘, ‘阳山县‘, ‘3‘);
INSERT INTO `city` VALUES (‘794‘, ‘87‘, ‘清新县‘, ‘3‘);
INSERT INTO `city` VALUES (‘795‘, ‘87‘, ‘连山‘, ‘3‘);
INSERT INTO `city` VALUES (‘796‘, ‘87‘, ‘连南‘, ‘3‘);
INSERT INTO `city` VALUES (‘797‘, ‘88‘, ‘南澳县‘, ‘3‘);
INSERT INTO `city` VALUES (‘798‘, ‘88‘, ‘潮阳区‘, ‘3‘);
INSERT INTO `city` VALUES (‘799‘, ‘88‘, ‘澄海区‘, ‘3‘);
INSERT INTO `city` VALUES (‘800‘, ‘88‘, ‘龙湖区‘, ‘3‘);
INSERT INTO `city` VALUES (‘801‘, ‘88‘, ‘金平区‘, ‘3‘);
INSERT INTO `city` VALUES (‘802‘, ‘88‘, ‘濠江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘803‘, ‘88‘, ‘潮南区‘, ‘3‘);
INSERT INTO `city` VALUES (‘804‘, ‘89‘, ‘城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘805‘, ‘89‘, ‘陆丰市‘, ‘3‘);
INSERT INTO `city` VALUES (‘806‘, ‘89‘, ‘海丰县‘, ‘3‘);
INSERT INTO `city` VALUES (‘807‘, ‘89‘, ‘陆河县‘, ‘3‘);
INSERT INTO `city` VALUES (‘808‘, ‘90‘, ‘曲江县‘, ‘3‘);
INSERT INTO `city` VALUES (‘809‘, ‘90‘, ‘浈江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘810‘, ‘90‘, ‘武江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘811‘, ‘90‘, ‘曲江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘812‘, ‘90‘, ‘乐昌市‘, ‘3‘);
INSERT INTO `city` VALUES (‘813‘, ‘90‘, ‘南雄市‘, ‘3‘);
INSERT INTO `city` VALUES (‘814‘, ‘90‘, ‘始兴县‘, ‘3‘);
INSERT INTO `city` VALUES (‘815‘, ‘90‘, ‘仁化县‘, ‘3‘);
INSERT INTO `city` VALUES (‘816‘, ‘90‘, ‘翁源县‘, ‘3‘);
INSERT INTO `city` VALUES (‘817‘, ‘90‘, ‘新丰县‘, ‘3‘);
INSERT INTO `city` VALUES (‘818‘, ‘90‘, ‘乳源‘, ‘3‘);
INSERT INTO `city` VALUES (‘819‘, ‘91‘, ‘江城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘820‘, ‘91‘, ‘阳春市‘, ‘3‘);
INSERT INTO `city` VALUES (‘821‘, ‘91‘, ‘阳西县‘, ‘3‘);
INSERT INTO `city` VALUES (‘822‘, ‘91‘, ‘阳东县‘, ‘3‘);
INSERT INTO `city` VALUES (‘823‘, ‘92‘, ‘云城区‘, ‘3‘);
INSERT INTO `city` VALUES (‘824‘, ‘92‘, ‘罗定市‘, ‘3‘);
INSERT INTO `city` VALUES (‘825‘, ‘92‘, ‘新兴县‘, ‘3‘);
INSERT INTO `city` VALUES (‘826‘, ‘92‘, ‘郁南县‘, ‘3‘);
INSERT INTO `city` VALUES (‘827‘, ‘92‘, ‘云安县‘, ‘3‘);
INSERT INTO `city` VALUES (‘828‘, ‘93‘, ‘赤坎区‘, ‘3‘);
INSERT INTO `city` VALUES (‘829‘, ‘93‘, ‘霞山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘830‘, ‘93‘, ‘坡头区‘, ‘3‘);
INSERT INTO `city` VALUES (‘831‘, ‘93‘, ‘麻章区‘, ‘3‘);
INSERT INTO `city` VALUES (‘832‘, ‘93‘, ‘廉江市‘, ‘3‘);
INSERT INTO `city` VALUES (‘833‘, ‘93‘, ‘雷州市‘, ‘3‘);
INSERT INTO `city` VALUES (‘834‘, ‘93‘, ‘吴川市‘, ‘3‘);
INSERT INTO `city` VALUES (‘835‘, ‘93‘, ‘遂溪县‘, ‘3‘);
INSERT INTO `city` VALUES (‘836‘, ‘93‘, ‘徐闻县‘, ‘3‘);
INSERT INTO `city` VALUES (‘837‘, ‘94‘, ‘肇庆市‘, ‘3‘);
INSERT INTO `city` VALUES (‘838‘, ‘94‘, ‘高要市‘, ‘3‘);
INSERT INTO `city` VALUES (‘839‘, ‘94‘, ‘四会市‘, ‘3‘);
INSERT INTO `city` VALUES (‘840‘, ‘94‘, ‘广宁县‘, ‘3‘);
INSERT INTO `city` VALUES (‘841‘, ‘94‘, ‘怀集县‘, ‘3‘);
INSERT INTO `city` VALUES (‘842‘, ‘94‘, ‘封开县‘, ‘3‘);
INSERT INTO `city` VALUES (‘843‘, ‘94‘, ‘德庆县‘, ‘3‘);
INSERT INTO `city` VALUES (‘844‘, ‘95‘, ‘石岐街道‘, ‘3‘);
INSERT INTO `city` VALUES (‘845‘, ‘95‘, ‘东区街道‘, ‘3‘);
INSERT INTO `city` VALUES (‘846‘, ‘95‘, ‘西区街道‘, ‘3‘);
INSERT INTO `city` VALUES (‘847‘, ‘95‘, ‘环城街道‘, ‘3‘);
INSERT INTO `city` VALUES (‘848‘, ‘95‘, ‘中山港街道‘, ‘3‘);
INSERT INTO `city` VALUES (‘849‘, ‘95‘, ‘五桂山街道‘, ‘3‘);
INSERT INTO `city` VALUES (‘850‘, ‘96‘, ‘香洲区‘, ‘3‘);
INSERT INTO `city` VALUES (‘851‘, ‘96‘, ‘斗门区‘, ‘3‘);
INSERT INTO `city` VALUES (‘852‘, ‘96‘, ‘金湾区‘, ‘3‘);
INSERT INTO `city` VALUES (‘853‘, ‘97‘, ‘邕宁区‘, ‘3‘);
INSERT INTO `city` VALUES (‘854‘, ‘97‘, ‘青秀区‘, ‘3‘);
INSERT INTO `city` VALUES (‘855‘, ‘97‘, ‘兴宁区‘, ‘3‘);
INSERT INTO `city` VALUES (‘856‘, ‘97‘, ‘良庆区‘, ‘3‘);
INSERT INTO `city` VALUES (‘857‘, ‘97‘, ‘西乡塘区‘, ‘3‘);
INSERT INTO `city` VALUES (‘858‘, ‘97‘, ‘江南区‘, ‘3‘);
INSERT INTO `city` VALUES (‘859‘, ‘97‘, ‘武鸣县‘, ‘3‘);
INSERT INTO `city` VALUES (‘860‘, ‘97‘, ‘隆安县‘, ‘3‘);
INSERT INTO `city` VALUES (‘861‘, ‘97‘, ‘马山县‘, ‘3‘);
INSERT INTO `city` VALUES (‘862‘, ‘97‘, ‘上林县‘, ‘3‘);
INSERT INTO `city` VALUES (‘863‘, ‘97‘, ‘宾阳县‘, ‘3‘);
INSERT INTO `city` VALUES (‘864‘, ‘97‘, ‘横县‘, ‘3‘);
INSERT INTO `city` VALUES (‘865‘, ‘98‘, ‘秀峰区‘, ‘3‘);
INSERT INTO `city` VALUES (‘866‘, ‘98‘, ‘叠彩区‘, ‘3‘);
INSERT INTO `city` VALUES (‘867‘, ‘98‘, ‘象山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘868‘, ‘98‘, ‘七星区‘, ‘3‘);
INSERT INTO `city` VALUES (‘869‘, ‘98‘, ‘雁山区‘, ‘3‘);
INSERT INTO `city` VALUES (‘870‘, ‘98‘, ‘阳朔县‘, ‘3‘);
INSERT INTO `city` VALUES (‘871‘, ‘98‘, ‘临桂县‘, ‘3‘);
INSERT INTO `city` VALUES (‘872‘, ‘98‘, ‘灵川县‘, ‘3‘);
INSERT INTO `city` VALUES (‘873‘, ‘98‘, ‘全州县‘, ‘3‘);
INSERT INTO `city` VALUES (‘874‘, ‘98‘, ‘平乐县‘, ‘3‘);
INSERT INTO `city` VALUES (‘875‘, ‘98‘, ‘兴安县‘, ‘3‘);
INSERT INTO `city` VALUES (‘876‘, ‘98‘, ‘灌阳县‘, ‘3‘);
INSERT INTO `city` VALUES (‘877‘, ‘98‘, ‘荔浦县‘, ‘3‘);
INSERT INTO `city` VALUES (‘878‘, ‘98‘, ‘资源县‘, ‘3‘);
INSERT INTO `city` VALUES (‘879‘, ‘98‘, ‘永福县‘, ‘3‘);
INSERT INTO `city` VALUES (‘880‘, ‘98‘, ‘龙胜‘, ‘3‘);
INSERT INTO `city` VALUES (‘881‘, ‘98‘, ‘恭城‘, ‘3‘);
INSERT INTO `city` VALUES (‘882‘, ‘99‘, ‘右江区‘, ‘3‘);
INSERT INTO `city` VALUES (‘883‘, ‘99‘, ‘凌云县‘, ‘3‘);
INSERT INTO `city` VALUES (‘884‘, ‘99‘, ‘平果县‘, ‘3‘);
INSERT INTO `city` VALUES (‘885‘, ‘99‘, ‘西林县‘, ‘3‘);
INSERT INTO `city` VALUES (‘886‘, ‘99‘, ‘乐业县‘, ‘3‘);
INSERT INTO `city                    

人气教程排行