mysql -省市区（市）

下载

https://download.csdn.net/download/fm15136/85028672

市

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for city
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
  `city_code` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '市编码',
  `city_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '市名',
  `province_code` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省编码',
  PRIMARY KEY (`city_code`),
  KEY `idx_provinceCode` (`province_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='市';

-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO `city` VALUES ('110100', '北京市', '110000');
INSERT INTO `city` VALUES ('130100', '石家庄市', '130000');
INSERT INTO `city` VALUES ('130200', '唐山市', '130000');
INSERT INTO `city` VALUES ('130300', '秦皇岛市', '130000');
INSERT INTO `city` VALUES ('130400', '邯郸市', '130000');
INSERT INTO `city` VALUES ('130500', '邢台市', '130000');
INSERT INTO `city` VALUES ('130600', '保定市', '130000');
INSERT INTO `city` VALUES ('130700', '张家口市', '130000');
INSERT INTO `city` VALUES ('130800', '承德市', '130000');
INSERT INTO `city` VALUES ('130900', '沧州市', '130000');
INSERT INTO `city` VALUES ('131000', '廊坊市', '130000');
INSERT INTO `city` VALUES ('131100', '衡水市', '130000');
INSERT INTO `city` VALUES ('140100', '太原市', '140000');
INSERT INTO `city` VALUES ('140200', '大同市', '140000');
INSERT INTO `city` VALUES ('140300', '阳泉市', '140000');
INSERT INTO `city` VALUES ('140400', '长治市', '140000');
INSERT INTO `city` VALUES ('140500', '晋城市', '140000');
INSERT INTO `city` VALUES ('140600', '朔州市', '140000');
INSERT INTO `city` VALUES ('140700', '晋中市', '140000');
INSERT INTO `city` VALUES ('140800', '运城市', '140000');
INSERT INTO `city` VALUES ('140900', '忻州市', '140000');
INSERT INTO `city` VALUES ('141000', '临汾市', '140000');
INSERT INTO `city` VALUES ('141100', '吕梁市', '140000');
INSERT INTO `city` VALUES ('150100', '呼和浩特市', '150000');
INSERT INTO `city` VALUES ('150200', '包头市', '150000');
INSERT INTO `city` VALUES ('150300', '乌海市', '150000');
INSERT INTO `city` VALUES ('150400', '赤峰市', '150000');
INSERT INTO `city` VALUES ('150500', '通辽市', '150000');
INSERT INTO `city` VALUES ('150600', '鄂尔多斯市', '150000');
INSERT INTO `city` VALUES ('150700', '呼伦贝尔市', '150000');
INSERT INTO `city` VALUES ('150800', '巴彦淖尔市', '150000');
INSERT INTO `city` VALUES ('150900', '乌兰察布市', '150000');
INSERT INTO `city` VALUES ('152200', '兴安盟', '150000');
INSERT INTO `city` VALUES ('152500', '锡林郭勒盟', '150000');
INSERT INTO `city` VALUES ('152900', '阿拉善盟', '150000');
INSERT INTO `city` VALUES ('210100', '沈阳市', '210000');
INSERT INTO `city` VALUES ('210200', '大连市', '210000');
INSERT INTO `city` VALUES ('210300', '鞍山市', '210000');
INSERT INTO `city` VALUES ('210400', '抚顺市', '210000');
INSERT INTO `city` VALUES ('210500', '本溪市', '210000');
INSERT INTO `city` VALUES ('210600', '丹东市', '210000');
INSERT INTO `city` VALUES ('210700', '锦州市', '210000');
INSERT INTO `city` VALUES ('210800', '营口市', '210000');
INSERT INTO `city` VALUES ('210900', '阜新市', '210000');
INSERT INTO `city` VALUES ('211000', '辽阳市', '210000');
INSERT INTO `city` VALUES ('211100', '盘锦市', '210000');
INSERT INTO `city` VALUES ('211200', '铁岭市', '210000');
INSERT INTO `city` VALUES ('211300', '朝阳市', '210000');
INSERT INTO `city` VALUES ('211400', '葫芦岛市', '210000');
INSERT INTO `city` VALUES ('220100', '长春市', '220000');
INSERT INTO `city` VALUES ('220200', '吉林市', '220000');
INSERT INTO `city` VALUES ('220300', '四平市', '220000');
INSERT INTO `city` VALUES ('220400', '辽源市', '220000');
INSERT INTO `city` VALUES ('220500', '通化市', '220000');
INSERT INTO `city` VALUES ('220600', '白山市', '220000');
INSERT INTO `city` VALUES ('220700', '松原市', '220000');
INSERT INTO `city` VALUES ('220800', '白城市', '220000');
INSERT INTO `city` VALUES ('222400', '延边朝鲜族自治州', '220000');
INSERT INTO `city` VALUES ('230100', '哈尔滨市', '230000');
INSERT INTO `city` VALUES ('230200', '齐齐哈尔市', '230000');
INSERT INTO `city` VALUES ('230300', '鸡西市', '230000');
INSERT INTO `city` VALUES ('230400', '鹤岗市', '230000');
INSERT INTO `city` VALUES ('230500', '双鸭山市', '230000');
INSERT INTO `city` VALUES ('230600', '大庆市', '230000');
INSERT INTO `city` VALUES ('230700', '伊春市', '230000');
INSERT INTO `city` VALUES ('230800', '佳木斯市', '230000');
INSERT INTO `city` VALUES ('230900', '七台河市', '230000');
INSERT INTO `city` VALUES ('231000', '牡丹江市', '230000');
INSERT INTO `city` VALUES ('231100', '黑河市', '230000');
INSERT INTO `city` VALUES ('231200', '绥化市', '230000');
INSERT INTO `city` VALUES ('232700', '大兴安岭地区', '230000');
INSERT INTO `city` VALUES ('310100', '上海市市辖区', '310000');
INSERT INTO `city` VALUES ('310200', '县', '310000');
INSERT INTO `city` VALUES ('320100', '南京市', '320000');
INSERT INTO `city` VALUES ('320200', '无锡市', '320000');
INSERT INTO `city` VALUES ('320300', '徐州市', '320000');
INSERT INTO `city` VALUES ('320400', '常州市', '320000');
INSERT INTO `city` VALUES ('320500', '苏州市', '320000');
INSERT INTO `city` VALUES ('320600', '南通市', '320000');
INSERT INTO `city` VALUES ('320700', '连云港市', '320000');
INSERT INTO `city` VALUES ('320800', '淮安市', '320000');
INSERT INTO `city` VALUES ('320900', '盐城市', '320000');
INSERT INTO `city` VALUES ('321000', '扬州市', '320000');
INSERT INTO `city` VALUES ('321100', '镇江市', '320000');
INSERT INTO `city` VALUES ('321200', '泰州市', '320000');
INSERT INTO `city` VALUES ('321300', '宿迁市', '320000');
INSERT INTO `city` VALUES ('330100', '杭州市', '330000');
INSERT INTO `city` VALUES ('330200', '宁波市', '330000');
INSERT INTO `city` VALUES ('330300', '温州市', '330000');
INSERT INTO `city` VALUES ('330400', '嘉兴市', '330000');
INSERT INTO `city` VALUES ('330500', '湖州市', '330000');
INSERT INTO `city` VALUES ('330600', '绍兴市', '330000');
INSERT INTO `city` VALUES ('330700', '金华市', '330000');
INSERT INTO `city` VALUES ('330800', '衢州市', '330000');
INSERT INTO `city` VALUES ('330900', '舟山市', '330000');
INSERT INTO `city` VALUES ('331000', '台州市', '330000');
INSERT INTO `city` VALUES ('331100', '丽水市', '330000');
INSERT INTO `city` VALUES ('340100', '合肥市', '340000');
INSERT INTO `city` VALUES ('340200', '芜湖市', '340000');
INSERT INTO `city` VALUES ('340300', '蚌埠市', '340000');
INSERT INTO `city` VALUES ('340400', '淮南市', '340000');
INSERT INTO `city` VALUES ('340500', '马鞍山市', '340000');
INSERT INTO `city` VALUES ('340600', '淮北市', '340000');
INSERT INTO `city` VALUES ('340700', '铜陵市', '340000');
INSERT INTO `city` VALUES ('340800', '安庆市', '340000');
INSERT INTO `city` VALUES ('341000', '黄山市', '340000');
INSERT INTO `city` VALUES ('341100', '滁州市', '340000');
INSERT INTO `city` VALUES ('341200', '阜阳市', '340000');
INSERT INTO `city` VALUES ('341300', '宿州市', '340000');
INSERT INTO `city` VALUES ('341400', '巢湖市', '340000');
INSERT INTO `city` VALUES ('341500', '六安市', '340000');
INSERT INTO `city` VALUES ('341600', '亳州市', '340000');
INSERT INTO `city` VALUES ('341700', '池州市', '340000');
INSERT INTO `city` VALUES ('341800', '宣城市', '340000');
INSERT INTO `city` VALUES ('350100', '福州市', '350000');
INSERT INTO `city` VALUES ('350200', '厦门市', '350000');
INSERT INTO `city` VALUES ('350300', '莆田市', '350000');
INSERT INTO `city` VALUES ('350400', '三明市', '350000');
INSERT INTO `city` VALUES ('350500', '泉州市', '350000');
INSERT INTO `city` VALUES ('350600', '漳州市', '350000');
INSERT INTO `city` VALUES ('350700', '南平市', '350000');
INSERT INTO `city` VALUES ('350800', '龙岩市', '350000');
INSERT INTO `city` VALUES ('350900', '宁德市', '350000');
INSERT INTO `city` VALUES ('360100', '南昌市', '360000');
INSERT INTO `city` VALUES ('360200', '景德镇市', '360000');
INSERT INTO `city` VALUES ('360300', '萍乡市', '360000');
INSERT INTO `city` VALUES ('360400', '九江市', '360000');
INSERT INTO `city` VALUES ('360500', '新余市', '360000');
INSERT INTO `city` VALUES ('360600', '鹰潭市', '360000');
INSERT INTO `city` VALUES ('360700', '赣州市', '360000');
INSERT INTO `city` VALUES ('360800', '吉安市', '360000');
INSERT INTO `city` VALUES ('360900', '宜春市', '360000');
INSERT INTO `city` VALUES ('361000', '抚州市', '360000');
INSERT INTO `city` VALUES ('361100', '上饶市', '360000');
INSERT INTO `city` VALUES ('370100', '济南市', '370000');
INSERT INTO `city` VALUES ('370200', '青岛市', '370000');
INSERT INTO `city` VALUES ('370300', '淄博市', '370000');
INSERT INTO `city` VALUES ('370400', '枣庄市', '370000');
INSERT INTO `city` VALUES ('370500', '东营市', '370000');
INSERT INTO `city` VALUES ('370600', '烟台市', '370000');
INSERT INTO `city` VALUES ('370700', '潍坊市', '370000');
INSERT INTO `city` VALUES ('370800', '济宁市', '370000');
INSERT INTO `city` VALUES ('370900', '泰安市', '370000');
INSERT INTO `city` VALUES ('371000', '威海市', '370000');
INSERT INTO `city` VALUES ('371100', '日照市', '370000');
INSERT INTO `city` VALUES ('371200', '莱芜市', '370000');
INSERT INTO `city` VALUES ('371300', '临沂市', '370000');
INSERT INTO `city` VALUES ('371400', '德州市', '370000');
INSERT INTO `city` VALUES ('371500', '聊城市', '370000');
INSERT INTO `city` VALUES ('371600', '滨州市', '370000');
INSERT INTO `city` VALUES ('371700', '荷泽市', '370000');
INSERT INTO `city` VALUES ('410100', '郑州市', '410000');
INSERT INTO `city` VALUES ('410200', '开封市', '410000');
INSERT INTO `city` VALUES ('410300', '洛阳市', '410000');
INSERT INTO `city` VALUES ('410400', '平顶山市', '410000');
INSERT INTO `city` VALUES ('410500', '安阳市', '410000');
INSERT INTO `city` VALUES ('410600', '鹤壁市', '410000');
INSERT INTO `city` VALUES ('410700', '新乡市', '410000');
INSERT INTO `city` VALUES ('410800', '焦作市', '410000');
INSERT INTO `city` VALUES ('410900', '濮阳市', '410000');
INSERT INTO `city` VALUES ('411000', '许昌市', '410000');
INSERT INTO `city` VALUES ('411100', '漯河市', '410000');
INSERT INTO `city` VALUES ('411200', '三门峡市', '410000');
INSERT INTO `city` VALUES ('411300', '南阳市', '410000');
INSERT INTO `city` VALUES ('411400', '商丘市', '410000');
INSERT INTO `city` VALUES ('411500', '信阳市', '410000');
INSERT INTO `city` VALUES ('411600', '周口市', '410000');
INSERT INTO `city` VALUES ('411700', '驻马店市', '410000');
INSERT INTO `city` VALUES ('420100', '武汉市', '420000');
INSERT INTO `city` VALUES ('420200', '黄石市', '420000');
INSERT INTO `city` VALUES ('420300', '十堰市', '420000');
INSERT INTO `city` VALUES ('420500', '宜昌市', '420000');
INSERT INTO `city` VALUES ('420600', '襄樊市', '420000');
INSERT INTO `city` VALUES ('420700', '鄂州市', '420000');
INSERT INTO `city` VALUES ('420800', '荆门市', '420000');
INSERT INTO `city` VALUES ('420900', '孝感市', '420000');
INSERT INTO `city` VALUES ('421000', '荆州市', '420000');
INSERT INTO `city` VALUES ('421100', '黄冈市', '420000');
INSERT INTO `city` VALUES ('421200', '咸宁市', '420000');
INSERT INTO `city` VALUES ('421300', '随州市', '420000');
INSERT INTO `city` VALUES ('422800', '恩施土家族苗族自治州', '420000');
INSERT INTO `city` VALUES ('429000', '省直辖行政单位', '420000');
INSERT INTO `city` VALUES ('430100', '长沙市', '430000');
INSERT INTO `city` VALUES ('430200', '株洲市', '430000');
INSERT INTO `city` VALUES ('430300', '湘潭市', '430000');
INSERT INTO `city` VALUES ('430400', '衡阳市', '430000');
INSERT INTO `city` VALUES ('430500', '邵阳市', '430000');
INSERT INTO `city` VALUES ('430600', '岳阳市', '430000');
INSERT INTO `city` VALUES ('430700', '常德市', '430000');
INSERT INTO `city` VALUES ('430800', '张家界市', '430000');
INSERT INTO `city` VALUES ('430900', '益阳市', '430000');
INSERT INTO `city` VALUES ('431000', '郴州市', '430000');
INSERT INTO `city` VALUES ('431100', '永州市', '430000');
INSERT INTO `city` VALUES ('431200', '怀化市', '430000');
INSERT INTO `city` VALUES ('431300', '娄底市', '430000');
INSERT INTO `city` VALUES ('433100', '湘西土家族苗族自治州', '430000');
INSERT INTO `city` VALUES ('440100', '广州市', '440000');
INSERT INTO `city` VALUES ('440200', '韶关市', '440000');
INSERT INTO `city` VALUES ('440300', '深圳市', '440000');
INSERT INTO `city` VALUES ('440400', '珠海市', '440000');
INSERT INTO `city` VALUES ('440500', '汕头市', '440000');
INSERT INTO `city` VALUES ('440600', '佛山市', '440000');
INSERT INTO `city` VALUES ('440700', '江门市', '440000');
INSERT INTO `city` VALUES ('440800', '湛江市', '440000');
INSERT INTO `city` VALUES ('440900', '茂名市', '440000');
INSERT INTO `city` VALUES ('441200', '肇庆市', '440000');
INSERT INTO `city` VALUES ('441300', '惠州市', '440000');
INSERT INTO `city` VALUES ('441400', '梅州市', '440000');
INSERT INTO `city` VALUES ('441500', '汕尾市', '440000');
INSERT INTO `city` VALUES ('441600', '河源市', '440000');
INSERT INTO `city` VALUES ('441700', '阳江市', '440000');
INSERT INTO `city` VALUES ('441800', '清远市', '440000');
INSERT INTO `city` VALUES ('441900', '东莞市', '440000');
INSERT INTO `city` VALUES ('442000', '中山市', '440000');
INSERT INTO `city` VALUES ('445100', '潮州市', '440000');
INSERT INTO `city` VALUES ('445200', '揭阳市', '440000');
INSERT INTO `city` VALUES ('445300', '云浮市', '440000');
INSERT INTO `city` VALUES ('450100', '南宁市', '450000');
INSERT INTO `city` VALUES ('450200', '柳州市', '450000');
INSERT INTO `city` VALUES ('450300', '桂林市', '450000');
INSERT INTO `city` VALUES ('450400', '梧州市', '450000');
INSERT INTO `city` VALUES ('450500', '北海市', '450000');
INSERT INTO `city` VALUES ('450600', '防城港市', '450000');
INSERT INTO `city` VALUES ('450700', '钦州市', '450000');
INSERT INTO `city` VALUES ('450800', '贵港市', '450000');
INSERT INTO `city` VALUES ('450900', '玉林市', '450000');
INSERT INTO `city` VALUES ('451000', '百色市', '450000');
INSERT INTO `city` VALUES ('451100', '贺州市', '450000');
INSERT INTO `city` VALUES ('451200', '河池市', '450000');
INSERT INTO `city` VALUES ('451300', '来宾市', '450000');
INSERT INTO `city` VALUES ('451400', '崇左市', '450000');
INSERT INTO `city` VALUES ('460100', '海口市', '460000');
INSERT INTO `city` VALUES ('460200', '三亚市', '460000');
INSERT INTO `city` VALUES ('469000', '省直辖县级行政单位', '460000');
INSERT INTO `city` VALUES ('500100', '市辖区', '500000');
INSERT INTO `city` VALUES ('500200', '县', '500000');
INSERT INTO `city` VALUES ('500300', '市', '500000');
INSERT INTO `city` VALUES ('510100', '成都市', '510000');
INSERT INTO `city` VALUES ('510300', '自贡市', '510000');
INSERT INTO `city` VALUES ('510400', '攀枝花市', '510000');
INSERT INTO `city` VALUES ('510500', '泸州市', '510000');
INSERT INTO `city` VALUES ('510600', '德阳市', '510000');
INSERT INTO `city` VALUES ('510700', '绵阳市', '510000');
INSERT INTO `city` VALUES ('510800', '广元市', '510000');
INSERT INTO `city` VALUES ('510900', '遂宁市', '510000');
INSERT INTO `city` VALUES ('511000', '内江市', '510000');
INSERT INTO `city` VALUES ('511100', '乐山市', '510000');
INSERT INTO `city` VALUES ('511300', '南充市', '510000');
INSERT INTO `city` VALUES ('511400', '眉山市', '510000');
INSERT INTO `city` VALUES ('511500', '宜宾市', '510000');
INSERT INTO `city` VALUES ('511600', '广安市', '510000');
INSERT INTO `city` VALUES ('511700', '达州市', '510000');
INSERT INTO `city` VALUES ('511800', '雅安市', '510000');
INSERT INTO `city` VALUES ('511900', '巴中市', '510000');
INSERT INTO `city` VALUES ('512000', '资阳市', '510000');
INSERT INTO `city` VALUES ('513200', '阿坝藏族羌族自治州', '510000');
INSERT INTO `city` VALUES ('513300', '甘孜藏族自治州', '510000');
INSERT INTO `city` VALUES ('513400', '凉山彝族自治州', '510000');
INSERT INTO `city` VALUES ('520100', '贵阳市', '520000');
INSERT INTO `city` VALUES ('520200', '六盘水市', '520000');
INSERT INTO `city` VALUES ('520300', '遵义市', '520000');
INSERT INTO `city` VALUES ('520400', '安顺市', '520000');
INSERT INTO `city` VALUES ('522200', '铜仁地区', '520000');
INSERT INTO `city` VALUES ('522300', '黔西南布依族苗族自治州', '520000');
INSERT INTO `city` VALUES ('522400', '毕节地区', '520000');
INSERT INTO `city` VALUES ('522600', '黔东南苗族侗族自治州', '520000');
INSERT INTO `city` VALUES ('522700', '黔南布依族苗族自治州', '520000');
INSERT INTO `city` VALUES ('530100', '昆明市', '530000');
INSERT INTO `city` VALUES ('530300', '曲靖市', '530000');
INSERT INTO `city` VALUES ('530400', '玉溪市', '530000');
INSERT INTO `city` VALUES ('530500', '保山市', '530000');
INSERT INTO `city` VALUES ('530600', '昭通市', '530000');
INSERT INTO `city` VALUES ('530700', '丽江市', '530000');
INSERT INTO `city` VALUES ('530800', '思茅市', '530000');
INSERT INTO `city` VALUES ('530900', '临沧市', '530000');
INSERT INTO `city` VALUES ('532300', '楚雄彝族自治州', '530000');
INSERT INTO `city` VALUES ('532500', '红河哈尼族彝族自治州', '530000');
INSERT INTO `city` VALUES ('532600', '文山壮族苗族自治州', '530000');
INSERT INTO `city` VALUES ('532800', '西双版纳傣族自治州', '530000');
INSERT INTO `city` VALUES ('532900', '大理白族自治州', '530000');
INSERT INTO `city` VALUES ('533100', '德宏傣族景颇族自治州', '530000');
INSERT INTO `city` VALUES ('533300', '怒江傈僳族自治州', '530000');
INSERT INTO `city` VALUES ('533400', '迪庆藏族自治州', '530000');
INSERT INTO `city` VALUES ('540100', '拉萨市', '540000');
INSERT INTO `city` VALUES ('542100', '昌都地区', '540000');
INSERT INTO `city` VALUES ('542200', '山南地区', '540000');
INSERT INTO `city` VALUES ('542300', '日喀则地区', '540000');
INSERT INTO `city` VALUES ('542400', '那曲地区', '540000');
INSERT INTO `city` VALUES ('542500', '阿里地区', '540000');
INSERT INTO `city` VALUES ('542600', '林芝地区', '540000');
INSERT INTO `city` VALUES ('610100', '西安市', '610000');
INSERT INTO `city` VALUES ('610200', '铜川市', '610000');
INSERT INTO `city` VALUES ('610300', '宝鸡市', '610000');
INSERT INTO `city` VALUES ('610400', '咸阳市', '610000');
INSERT INTO `city` VALUES ('610500', '渭南市', '610000');
INSERT INTO `city` VALUES ('610600', '延安市', '610000');
INSERT INTO `city` VALUES ('610700', '汉中市', '610000');
INSERT INTO `city` VALUES ('610800', '榆林市', '610000');
INSERT INTO `city` VALUES ('610900', '安康市', '610000');
INSERT INTO `city` VALUES ('611000', '商洛市', '610000');
INSERT INTO `city` VALUES ('620100', '兰州市', '620000');
INSERT INTO `city` VALUES ('620200', '嘉峪关市', '620000');
INSERT INTO `city` VALUES ('620300', '金昌市', '620000');
INSERT INTO `city` VALUES ('620400', '白银市', '620000');
INSERT INTO `city` VALUES ('620500', '天水市', '620000');
INSERT INTO `city` VALUES ('620600', '武威市', '620000');
INSERT INTO `city` VALUES ('620700', '张掖市', '620000');
INSERT INTO `city` VALUES ('620800', '平凉市', '620000');
INSERT INTO `city` VALUES ('620900', '酒泉市', '620000');
INSERT INTO `city` VALUES ('621000', '庆阳市', '620000');
INSERT INTO `city` VALUES ('621100', '定西市', '620000');
INSERT INTO `city` VALUES ('621200', '陇南市', '620000');
INSERT INTO `city` VALUES ('622900', '临夏回族自治州', '620000');
INSERT INTO `city` VALUES ('623000', '甘南藏族自治州', '620000');
INSERT INTO `city` VALUES ('630100', '西宁市', '630000');
INSERT INTO `city` VALUES ('632100', '海东地区', '630000');
INSERT INTO `city` VALUES ('632200', '海北藏族自治州', '630000');
INSERT INTO `city` VALUES ('632300', '黄南藏族自治州', '630000');
INSERT INTO `city` VALUES ('632500', '海南藏族自治州', '630000');
INSERT INTO `city` VALUES ('632600', '果洛藏族自治州', '630000');
INSERT INTO `city` VALUES ('632700', '玉树藏族自治州', '630000');
INSERT INTO `city` VALUES ('632800', '海西蒙古族藏族自治州', '630000');
INSERT INTO `city` VALUES ('640100', '银川市', '640000');
INSERT INTO `city` VALUES ('640200', '石嘴山市', '640000');
INSERT INTO `city` VALUES ('640300', '吴忠市', '640000');
INSERT INTO `city` VALUES ('640400', '固原市', '640000');
INSERT INTO `city` VALUES ('640500', '中卫市', '640000');
INSERT INTO `city` VALUES ('650100', '乌鲁木齐市', '650000');
INSERT INTO `city` VALUES ('650200', '克拉玛依市', '650000');
INSERT INTO `city` VALUES ('652100', '吐鲁番地区', '650000');
INSERT INTO `city` VALUES ('652200', '哈密地区', '650000');
INSERT INTO `city` VALUES ('652300', '昌吉回族自治州', '650000');
INSERT INTO `city` VALUES ('652700', '博尔塔拉蒙古自治州', '650000');
INSERT INTO `city` VALUES ('652800', '巴音郭楞蒙古自治州', '650000');
INSERT INTO `city` VALUES ('652900', '阿克苏地区', '650000');
INSERT INTO `city` VALUES ('653000', '克孜勒苏柯尔克孜自治州', '650000');
INSERT INTO `city` VALUES ('653100', '喀什地区', '650000');
INSERT INTO `city` VALUES ('653200', '和田地区', '650000');
INSERT INTO `city` VALUES ('654000', '伊犁哈萨克自治州', '650000');
INSERT INTO `city` VALUES ('654200', '塔城地区', '650000');
INSERT INTO `city` VALUES ('654300', '阿勒泰地区', '650000');
INSERT INTO `city` VALUES ('659000', '省直辖行政单位', '650000');
INSERT INTO `city` VALUES ('999996', '澳门', '820000');
INSERT INTO `city` VALUES ('999997', '香港', '810000');
INSERT INTO `city` VALUES ('999998', '台湾', '710000');
INSERT INTO `city` VALUES ('999999', '天津市', '120000');
SET FOREIGN_KEY_CHECKS=1;