全国省份信息

发布时间：2016-01-19 15:36:35编辑：丝画阁阅读（244）

INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('1', '北京');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('2', '上海');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('3', '天津');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('4', '重庆');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('5', '广东');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('6', '浙江');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('7', '江苏');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('8', '山东');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('9', '四川');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('10', '湖北');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('11', '湖南');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('12', '河北');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('13', '河南');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('14', '安徽');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('15', '福建');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('16', '江西');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('17', '山西');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('18', '辽宁');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('19', '吉林');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('20', '黑龙江');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('21', '广西');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('22', '海南');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('23', '贵州');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('24', '云南');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('25', '陕西');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('26', '甘肃');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('27', '内蒙古');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('28', '宁夏');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('29', '新疆');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('30', '青海');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('31', '西藏');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('32', '香港');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('33', '澳门');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('34', '台湾');
INSERT INTO yzj_areaprovince (provinceid, provincename) VALUES ('35', '外国');






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