全国各地市编码 for mysql

/*
MySQL Data Transfer
Source Host: localhost
Source Database: platform
Target Host: localhost
Target Database: platform
Date: 2011-9-29 15:20:13
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_province
-- ----------------------------
CREATE TABLE `t_province` (
  `proID` char(2) NOT NULL,
  `name` varchar(16) NOT NULL,
  PRIMARY KEY (`proID`),
  UNIQUE KEY `index_province` (`proID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `t_province` VALUES ('01', '北京市');
INSERT INTO `t_province` VALUES ('02', '天津市');
INSERT INTO `t_province` VALUES ('03', '上海市');
INSERT INTO `t_province` VALUES ('04', '重庆市');
INSERT INTO `t_province` VALUES ('05', '河北省');
INSERT INTO `t_province` VALUES ('06', '山西省');
INSERT INTO `t_province` VALUES ('07', '台湾省');
INSERT INTO `t_province` VALUES ('08', '辽宁省');
INSERT INTO `t_province` VALUES ('09', '吉林省');
INSERT INTO `t_province` VALUES ('10', '黑龙江省');
INSERT INTO `t_province` VALUES ('11', '江苏省');
INSERT INTO `t_province` VALUES ('12', '浙江省');
INSERT INTO `t_province` VALUES ('13', '安徽省');
INSERT INTO `t_province` VALUES ('14', '福建省');
INSERT INTO `t_province` VALUES ('15', '江西省');
INSERT INTO `t_province` VALUES ('16', '山东省');
INSERT INTO `t_province` VALUES ('17', '河南省');
INSERT INTO `t_province` VALUES ('18', '湖北省');
INSERT INTO `t_province` VALUES ('19', '湖南省');
INSERT INTO `t_province` VALUES ('20', '广东省');
INSERT INTO `t_province` VALUES ('21', '甘肃省');
INSERT INTO `t_province` VALUES ('22', '四川省');
INSERT INTO `t_province` VALUES ('23', '贵州省');
INSERT INTO `t_province` VALUES ('24', '海南省');
INSERT INTO `t_province` VALUES ('25', '云南省');
INSERT INTO `t_province` VALUES ('26', '青海省');
INSERT INTO `t_province` VALUES ('27', '陕西省');
INSERT INTO `t_province` VALUES ('28', '广西壮族自治区');
INSERT INTO `t_province` VALUES ('29', '西藏自治区');
INSERT INTO `t_province` VALUES ('30', '宁夏回族自治区');
INSERT INTO `t_province` VALUES ('31', '新疆维吾尔自治区');
INSERT INTO `t_province` VALUES ('32', '内蒙古自治区');
INSERT INTO `t_province` VALUES ('33', '澳门特别行政区');
INSERT INTO `t_province` VALUES ('34', '香港特别行政区');
-------------------------------------------------------------------
/*
MySQL Data Transfer
Source Host: localhost
Source Database: platform
Target Host: localhost
Target Database: platform
Date: 2011-9-29 15:20:20
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_city
-- ----------------------------
CREATE TABLE `t_city` (
  `cityID` char(5) NOT NULL,
  `name` varchar(22) NOT NULL,
  `proID` char(2) NOT NULL,
  PRIMARY KEY (`cityID`),
  UNIQUE KEY `index_city` (`cityID`),
  KEY `proID` (`proID`),
  CONSTRAINT `t_city_ibfk_1` FOREIGN KEY (`proID`) REFERENCES `t_province` (`proID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `t_city` VALUES ('01001', '北京市', '01');
INSERT INTO `t_city` VALUES ('02001', '天津市', '02');
INSERT INTO `t_city` VALUES ('03001', '上海市', '03');
INSERT INTO `t_city` VALUES ('04001', '重庆市', '04');
INSERT INTO `t_city` VALUES ('05001', '石家庄市', '05');
INSERT INTO `t_city` VALUES ('05002', '唐山市', '05');
INSERT INTO `t_city` VALUES ('05003', '秦皇岛市', '05');
INSERT INTO `t_city` VALUES ('05004', '邯郸市', '05');
INSERT INTO `t_city` VALUES ('05005', '邢台市', '05');
INSERT INTO `t_city` VALUES ('05006', '保定市', '05');
INSERT INTO `t_city` VALUES ('05007', '张家口市', '05');
INSERT INTO `t_city` VALUES ('05008', '承德市', '05');
INSERT INTO `t_city` VALUES ('05009', '沧州市', '05');
INSERT INTO `t_city` VALUES ('05010', '廊坊市', '05');
INSERT INTO `t_city` VALUES ('05011', '衡水市', '05');
INSERT INTO `t_city` VALUES ('06001', '太原市', '06');
INSERT INTO `t_city` VALUES ('06002', '大同市', '06');
INSERT INTO `t_city` VALUES ('06003', '阳泉市', '06');
INSERT INTO `t_city` VALUES ('06004', '长治市', '06');
INSERT INTO `t_city` VALUES ('06005', '晋城市', '06');
INSERT INTO `t_city` VALUES ('06006', '朔州市', '06');
INSERT INTO `t_city` VALUES ('06007', '晋中市', '06');
INSERT INTO `t_city` VALUES ('06008', '运城市', '06');
INSERT INTO `t_city` VALUES ('06009', '忻州市', '06');
INSERT INTO `t_city` VALUES ('06010', '临汾市', '06');
INSERT INTO `t_city` VALUES ('06011', '吕梁市', '06');
INSERT INTO `t_city` VALUES ('07001', '台北市', '07');
INSERT INTO `t_city` VALUES ('07002', '高雄市', '07');
INSERT INTO `t_city` VALUES ('07003', '基隆市', '07');
INSERT INTO `t_city` VALUES ('07004', '台中市', '07');
INSERT INTO `t_city` VALUES ('07005', '台南市', '07');
INSERT INTO `t_city` VALUES ('07006', '新竹市', '07');
INSERT INTO `t_city` VALUES ('07007', '嘉义市', '07');
INSERT INTO `t_city` VALUES ('07008', '台北县', '07');
INSERT INTO `t_city` VALUES ('07009', '宜兰县', '07');
INSERT INTO `t_city` VALUES ('07010', '桃园县', '07');
INSERT INTO `t_city` VALUES ('07011', '新竹县', '07');
INSERT INTO `t_city` VALUES ('07012', '苗栗县', '07');
INSERT INTO `t_city` VALUES ('07013', '台中县', '07');
INSERT INTO `t_city` VALUES ('07014', '彰化县', '07');
INSERT INTO `t_city` VALUES ('07015', '南投县', '07');
INSERT INTO `t_city` VALUES ('07016', '云林县', '07');
INSERT INTO `t_city` VALUES ('07017', '嘉义县', '07');
INSERT INTO `t_city` VALUES ('07018', '台南县', '07');
INSERT INTO `t_city` VALUES ('07019', '高雄县', '07');
INSERT INTO `t_city` VALUES ('07020', '屏东县', '07');
INSERT INTO `t_city` VALUES ('07021', '澎湖县', '07');
INSERT INTO `t_city` VALUES ('07022', '台东县', '07');
INSERT INTO `t_city` VALUES ('07023', '花莲县', '07');
INSERT INTO `t_city` VALUES ('08001', '沈阳市', '08');
INSERT INTO `t_city` VALUES ('08002', '大连市', '08');
INSERT INTO `t_city` VALUES ('08003', '鞍山市', '08');
INSERT INTO `t_city` VALUES ('08004', '抚顺市', '08');
INSERT INTO `t_city` VALUES ('08005', '本溪市', '08');
INSERT INTO `t_city` VALUES ('08006', '丹东市', '08');
INSERT INTO `t_city` VALUES ('08007', '锦州市', '08');
INSERT INTO `t_city` VALUES ('08008', '营口市', '08');
INSERT INTO `t_city` VALUES ('08009', '阜新市', '08');
INSERT INTO `t_city` VALUES ('08010', '辽阳市', '08');
INSERT INTO `t_city` VALUES ('08011', '盘锦市', '08');
INSERT INTO `t_city` VALUES ('08012', '铁岭市', '08');
INSERT INTO `t_city` VALUES ('08013', '朝阳市', '08');
INSERT INTO `t_city` VALUES ('08014', '葫芦岛市', '08');
INSERT INTO `t_city` VALUES ('09001', '长春市', '09');
INSERT INTO `t_city` VALUES ('09002', '吉林市', '09');
INSERT INTO `t_city` VALUES ('09003', '四平市', '09');
INSERT INTO `t_city` VALUES ('09004', '辽源市', '09');
INSERT INTO `t_city` VALUES ('09005', '通化市', '09');
INSERT INTO `t_city` VALUES ('09006', '白山市', '09');
INSERT INTO `t_city` VALUES ('09007', '松原市', '09');
INSERT INTO `t_city` VALUES ('09008', '白城市', '09');
INSERT INTO `t_city` VALUES ('09009', '延边朝鲜族自治州', '09');
INSERT INTO `t_city` VALUES ('10001', '哈尔滨市', '10');
INSERT INTO `t_city` VALUES ('10002', '齐齐哈尔市', '10');
INSERT INTO `t_city` VALUES ('10003', '鹤 岗 市', '10');
INSERT INTO `t_city` VALUES ('10004', '双鸭山市', '10');
INSERT INTO `t_city` VALUES ('10005', '鸡 西 市', '10');
INSERT INTO `t_city` VALUES ('10006', '大 庆 市', '10');
INSERT INTO `t_city` VALUES ('10007', '伊 春 市', '10');
INSERT INTO `t_city` VALUES ('10008', '牡丹江市', '10');
INSERT INTO `t_city` VALUES ('10009', '佳木斯市', '10');
INSERT INTO `t_city` VALUES ('10010', '七台河市', '10');
INSERT INTO `t_city` VALUES ('10011', '黑 河 市', '10');
INSERT INTO `t_city` VALUES ('10012', '绥 化 市', '10');
INSERT INTO `t_city` VALUES ('10013', '大兴安岭地区', '10');
INSERT INTO `t_city` VALUES ('11001', '南京市', '11');
INSERT INTO `t_city` VALUES ('11002', '无锡市', '11');
INSERT INTO `t_city` VALUES ('11003', '徐州市', '11');
INSERT INTO `t_city` VALUES ('11004', '常州市', '11');
INSERT INTO `t_city` VALUES ('11005', '苏州市', '11');
INSERT INTO `t_city` VALUES ('11006', '南通市', '11');
INSERT INTO `t_city` VALUES ('11007', '连云港市', '11');
INSERT INTO `t_city` VALUES ('11008', '淮安市', '11');
INSERT INTO `t_city` VALUES ('11009', '盐城市', '11');
INSERT INTO `t_city` VALUES ('11010', '扬州市', '11');
INSERT INTO `t_city` VALUES ('11011', '镇江市', '11');
INSERT INTO `t_city` VALUES ('11012', '泰州市', '11');
INSERT INTO `t_city` VALUES ('11013', '宿迁市', '11');
INSERT INTO `t_city` VALUES ('12001', '杭州市', '12');
INSERT INTO `t_city` VALUES ('12002', '宁波市', '12');
INSERT INTO `t_city` VALUES ('12003', '温州市', '12');
INSERT INTO `t_city` VALUES ('12004', '嘉兴市', '12');
INSERT INTO `t_city` VALUES ('12005', '湖州市', '12');
INSERT INTO `t_city` VALUES ('12006', '绍兴市', '12');
INSERT INTO `t_city` VALUES ('12007', '金华市', '12');
INSERT INTO `t_city` VALUES ('12008', '衢州市', '12');
INSERT INTO `t_city` VALUES ('12009', '舟山市', '12');
INSERT INTO `t_city` VALUES ('12010', '台州市', '12');
INSERT INTO `t_city` VALUES ('12011', '丽水市', '12');
INSERT INTO `t_city` VALUES ('13001', '合肥市', '13');
INSERT INTO `t_city` VALUES ('13002', '芜湖市', '13');
INSERT INTO `t_city` VALUES ('13003', '蚌埠市', '13');
INSERT INTO `t_city` VALUES ('13004', '淮南市', '13');
INSERT INTO `t_city` VALUES ('13005', '马鞍山市', '13');
INSERT INTO `t_city` VALUES ('13006', '淮北市', '13');
INSERT INTO `t_city` VALUES ('13007', '铜陵市', '13');
INSERT INTO `t_city` VALUES ('13008', '安庆市', '13');
INSERT INTO `t_city` VALUES ('13009', '黄山市', '13');
INSERT INTO `t_city` VALUES ('13010', '滁州市', '13');
INSERT INTO `t_city` VALUES ('13011', '阜阳市', '13');
INSERT INTO `t_city` VALUES ('13012', '宿州市', '13');
INSERT INTO `t_city` VALUES ('13013', '巢湖市', '13');
INSERT INTO `t_city` VALUES ('13014', '六安市', '13');
INSERT INTO `t_city` VALUES ('13015', '亳州市', '13');
INSERT INTO `t_city` VALUES ('13016', '池州市', '13');
INSERT INTO `t_city` VALUES ('13017', '宣t_city', '13');
INSERT INTO `t_city` VALUES ('14001', '福州市', '14');
INSERT INTO `t_city` VALUES ('14002', '厦门市', '14');
INSERT INTO `t_city` VALUES ('14003', '莆田市', '14');
INSERT INTO `t_city` VALUES ('14004', '三明市', '14');
INSERT INTO `t_city` VALUES ('14005', '泉州市', '14');
INSERT INTO `t_city` VALUES ('14006', '漳州市', '14');
INSERT INTO `t_city` VALUES ('14007', '南平市', '14');
INSERT INTO `t_city` VALUES ('14008', '龙岩市', '14');
INSERT INTO `t_city` VALUES ('14009', '宁德市', '14');
INSERT INTO `t_city` VALUES ('15001', '南昌市', '15');
INSERT INTO `t_city` VALUES ('15002', '景德镇市', '15');
INSERT INTO `t_city` VALUES ('15003', '萍乡市', '15');
INSERT INTO `t_city` VALUES ('15004', '九江市', '15');
INSERT INTO `t_city` VALUES ('15005', '新余市', '15');
INSERT INTO `t_city` VALUES ('15006', '鹰潭市', '15');
INSERT INTO `t_city` VALUES ('15007', '赣州市', '15');
INSERT INTO `t_city` VALUES ('15008', '吉安市', '15');
INSERT INTO `t_city` VALUES ('15009', '宜春市', '15');
INSERT INTO `t_city` VALUES ('15010', '抚州市', '15');
INSERT INTO `t_city` VALUES ('15011', '上饶市', '15');
INSERT INTO `t_city` VALUES ('16001', '济南市', '16');
INSERT INTO `t_city` VALUES ('16002', '青岛市', '16');
INSERT INTO `t_city` VALUES ('16003', '淄博市', '16');
INSERT INTO `t_city` VALUES ('16004', '枣庄市', '16');
INSERT INTO `t_city` VALUES ('16005', '东营市', '16');
INSERT INTO `t_city` VALUES ('16006', '烟台市', '16');
INSERT INTO `t_city` VALUES ('16007', '潍坊市', '16');
INSERT INTO `t_city` VALUES ('16008', '济宁市', '16');
INSERT INTO `t_city` VALUES ('16009', '泰安市', '16');
INSERT INTO `t_city` VALUES ('16010', '威海市', '16');
INSERT INTO `t_city` VALUES ('16011', '日照市', '16');
INSERT INTO `t_city` VALUES ('16012', '莱芜市', '16');
INSERT INTO `t_city` VALUES ('16013', '临沂市', '16');
INSERT INTO `t_city` VALUES ('16014', '德州市', '16');
INSERT INTO `t_city` VALUES ('16015', '聊城市', '16');
INSERT INTO `t_city` VALUES ('16016', '滨州市', '16');
INSERT INTO `t_city` VALUES ('16017', '菏泽市', '16');
INSERT INTO `t_city` VALUES ('17001', '郑州市', '17');
INSERT INTO `t_city` VALUES ('17002', '开封市', '17');
INSERT INTO `t_city` VALUES ('17003', '洛阳市', '17');
INSERT INTO `t_city` VALUES ('17004', '平顶山市', '17');
INSERT INTO `t_city` VALUES ('17005', '安阳市', '17');
INSERT INTO `t_city` VALUES ('17006', '鹤壁市', '17');
INSERT INTO `t_city` VALUES ('17007', '新乡市', '17');
INSERT INTO `t_city` VALUES ('17008', '焦作市', '17');
INSERT INTO `t_city` VALUES ('17009', '濮阳市', '17');
INSERT INTO `t_city` VALUES ('17010', '许昌市', '17');
INSERT INTO `t_city` VALUES ('17011', '漯河市', '17');
INSERT INTO `t_city` VALUES ('17012', '三门峡市', '17');
INSERT INTO `t_city` VALUES ('17013', '南阳市', '17');
INSERT INTO `t_city` VALUES ('17014', '商丘市', '17');
INSERT INTO `t_city` VALUES ('17015', '信阳市', '17');
INSERT INTO `t_city` VALUES ('17016', '周口市', '17');
INSERT INTO `t_city` VALUES ('17017', '驻马店市', '17');
INSERT INTO `t_city` VALUES ('17018', '济源市', '17');
INSERT INTO `t_city` VALUES ('18001', '武汉市', '18');
INSERT INTO `t_city` VALUES ('18002', '黄石市', '18');
INSERT INTO `t_city` VALUES ('18003', '十堰市', '18');
INSERT INTO `t_city` VALUES ('18004', '荆州市', '18');
INSERT INTO `t_city` VALUES ('18005', '宜昌市', '18');
INSERT INTO `t_city` VALUES ('18006', '襄樊市', '18');
INSERT INTO `t_city` VALUES ('18007', '鄂州市', '18');
INSERT INTO `t_city` VALUES ('18008', '荆门市', '18');
INSERT INTO `t_city` VALUES ('18009', '孝感市', '18');
INSERT INTO `t_city` VALUES ('18010', '黄冈市', '18');
INSERT INTO `t_city` VALUES ('18011', '咸宁市', '18');
INSERT INTO `t_city` VALUES ('18012', '随州市', '18');
INSERT INTO `t_city` VALUES ('18013', '仙桃市', '18');
INSERT INTO `t_city` VALUES ('18014', '天门市', '18');
INSERT INTO `t_city` VALUES ('18015', '潜江市', '18');
INSERT INTO `t_city` VALUES ('18016', '神农架林区', '18');
INSERT INTO `t_city` VALUES ('18017', '恩施土家族苗族自治州', '18');
INSERT INTO `t_city` VALUES ('19001', '长沙市', '19');
INSERT INTO `t_city` VALUES ('19002', '株洲市', '19');
INSERT INTO `t_city` VALUES ('19003', '湘潭市', '19');
INSERT INTO `t_city` VALUES ('19004', '衡阳市', '19');
INSERT INTO `t_city` VALUES ('19005', '邵阳市', '19');
INSERT INTO `t_city` VALUES ('19006', '岳阳市', '19');
INSERT INTO `t_city` VALUES ('19007', '常德市', '19');
INSERT INTO `t_city` VALUES ('19008', '张家界市', '19');
INSERT INTO `t_city` VALUES ('19009', '益阳市', '19');
INSERT INTO `t_city` VALUES ('19010', '郴州市', '19');
INSERT INTO `t_city` VALUES ('19011', '永州市', '19');
INSERT INTO `t_city` VALUES ('19012', '怀化市', '19');
INSERT INTO `t_city` VALUES ('19013', '娄底市', '19');
INSERT INTO `t_city` VALUES ('19014', '湘西土家族苗族自治州', '19');
INSERT INTO `t_city` VALUES ('20001', '广州市', '20');
INSERT INTO `t_city` VALUES ('20002', '深圳市', '20');
INSERT INTO `t_city` VALUES ('20003', '珠海市', '20');
INSERT INTO `t_city` VALUES ('20004', '汕头市', '20');
INSERT INTO `t_city` VALUES ('20005', '韶关市', '20');
INSERT INTO `t_city` VALUES ('20006', '佛山市', '20');
INSERT INTO `t_city` VALUES ('20007', '江门市', '20');
INSERT INTO `t_city` VALUES ('20008', '湛江市', '20');
INSERT INTO `t_city` VALUES ('20009', '茂名市', '20');
INSERT INTO `t_city` VALUES ('20010', '肇庆市', '20');
INSERT INTO `t_city` VALUES ('20011', '惠州市', '20');
INSERT INTO `t_city` VALUES ('20012', '梅州市', '20');
INSERT INTO `t_city` VALUES ('20013', '汕尾市', '20');
INSERT INTO `t_city` VALUES ('20014', '河源市', '20');
INSERT INTO `t_city` VALUES ('20015', '阳江市', '20');
INSERT INTO `t_city` VALUES ('20016', '清远市', '20');
INSERT INTO `t_city` VALUES ('20017', '东莞市', '20');
INSERT INTO `t_city` VALUES ('20018', '中山市', '20');
INSERT INTO `t_city` VALUES ('20019', '潮州市', '20');
INSERT INTO `t_city` VALUES ('20020', '揭阳市', '20');
INSERT INTO `t_city` VALUES ('20021', '云浮市', '20');
INSERT INTO `t_city` VALUES ('21001', '兰州市', '21');
INSERT INTO `t_city` VALUES ('21002', '金昌市', '21');
INSERT INTO `t_city` VALUES ('21003', '白银市', '21');
INSERT INTO `t_city` VALUES ('21004', '天水市', '21');
INSERT INTO `t_city` VALUES ('21005', '嘉峪关市', '21');
INSERT INTO `t_city` VALUES ('21006', '武威市', '21');
INSERT INTO `t_city` VALUES ('21007', '张掖市', '21');
INSERT INTO `t_city` VALUES ('21008', '平凉市', '21');
INSERT INTO `t_city` VALUES ('21009', '酒泉市', '21');
INSERT INTO `t_city` VALUES ('21010', '庆阳市', '21');
INSERT INTO `t_city` VALUES ('21011', '定西市', '21');
INSERT INTO `t_city` VALUES ('21012', '陇南市', '21');
INSERT INTO `t_city` VALUES ('21013', '临夏回族自治州', '21');
INSERT INTO `t_city` VALUES ('21014', '甘南藏族自治州', '21');
INSERT INTO `t_city` VALUES ('22001', '成都市', '22');
INSERT INTO `t_city` VALUES ('22002', '自贡市', '22');
INSERT INTO `t_city` VALUES ('22003', '攀枝花市', '22');
INSERT INTO `t_city` VALUES ('22004', '泸州市', '22');
INSERT INTO `t_city` VALUES ('22005', '德阳市', '22');
INSERT INTO `t_city` VALUES ('22006', '绵阳市', '22');
INSERT INTO `t_city` VALUES ('22007', '广元市', '22');
INSERT INTO `t_city` VALUES ('22008', '遂宁市', '22');
INSERT INTO `t_city` VALUES ('22009', '内江市', '22');
INSERT INTO `t_city` VALUES ('22010', '乐山市', '22');
INSERT INTO `t_city` VALUES ('22011', '南充市', '22');
INSERT INTO `t_city` VALUES ('22012', '眉山市', '22');
INSERT INTO `t_city` VALUES ('22013', '宜宾市', '22');
INSERT INTO `t_city` VALUES ('22014', '广安市', '22');
INSERT INTO `t_city` VALUES ('22015', '达州市', '22');
INSERT INTO `t_city` VALUES ('22016', '雅安市', '22');
INSERT INTO `t_city` VALUES ('22017', '巴中市', '22');
INSERT INTO `t_city` VALUES ('22018', '资阳市', '22');
INSERT INTO `t_city` VALUES ('22019', '阿坝藏族羌族自治州', '22');
INSERT INTO `t_city` VALUES ('22020', '甘孜藏族自治州', '22');
INSERT INTO `t_city` VALUES ('22021', '凉山彝族自治州', '22');
INSERT INTO `t_city` VALUES ('23001', '贵阳市', '23');
INSERT INTO `t_city` VALUES ('23002', '六盘水市', '23');
INSERT INTO `t_city` VALUES ('23003', '遵义市', '23');
INSERT INTO `t_city` VALUES ('23004', '安顺市', '23');
INSERT INTO `t_city` VALUES ('23005', '铜仁地区', '23');
INSERT INTO `t_city` VALUES ('23006', '毕节地区', '23');
INSERT INTO `t_city` VALUES ('23007', '黔西南布依族苗族自治州', '23');
INSERT INTO `t_city` VALUES ('23008', '黔东南苗族侗族自治州', '23');
INSERT INTO `t_city` VALUES ('23009', '黔南布依族苗族自治州', '23');
INSERT INTO `t_city` VALUES ('24001', '海口市', '24');
INSERT INTO `t_city` VALUES ('24002', '三亚市', '24');
INSERT INTO `t_city` VALUES ('24003', '五指山市', '24');
INSERT INTO `t_city` VALUES ('24004', '琼海市', '24');
INSERT INTO `t_city` VALUES ('24005', '儋州市', '24');
INSERT INTO `t_city` VALUES ('24006', '文昌市', '24');
INSERT INTO `t_city` VALUES ('24007', '万宁市', '24');
INSERT INTO `t_city` VALUES ('24008', '东方市', '24');
INSERT INTO `t_city` VALUES ('24009', '澄迈县', '24');
INSERT INTO `t_city` VALUES ('24010', '定安县', '24');
INSERT INTO `t_city` VALUES ('24011', '屯昌县', '24');
INSERT INTO `t_city` VALUES ('24012', '临高县', '24');
INSERT INTO `t_city` VALUES ('24013', '白沙黎族自治县', '24');
INSERT INTO `t_city` VALUES ('24014', '昌江黎族自治县', '24');
INSERT INTO `t_city` VALUES ('24015', '乐东黎族自治县', '24');
INSERT INTO `t_city` VALUES ('24016', '陵水黎族自治县', '24');
INSERT INTO `t_city` VALUES ('24017', '保亭黎族苗族自治县', '24');
INSERT INTO `t_city` VALUES ('24018', '琼中黎族苗族自治县', '24');
INSERT INTO `t_city` VALUES ('25001', '昆明市', '25');
INSERT INTO `t_city` VALUES ('25002', '曲靖市', '25');
INSERT INTO `t_city` VALUES ('25003', '玉溪市', '25');
INSERT INTO `t_city` VALUES ('25004', '保山市', '25');
INSERT INTO `t_city` VALUES ('25005', '昭通市', '25');
INSERT INTO `t_city` VALUES ('25006', '丽江市', '25');
INSERT INTO `t_city` VALUES ('25007', '思茅市', '25');
INSERT INTO `t_city` VALUES ('25008', '临沧市', '25');
INSERT INTO `t_city` VALUES ('25009', '文山壮族苗族自治州', '25');
INSERT INTO `t_city` VALUES ('25010', '红河哈尼族彝族自治州', '25');
INSERT INTO `t_city` VALUES ('25011', '西双版纳傣族自治州', '25');
INSERT INTO `t_city` VALUES ('25012', '楚雄彝族自治州', '25');
INSERT INTO `t_city` VALUES ('25013', '大理白族自治州', '25');
INSERT INTO `t_city` VALUES ('25014', '德宏傣族景颇族自治州', '25');
INSERT INTO `t_city` VALUES ('25015', '怒江傈傈族自治州', '25');
INSERT INTO `t_city` VALUES ('25016', '迪庆藏族自治州', '25');
INSERT INTO `t_city` VALUES ('26001', '西宁市', '26');
INSERT INTO `t_city` VALUES ('26002', '海东地区', '26');
INSERT INTO `t_city` VALUES ('26003', '海北藏族自治州', '26');
INSERT INTO `t_city` VALUES ('26004', '黄南藏族自治州', '26');
INSERT INTO `t_city` VALUES ('26005', '海南藏族自治州', '26');
INSERT INTO `t_city` VALUES ('26006', '果洛藏族自治州', '26');
INSERT INTO `t_city` VALUES ('26007', '玉树藏族自治州', '26');
INSERT INTO `t_city` VALUES ('26008', '海西蒙古族藏族自治州', '26');
INSERT INTO `t_city` VALUES ('27001', '西安市', '27');
INSERT INTO `t_city` VALUES ('27002', '铜川市', '27');
INSERT INTO `t_city` VALUES ('27003', '宝鸡市', '27');
INSERT INTO `t_city` VALUES ('27004', '咸阳市', '27');
INSERT INTO `t_city` VALUES ('27005', '渭南市', '27');
INSERT INTO `t_city` VALUES ('27006', '延安市', '27');
INSERT INTO `t_city` VALUES ('27007', '汉中市', '27');
INSERT INTO `t_city` VALUES ('27008', '榆林市', '27');
INSERT INTO `t_city` VALUES ('27009', '安康市', '27');
INSERT INTO `t_city` VALUES ('27010', '商洛市', '27');
INSERT INTO `t_city` VALUES ('28001', '南宁市', '28');
INSERT INTO `t_city` VALUES ('28002', '柳州市', '28');
INSERT INTO `t_city` VALUES ('28003', '桂林市', '28');
INSERT INTO `t_city` VALUES ('28004', '梧州市', '28');
INSERT INTO `t_city` VALUES ('28005', '北海市', '28');
INSERT INTO `t_city` VALUES ('28006', '防城港市', '28');
INSERT INTO `t_city` VALUES ('28007', '钦州市', '28');
INSERT INTO `t_city` VALUES ('28008', '贵港市', '28');
INSERT INTO `t_city` VALUES ('28009', '玉林市', '28');
INSERT INTO `t_city` VALUES ('28010', '百色市', '28');
INSERT INTO `t_city` VALUES ('28011', '贺州市', '28');
INSERT INTO `t_city` VALUES ('28012', '河池市', '28');
INSERT INTO `t_city` VALUES ('28013', '来宾市', '28');
INSERT INTO `t_city` VALUES ('28014', '崇左市', '28');
INSERT INTO `t_city` VALUES ('29001', '拉萨市', '29');
INSERT INTO `t_city` VALUES ('29002', '那曲地区', '29');
INSERT INTO `t_city` VALUES ('29003', '昌都地区', '29');
INSERT INTO `t_city` VALUES ('29004', '山南地区', '29');
INSERT INTO `t_city` VALUES ('29005', '日喀则地区', '29');
INSERT INTO `t_city` VALUES ('29006', '阿里地区', '29');
INSERT INTO `t_city` VALUES ('29007', '林芝地区', '29');
INSERT INTO `t_city` VALUES ('30001', '银川市', '30');
INSERT INTO `t_city` VALUES ('30002', '石嘴山市', '30');
INSERT INTO `t_city` VALUES ('30003', '吴忠市', '30');
INSERT INTO `t_city` VALUES ('30004', '固原市', '30');
INSERT INTO `t_city` VALUES ('30005', '中卫市', '30');
INSERT INTO `t_city` VALUES ('31001', '乌鲁木齐市', '31');
INSERT INTO `t_city` VALUES ('31002', '克拉玛依市', '31');
INSERT INTO `t_city` VALUES ('31003', '石河子市　', '31');
INSERT INTO `t_city` VALUES ('31004', '阿拉尔市', '31');
INSERT INTO `t_city` VALUES ('31005', '图木舒克市', '31');
INSERT INTO `t_city` VALUES ('31006', '五家渠市', '31');
INSERT INTO `t_city` VALUES ('31007', '吐鲁番市', '31');
INSERT INTO `t_city` VALUES ('31008', '阿克苏市', '31');
INSERT INTO `t_city` VALUES ('31009', '喀什市', '31');
INSERT INTO `t_city` VALUES ('31010', '哈密市', '31');
INSERT INTO `t_city` VALUES ('31011', '和田市', '31');
INSERT INTO `t_city` VALUES ('31012', '阿图什市', '31');
INSERT INTO `t_city` VALUES ('31013', '库尔勒市', '31');
INSERT INTO `t_city` VALUES ('31014', '昌吉市　', '31');
INSERT INTO `t_city` VALUES ('31015', '阜康市', '31');
INSERT INTO `t_city` VALUES ('31016', '米泉市', '31');
INSERT INTO `t_city` VALUES ('31017', '博乐市', '31');
INSERT INTO `t_city` VALUES ('31018', '伊宁市', '31');
INSERT INTO `t_city` VALUES ('31019', '奎屯市', '31');
INSERT INTO `t_city` VALUES ('31020', '塔t_city', '31');
INSERT INTO `t_city` VALUES ('31021', '乌苏市', '31');
INSERT INTO `t_city` VALUES ('31022', '阿勒泰市', '31');
INSERT INTO `t_city` VALUES ('32001', '呼和浩特市', '32');
INSERT INTO `t_city` VALUES ('32002', '包头市', '32');
INSERT INTO `t_city` VALUES ('32003', '乌海市', '32');
INSERT INTO `t_city` VALUES ('32004', '赤峰市', '32');
INSERT INTO `t_city` VALUES ('32005', '通辽市', '32');
INSERT INTO `t_city` VALUES ('32006', '鄂尔多斯市', '32');
INSERT INTO `t_city` VALUES ('32007', '呼伦贝尔市', '32');
INSERT INTO `t_city` VALUES ('32008', '巴彦淖尔市', '32');
INSERT INTO `t_city` VALUES ('32009', '乌兰察布市', '32');
INSERT INTO `t_city` VALUES ('32010', '锡林郭勒盟', '32');
INSERT INTO `t_city` VALUES ('32011', '兴安盟', '32');
INSERT INTO `t_city` VALUES ('32012', '阿拉善盟', '32');
INSERT INTO `t_city` VALUES ('33001', '澳门特别行政区', '33');
INSERT INTO `t_city` VALUES ('34001', '香港特别行政区', '34');