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