省市区 Mysql 数据库表（一）

1.查省

SELECT * FROM china WHERE china.Pid=0

2.查市

SELECT * FROM chinaWHERE china.Pid=330000

3.查区

SELECT * FROM china WHERE china.Pid = 330100

4.Mysql脚本

CREATE TABLE `china` ( `Id` int(11) NOT NULL, `Name` varchar(40) default NULL, `Pid` int(11) default NULL, PRIMARY KEY (`Id`), KEY `FK_CHINA_REFERENCE_CHINA` (`Pid`), CONSTRAINT `FK_CHINA_REFERENCE_CHINA` FOREIGN KEY (`Pid`) REFERENCES `china` (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of china -- ---------------------------- INSERT INTO `china` VALUES ('0', '中国', '0'); INSERT INTO `china` VALUES ('110000', '北京市', '0'); INSERT INTO `china` VALUES ('110100', '东城区', '110000'); INSERT INTO `china` VALUES ('110200', '西城区', '110000'); INSERT INTO `china` VALUES ('110500', '朝阳区', '110000'); INSERT INTO `china` VALUES ('110600', '丰台区', '110000'); INSERT INTO `china` VALUES ('110700', '石景山区', '110000'); INSERT INTO `china` VALUES ('110800', '海淀区', '110000'); INSERT INTO `china` VALUES ('110900', '门头沟区', '110000'); INSERT INTO `china` VALUES ('111100', '房山区', '110000'); INSERT INTO `china` VALUES ('111200', '通州区', '110000'); INSERT INTO `china` VALUES ('111300', '顺义区', '110000'); INSERT INTO `china` VALUES ('111400', '昌平区', '110000'); INSERT INTO `china` VALUES ('111500', '大兴区', '110000'); INSERT INTO `china` VALUES ('111600', '怀柔区', '110000'); INSERT INTO `china` VALUES ('111700', '平谷区', '110000'); INSERT INTO `china` VALUES ('112800', '密云县', '110000'); INSERT INTO `china` VALUES ('112900', '延庆县', '110000'); INSERT INTO `china` VALUES ('120000', '天津市', '0'); INSERT INTO `china` VALUES ('10', '和平区', '120000'); INSERT INTO `china` VALUES ('10', '河东区', '120000'); INSERT INTO `china` VALUES ('120300', '河西区', '120000'); INSERT INTO `china` VALUES ('120400', '南开区', '120000'); INSERT INTO `china` VALUES ('120500', '河北区', '120000'); INSERT INTO `china` VALUES ('120600', '红桥区', '120000'); INSERT INTO `china` VALUES ('120900', '滨海新区', '120000'); INSERT INTO `china` VALUES ('121000', '东丽区', '120000'); INSERT INTO `china` VALUES ('121100', '西青区', '120000'); INSERT INTO `china` VALUES ('121200', '津南区', '120000'); INSERT INTO `china` VALUES ('121300', '北辰区', '120000'); INSERT INTO `china` VALUES ('121400', '武清区', '120000'); INSERT INTO `china` VALUES ('121500', '宝坻区', '120000'); INSERT INTO `china` VALUES ('122100', '宁河县', '120000'); INSERT INTO `china` VALUES ('122300', '静海县', '120000'); INSERT INTO `china` VALUES ('122500', '蓟县', '120000'); INSERT INTO `china` VALUES ('130000', '河北省', '0'); INSERT INTO `china` VALUES ('130100', '石家庄市', '130000'); INSERT INTO `china` VALUES ('130101', '市辖区', '130100'); INSERT INTO `china` VALUES ('130102', '长安区', '130101'); INSERT INTO `china` VALUES ('130103', '桥东区', '130101'); INSERT INTO `china` VALUES ('130104', '桥西区', '130101'); INSERT INTO `china` VALUES ('130105', '新华区', '130101'); INSERT INTO `china` VALUES ('130107', '井陉矿区', '130101'); INSERT INTO `china` VALUES ('130108', '裕华区', '130101'); INSERT INTO `china` VALUES ('130121', '井陉县', '130100'); INSERT INTO `china` VALUES ('130123', '正定县', '130100'); INSERT INTO `china` VALUES ('130124', '栾城县', '130100'); INSERT INTO `china` VALUES ('130125', '行唐县', '130100'); INSERT INTO `china` VALUES ('130126', '灵寿县', '130100'); INSERT INTO `china` VALUES ('130127', '高邑县', '130100'); INSERT INTO `china` VALUES ('130128', '深泽县', '130100'); INSERT INTO `china` VALUES ('130129', '赞皇县', '130100'); INSERT INTO `china` VALUES ('130130', '无极县', '130100'); INSERT INTO `china` VALUES ('130131', '平山县', '130100'); INSERT INTO `china` VALUES ('130132', '元氏县', '130100'); INSERT INTO `china` VALUES ('130133', '赵县', '130100'); INSERT INTO `china` VALUES ('130181', '辛集市', '130100'); INSERT INTO `china` VALUES ('130182', '藁城市', '130100'); INSERT INTO `china` VALUES ('130183', '晋州市', '130100'); INSERT INTO `china` VALUES ('130184', '新乐市', '130100'); INSERT INTO `china` VALUES ('130185', '鹿泉市', '130100'); INSERT INTO `china` VALUES ('130200', '唐山市', '130000'); INSERT INTO `china` VALUES ('130201', '市辖区', '130200'); INSERT INTO `china` VALUES ('130202', '路南区', '130201'); INSERT INTO `china` VALUES ('130203', '路北区', '130201'); INSERT INTO `china` VALUES ('130204', '古冶区', '130201'); INSERT INTO `china` VALUES ('130205', '开平区', '130201'); INSERT INTO `china` VALUES ('130207', '丰南区', '130201'); INSERT INTO `china` VALUES ('130208', '丰润区', '130201'); INSERT INTO `china` VALUES ('130223', '滦县', '130200'); INSERT INTO `china` VALUES ('130224', '滦南县', '130200'); INSERT INTO `china` VALUES ('130225', '乐亭县', '130200'); INSERT INTO `china` VALUES ('130227', '迁西县', '130200'); INSERT INTO `china` VALUES ('130229', '玉田县', '130200'); INSERT INTO `china` VALUES ('130230', '唐海县', '130200'); INSERT INTO `china` VALUES ('130281', '遵化市', '130200'); INSERT INTO `china` VALUES ('130283', '迁安市', '130200'); INSERT INTO `china` VALUES ('130300', '秦皇岛市', '130000'); INSERT INTO `china` VALUES ('130301', '海港区', '130300'); INSERT INTO `china` VALUES ('130303', '山海关区', '130300'); INSERT INTO `china` VALUES ('130304', '北戴河区', '130300'); INSERT INTO `china` VALUES ('130321', '青龙满族自治县', '130300'); INSERT INTO `china` VALUES ('130322', '昌黎县', '130300'); INSERT INTO `china` VALUES ('130323', '抚宁县', '130300'); INSERT INTO `china` VALUES ('130324', '卢龙县', '130300'); INSERT INTO `china` VALUES ('130400', '邯郸市', '130000'); INSERT INTO `china` VALUES ('130401', '市辖区', '130400'); INSERT INTO `china` VALUES ('130402', '邯山区', '130401'); INSERT INTO `china` VALUES ('130403', '丛台区', '130401'); INSERT INTO `china` VALUES ('130404', '复兴区', '130401'); INSERT INTO `china` VALUES ('130406', '峰峰矿区', '130401'); INSERT INTO `china` VALUES ('130421', '邯郸县', '130400'); INSERT INTO `china` VALUES ('130423', '临漳县', '130400'); INSERT INTO `china` VALUES ('130424', '成安县', '130400'); INSERT INTO `china` VALUES ('130425', '大名县', '130400'); INSERT INTO `china` VALUES ('130426', '涉县', '130400'); INSERT INTO `china` VALUES ('130427', '磁县', '130400'); INSERT INTO `china` VALUES ('130428', '肥乡县', '130400'); INSERT INTO `china` VALUES ('130429', '永年县', '130400'); INSERT INTO `china` VALUES ('130430', '邱县', '130400'); INSERT INTO `china` VALUES ('130431', '鸡泽县', '130400'); INSERT INTO `china` VALUES ('130432', '广平县', '130400'); INSERT INTO `china` VALUES ('130433', '馆陶县', '130400'); INSERT INTO `china` VALUES ('130434', '魏县', '130400'); INSERT INTO `china` VALUES ('130435', '曲周县', '130400'); INSERT INTO `china` VALUES ('130481', '武安市', '130400'); INSERT INTO `china` VALUES ('130500', '邢台市', '130000'); INSERT INTO `china` VALUES ('130501', '市辖区', '130500'); INSERT INTO `china` VALUES ('130502', '桥东区', '130501'); INSERT INTO `china` VALUES ('130503', '桥西区', '130501'); INSERT INTO `china` VALUES ('130521', '邢台县', '130500'); INSERT INTO `china` VALUES ('130522', '临城县', '130500'); INSERT INTO `china` VALUES ('130523', '内丘县', '130500'); INSERT INTO `china` VALUES ('130524', '柏乡县', '130500'); INSERT INTO `china` VALUES ('130525', '隆尧县', '130500'); INSERT INTO `china` VALUES ('130526', '任县', '130500'); INSERT INTO `china` VALUES ('130527', '南和县', '130500'); INSERT INTO `china` VALUES ('130528', '宁晋县', '130500'); INSERT INTO `china` VALUES ('130529', '巨鹿县', '130529'); INSERT INTO `china` VALUES ('130530', '新河县', '130500'); INSERT INTO `china` VALUES ('130531', '广宗县', '130500'); INSERT INTO `china` VALUES ('130532', '平乡县', '130500'); INSERT INTO `china` VALUES ('130533', '威县', '130500'); INSERT INTO `china` VALUES ('130534', '清河县', '130500'); INSERT INTO `china` VALUES ('130535', '临西县', '130500'); INSERT INTO `china` VALUES ('130581', '南宫市', '130500'); INSERT INTO `china` VALUES ('130582', '沙河市', '130500'); INSERT INTO `china` VALUES ('130600', '保定市', '130000'); INSERT INTO `china` VALUES ('130601', '新市区', '130600'); INSERT INTO `china` VALUES ('130603', '北市区', '130600'); INSERT INTO `china` VALUES ('130604', '南市区', '130600'); INSERT INTO `china` VALUES ('130621', '满城县', '130600'); INSERT INTO `china` VALUES ('130622', '清苑县', '130600'); INSERT INTO `china` VALUES ('130623', '涞水县', '130600'); INSERT INTO `china` VALUES ('130624', '阜平县', '130600'); INSERT INTO `china` VALUES ('130625', '徐水县', '130600'); INSERT INTO `china` VALUES ('130626', '定兴县', '130600'); INSERT INTO `china` VALUES ('130627', '唐县', '130600'); INSERT INTO `china` VALUES ('130628', '高阳县', '130600'); INSERT INTO `china` VALUES ('130629', '容城县', '130600'); INSERT INTO `china` VALUES ('130630', '涞源县', '130600'); INSERT INTO `china` VALUES ('130631', '望都县', '130600'); INSERT INTO `china` VALUES ('130632', '安新县', '130600'); INSERT INTO `china` VALUES ('130633', '易县', '130600'); INSERT INTO `china` VALUES ('130634', '曲阳县', '130600'); INSERT INTO `china` VALUES ('130635', '蠡县', '130600'); INSERT INTO `china` VALUES ('130636', '顺平县', '130600'); INSERT INTO `china` VALUES ('130637', '博野县', '130600'); INSERT INTO `china` VALUES ('130638', '雄县', '130600'); INSERT INTO `china` VALUES ('130681', '涿州市', '130600'); INSERT INTO `china` VALUES ('130682', '定州市', '130600'); INSERT INTO `china` VALUES ('130683', '安国市', '130600'); INSERT INTO `china` VALUES ('130684', '高碑店市', '130600'); INSERT INTO `china` VALUES ('130685', '白沟新城县', '130600'); INSERT INTO `china` VALUES ('130700', '张家口市', '130000'); INSERT INTO `china` VALUES ('130701', '市辖区', '130700'); INSERT INTO `china` VALUES ('130702', '桥东区', '130701'); INSERT INTO `china` VALUES ('130703', '桥西区', '130701'); INSERT INTO `china` VALUES ('130705', '宣化区', '130701'); INSERT INTO `china` VALUES ('130706', '下花园区', '130701'); INSERT INTO `china` VALUES ('130721', '宣化县', '130700'); INSERT INTO `china` VALUES ('130722', '张北县', '130700'); INSERT INTO `china` VALUES ('130723', '康保县', '130700'); INSERT INTO `china` VALUES ('130724', '沽源县', '130700'); INSERT INTO `china` VALUES ('130725', '尚义县', '130700'); INSERT INTO `china` VALUES ('130726', '蔚县', '130700'); INSERT INTO `china` VALUES ('130727', '阳原县', '130700'); INSERT INTO `china` VALUES ('130728', '怀安县', '130700'); INSERT INTO `china` VALUES ('130729', '万全县', '130700'); INSERT INTO `china` VALUES ('130730', '怀来县', '130700'); INSERT INTO `china` VALUES ('130731', '涿鹿县', '130700'); INSERT INTO `china` VALUES ('130732', '赤城县', '130700'); INSERT INTO `china` VALUES ('130733', '崇礼县', '130700'); INSERT INTO `china` VALUES ('130800', '承德市', '130000'); INSERT INTO `china` VALUES ('130801', '市辖区', '130800'); INSERT INTO `china` VALUES ('130802', '双桥区', '130801'); INSERT INTO `china` VALUES ('130803', '双滦区', '130801'); INSERT INTO `china` VALUES ('130804', '鹰手营子矿区', '130801'); INSERT INTO `china` VALUES ('130821', '承德县', '130800'); INSERT INTO `china` VALUES ('130822', '兴隆县', '130800'); INSERT INTO `china` VALUES ('130823', '平泉县', '130800'); INSERT INTO `china` VALUES ('130824', '滦平县', '130800'); INSERT INTO `china` VALUES ('130825', '隆化县', '130800'); INSERT INTO `china` VALUES ('130826', '丰宁满族自治县', '130800'); INSERT INTO `china` VALUES ('130827', '宽城满族自治县', '130800'); INSERT INTO `china` VALUES ('130828', '围场满族蒙古族自治县', '130800'); INSERT INTO `china` VALUES ('130900', '沧州市', '130000'); INSERT INTO `china` VALUES ('130901', '市辖区', '130900'); INSERT INTO `china` VALUES ('130902', '新华区', '130901'); INSERT INTO `china` VALUES ('130903', '运河区', '130901'); INSERT INTO `china` VALUES ('130921', '沧县', '130900'); INSERT INTO `china` VALUES ('130922', '青县', '130900'); INSERT INTO `china` VALUES ('130923', '东光县', '130900'); INSERT INTO `china` VALUES ('130924', '海兴县', '130900'); INSERT INTO `china` VALUES ('130925', '盐山县', '130900'); INSERT INTO `china` VALUES ('130926', '肃宁县', '130900'); INSERT INTO `china` VALUES ('130927', '南皮县', '130900'); INSERT INTO `china` VALUES ('130928', '吴桥县', '130900'); INSERT INTO `china` VALUES ('130929', '献县', '130900'); INSERT INTO `china` VALUES ('130930', '孟村回族自治县', '130900'); INSERT INTO `china` VALUES ('130981', '泊头市', '130900'); INSERT INTO `china` VALUES ('130982', '任丘市', '130900'); INSERT INTO `china` VALUES ('130983', '黄骅市', '130900'); INSERT INTO `china` VALUES ('130984', '河间市', '130900'); INSERT INTO `china` VALUES ('131000', '廊坊市', '130000'); INSERT INTO `china` VALUES ('131001', '市辖区', '131000'); INSERT INTO `china` VALUES ('131002', '安次区', '131001'); INSERT INTO `china` VALUES ('131003', '广阳区', '131001'); INSERT INTO `china` VALUES ('131022', '固安县', '131000'); INSERT INTO `china` VALUES ('131023', '永清县', '131000'); INSERT INTO `china` VALUES ('131024', '香河县', '131000'); INSERT INTO `china` VALUES ('131025', '大城县', '131000'); INSERT INTO `china` VALUES ('131026', '文安县', '131000'); INSERT INTO `china` VALUES ('131028', '大厂回族自治县', '131000'); INSERT INTO `china` VALUES ('131081', '霸州市', '131000'); INSERT INTO `china` VALUES ('131082', '三河市', '131000'); INSERT INTO `china` VALUES ('131100', '衡水市', '130000'); INSERT INTO `china` VALUES ('131101', '市辖区', '131100'); INSERT INTO `china` VALUES ('131102', '桃城区', '131101'); INSERT INTO `china` VALUES ('131121', '枣强县', '131100'); INSERT INTO `china` VALUES ('131122', '武邑县', '131100'); INSERT INTO `china` VALUES ('131123', '武强县', '131100'); INSERT INTO `china` VALUES ('131124', '饶阳县', '131100'); INSERT INTO `china` VALUES ('131125', '安平县', '131100'); INSERT INTO `china` VALUES ('131126', '故城县', '131100'); INSERT INTO `china` VALUES ('131127', '景县', '131100'); INSERT INTO `china` VALUES ('131128', '阜城县', '131100'); INSERT INTO `china` VALUES ('131181', '冀州市', '131100'); INSERT INTO `china` VALUES ('131182', '深州市', '131100'); INSERT INTO `china` VALUES ('140000', '山西省', '0'); INSERT INTO `china` VALUES ('140100', '太原市', '140000'); INSERT INTO `china` VALUES ('140101', '市辖区', '140100'); INSERT INTO `china` VALUES ('140105', '小店区', '140101'); INSERT INTO `china` VALUES ('140106', '迎泽区', '140101'); INSERT INTO `china` VALUES ('140107', '杏花岭区', '140101'); INSERT INTO `china` VALUES ('140108', '尖草坪区', '140101'); INSERT INTO `china` VALUES ('140109', '万柏林区', '140101'); INSERT INTO `china` VALUES ('140110', '晋源区', '140101'); INSERT INTO `china` VALUES ('140121', '清徐县', '140100'); INSERT INTO `china` VALUES ('140122', '阳曲县', '140100'); INSERT INTO `china` VALUES ('140123', '娄烦县', '140100'); INSERT INTO `china` VALUES ('140181', '古交市', '140100'); INSERT INTO `china` VALUES ('140200', '大同市', '140000'); INSERT INTO `china` VALUES ('140201', '市辖区', '140200'); INSERT INTO `china` VALUES ('140202', '城区', '140201'); INSERT INTO `china` VALUES ('140203', '矿区', '140201'); INSERT INTO `china` VALUES ('140211', '南郊区', '140201'); INSERT INTO `china` VALUES ('140212', '新荣区', '140201'); INSERT INTO `china` VALUES ('140221', '阳高县', '140200'); INSERT INTO `china` VALUES ('140222', '天镇县', '140200'); INSERT INTO `china` VALUES ('140223', '广灵县', '140200'); INSERT INTO `china` VALUES ('140224', '灵丘县', '140200'); INSERT INTO `china` VALUES ('140225', '浑源县', '140200'); INSERT INTO `china` VALUES ('140226', '左云县', '140200'); INSERT INTO `china` VALUES ('140227', '大同县', '140200'); INSERT INTO `china` VALUES ('140300', '阳泉市', '140000'); INSERT INTO `china` VALUES ('140301', '市辖区', '140300'); INSERT INTO `china` VALUES ('140302', '城区', '140301'); INSERT INTO `china` VALUES ('140303', '矿区', '140301'); INSERT INTO `china` VALUES ('140311', '郊区', '140301'); INSERT INTO `china` VALUES ('140321', '平定县', '140300'); INSERT INTO `china` VALUES ('140322', '盂县', '140300'); INSERT INTO `china` VALUES ('140400', '长治市', '140000'); INSERT INTO `china` VALUES ('140401', '市辖区', '140400'); INSERT INTO `china` VALUES ('140402', '城区', '140401'); INSERT INTO `china` VALUES ('140411', '郊区', '140401'); INSERT INTO `china` VALUES ('140421', '长治县', '140400'); INSERT INTO `china` VALUES ('140423', '襄垣县', '140400'); INSERT INTO `china` VALUES ('140424', '屯留县', '140400'); INSERT INTO `china` VALUES ('140425', '平顺县', '140400'); INSERT INTO `china` VALUES ('140426', '黎城县', '140400'); INSERT INTO `china` VALUES ('140427', '壶关县', '140400'); INSERT INTO `china` VALUES ('140428', '长子县', '140400'); INSERT INTO `china` VALUES ('140429', '武乡县', '140400'); INSERT INTO `china` VALUES ('140430', '沁县', '140400'); INSERT INTO `china` VALUES ('140431', '沁源县', '140400'); INSERT INTO `china` VALUES ('140481', '潞城市', '140400'); INSERT INTO `china` VALUES ('140500', '晋城市', '140000'); INSERT INTO `china` VALUES ('140501', '市辖区', '140500'); INSERT INTO `china` VALUES ('140502', '城区', '140501'); INSERT INTO `china` VALUES ('140521', '沁水县', '140500'); INSERT INTO `china` VALUES ('140522', '阳城县', '140500'); INSERT INTO `china` VALUES ('140524', '陵川县', '140500'); INSERT INTO `china` VALUES ('140525', '泽州县', '140500'); INSERT INTO `china` VALUES ('140581', '高平市', '140500'); INSERT INTO `china` VALUES ('140600', '朔州市', '140000'); INSERT INTO `china` VALUES ('140601', '市辖区', '140600'); INSERT INTO `china` VALUES ('140602', '朔城区', '140601'); INSERT INTO `china` VALUES ('140603', '平鲁区', '140601'); INSERT INTO `china` VALUES ('140621', '山阴县', '140600'); INSERT INTO `china` VALUES ('140622', '应县', '140600'); INSERT INTO `china` VALUES ('140623', '右玉县', '140600'); INSERT INTO `china` VALUES ('140624', '怀仁县', '140600'); INSERT INTO `china` VALUES ('140700', '晋中市', '140000'); INSERT INTO `china` VALUES ('140701', '市辖区', '140700'); INSERT INTO `china` VALUES ('140702', '榆次区', '140701'); INSERT INTO `china` VALUES ('140721', '榆社县', '140700'); INSERT INTO `china` VALUES ('140722', '左权县', '140700'); INSERT INTO `china` VALUES ('140723', '和顺县', '140700'); INSERT INTO `china` VALUES ('140724', '昔阳县', '140700'); INSERT INTO `china` VALUES ('140725', '寿阳县', '140700'); INSERT INTO `china` VALUES ('140726', '太谷县', '140700'); INSERT INTO `china` VALUES ('140727', '祁县', '140700'); INSERT INTO `china` VALUES ('140728', '平遥县', '140700'); INSERT INTO `china` VALUES ('140729', '灵石县', '140700'); INSERT INTO `china` VALUES ('140781', '介休市', '140700'); INSERT INTO `china` VALUES ('140800', '运城市', '140000'); INSERT INTO `china` VALUES ('140801', '市辖区', '140800'); INSERT INTO `china` VALUES ('140802', '盐湖区', '140801'); INSERT INTO `china` VALUES ('140821', '临猗县', '140800'); INSERT INTO `china` VALUES ('140822', '万荣县', '140800'); INSERT INTO `china` VALUES ('140823', '闻喜县', '140800'); INSERT INTO `china` VALUES ('140824', '稷山县', '140800'); INSERT INTO `china` VALUES ('140825', '新绛县', '140800'); INSERT INTO `china` VALUES ('140826', '绛县', '140800'); INSERT INTO `china` VALUES ('140827', '垣曲县', '140800'); INSERT INTO `china` VALUES ('140828', '夏县', '140800'); INSERT INTO `china` VALUES ('140829', '平陆县', '140800'); INSERT INTO `china` VALUES ('140830', '芮城县', '140800'); INSERT INTO `china` VALUES ('140881', '永济市', '140800'); INSERT INTO `china` VALUES ('140882', '河津市', '140800'); INSERT INTO `china` VALUES ('140900', '忻州市', '140000'); INSERT INTO `china` VALUES ('140901', '忻府区', '140900'); INSERT INTO `china` VALUES ('140921', '定襄县', '140900'); INSERT INTO `china` VALUES ('140922', '五台县', '140900'); INSERT INTO `china` VALUES ('140923', '代县', '140900'); INSERT INTO `china` VALUES ('140924', '繁峙县', '140900'); INSERT INTO `china` VALUES ('140925', '宁武县', '140900'); INSERT INTO `china` VALUES ('140926', '静乐县', '140900'); INSERT INTO `china` VALUES ('140927', '神池县', '140900'); INSERT INTO `china` VALUES ('140928', '五寨县', '140900'); INSERT INTO `china` VALUES ('140929', '岢岚县', '140900'); INSERT INTO `china` VALUES ('140930', '河曲县', '140900'); INSERT INTO `china` VALUES ('140931', '保德县', '140900'); INSERT INTO `china` VALUES ('140932', '偏关县', '140900'); INSERT INTO `china` VALUES ('140981', '原平市', '140900'); INSERT INTO `china` VALUES ('141000', '临汾市', '140000'); INSERT INTO `china` VALUES ('141001', '市辖区', '141000'); INSERT INTO `china` VALUES ('141002', '尧都区', '141000'); INSERT INTO `china` VALUES ('141021', '曲沃县', '141000'); INSERT INTO `china` VALUES ('141022', '翼城县', '141000'); INSERT INTO `china` VALUES ('141023', '襄汾县', '141000'); INSERT INTO `china` VALUES ('141024', '洪洞县', '141000'); INSERT INTO `china` VALUES ('141025', '古县', '141000'); INSERT INTO `china` VALUES ('141026', '安泽县', '141000'); INSERT INTO `china` VALUES ('141027', '浮山县', '141000'); INSERT INTO `china` VALUES ('141028', '吉县', '141000'); INSERT INTO `china` VALUES ('141029', '乡宁县', '141000'); INSERT INTO `china` VALUES ('141030', '大宁县', '141000'); INSERT INTO `china` VALUES ('141031', '隰县', '141000'); INSERT INTO `china` VALUES ('141032', '永和县', '141000'); INSERT INTO `china` VALUES ('141033', '蒲县', '141000'); INSERT INTO `china` VALUES ('141034', '汾西县', '141000'); INSERT INTO `china` VALUES ('141081', '侯马市', '141000'); INSERT INTO `china` VALUES ('141082', '霍州市', '141000'); INSERT INTO `china` VALUES ('141100', '吕梁市', '140000'); INSERT INTO `china` VALUES ('141101', '市辖区', '141100'); INSERT INTO `china` VALUES ('141102', '离石区', '141101'); INSERT INTO `china` VALUES ('141121', '文水县', '141100'); INSERT INTO `china` VALUES ('141122', '交城县', '141100'); INSERT INTO `china` VALUES ('141123', '兴县', '141100'); INSERT INTO `china` VALUES ('141124', '临县', '141100'); INSERT INTO `china` VALUES ('141125', '柳林县', '141100'); INSERT INTO `china` VALUES ('141126', '石楼县', '141100'); INSERT INTO `china` VALUES ('141127', '岚县', '141100'); INSERT INTO `china` VALUES ('141128', '方山县', '141100'); INSERT INTO `china` VALUES ('141129', '中阳县', '141100'); INSERT INTO `china` VALUES ('141130', '交口县', '141100'); INSERT INTO `china` VALUES ('141181', '孝义市', '141100'); INSERT INTO `china` VALUES ('141182', '汾阳市', '141100'); INSERT INTO `china` VALUES ('150000', '内蒙古自治区', '0'); INSERT INTO `china` VALUES ('150100', '呼和浩特市', '150000'); INSERT INTO `china` VALUES ('150101', '市辖区', '150100'); INSERT INTO `china` VALUES ('150102', '新城区', '150101'); INSERT INTO `china` VALUES ('150103', '回民区', '150101'); INSERT INTO `china` VALUES ('150104', '玉泉区', '150101'); INSERT INTO `china` VALUES ('150105', '赛罕区', '150101'); INSERT INTO `china` VALUES ('150121', '土默特左旗', '150100'); INSERT INTO `china` VALUES ('150122', '托克托县', '150100'); INSERT INTO `china` VALUES ('150123', '和林格尔县', '150100'); INSERT INTO `china` VALUES ('150124', '清水河县', '150100'); INSERT INTO `china` VALUES ('150125', '武川县', '150100'); INSERT INTO `china` VALUES ('150200', '包头市', '150000'); INSERT INTO `china` VALUES ('150201', '市辖区', '150200'); INSERT INTO `china` VALUES ('150202', '东河区', '150201'); INSERT INTO `china` VALUES ('150203', '昆都仑区', '150201'); INSERT INTO `china` VALUES ('150204', '青山区', '150201'); INSERT INTO `china` VALUES ('150205', '石拐区', '150201'); INSERT INTO `china` VALUES ('150206', '白云矿区', '150201'); INSERT INTO `china` VALUES ('150207', '九原区', '150201'); INSERT INTO `china` VALUES ('150221', '土默特右旗', '150200'); INSERT INTO `china` VALUES ('150222', '固阳县', '150200'); INSERT INTO `china` VALUES ('150223', '达尔罕茂明安联合旗', '150200'); INSERT INTO `china` VALUES ('150300', '乌海市', '150000'); INSERT INTO `china` VALUES ('150301', '市辖区', '150300'); INSERT INTO `china` VALUES ('150302', '海勃湾区', '150301'); INSERT INTO `china` VALUES ('150303', '海南区', '150301'); INSERT INTO `china` VALUES ('150304', '乌达区', '150301'); INSERT INTO `china` VALUES ('150400', '赤峰市', '150000'); INSERT INTO `china` VALUES ('150401', '市辖区', '150400'); INSERT INTO `china` VALUES ('150402', '红山区', '150401'); INSERT INTO `china` VALUES ('150403', '元宝山区', '150401'); INSERT INTO `china` VALUES ('150404', '松山区', '150401'); INSERT INTO `china` VALUES ('150421', '阿鲁科尔沁旗', '150400'); INSERT INTO `china` VALUES ('150422', '巴林左旗', '150400'); INSERT INTO `china` VALUES ('150423', '巴林右旗', '150400'); INSERT INTO `china` VALUES ('150424', '林西县', '150400'); INSERT INTO `china` VALUES ('150425', '克什克腾旗', '150400'); INSERT INTO `china` VALUES ('150426', '翁牛特旗', '150400'); INSERT INTO `china` VALUES ('150428', '喀喇沁旗', '150400'); INSERT INTO `china` VALUES ('150429', '宁城县', '150400'); INSERT INTO `china` VALUES ('150430', '敖汉旗', '150400'); INSERT INTO `china` VALUES ('150500', '通辽市', '150000'); INSERT INTO `china` VALUES ('150501', '市辖区', '150500'); INSERT INTO `china` VALUES ('150502', '科尔沁区', '150501'); INSERT INTO `china` VALUES ('150521', '科尔沁左翼中旗', '150500'); INSERT INTO `china` VALUES ('150522', '科尔沁左翼后旗', '150500'); INSERT INTO `china` VALUES ('150523', '开鲁县', '150500'); INSERT INTO `china` VALUES ('150524', '库伦旗', '150500'); INSERT INTO `china` VALUES ('150525', '奈曼旗', '150500'); INSERT INTO `china` VALUES ('150526', '扎鲁特旗', '150500'); INSERT INTO `china` VALUES ('150581', '霍林郭勒市', '150500'); INSERT INTO `china` VALUES ('150600', '鄂尔多斯市', '150000'); INSERT INTO `china` VALUES ('150602', '东胜区', '150600'); INSERT INTO `china` VALUES ('150621', '达拉特旗', '150600'); INSERT INTO `china` VALUES ('150622', '准格尔旗', '150600'); INSERT INTO `china` VALUES ('150623', '鄂托克前旗', '150600'); INSERT INTO `china` VALUES ('150624', '鄂托克旗', '150600'); INSERT INTO `china` VALUES ('150625', '杭锦旗', '150600'); INSERT INTO `china` VALUES ('150626', '乌审旗', '150600'); INSERT INTO `china` VALUES ('150627', '伊金霍洛旗', '150600'); INSERT INTO `china` VALUES ('150700', '呼伦贝尔市', '150000'); INSERT INTO `china` VALUES ('150701', '市辖区', '150700'); INSERT INTO `china` VALUES ('150702', '海拉尔区', '150701'); INSERT INTO `china` VALUES ('150721', '阿荣旗', '150700'); INSERT INTO `china` VALUES ('150722', '莫力达瓦达斡尔族自治旗', '150700'); INSERT INTO `china` VALUES ('150723', '鄂伦春自治旗', '150700'); INSERT INTO `china` VALUES ('150724', '鄂温克族自治旗', '150700'); INSERT INTO `china` VALUES ('150725', '陈巴尔虎旗', '150700'); INSERT INTO `china` VALUES ('150726', '新巴尔虎左旗', '150700'); INSERT INTO `china` VALUES ('150727', '新巴尔虎右旗', '150700'); INSERT INTO `china` VALUES ('150781', '满洲里市', '150700'); INSERT INTO `china` VALUES ('150782', '牙克石市', '150700'); INSERT INTO `china` VALUES ('150783', '扎兰屯市', '150700'); INSERT INTO `china` VALUES ('150784', '额尔古纳市', '150700'); INSERT INTO `china` VALUES ('150785', '根河市', '150700'); INSERT INTO `china` VALUES ('150800', '巴彦淖尔市', '150000'); INSERT INTO `china` VALUES ('150801', '市辖区', '150800'); INSERT INTO `china` VALUES ('150802', '临河区', '150800'); INSERT INTO `china` VALUES ('150821', '五原县', '150800'); INSERT INTO `china` VALUES ('150822', '磴口县', '150800'); INSERT INTO `china` VALUES ('150823', '乌拉特前旗', '150800'); INSERT INTO `china` VALUES ('150824', '乌拉特中旗', '150800'); INSERT INTO `china` VALUES ('150825', '乌拉特后旗', '150800'); INSERT INTO `china` VALUES ('150826', '杭锦后旗', '150800'); INSERT INTO `china` VALUES ('150900', '乌兰察布市', '150000'); INSERT INTO `china` VALUES ('150901', '市辖区', '150900'); INSERT INTO `china` VALUES ('150902', '集宁区', '150901'); INSERT INTO `china` VALUES ('150921', '卓资县', '150900'); INSERT INTO `china` VALUES ('150922', '化德县', '150900'); INSERT INTO `china` VALUES ('150923', '商都县', '150900'); INSERT INTO `china` VALUES ('150924', '兴和县', '150900'); INSERT INTO `china` VALUES ('150925', '凉城县', '150900'); INSERT INTO `china` VALUES ('150926', '察哈尔右翼前旗', '150900'); INSERT INTO `china` VALUES ('150927', '察哈尔右翼中旗', '150900'); INSERT INTO `china` VALUES ('150928', '察哈尔右翼后旗', '150900'); INSERT INTO `china` VALUES ('150929', '四子王旗', '150900'); INSERT INTO `china` VALUES ('150981', '丰镇市', '150900'); INSERT INTO `china` VALUES ('152200', '兴安盟', '150000'); INSERT INTO `china` VALUES ('152201', '乌兰浩特市', '152200'); INSERT INTO `china` VALUES ('152202', '阿尔山市', '152200'); INSERT INTO `china` VALUES ('152221', '科尔沁右翼前旗', '152200'); INSERT INTO `china` VALUES ('152222', '科尔沁右翼中旗', '152200'); INSERT INTO `china` VALUES ('152223', '扎赉特旗', '152200'); INSERT INTO `china` VALUES ('152224', '突泉县', '152200'); INSERT INTO `china` VALUES ('152500', '锡林郭勒盟', '150000'); INSERT INTO `china` VALUES ('152501', '二连浩特市', '152500'); INSERT INTO `china` VALUES ('152502', '锡林浩特市', '152500'); INSERT INTO `china` VALUES ('152522', '阿巴嘎旗', '152500'); INSERT INTO `china` VALUES ('152523', '苏尼特左旗', '152500'); INSERT INTO `china` VALUES ('152524', '苏尼特右旗', '152500'); INSERT INTO `china` VALUES ('152525', '东乌珠穆沁旗', '152500'); INSERT INTO `china` VALUES ('152526', '西乌珠穆沁旗', '152500'); INSERT INTO `china` VALUES ('152527', '太仆寺旗', '152500'); INSERT INTO `china` VALUES ('152528', '镶黄旗', '152500'); INSERT INTO `china` VALUES ('152529', '正镶白旗', '152500'); INSERT INTO `china` VALUES ('152530', '正蓝旗', '152500'); INSERT INTO `china` VALUES ('152531', '多伦县', '152500'); INSERT INTO `china` VALUES ('152900', '阿拉善盟', '150000'); INSERT INTO `china` VALUES ('152921', '阿拉善左旗', '152900'); INSERT INTO `china` VALUES ('152922', '阿拉善右旗', '152900'); INSERT INTO `china` VALUES ('152923', '额济纳旗', '152900'); INSERT INTO `china` VALUES ('210000', '辽宁省', '0'); INSERT INTO `china` VALUES ('210100', '沈阳市', '210000'); INSERT INTO `china` VALUES ('210101', '市辖区', '210100'); INSERT INTO `china` VALUES ('210102', '和平区', '210101'); INSERT INTO `china` VALUES ('210103', '沈河区', '210101'); INSERT INTO `china` VALUES ('210104', '大东区', '210101'); INSERT INTO `china` VALUES ('210105', '皇姑区', '210101'); INSERT INTO `china` VALUES ('210106', '铁西区', '210101'); INSERT INTO `china` VALUES ('210111', '苏家屯区', '210101'); INSERT INTO `china` VALUES ('210112', '东陵区', '210101'); INSERT INTO `china` VALUES ('210113', '新城子区', '210101'); INSERT INTO `china` VALUES ('210114', '于洪区', '210101'); INSERT INTO `china` VALUES ('210122', '辽中县', '210100'); INSERT INTO `china` VALUES ('210123', '康平县', '210100'); INSERT INTO `china` VALUES ('210124', '法库县', '210100'); INSERT INTO `china` VALUES ('210181', '新民市', '210100'); INSERT INTO `china` VALUES ('210182', '沈北新区', '210100'); INSERT INTO `china` VALUES ('210200', '大连市', '210000'); INSERT INTO `china` VALUES ('210201', '市辖区', '210200'); INSERT INTO `china` VALUES ('210202', '中山区', '210201'); INSERT INTO `china` VALUES ('210203', '西岗区', '210201'); INSERT INTO `china` VALUES ('210204', '沙河口区', '210201'); INSERT INTO `china` VALUES ('210211', '甘井子区', '210201'); INSERT INTO `china` VALUES ('210212', '旅顺口区', '210201'); INSERT INTO `china` VALUES ('210213', '金州区', '210201'); INSERT INTO `china` VALUES ('210224', '长海县', '210200'); INSERT INTO `china` VALUES ('210281', '瓦房店市', '210200'); INSERT INTO `china` VALUES ('210282', '普兰店市', '210200'); INSERT INTO `china` VALUES ('210283', '庄河市', '210200'); INSERT INTO `china` VALUES ('210300', '鞍山市', '210000'); INSERT INTO `china` VALUES ('210301', '市辖区', '210300'); INSERT INTO `china` VALUES ('210302', '铁东区', '210301'); INSERT INTO `china` VALUES ('210303', '铁西区', '210301'); INSERT INTO `china` VALUES ('210304', '立山区', '210301'); INSERT INTO `china` VALUES ('210311', '千山区', '210301'); INSERT INTO `china` VALUES ('210321', '台安县', '210300'); INSERT INTO `china` VALUES ('210323', '岫岩满族自治县', '210300'); INSERT INTO `china` VALUES ('210381', '海城市', '210300'); INSERT INTO `china` VALUES ('210400', '抚顺市', '210000'); INSERT INTO `china` VALUES ('210401', '市辖区', '210400'); INSERT INTO `china` VALUES ('210402', '新抚区', '210401'); INSERT INTO `china` VALUES ('210403', '东洲区', '210401'); INSERT INTO `china` VALUES ('210404', '望花区', '210401'); INSERT INTO `china` VALUES ('210411', '顺城区', '210401'); INSERT INTO `china` VALUES ('210421', '抚顺县', '210400'); INSERT INTO `china` VALUES ('210422', '新宾满族自治县', '210400'); INSERT INTO `china` VALUES ('210423', '清原满族自治县', '210400'); INSERT INTO `china` VALUES ('210500', '本溪市', '210000'); INSERT INTO `china` VALUES ('210501', '市辖区', '210500'); INSERT INTO `china` VALUES ('210502', '平山区', '210501'); INSERT INTO `china` VALUES ('210503', '溪湖??', '210501'); INSERT INTO `china` VALUES ('210504', '明山区', '210501'); INSERT INTO `china` VALUES ('210505', '南芬区', '210501'); INSERT INTO `china` VALUES ('210521', '本溪满族自治县', '210500'); INSERT INTO `china` VALUES ('210522', '桓仁满族自治县', '210500'); INSERT INTO `china` VALUES ('210600', '丹东市', '210000'); INSERT INTO `china` VALUES ('210601', '市辖区', '210600'); INSERT INTO `china` VALUES ('210602', '元宝区', '210601'); INSERT INTO `china` VALUES ('210603', '振兴区', '210601'); INSERT INTO `china` VALUES ('210604', '振安区', '210601'); INSERT INTO `china` VALUES ('210624', '宽甸满族自治县', '210600'); INSERT INTO `china` VALUES ('210681', '东港市', '210600'); INSERT INTO `china` VALUES ('210682', '凤城市', '210600'); INSERT INTO `china` VALUES ('210700', '锦州市', '210000'); INSERT INTO `china` VALUES ('210701', '市辖区', '210700'); INSERT INTO `china` VALUES ('210702', '古塔区', '210701'); INSERT INTO `china` VALUES ('210703', '凌河区', '210701'); INSERT INTO `china` VALUES ('210711', '太和区', '210701'); INSERT INTO `china` VALUES ('210726', '黑山县', '210700'); INSERT INTO `china` VALUES ('210727', '义县', '210700'); INSERT INTO `china` VALUES ('210781', '凌海市', '210700'); INSERT INTO `china` VALUES ('210782', '北宁市', '210700'); INSERT INTO `china` VALUES ('210800', '营口市', '210000'); INSERT INTO `china` VALUES ('210801', '市辖区', '210800'); INSERT INTO `china` VALUES ('210802', '站前区', '210801'); INSERT INTO `china` VALUES ('210803', '西市区', '210801'); INSERT INTO `china` VALUES ('210804', '鲅鱼圈区', '210801'); INSERT INTO `china` VALUES ('210811', '老边区', '210801'); INSERT INTO `china` VALUES ('210881', '盖州市', '210800'); INSERT INTO `china` VALUES ('210882', '大石桥市', '210800'); INSERT INTO `china` VALUES ('210900', '阜新市', '210000'); INSERT INTO `china` VALUES ('210901', '市辖区', '210900'); INSERT INTO `china` VALUES ('210902', '海州区', '210901'); INSERT INTO `china` VALUES ('210903', '新邱区', '210901'); INSERT INTO `china` VALUES ('210904', '太平区', '210901'); INSERT INTO `china` VALUES ('210905', '清河门区', '210901'); INSERT INTO `china` VALUES ('210911', '细河区', '210901'); INSERT INTO `china` VALUES ('210921', '阜新蒙古族自治县', '210900'); INSERT INTO `china` VALUES ('210922', '彰武县', '210900'); INSERT INTO `china` VALUES ('211000', '辽阳市', '210000'); INSERT INTO `china` VALUES ('211001', '市辖区', '211000'); INSERT INTO `china` VALUES ('211002', '白塔区', '211001'); INSERT INTO `china` VALUES ('211003', '文圣区', '211001'); INSERT INTO `china` VALUES ('211004', '宏伟区', '211001'); INSERT INTO `china` VALUES ('211005', '弓长岭区', '211001'); INSERT INTO `china` VALUES ('211011', '太子河区', '211001'); INSERT INTO `china` VALUES ('211021', '辽阳县', '211000'); INSERT INTO `china` VALUES ('211081', '灯塔市', '211000'); INSERT INTO `china` VALUES ('211100', '盘锦市', '210000'); INSERT INTO `china` VALUES ('211101', '市辖区', '211100'); INSERT INTO `china` VALUES ('211102', '双台子区', '211101'); INSERT INTO `china` VALUES ('211103', '兴隆台区', '211101'); INSERT INTO `china` VALUES ('211121', '大洼县', '211100'); INSERT INTO `china` VALUES ('211122', '盘山县', '211100'); INSERT INTO `china` VALUES ('211200', '铁岭市', '210000'); INSERT INTO `china` VALUES ('211201', '市辖区', '211200'); INSERT INTO `china` VALUES ('211202', '银州区', '211201'); INSERT INTO `china` VALUES ('211204', '清河区', '211201'); INSERT INTO `china` VALUES ('211221', '铁岭县', '211200'); INSERT INTO `china` VALUES ('211223', '西丰县', '211200'); INSERT INTO `china` VALUES ('211224', '昌图县', '211200'); INSERT INTO `china` VALUES ('211281', '调兵山市', '211200'); INSERT INTO `china` VALUES ('211282', '开原市', '211200'); INSERT INTO `china` VALUES ('211300', '朝阳市', '210000'); INSERT INTO `china` VALUES ('211301', '市辖区', '211300'); INSERT INTO `china` VALUES ('211302', '双塔区', '211301'); INSERT INTO `china` VALUES ('211303', '龙城区', '211301'); INSERT INTO `china` VALUES ('211321', '朝阳县', '211300'); INSERT INTO `china` VALUES ('211322', '建平县', '211300'); INSERT INTO `china` VALUES ('211324', '喀喇沁左翼蒙古族自治县', '211300'); INSERT INTO `china` VALUES ('211381', '北票市', '211300'); INSERT INTO `china` VALUES ('211382', '凌源市', '211300'); INSERT INTO `china` VALUES ('211400', '葫芦岛市', '210000'); INSERT INTO `china` VALUES ('211401', '市辖区', '211400'); INSERT INTO `china` VALUES ('211402', '连山区', '211401'); INSERT INTO `china` VALUES ('211403', '龙港区', '211401'); INSERT INTO `china` VALUES ('211404', '南票区', '211401'); INSERT INTO `china` VALUES ('211421', '绥中县', '211400'); INSERT INTO `china` VALUES ('211422', '建昌县', '211400'); INSERT INTO `china` VALUES ('211481', '兴城市', '211400'); INSERT INTO `china` VALUES ('220000', '吉林省', '0'); INSERT INTO `china` VALUES ('20', '长春市', '220000'); INSERT INTO `china` VALUES ('21', '市辖区', '20'); INSERT INTO `china` VALUES ('22', '南关区', '21'); INSERT INTO `china` VALUES ('23', '宽城区', '21'); INSERT INTO `china` VALUES ('24', '朝阳区', '21'); INSERT INTO `china` VALUES ('25', '二道区', '21'); INSERT INTO `china` VALUES ('26', '绿园区', '21'); INSERT INTO `china` VALUES ('22', '双阳区', '21'); INSERT INTO `china` VALUES ('22', '农安县', '20'); INSERT INTO `china` VALUES ('21', '九台市', '20'); INSERT INTO `china` VALUES ('22', '榆树市', '20'); INSERT INTO `china` VALUES ('23', '德惠市', '20'); INSERT INTO `china` VALUES ('20', '吉林市', '220000'); INSERT INTO `china` VALUES ('21', '市辖区', '20'); INSERT INTO `china` VALUES ('22', '昌邑区', '21'); INSERT INTO `china` VALUES ('23', '龙潭区', '21'); INSERT INTO `china` VALUES ('24', '船营区', '21'); INSERT INTO `china` VALUES ('21', '丰满区', '21'); INSERT INTO `china` VALUES ('21', '永吉县', '20'); INSERT INTO `china` VALUES ('220281', '蛟河市', '20'); INSERT INTO `china` VALUES ('220282', '桦甸市', '20'); INSERT INTO `china` VALUES ('220283', '舒兰市', '20'); INSERT INTO `china` VALUES ('220284', '磐石市', '20'); INSERT INTO `china` VALUES ('220300', '四平市', '220000'); INSERT INTO `china` VALUES ('220301', '市辖区', '220300'); INSERT INTO `china` VALUES ('220302', '铁西区', '220301'); INSERT INTO `china` VALUES ('220303', '铁东区', '220301'); INSERT INTO `china` VALUES ('220322', '梨树县', '220300'); INSERT INTO `china` VALUES ('220323', '伊通满族自治县', '220300'); INSERT INTO `china` VALUES ('220381', '公主岭市', '220300'); INSERT INTO `china` VALUES ('220382', '双辽市', '220300'); INSERT INTO `china` VALUES ('220400', '辽源市', '220000'); INSERT INTO `china` VALUES ('220401', '市辖区', '220400'); INSERT INTO `china` VALUES ('220402', '龙山区', '220401'); INSERT INTO `china` VALUES ('220403', '西安区', '220401'); INSERT INTO `china` VALUES ('220421', '东丰县', '220400'); INSERT INTO `china` VALUES ('220422', '东辽县', '220400'); INSERT INTO `china` VALUES ('220500', '通化市', '220000'); INSERT INTO `china` VALUES ('220501', '市辖区', '220500'); INSERT INTO `china` VALUES ('220502', '东昌区', '220501'); INSERT INTO `china` VALUES ('220503', '二道江区', '220501'); INSERT INTO `china` VALUES ('220521', '通化县', '220500'); INSERT INTO `china` VALUES ('220523', '辉南县', '220500'); INSERT INTO `china` VALUES ('220524', '柳河县', '220500'); INSERT INTO `china` VALUES ('220581', '梅河口市', '220500'); INSERT INTO `china` VALUES ('220582', '集安市', '220500'); INSERT INTO `china` VALUES ('220600', '白山市', '220000'); INSERT INTO `china` VALUES ('220601', '市辖区', '220600'); INSERT INTO `china` VALUES ('220602', '八道江区', '220601'); INSERT INTO `china` VALUES ('220621', '抚松县', '220600'); INSERT INTO `china` VALUES ('220622', '靖宇县', '220600'); INSERT INTO `china` VALUES ('220623', '长白朝鲜族自治县', '220600'); INSERT INTO `china` VALUES ('220625', '江源区', '220600'); INSERT INTO `china` VALUES ('220681', '临江市', '220600'); INSERT INTO `china` VALUES ('220700', '松原市', '220000'); INSERT INTO `china` VALUES ('220701', '市辖区', '220700'); INSERT INTO `china` VALUES ('220702', '宁江区', '220701'); INSERT INTO `china` VALUES ('220721', '前郭尔罗斯蒙古族自治县', '220700'); INSERT INTO `china` VALUES ('220722', '长岭县', '220700'); INSERT INTO `china` VALUES ('220723', '乾安县', '220700'); INSERT INTO `china` VALUES ('220724', '扶余市', '220700'); INSERT INTO `china` VALUES ('220800', '白城市', '220000'); INSERT INTO `china` VALUES ('220801', '市辖区', '220800'); INSERT INTO `china` VALUES ('220802', '洮北区', '220800'); INSERT INTO `china` VALUES ('220821', '镇赉县', '220800'); INSERT INTO `china` VALUES ('220822', '通榆县', '220800'); INSERT INTO `china` VALUES ('220881', '洮南市', '220800'); INSERT INTO `china` VALUES ('220882', '大安市', '220800'); INSERT INTO `china` VALUES ('222400', '延边朝鲜族自治州', '220000'); INSERT INTO `china` VALUES ('222401', '延吉市', '222400'); INSERT INTO `china` VALUES ('222402', '图们市', '222400'); INSERT INTO `china` VALUES ('222403', '敦化市', '222400'); INSERT INTO `china` VALUES ('222404', '珲春市', '222400'); INSERT INTO `china` VALUES ('222405', '龙井市', '222400'); INSERT INTO `china` VALUES ('222406', '和龙市', '222400'); INSERT INTO `china` VALUES ('222424', '汪清县', '222400'); INSERT INTO `china` VALUES ('222426', '安图县', '222400'); INSERT INTO `china` VALUES ('230000', '黑龙江省', '0'); INSERT INTO `china` VALUES ('230100', '哈尔滨市', '230000'); INSERT INTO `china` VALUES ('230101', '市辖区', '230100'); INSERT INTO `china` VALUES ('230102', '道里区', '230101'); INSERT INTO `china` VALUES ('230103', '南岗区', '230101'); INSERT INTO `china` VALUES ('230104', '道外区', '230101'); INSERT INTO `china` VALUES ('230106', '香坊区', '230101'); INSERT INTO `china` VALUES ('230107', '动力区', '230101'); INSERT INTO `china` VALUES ('230108', '平房区', '230101'); INSERT INTO `china` VALUES ('230109', '松北区', '230101'); INSERT INTO `china` VALUES ('230111', '呼兰区', '230101'); INSERT INTO `china` VALUES ('230123', '依兰县', '230100'); INSERT INTO `china` VALUES ('230124', '方正县', '230100'); INSERT INTO `china` VALUES ('230125', '宾县', '230100'); INSERT INTO `china` VALUES ('230126', '巴彦县', '230100'); INSERT INTO `china` VALUES ('230127', '木兰县', '230100'); INSERT INTO `china` VALUES ('230128', '通河县', '230100'); INSERT INTO `china` VALUES ('230129', '延寿县', '230100'); INSERT INTO `china` VALUES ('230181', '阿城市', '230100'); INSERT INTO `china` VALUES ('230182', '双城市', '230100'); INSERT INTO `china` VALUES ('230183', '尚志市', '230100'); INSERT INTO `china` VALUES ('230184', '五常市', '230100'); INSERT INTO `china` VALUES ('230200', '齐齐哈尔市', '230000'); INSERT INTO `china` VALUES ('230201', '市辖区', '230200'); INSERT INTO `china` VALUES ('230202', '龙沙区', '230201'); INSERT INTO `china` VALUES ('230203', '建华区', '230201'); INSERT INTO `china` VALUES ('230204', '铁锋区', '230201'); INSERT INTO `china` VALUES ('230205', '昂昂溪区', '230201'); INSERT INTO `china` VALUES ('230206', '富拉尔基区', '230201'); INSERT INTO `china` VALUES ('230207', '碾子山区', '230201'); INSERT INTO `china` VALUES ('230208', '梅里斯达斡尔族区', '230201'); INSERT INTO `china` VALUES ('230221', '龙江县', '230200'); INSERT INTO `china` VALUES ('230223', '依安县', '230200'); INSERT INTO `china` VALUES ('230224', '泰来县', '230200'); INSERT INTO `china` VALUES ('230225', '甘南县', '230200'); INSERT INTO `china` VALUES ('230227', '富裕县', '230200'); INSERT INTO `china` VALUES ('230229', '克山县', '230200'); INSERT INTO `china` VALUES ('230230', '克东县', '230200'); INSERT INTO `china` VALUES ('230231', '拜泉县', '230200'); INSERT INTO `china` VALUES ('230281', '讷河市', '230200'); INSERT INTO `china` VALUES ('230300', '鸡西市', '230000'); INSERT INTO `china` VALUES ('230301', '市辖区', '230300'); INSERT INTO `china` VALUES ('230302', '鸡冠区', '230301'); INSERT INTO `china` VALUES ('230303', '恒山区', '230301'); INSERT INTO `china` VALUES ('230304', '滴道区', '230301'); INSERT INTO `china` VALUES ('230305', '梨树区', '230301'); INSERT INTO `china` VALUES ('230306', '城子河区', '230301'); INSERT INTO `china` VALUES ('230307', '麻山区', '230301'); INSERT INTO `china` VALUES ('230321', '鸡东县', '230300'); INSERT INTO `china` VALUES ('230381', '虎林市', '230300'); INSERT INTO `china` VALUES ('230382', '密山市', '230300'); INSERT INTO `china` VALUES ('230400', '鹤岗市', '230000'); INSERT INTO `china` VALUES ('230401', '市辖区', '230400'); INSERT INTO `china` VALUES ('230402', '向阳区', '230401'); INSERT INTO `china` VALUES ('230403', '工农区', '230401'); INSERT INTO `china` VALUES ('230404', '南山区', '230401'); INSERT INTO `china` VALUES ('230405', '兴安区', '230401'); INSERT INTO `china` VALUES ('230406', '东山区', '230401'); INSERT INTO `china` VALUES ('230407', '兴山区', '230401'); INSERT INTO `china` VALUES ('230421', '萝北县', '230400'); INSERT INTO `china` VALUES ('230422', '绥滨县', '230400'); INSERT INTO `china` VALUES ('230500', '双鸭山市', '230000'); INSERT INTO `china` VALUES ('230501', '市辖区', '230500'); INSERT INTO `china` VALUES ('230502', '尖山区', '230501'); INSERT INTO `china` VALUES ('230503', '岭东区', '230501'); INSERT INTO `china` VALUES ('230505', '四方台区', '230501'); INSERT INTO `china` VALUES ('230506', '宝山区', '230501'); INSERT INTO `china` VALUES ('230521', '集贤县', '230500'); INSERT INTO `china` VALUES ('230522', '友谊县', '230500'); INSERT INTO `china` VALUES ('230523', '宝清县', '230500'); INSERT INTO `china` VALUES ('230524', '饶河县', '230500'); INSERT INTO `china` VALUES ('230600', '大庆市', '230000'); INSERT INTO `china` VALUES ('230601', '市辖区', '230600'); INSERT INTO `china` VALUES ('230602', '萨尔图区', '230601'); INSERT INTO `china` VALUES ('230603', '龙凤区', '230601'); INSERT INTO `china` VALUES ('230604', '让胡路区', '230601'); INSERT INTO `china` VALUES ('230605', '红岗区', '230601'); INSERT INTO `china` VALUES ('230606', '大同区', '230601'); INSERT INTO `china` VALUES ('230621', '肇州县', '230600'); INSERT INTO `china` VALUES ('230622', '肇源县', '230600'); INSERT INTO `china` VALUES ('230623', '林甸县', '230600'); INSERT INTO `china` VALUES ('230624', '杜尔伯特蒙古族自治县', '230600'); INSERT INTO `china` VALUES ('230700', '伊春市', '230000'); INSERT INTO `china` VALUES ('230701', '市辖区', '230700'); INSERT INTO `china` VALUES ('230702', '伊春区', '230701'); INSERT INTO `china` VALUES ('230703', '南岔区', '230701'); INSERT INTO `china` VALUES ('230704', '友好区', '230701'); INSERT INTO `china` VALUES ('230705', '西林区', '230701'); INSERT INTO `china` VALUES ('230706', '翠峦区', '230701'); INSERT INTO `china` VALUES ('230707', '新青区', '230701'); INSERT INTO `china` VALUES ('230708', '美溪区', '230701'); INSERT INTO `china` VALUES ('230709', '金山屯区', '230701'); INSERT INTO `china` VALUES ('230710', '五营区', '230701'); INSERT INTO `china` VALUES ('230711', '乌马河区', '230701'); INSERT INTO `china` VALUES ('230712', '汤旺河区', '230701'); INSERT INTO `china` VALUES ('230713', '带岭区', '230701'); INSERT INTO `china` VALUES ('230714', '乌伊岭区', '230701'); INSERT INTO `china` VALUES ('230715', '红星区', '230701'); INSERT INTO `china` VALUES ('230716', '上甘岭区', '230701'); INSERT INTO `china` VALUES ('230722', '嘉荫县', '230700'); INSERT INTO `china` VALUES ('230781', '铁力市', '230700'); INSERT INTO `china` VALUES ('230800', '佳木斯市', '230000'); INSERT INTO `china` VALUES ('230801', '市辖区', '230800'); INSERT INTO `china` VALUES ('230803', '向阳区', '230801'); INSERT INTO `china` VALUES ('230804', '前进区', '230801'); INSERT INTO `china` VALUES ('230805', '东风区', '230801'); INSERT INTO `china` VALUES ('230811', '郊区', '230801'); INSERT INTO `china` VALUES ('230822', '桦南县', '230800'); INSERT INTO `china` VALUES ('230826', '桦川县', '230800'); INSERT INTO `china` VALUES ('230828', '汤原县', '230800'); INSERT INTO `china` VALUES ('230833', '抚远县', '230800'); INSERT INTO `china` VALUES ('230881', '同江市', '230800'); INSERT INTO `china` VALUES ('230882', '富锦市', '230800'); INSERT INTO `china` VALUES ('230900', '七台河市', '230000'); INSERT INTO `china` VALUES ('230901', '市辖区', '230900'); INSERT INTO `china` VALUES ('230902', '新兴区', '230901'); INSERT INTO `china` VALUES ('230903', '桃山区', '230901'); INSERT INTO `china` VALUES ('230904', '茄子河区', '230901'); INSERT INTO `china` VALUES ('230921', '勃利县', '230900'); INSERT INTO `china` VALUES ('231000', '牡丹江市', '230000'); INSERT INTO `china` VALUES ('231001', '市辖区', '231000'); INSERT INTO `china` VALUES ('231002', '东安区', '231001'); INSERT INTO `china` VALUES ('231003', '阳明区', '231001'); INSERT INTO `china` VALUES ('231004', '爱民区', '231001'); INSERT INTO `china` VALUES ('231005', '西安区', '231001'); INSERT INTO `china` VALUES ('231024', '东宁县', '231000'); INSERT INTO `china` VALUES ('231025', '林口县', '231000'); INSERT INTO `china` VALUES ('231081', '绥芬河市', '231000'); INSERT INTO `china` VALUES ('231083', '海林市', '231000'); INSERT INTO `china` VALUES ('231084', '宁安市', '231000'); INSERT INTO `china` VALUES ('231085', '穆棱市', '231000'); INSERT INTO `china` VALUES ('231100', '黑河市', '230000'); INSERT INTO `china` VALUES ('231101', '市辖区', '231100'); INSERT INTO `china` VALUES ('231102', '爱辉区', '231101'); INSERT INTO `china` VALUES ('231121', '嫩江县', '231100'); INSERT INTO `china` VALUES ('231123', '逊克县', '231100'); INSERT INTO `china` VALUES ('231124', '孙吴县', '231100'); INSERT INTO `china` VALUES ('231181', '北安市', '231100'); INSERT INTO `china` VALUES ('231182', '五大连池市', '231100'); INSERT INTO `china` VALUES ('231200', '绥化市', '230000'); INSERT INTO `china` VALUES ('231201', '北林区', '231200'); INSERT INTO `china` VALUES ('231221', '望奎县', '231200'); INSERT INTO `china` VALUES ('231222', '兰西县', '231200'); INSERT INTO `china` VALUES ('231223', '青冈县', '231200'); INSERT INTO `china` VALUES ('231224', '庆安县', '231200'); INSERT INTO `china` VALUES ('231225', '明水县', '231200'); INSERT INTO `china` VALUES ('231226', '绥棱县', '231200'); INSERT INTO `china` VALUES ('231281', '安达市', '231200'); INSERT INTO `china` VALUES ('231282', '肇东市', '231200'); INSERT INTO `china` VALUES ('231283', '海伦市', '231200'); INSERT INTO `china` VALUES ('232700', '大兴安岭地区', '230000'); INSERT INTO `china` VALUES ('232701', '加格达奇区', '232700'); INSERT INTO `china` VALUES ('232702', '松岭区', '232700'); INSERT INTO `china` VALUES ('232703', '新林区', '232700'); INSERT INTO `china` VALUES ('232704', '呼中区', '232700'); INSERT INTO `china` VALUES ('232721', '呼玛县', '232700'); INSERT INTO `china` VALUES ('232722', '塔河县', '232700'); INSERT INTO `china` VALUES ('232723', '漠河县', '232700'); INSERT INTO `china` VALUES ('310000', '上海市', '0'); INSERT INTO `china` VALUES ('310100', '黄浦区', '310000'); INSERT INTO `china` VALUES ('310300', '卢湾区', '310000'); INSERT INTO `china` VALUES ('310400', '徐汇区', '310000'); INSERT INTO `china` VALUES ('310500', '长宁区', '310000'); INSERT INTO `china` VALUES ('310600', '静安区', '310000'); INSERT INTO `china` VALUES ('310700', '普陀区', '310000'); INSERT INTO `china` VALUES ('310800', '闸北区', '310000'); INSERT INTO `china` VALUES ('310900', '虹口区', '310000'); INSERT INTO `china` VALUES ('311000', '杨浦区', '310000'); INSERT INTO `china` VALUES ('311200', '闵行区', '310000'); INSERT INTO `china` VALUES ('311300', '宝山区', '310000'); INSERT INTO `china` VALUES ('311400', '嘉定区', '310000'); INSERT INTO `china` VALUES ('311500', '浦东新区', '310000'); INSERT INTO `china` VALUES ('311600', '金山区', '310000'); INSERT INTO `china` VALUES ('311700', '松江区', '310000'); INSERT INTO `china` VALUES ('311800', '青浦区', '310000'); INSERT INTO `china` VALUES ('311900', '南汇区', '310000'); INSERT INTO `china` VALUES ('312000', '奉贤区', '310000'); INSERT INTO `china` VALUES ('313000', '崇明县', '310000'); INSERT INTO `china` VALUES ('320000', '江苏省', '0'); INSERT INTO `china` VALUES ('30', '南京市', '320000'); INSERT INTO `china` VALUES ('31', '市辖区', '30'); INSERT INTO `china` VALUES ('32', '玄武区', '31'); INSERT INTO `china` VALUES ('33', '白下区', '31'); INSERT INTO `china` VALUES ('34', '秦淮区', '31'); INSERT INTO `china` VALUES ('35', '建邺区', '31'); INSERT INTO `china` VALUES ('36', '鼓楼区', '31'); INSERT INTO `china` VALUES ('37', '下关区', '31'); INSERT INTO `china` VALUES ('31', '浦口区', '31'); INSERT INTO `china` VALUES ('33', '栖霞区', '31'); INSERT INTO `china` VALUES ('34', '雨花台区', '31'); INSERT INTO `china` VALUES ('35', '江宁区', '31'); INSERT INTO `china` VALUES ('36', '六合区', '31'); INSERT INTO `china` VALUES ('34', '溧水区', '30'); INSERT INTO `china` VALUES ('35', '高淳区', '30'); INSERT INTO `china` VALUES ('30', '无锡市', '320000'); INSERT INTO `china` VALUES ('31', '市辖区', '30'); INSERT INTO `china` VALUES ('32', '崇安区', '31'); INSERT INTO `china` VALUES ('33', '南长区', '31'); INSERT INTO `china` VALUES ('34', '北塘区', '31'); INSERT INTO `china` VALUES ('35', '锡山区', '31'); INSERT INTO `china` VALUES ('36', '惠山区', '31'); INSERT INTO `china` VALUES ('31', '滨湖区', '31'); INSERT INTO `china` VALUES ('320281', '江阴市', '30'); INSERT INTO `china` VALUES ('320282', '宜兴市', '30'); INSERT INTO `china` VALUES ('320300', '徐州市', '320000'); INSERT INTO `china` VALUES ('320301', '泉山区', '320300'); INSERT INTO `china` VALUES ('320302', '鼓楼区', '320300'); INSERT INTO `china` VALUES ('320303', '云龙区', '320300'); INSERT INTO `china` VALUES ('320304', '九里区', '320301'); INSERT INTO `china` VALUES ('320305', '贾汪区', '320300'); INSERT INTO `china` VALUES ('320321', '丰县', '320300'); INSERT INTO `china` VALUES ('320322', '沛县', '320300'); INSERT INTO `china` VALUES ('320323', '铜山县', '320300'); INSERT INTO `china` VALUES ('320324', '睢宁县', '320300'); INSERT INTO `china` VALUES ('320381', '新沂市', '320300'); INSERT INTO `china` VALUES ('320382', '邳州市', '320300'); INSERT INTO `china` VALUES ('320400', '常州市', '320000'); INSERT INTO `china` VALUES ('320401', '市辖区', '320400'); INSERT INTO `china` VALUES ('320402', '天宁区', '320401'); INSERT INTO `china` VALUES ('320404', '钟楼区', '320401'); INSERT INTO `china` VALUES ('320405', '戚墅堰区', '320401'); INSERT INTO `china` VALUES ('320411', '新北区', '320401'); INSERT INTO `china` VALUES ('320412', '武进区', '320401'); INSERT INTO `china` VALUES ('320481', '溧阳市', '320400'); INSERT INTO `china` VALUES ('320482', '金坛市', '320400'); INSERT INTO `china` VALUES ('320500', '苏州市', '320000'); INSERT INTO `china` VALUES ('320501', '市辖区', '320500'); INSERT INTO `china` VALUES ('320502', '沧浪区', '320501'); INSERT INTO `china` VALUES ('320503', '平江区', '320501'); INSERT INTO `china` VALUES ('320504', '金阊区', '320501'); INSERT INTO `china` VALUES ('320505', '虎丘区', '320501'); INSERT INTO `china` VALUES ('320506', '吴中区', '320501'); INSERT INTO `china` VALUES ('320507', '相城区', '320501'); INSERT INTO `china` VALUES ('320581', '常熟市', '320500'); INSERT INTO `china` VALUES ('320582', '张家港市', '320500'); INSERT INTO `china` VALUES ('320583', '昆山市', '320500'); INSERT INTO `china` VALUES ('320584', '吴江市', '320500'); INSERT INTO `china` VALUES ('320585', '太仓市', '320500'); INSERT INTO `china` VALUES ('320600', '南通市', '320000'); INSERT INTO `china` VALUES ('320601', '市辖区', '320600'); INSERT INTO `china` VALUES ('320602', '崇川区', '320601'); INSERT INTO `china` VALUES ('320611', '港闸区', '320601'); INSERT INTO `china` VALUES ('320621', '海安县', '320600'); INSERT INTO `china` VALUES ('320623', '如东县', '320600'); INSERT INTO `china` VALUES ('320681', '启东市', '320600'); INSERT INTO `china` VALUES ('320682', '如皋市', '320600'); INSERT INTO `china` VALUES ('320683', '通州市', '320600'); INSERT INTO `china` VALUES ('320684', '海门市', '320600'); INSERT INTO `china` VALUES ('320700', '连云港市', '320000'); INSERT INTO `china` VALUES ('320701', '市辖区', '320700'); INSERT INTO `china` VALUES ('320703', '连云区', '320701'); INSERT INTO `china` VALUES ('320705', '新浦区', '320701'); INSERT INTO `china` VALUES ('320706', '海州区', '320701'); INSERT INTO `china` VALUES ('320721', '赣榆县', '320700'); INSERT INTO `china` VALUES ('320722', '东海县', '320700'); INSERT INTO `china` VALUES ('320723', '灌云县', '320700'); INSERT INTO `china` VALUES ('320724', '灌南县', '320700'); INSERT INTO `china` VALUES ('320800', '淮安市', '320000'); INSERT INTO `china` VALUES ('320801', '市辖区', '320800'); INSERT INTO `china` VALUES ('320802', '清河区', '320801'); INSERT INTO `china` VALUES ('320803', '楚州区', '320801'); INSERT INTO `china` VALUES ('320804', '淮阴区', '320801'); INSERT INTO `china` VALUES ('320811', '清浦区', '320801'); INSERT INTO `china` VALUES ('320826', '涟水县', '320800'); INSERT INTO `china` VALUES ('320829', '洪泽县', '320800'); INSERT INTO `china` VALUES ('320830', '盱眙县', '320800'); INSERT INTO `china` VALUES ('320831', '金湖县', '320800'); INSERT INTO `china` VALUES ('320900', '盐城市', '320000'); INSERT INTO `china` VALUES ('320901', '市辖区', '320900'); INSERT INTO `china` VALUES ('320902', '亭湖区', '320901'); INSERT INTO `china` VALUES ('320903', '盐都区', '320901'); INSERT INTO `china` VALUES ('320921', '响水县', '320900'); INSERT INTO `china` VALUES ('320922', '滨海县', '320900'); INSERT INTO `china` VALUES ('320923', '阜宁县', '320900'); INSERT INTO `china` VALUES ('320924', '射阳县', '320900'); INSERT INTO `china` VALUES ('320925', '建湖县', '320900'); INSERT INTO `china` VALUES ('320981', '东台市', '320900'); INSERT INTO `china` VALUES ('320982', '大丰市', '320900'); INSERT INTO `china` VALUES ('321000', '扬州市', '320000'); INSERT INTO `china` VALUES ('321001', '市辖区', '321000'); INSERT INTO `china` VALUES ('321002', '广陵区', '321001'); INSERT INTO `china` VALUES ('321003', '邗江区', '321001'); INSERT INTO `china` VALUES ('321011', '维扬区', '321001'); INSERT INTO `china` VALUES ('321023', '宝应县', '321000'); INSERT INTO `china` VALUES ('321081', '仪征市', '321000'); INSERT INTO `china` VALUES ('321084', '高邮市', '321000'); INSERT INTO `china` VALUES ('321088', '江都市', '321000'); INSERT INTO `china` VALUES ('321100', '镇江市', '320000'); INSERT INTO `china` VALUES ('321101', '市辖区', '321100'); INSERT INTO `china` VALUES ('321102', '京口区', '321101'); INSERT INTO `china` VALUES ('321111', '润州区', '321101'); INSERT INTO `china` VALUES ('321112', '丹徒区', '321101'); INSERT INTO `china` VALUES ('321181', '丹阳市', '321100'); INSERT INTO `china` VALUES ('321182', '扬中市', '321100'); INSERT INTO `china` VALUES ('321183', '句容市', '321100'); INSERT INTO `china` VALUES ('321200', '泰州市', '320000'); INSERT INTO `china` VALUES ('321201', '市辖区', '321200'); INSERT INTO `china` VALUES ('321202', '海陵区', '321201'); INSERT INTO `china` VALUES ('321203', '高港区', '321201'); INSERT INTO `china` VALUES ('321281', '兴化市', '321200'); INSERT INTO `china` VALUES ('321282', '靖江市', '321200'); INSERT INTO `china` VALUES ('321283', '泰兴市', '321200'); INSERT INTO `china` VALUES ('321284', '姜堰市', '321200'); INSERT INTO `china` VALUES ('321300', '宿迁市', '320000'); INSERT INTO `china` VALUES ('321301', '市辖区', '321300'); INSERT INTO `china` VALUES ('321302', '宿城区', '321301'); INSERT INTO `china` VALUES ('321311', '宿豫区', '321301'); INSERT INTO `china` VALUES ('321322', '沭阳县', '321300'); INSERT INTO `china` VALUES ('321323', '泗阳县', '321300'); INSERT INTO `china` VALUES ('321324', '泗洪县', '321300'); INSERT INTO `china` VALUES ('330000', '浙江省', '0'); INSERT INTO `china` VALUES ('330100', '杭州市', '330000'); INSERT INTO `china` VALUES ('330101', '市辖区', '330100'); INSERT INTO `china` VALUES ('330102', '上城区', '330101'); INSERT INTO `china` VALUES ('330103', '下城区', '330101'); INSERT INTO `china` VALUES ('330104', '江干区', '330101'); INSERT INTO `china` VALUES ('330105', '拱墅区', '330101'); INSERT INTO `china` VALUES ('330106', '西湖区', '330101'); INSERT INTO `china` VALUES ('330108', '滨江区', '330101'); INSERT INTO `china` VALUES ('330109', '萧山区', '330101'); INSERT INTO `china` VALUES ('330110', '余杭区', '330101'); INSERT INTO `china` VALUES ('330122', '桐庐县', '330100'); INSERT INTO `china` VALUES ('330127', '淳安县', '330100'); INSERT INTO `china` VALUES ('330182', '建德市', '330100'); INSERT INTO `china` VALUES ('330183', '富阳市', '330100'); INSERT INTO `china` VALUES ('330185', '临安市', '330100'); INSERT INTO `china` VALUES ('330200', '宁波市', '330000'); INSERT INTO `china` VALUES ('330201', '市辖区', '330200'); INSERT INTO `china` VALUES ('330203', '海曙区', '330201'); INSERT INTO `china` VALUES ('330204', '江东区', '330201'); INSERT INTO `china` VALUES ('330205', '江北区', '330201'); INSERT INTO `china` VALUES ('330206', '北仑区', '330201'); INSERT INTO `china` VALUES ('330211', '镇海区', '330201'); INSERT INTO `china` VALUES ('330212', '鄞州区', '330201'); INSERT INTO `china` VALUES ('330225', '象山县', '330200'); INSERT INTO `china` VALUES ('330226', '宁海县', '330200'); INSERT INTO `china` VALUES ('330281', '余姚市', '330200'); INSERT INTO `china` VALUES ('330282', '慈溪市', '330200'); INSERT INTO `china` VALUES ('330283', '奉化市', '330200'); INSERT INTO `china` VALUES ('330300', '温州市', '330000'); INSERT INTO `china` VALUES ('330301', '市辖区', '330300'); INSERT INTO `china` VALUES ('330302', '鹿城区', '330301'); INSERT INTO `china` VALUES ('330303', '龙湾区', '330301'); INSERT INTO `china` VALUES ('330304', '瓯海区', '330301'); INSERT INTO `china` VALUES ('330322', '洞头县', '330300'); INSERT INTO `china` VALUES ('330324', '永嘉县', '330300'); INSERT INTO `china` VALUES ('330326', '平阳县', '330300'); INSERT INTO `china` VALUES ('330327', '苍南县', '330300'); INSERT INTO `china` VALUES ('330328', '文成县', '330300'); INSERT INTO `china` VALUES ('330329', '泰顺县', '330300'); INSERT INTO `china` VALUES ('330381', '瑞安市', '330300'); INSERT INTO `china` VALUES ('330382', '乐清市', '330300'); INSERT INTO `china` VALUES ('330400', '嘉兴市', '330000'); INSERT INTO `china` VALUES ('330401', '市辖区', '330400'); INSERT INTO `china` VALUES ('330402', '南湖区', '330401'); INSERT INTO `china` VALUES ('330411', '秀洲区', '330401'); INSERT INTO `china` VALUES ('330421', '嘉善县', '330400'); INSERT INTO `china` VALUES ('330424', '海盐县', '330400'); INSERT INTO `china` VALUES ('330481', '海宁市', '330400'); INSERT INTO `china` VALUES ('330482', '平湖市', '330400'); INSERT INTO `china` VALUES ('330483', '桐乡市', '330400'); INSERT INTO `china` VALUES ('330500', '湖州市', '330000'); INSERT INTO `china` VALUES ('330501', '市辖区', '330500'); INSERT INTO `china` VALUES ('330502', '吴兴区', '330501'); INSERT INTO `china` VALUES ('330503', '南浔区', '330501'); INSERT INTO `china` VALUES ('330521', '德清县', '330500'); INSERT INTO `china` VALUES ('330522', '长兴县', '330500'); INSERT INTO `china` VALUES ('330523', '安吉县', '330500'); INSERT INTO `china` VALUES ('330600', '绍兴市', '330000'); INSERT INTO `china` VALUES ('330601', '市辖区', '330600'); INSERT INTO `china` VALUES ('330602', '越城区', '330601'); INSERT INTO `china` VALUES ('330621', '绍兴县', '330600'); INSERT INTO `china` VALUES ('330624', '新昌县', '330600'); INSERT INTO `china` VALUES ('330681', '诸暨市', '330600'); INSERT INTO `china` VALUES ('330682', '上虞市', '330600'); INSERT INTO `china` VALUES ('330683', '嵊州市', '330600'); INSERT INTO `china` VALUES ('330700', '金华市', '330000'); INSERT INTO `china` VALUES ('330701', '市辖区', '330700'); INSERT INTO `china` VALUES ('330702', '婺城区', '330701'); INSERT INTO `china` VALUES ('330703', '金东区', '330701'); INSERT INTO `china` VALUES ('330723', '武义县', '330700'); INSERT INTO `china` VALUES ('330726', '浦江县', '330700'); INSERT INTO `china` VALUES ('330727', '磐安县', '330700'); INSERT INTO `china` VALUES ('330781', '兰溪市', '330700'); INSERT INTO `china` VALUES ('330782', '义乌市', '330700'); INSERT INTO `china` VALUES ('330783', '东阳市', '330700'); INSERT INTO `china` VALUES ('330784', '永康市', '330700'); INSERT INTO `china` VALUES ('330800', '衢州市', '330000'); INSERT INTO `china` VALUES ('330801', '市辖区', '330800'); INSERT INTO `china` VALUES ('330802', '柯城区', '330801'); INSERT INTO `china` VALUES ('330803', '衢江区', '330801'); INSERT INTO `china` VALUES ('330822', '常山县', '330800'); INSERT INTO `china` VALUES ('330824', '开化县', '330800'); INSERT INTO `china` VALUES ('330825', '龙游县', '330800'); INSERT INTO `china` VALUES ('330881', '江山市', '330800'); INSERT INTO `china` VALUES ('330900', '舟山市', '330000'); INSERT INTO `china` VALUES ('330901', '市辖区', '330900'); INSERT INTO `china` VALUES ('330902', '定海区', '330901'); INSERT INTO `china` VALUES ('330903', '普陀区', '330901'); INSERT INTO `china` VALUES ('330921', '岱山县', '330900'); INSERT INTO `china` VALUES ('330922', '嵊泗县', '330900'); INSERT INTO `china` VALUES ('331000', '台州市', '330000'); INSERT INTO `china` VALUES ('331001', '市辖区', '331000'); INSERT INTO `china` VALUES ('331002', '椒江区', '331001'); INSERT INTO `china` VALUES ('331003', '黄岩区', '331001'); INSERT INTO `china` VALUES ('331004', '路桥区', '331001'); INSERT INTO `china` VALUES ('331021', '玉环县', '331000'); INSERT INTO `china` VALUES ('331022', '三门县', '331000'); INSERT INTO `china` VALUES ('331023', '天台县', '331000'); INSERT INTO `china` VALUES ('331024', '仙居县', '331000'); INSERT INTO `china` VALUES ('331081', '温岭市', '331000'); INSERT INTO `china` VALUES ('331082', '临海市', '331000'); INSERT INTO `china` VALUES ('331100', '丽水市', '330000'); INSERT INTO `china` VALUES ('331101', '市辖区', '331100'); INSERT INTO `china` VALUES ('331102', '莲都区', '331101'); INSERT INTO `china` VALUES ('331121', '青田县', '331100'); INSERT INTO `china` VALUES ('331122', '缙云县', '331100'); INSERT INTO `china` VALUES ('331123', '遂昌县', '331100'); INSERT INTO `china` VALUES ('331124', '松阳县', '331100'); INSERT INTO `china` VALUES ('331125', '云和县', '331100'); INSERT INTO `china` VALUES ('331126', '庆元县', '331100'); INSERT INTO `china` VALUES ('331127', '景宁畲族自治县', '331100'); INSERT INTO `china` VALUES ('331181', '龙泉市', '331100'); INSERT INTO `china` VALUES ('340000', '安徽省', '0'); INSERT INTO `china` VALUES ('340100', '合肥市', '340000'); INSERT INTO `china` VALUES ('340101', '市辖区', '340100'); INSERT INTO `china` VALUES ('340102', '瑶海区', '340101'); INSERT INTO `china` VALUES ('340103', '庐阳区', '340101'); INSERT INTO `china` VALUES ('340104', '蜀山区', '340101'); INSERT INTO `china` VALUES ('340111', '包河区', '340101'); INSERT INTO `china` VALUES ('340121', '长丰县', '340100'); INSERT INTO `china` VALUES ('340122', '肥东县', '340100'); INSERT INTO `china` VALUES ('340123', '肥西县', '340100'); INSERT INTO `china` VALUES ('340124', '庐江县', '340100'); INSERT INTO `china` VALUES ('340181', '巢湖市', '340100'); INSERT INTO `china` VALUES ('340200', '芜湖市', '340000'); INSERT INTO `china` VALUES ('340201', '市辖区', '340200'); INSERT INTO `china` VALUES ('340202', '镜湖区', '340201'); INSERT INTO `china` VALUES ('340203', '马塘区', '340201'); INSERT INTO `china` VALUES ('340207', '鸠江区', '340201'); INSERT INTO `china` VALUES ('340221', '芜湖县', '340200'); INSERT INTO `china` VALUES ('340222', '繁昌县', '340200'); INSERT INTO `china` VALUES ('340223', '南陵县', '340200'); INSERT INTO `china` VALUES ('340225', '无为县', '340200'); INSERT INTO `china` VALUES ('340300', '蚌埠市', '340000'); INSERT INTO `china` VALUES ('340301', '市辖区', '340300'); INSERT INTO `china` VALUES ('340302', '龙子湖区', '340301'); INSERT INTO `china` VALUES ('340303', '蚌山区', '340301'); INSERT INTO `china` VALUES ('340304', '禹会区', '340301'); INSERT INTO `china` VALUES ('340311', '淮上区', '340301'); INSERT INTO `china` VALUES ('340321', '怀远县', '340300'); INSERT INTO `china` VALUES ('340322', '五河县', '340300'); INSERT INTO `china` VALUES ('340323', '固镇县', '340300'); INSERT INTO `china` VALUES ('340400', '淮南市', '340000'); INSERT INTO `china` VALUES ('340401', '市辖区', '340400'); INSERT INTO `china` VALUES ('340402', '大通区', '340401'); INSERT INTO `china` VALUES ('340403', '田家庵区', '340401'); INSERT INTO `china` VALUES ('340404', '谢家集区', '340401'); INSERT INTO `china` VALUES ('340405', '八公山区', '340401'); INSERT INTO `china` VALUES ('340406', '潘集区', '340401'); INSERT INTO `china` VALUES ('340421', '凤台县', '340400'); INSERT INTO `china` VALUES ('340500', '马鞍山市', '340000'); INSERT INTO `china` VALUES ('340501', '市辖区', '340500'); INSERT INTO `china` VALUES ('340502', '金家庄区', '340501'); INSERT INTO `china` VALUES ('340503', '花山区', '340501'); INSERT INTO `china` VALUES ('340504', '雨山区', '340501'); INSERT INTO `china` VALUES ('340521', '当涂县', '340500'); INSERT INTO `china` VALUES ('340522', '含山县', '340500'); INSERT INTO `china` VALUES ('340523', '和县', '340500'); INSERT INTO `china` VALUES ('340600', '淮北市', '340000'); INSERT INTO `china` VALUES ('340601', '市辖区', '340600'); INSERT INTO `china` VALUES ('340602', '杜集区', '340601'); INSERT INTO `china` VALUES ('340603', '相山区', '340601'); INSERT INTO `china` VALUES ('340604', '烈山区', '340601'); INSERT INTO `china` VALUES ('340621', '濉溪县', '340600'); INSERT INTO `china` VALUES ('340700', '铜陵市', '340000'); INSERT INTO `china` VALUES ('340701', '市辖区', '340700'); INSERT INTO `china` VALUES ('340702', '铜官山区', '340701'); INSERT INTO `china` VALUES ('340703', '狮子山区', '340701'); INSERT INTO `china` VALUES ('340711', '郊区', '340701'); INSERT INTO `china` VALUES ('340721', '铜陵县', '340700'); INSERT INTO `china` VALUES ('340800', '安庆市', '340000'); INSERT INTO `china` VALUES ('340801', '市辖区', '340800'); INSERT INTO `china` VALUES ('340802', '迎江区', '340801'); INSERT INTO `china` VALUES ('340803', '大观区', '340801'); INSERT INTO `china` VALUES ('340811', '宜秀区', '340801'); INSERT INTO `china` VALUES ('340822', '怀宁县', '340800'); INSERT INTO `china` VALUES ('340823', '枞阳县', '340800'); INSERT INTO `china` VALUES ('340824', '潜山县', '340800'); INSERT INTO `china` VALUES ('340825', '太湖县', '340800'); INSERT INTO `china` VALUES ('340826', '宿松县', '340800'); INSERT INTO `china` VALUES ('340827', '望江县', '340800'); INSERT INTO `china` VALUES ('340828', '岳西县', '340800'); INSERT INTO `china` VALUES ('340881', '桐城市', '340800'); INSERT INTO `china` VALUES ('341000', '黄山市', '340000'); INSERT INTO `china` VALUES ('341001', '黄山区', '341000'); INSERT INTO `china` VALUES ('341002', '屯溪区', '341000'); INSERT INTO `china` VALUES ('341004', '徽州区', '341000'); INSERT INTO `china` VALUES ('341021', '歙县', '341000'); INSERT INTO `china` VALUES ('341022', '休宁县', '341000'); INSERT INTO `china` VALUES ('341023', '黟县', '341000'); INSERT INTO `china` VALUES ('341024', '祁门县', '341000'); INSERT INTO `china` VALUES ('341091', '汤口镇', '341000'); INSERT INTO `china` VALUES ('341100', '滁州市', '340000'); INSERT INTO `china` VALUES ('341101', '市辖区', '341100'); INSERT INTO `china` VALUES ('341102', '琅琊区', '341101'); INSERT INTO `china` VALUES ('341103', '南谯区', '341101'); INSERT INTO `china` VALUES ('341122', '来安县', '341100'); INSERT INTO `china` VALUES ('341124', '全椒县', '341100'); INSERT INTO `china` VALUES ('341125', '定远县', '341100'); INSERT INTO `china` VALUES ('341126', '凤阳县', '341100'); INSERT INTO `china` VALUES ('341181', '天长市', '341100'); INSERT INTO `china` VALUES ('341182', '明光市', '341100'); INSERT INTO `china` VALUES ('341200', '阜阳市', '340000'); INSERT INTO `china` VALUES ('341201', '颍泉区', '341200'); INSERT INTO `china` VALUES ('341202', '颍州区', '341200'); INSERT INTO `china` VALUES ('341203', '颍东区', '341200'); INSERT INTO `china` VALUES ('341221', '临泉县', '341200'); INSERT INTO `china` VALUES ('341222', '太和县', '341200'); INSERT INTO `china` VALUES ('341225', '阜南县', '341200'); INSERT INTO `china` VALUES ('341226', '颍上县', '341200'); INSERT INTO `china` VALUES ('341282', '界首市', '341200'); INSERT INTO `china` VALUES ('341300', '宿州市', '340000'); INSERT INTO `china` VALUES ('341301', '市辖区', '341300'); INSERT INTO `china` VALUES ('341302', '埇桥区', '341301'); INSERT INTO `china` VALUES ('341321', '砀山县', '341300'); INSERT INTO `china` VALUES ('341322', '萧县', '341300'); INSERT INTO `china` VALUES ('341323', '灵璧县', '341300'); INSERT INTO `china` VALUES ('341324', '泗县', '341300'); INSERT INTO `china` VALUES ('341402', '居巢区', null); INSERT INTO `china` VALUES ('341500', '六安市', '340000'); INSERT INTO `china` VALUES ('341501', '市辖区', '341500'); INSERT INTO `china` VALUES ('341502', '金安区', '341501'); INSERT INTO `china` VALUES ('341503', '裕安区', '341501'); INSERT INTO `china` VALUES ('341521', '寿县', '341500'); INSERT INTO `china` VALUES ('341522', '霍邱县', '341500'); INSERT INTO `china` VALUES ('341523', '舒城县', '341500'); INSERT INTO `china` VALUES ('341524', '金寨县', '341500'); INSERT INTO `china` VALUES ('341525', '霍山县', '341500'); INSERT INTO `china` VALUES ('341600', '亳州市', '340000'); INSERT INTO `china` VALUES ('341601', '谯城区', '341600'); INSERT INTO `china` VALUES ('341621', '涡阳县', '341600'); INSERT INTO `china` VALUES ('341622', '蒙城县', '341600'); INSERT INTO `china` VALUES ('341623', '利辛县', '341600'); INSERT INTO `china` VALUES ('341700', '池州市', '340000'); INSERT INTO `china` VALUES ('341701', '市辖区', '341700'); INSERT INTO `china` VALUES ('341702', '贵池区', '341701'); INSERT INTO `china` VALUES ('341721', '东至县', '341700'); INSERT INTO `china` VALUES ('341722', '石台县', '341700'); INSERT INTO `china` VALUES ('341723', '青阳县', '341700'); INSERT INTO `china` VALUES ('341800', '宣城市', '340000'); INSERT INTO `china` VALUES ('341801', '市辖区', '341800'); INSERT INTO `china` VALUES ('341802', '宣州区', '341801'); INSERT INTO `china` VALUES ('341821', '郎溪县', '341800'); INSERT INTO `china` VALUES ('341822', '广德县', '341800'); INSERT INTO `china` VALUES ('341823', '泾县', '341800'); INSERT INTO `china` VALUES ('341824', '绩溪县', '341800'); INSERT INTO `china` VALUES ('341825', '旌德县', '341800'); INSERT INTO `china` VALUES ('341881', '宁国市', '341800'); INSERT INTO `china` VALUES ('350000', '福建省', '0'); INSERT INTO `china` VALUES ('350100', '福州市', '350000'); INSERT INTO `china` VALUES ('350101', '市辖区', '350100'); INSERT INTO `china` VALUES ('350102', '鼓楼区', '350101'); INSERT INTO `china` VALUES ('350103', '台江区', '350101'); INSERT INTO `china` VALUES ('350104', '仓山区', '350101'); INSERT INTO `china` VALUES ('350105', '马尾区', '350101'); INSERT INTO `china` VALUES ('350111', '晋安区', '350101'); INSERT INTO `china` VALUES ('350121', '闽侯县', '350100'); INSERT INTO `china` VALUES ('350122', '连江县', '350100'); INSERT INTO `china` VALUES ('350123', '罗源县', '350100'); INSERT INTO `china` VALUES ('350124', '闽清县', '350100'); INSERT INTO `china` VALUES ('350125', '永泰县', '350100'); INSERT INTO `china` VALUES ('350128', '平潭县', '350100'); INSERT INTO `china` VALUES ('350181', '福清市', '350100'); INSERT INTO `china` VALUES ('350182', '长乐市', '350100'); INSERT INTO `china` VALUES ('350200', '厦门市', '350000'); INSERT INTO `china` VALUES ('350201', '市辖区', '350200'); INSERT INTO `china` VALUES ('350203', '思明区', '350201'); INSERT INTO `china` VALUES ('350205', '海沧区', '350201'); INSERT INTO `china` VALUES ('350206', '湖里区', '350201'); INSERT INTO `china` VALUES ('350211', '集美区', '350201'); INSERT INTO `china` VALUES ('350212', '同安区', '350201'); INSERT INTO `china` VALUES ('350213', '翔安区', '350201'); INSERT INTO `china` VALUES ('350300', '莆田市', '350000'); INSERT INTO `china` VALUES ('350301', '市辖区', '350300'); INSERT INTO `china` VALUES ('350302', '城厢区', '350301'); INSERT INTO `china` VALUES ('350303', '涵江区', '350301'); INSERT INTO `china` VALUES ('350304', '荔城区', '350301'); INSERT INTO `china` VALUES ('350305', '秀屿区', '350301'); INSERT INTO `china` VALUES ('350322', '仙游县', '350300'); INSERT INTO `china` VALUES ('350400', '三明市', '350000'); INSERT INTO `china` VALUES ('350401', '市辖区', '350400'); INSERT INTO `china` VALUES ('350402', '梅列区', '350401'); INSERT INTO `china` VALUES ('350403', '三元区', '350401'); INSERT INTO `china` VALUES ('350421', '明溪县', '350400'); INSERT INTO `china` VALUES ('350423', '清流县', '350400'); INSERT INTO `china` VALUES ('350424', '宁化县', '350400'); INSERT INTO `china` VALUES ('350425', '大田县', '350400'); INSERT INTO `china` VALUES ('350426', '尤溪县', '350400'); INSERT INTO `china` VALUES ('350427', '沙县', '350400'); INSERT INTO `china` VALUES ('350428', '将乐县', '350400'); INSERT INTO `china` VALUES ('350429', '泰宁县', '350400'); INSERT INTO `china` VALUES ('350430', '建宁县', '350400'); INSERT INTO `china` VALUES ('350481', '永安市', '350400'); INSERT INTO `china` VALUES ('350500', '泉州市', '350000'); INSERT INTO `china` VALUES ('350501', '市辖区', '350500'); INSERT INTO `china` VALUES ('350502', '鲤城区', '350501'); INSERT INTO `china` VALUES ('350503', '丰泽区', '350501'); INSERT INTO `china` VALUES ('350504', '洛江区', '350501'); INSERT INTO `china` VALUES ('350505', '泉港区', '350501'); INSERT INTO `china` VALUES ('350521', '惠安县', '350500'); INSERT INTO `china` VALUES ('350524', '安溪县', '350500'); INSERT INTO `china` VALUES ('350525', '永春县', '350500'); INSERT INTO `china` VALUES ('350526', '德化县', '350500'); INSERT INTO `china` VALUES ('350527', '金门县', '350500'); INSERT INTO `china` VALUES ('350581', '石狮市', '350500'); INSERT INTO `china` VALUES ('350582', '晋江市', '350500'); INSERT INTO `china` VALUES ('350583', '南安市', '350500'); INSERT INTO `china` VALUES ('350600', '漳州市', '350000'); INSERT INTO `china` VALUES ('350601', '市辖区', '350600'); INSERT INTO `china` VALUES ('350602', '芗城区', '350601'); INSERT INTO `china` VALUES ('350603', '龙文区', '350601'); INSERT INTO `china` VALUES ('350622', '云霄县', '350600'); INSERT INTO `china` VALUES ('350623', '漳浦县', '350600'); INSERT INTO `china` VALUES ('350624', '诏安县', '350600'); INSERT INTO `china` VALUES ('350625', '长泰县', '350600'); INSERT INTO `china` VALUES ('350626', '东山县', '350600'); INSERT INTO `china` VALUES ('350627', '南靖县', '350600'); INSERT INTO `china` VALUES ('350628', '平和县', '350600'); INSERT INTO `china` VALUES ('350629', '华安县', '350600'); INSERT INTO `china` VALUES ('350681', '龙海市', '350600'); INSERT INTO `china` VALUES ('350700', '南平市', '350000'); INSERT INTO `china` VALUES ('350701', '市辖区', '350700'); INSERT INTO `china` VALUES ('350702', '延平区', '350701'); INSERT INTO `china` VALUES ('350721', '顺昌县', '350700'); INSERT INTO `china` VALUES ('350722', '浦城县', '350700'); INSERT INTO `china` VALUES ('350723', '光泽县', '350700'); INSERT INTO `china` VALUES ('350724', '松溪县', '350700'); INSERT INTO `china` VALUES ('350725', '政和县', '350700'); INSERT INTO `china` VALUES ('350781', '邵武市', '350700'); INSERT INTO `china` VALUES ('350782', '武夷山市', '350700'); INSERT INTO `china` VALUES ('350783', '建瓯市', '350700'); INSERT INTO `china` VALUES ('350784', '建阳市', '350700'); INSERT INTO `china` VALUES ('350800', '龙岩市', '350000'); INSERT INTO `china` VALUES ('350801', '市辖区', '350800'); INSERT INTO `china` VALUES ('350802', '新罗区', '350801'); INSERT INTO `china` VALUES ('350821', '长汀县', '350800'); INSERT INTO `china` VALUES ('350822', '永定县', '350800'); INSERT INTO `china` VALUES ('350823', '上杭县', '350800'); INSERT INTO `china` VALUES ('350824', '武平县', '350800'); INSERT INTO `china` VALUES ('350825', '连城县', '350800'); INSERT INTO `china` VALUES ('350881', '漳平市', '350800'); INSERT INTO `china` VALUES ('350900', '宁德市', '350000'); INSERT INTO `china` VALUES ('350901', '市辖区', '350900'); INSERT INTO `china` VALUES ('350902', '蕉城区', '350901'); INSERT INTO `china` VALUES ('350921', '霞浦县', '350900'); INSERT INTO `china` VALUES ('350922', '古田县', '350900'); INSERT INTO `china` VALUES ('350923', '屏南县', '350900'); INSERT INTO `china` VALUES ('350924', '寿宁县', '350900'); INSERT INTO `china` VALUES ('350925', '周宁县', '350900'); INSERT INTO `china` VALUES ('350926', '柘荣县', '350900'); INSERT INTO `china` VALUES ('350981', '福安市', '350900'); INSERT INTO `china` VALUES ('350982', '福鼎市', '350900'); INSERT INTO `china` VALUES ('360000', '江西省', '0'); INSERT INTO `china` VALUES ('360100', '南昌市', '360000'); INSERT INTO `china` VALUES ('360101', '市辖区', '360100'); INSERT INTO `china` VALUES ('360102', '东湖区', '360101'); INSERT INTO `china` VALUES ('360103', '西湖区', '360101'); INSERT INTO `china` VALUES ('360104', '青云谱区', '360101'); INSERT INTO `china` VALUES ('360105', '湾里区', '360101'); INSERT INTO `china` VALUES ('360111', '青山湖区', '360101'); INSERT INTO `china` VALUES ('360121', '南昌县', '360100'); INSERT INTO `china` VALUES ('360122', '新建县', '360100'); INSERT INTO `china` VALUES ('360123', '安义县', '360100'); INSERT INTO `china` VALUES ('360124', '进贤县', '360100'); INSERT INTO `china` VALUES ('360200', '景德镇市', '360000'); INSERT INTO `china` VALUES ('360201', '市辖区', '360200'); INSERT INTO `china` VALUES ('360202', '昌江区', '360201'); INSERT INTO `china` VALUES ('360203', '珠山区', '360201'); INSERT INTO `china` VALUES ('360222', '浮梁县', '360200'); INSERT INTO `china` VALUES ('360281', '乐平市', '360200'); INSERT INTO `china` VALUES ('360300', '萍乡市', '360000'); INSERT INTO `china` VALUES ('360301', '市辖区', '360300'); INSERT INTO `china` VALUES ('360302', '安源区', '360301'); INSERT INTO `china` VALUES ('360313', '湘东区', '360301'); INSERT INTO `china` VALUES ('360321', '莲花县', '360300'); INSERT INTO `china` VALUES ('360322', '上栗县', '360300'); INSERT INTO `china` VALUES ('360323', '芦溪县', '360300'); INSERT INTO `china` VALUES ('360400', '九江市', '360000'); INSERT INTO `china` VALUES ('360401', '市辖区', '360400'); INSERT INTO `china` VALUES ('360402', '庐山区', '360401'); INSERT INTO `china` VALUES ('360403', '浔阳区', '360401'); INSERT INTO `china` VALUES ('360421', '九江县', '360400'); INSERT INTO `china` VALUES ('360423', '武宁县', '360400'); INSERT INTO `china` VALUES ('360424', '修水县', '360400'); INSERT INTO `china` VALUES ('360425', '永修县', '360400'); INSERT INTO `china` VALUES ('360426', '德安县', '360400'); INSERT INTO `china` VALUES ('360427', '星子县', '360400'); INSERT INTO `china` VALUES ('360428', '都昌县', '360400'); INSERT INTO `china` VALUES ('360429', '湖口县', '360400'); INSERT INTO `china` VALUES ('360430', '彭泽县', '360400'); INSERT INTO `china` VALUES ('360481', '瑞昌市', '360400'); INSERT INTO `china` VALUES ('360482', '共青城市', '360400'); INSERT INTO `china` VALUES ('360500', '新余市', '360000'); INSERT INTO `china` VALUES ('360501', '市辖区', '360500'); INSERT INTO `china` VALUES ('360502', '渝水区', '360501'); INSERT INTO `china` VALUES ('360521', '分宜县', '360500'); INSERT INTO `china` VALUES ('360600', '鹰潭市', '360000'); INSERT INTO `china` VALUES ('360601', '市辖区', '360600'); INSERT INTO `china` VALUES ('360602', '月湖区', '360601'); INSERT INTO `china` VALUES ('360622', '余江县', '360600'); INSERT INTO `china` VALUES ('360681', '贵溪市', '360600'); INSERT INTO `china` VALUES ('360700', '赣州市', '360000'); INSERT INTO `china` VALUES ('360701', '市辖区', '360700'); INSERT INTO `china` VALUES ('360702', '章贡区', '360701'); INSERT INTO `china` VALUES ('360721', '赣县', '360700'); INSERT INTO `china` VALUES ('360722', '信丰县', '360700'); INSERT INTO `china` VALUES ('360723', '大余县', '360700'); INSERT INTO `china` VALUES ('360724', '上犹县', '360700'); INSERT INTO `china` VALUES ('360725', '崇义县', '360700'); INSERT INTO `china` VALUES ('360726', '安远县', '360700'); INSERT INTO `china` VALUES ('360727', '龙南县', '360700'); INSERT INTO `china` VALUES ('360728', '定南县', '360700'); INSERT INTO `china` VALUES ('360729', '全南县', '360700'); INSERT INTO `china` VALUES ('360730', '宁都县', '360700'); INSERT INTO `china` VALUES ('360731', '于都县', '360700'); INSERT INTO `china` VALUES ('360732', '兴国县', '360700'); INSERT INTO `china` VALUES ('360733', '会昌县', '360700'); INSERT INTO `china` VALUES ('360734', '寻乌县', '360700'); INSERT INTO `china` VALUES ('360735', '石城县', '360700'); INSERT INTO `china` VALUES ('360781', '瑞金市', '360700'); INSERT INTO `china` VALUES ('360782', '南康市', '360700'); INSERT INTO `china` VALUES ('360800', '吉安市', '360000'); INSERT INTO `china` VALUES ('360801', '市辖区', '360800'); INSERT INTO `china` VALUES ('360802', '吉州区', '360801'); INSERT INTO `china` VALUES ('360803', '青原区', '360801'); INSERT INTO `china` VALUES ('360821', '吉安县', '360800'); INSERT INTO `china` VALUES ('360822', '吉水县', '360800'); INSERT INTO `china` VALUES ('360823', '峡江县', '360800'); INSERT INTO `china` VALUES ('360824', '新干县', '360800'); INSERT INTO `china` VALUES ('360825', '永丰县', '360800'); INSERT INTO `china` VALUES ('360826', '泰和县', '360800'); INSERT INTO `china` VALUES ('360827', '遂川县', '360800'); INSERT INTO `china` VALUES ('360828', '万安县', '360800'); INSERT INTO `china` VALUES ('360829', '安福县', '360800'); INSERT INTO `china` VALUES ('360830', '永新县', '360800'); INSERT INTO `china` VALUES ('360881', '井冈山市', '360800'); INSERT INTO `china` VALUES ('360900', '宜春市', '360000'); INSERT INTO `china` VALUES ('360901', '市辖区', '360900'); INSERT INTO `china` VALUES ('360902', '袁州区', '360901'); INSERT INTO `china` VALUES ('360921', '奉新县', '360900'); INSERT INTO `china` VALUES ('360922', '万载县', '360900'); INSERT INTO `china` VALUES ('360923', '上高县', '360900'); INSERT INTO `china` VALUES ('360924', '宜丰县', '360900'); INSERT INTO `china` VALUES ('360925', '靖安县', '360900'); INSERT INTO `china` VALUES ('360926', '铜鼓县', '360900'); INSERT INTO `china` VALUES ('360981', '丰城市', '360900'); INSERT INTO `china` VALUES ('360982', '樟树市', '360900'); INSERT INTO `china` VALUES ('360983', '高安市', '360900'); INSERT INTO `china` VALUES ('361000', '抚州市', '360000'); INSERT INTO `china` VALUES ('361001', '市辖区', '361000'); INSERT INTO `china` VALUES ('361002', '临川区', '361001'); INSERT INTO `china` VALUES ('361021', '南城县', '361000'); INSERT INTO `china` VALUES ('361022', '黎川县', '361000'); INSERT INTO `china` VALUES ('361023', '南丰县', '361000'); INSERT INTO `china` VALUES ('361024', '崇仁县', '361000'); INSERT INTO `china` VALUES ('361025', '乐安县', '361000'); INSERT INTO `china` VALUES ('361026', '宜黄县', '361000'); INSERT INTO `china` VALUES ('361027', '金溪县', '361000'); INSERT INTO `china` VALUES ('361028', '资溪县', '361000'); INSERT INTO `china` VALUES ('361029', '东乡县', '361000'); INSERT INTO `china` VALUES ('361030', '广昌县', '361000'); INSERT INTO `china` VALUES ('361100', '上饶市', '360000'); INSERT INTO `china` VALUES ('361101', '市辖区', '361100'); INSERT INTO `china` VALUES ('361102', '信州区', '361101'); INSERT INTO `china` VALUES ('361121', '上饶县', '361100'); INSERT INTO `china` VALUES ('361122', '广丰县', '361100'); INSERT INTO `china` VALUES ('361123', '玉山县', '361100'); INSERT INTO `china` VALUES ('361124', '铅山县', '361100'); INSERT INTO `china` VALUES ('361125', '横峰县', '361100'); INSERT INTO `china` VALUES ('361126', '弋阳县', '361100'); INSERT INTO `china` VALUES ('361127', '余干县', '361100'); INSERT INTO `china` VALUES ('361128', '鄱阳县', '361100'); INSERT INTO `china` VALUES ('361129', '万年县', '361100'); INSERT INTO `china` VALUES ('361130', '婺源县', '361100'); INSERT INTO `china` VALUES ('361181', '德兴市', '361100'); INSERT INTO `china` VALUES ('370000', '山东省', '0'); INSERT INTO `china` VALUES ('370100', '济南市', '370000'); INSERT INTO `china` VALUES ('370101', '市辖区', '370100'); INSERT INTO `china` VALUES ('370102', '历下区', '370101'); INSERT INTO `china` VALUES ('370103', '市中区', '370101'); INSERT INTO `china` VALUES ('370104', '槐荫区', '370101'); INSERT INTO `china` VALUES ('370105', '天桥区', '370101'); INSERT INTO `china` VALUES ('370112', '历城区', '370101'); INSERT INTO `china` VALUES ('370113', '长清区', '370101'); INSERT INTO `china` VALUES ('370124', '平阴县', '370100'); INSERT INTO `china` VALUES ('370125', '济阳县', '370100'); INSERT INTO `china` VALUES ('370126', '商河县', '370100'); INSERT INTO `china` VALUES ('370181', '章丘市', '370100'); INSERT INTO `china` VALUES ('370200', '青岛市', '370000'); INSERT INTO `china` VALUES ('370201', '市辖区', '370200'); INSERT INTO `china` VALUES ('370202', '市南区', '370201'); INSERT INTO `china` VALUES ('370203', '市北区', '370201'); INSERT INTO `china` VALUES ('370205', '四方区', '370201'); INSERT INTO `china` VALUES ('370211', '黄岛区', '370201'); INSERT INTO `china` VALUES ('370212', '崂山区', '370201'); INSERT INTO `china` VALUES ('370213', '李沧区', '370201'); INSERT INTO `china` VALUES ('370214', '城阳区', '370201'); INSERT INTO `china` VALUES ('370281', '胶州市', '370200'); INSERT INTO `china` VALUES ('370282', '即墨市', '370200'); INSERT INTO `china` VALUES ('370283', '平度市', '370200'); INSERT INTO `china` VALUES ('370284', '胶南市', '370200'); INSERT INTO `china` VALUES ('370285', '莱西市', '370200'); INSERT INTO `china` VALUES ('370300', '淄博市', '370000'); INSERT INTO `china` VALUES ('370301', '市辖区', '370300'); INSERT INTO `china` VALUES ('370302', '淄川区', '370301'); INSERT INTO `china` VALUES ('370303', '张店区', '370301'); INSERT INTO `china` VALUES ('370304', '博山区', '370301'); INSERT INTO `china` VALUES ('370305', '临淄区', '370301'); INSERT INTO `china` VALUES ('370306', '周村区', '370301'); INSERT INTO `china` VALUES ('370321', '桓台县', '370300'); INSERT INTO `china` VALUES ('370322', '高青县', '370300'); INSERT INTO `china` VALUES ('370323', '沂源县', '370300'); INSERT INTO `china` VALUES ('370400', '枣庄市', '370000'); INSERT INTO `china` VALUES ('370401', '市辖区', '370400'); INSERT INTO `china` VALUES ('370402', '市中区', '370401'); INSERT INTO `china` VALUES ('370403', '薛城区', '370401'); INSERT INTO `china` VALUES ('370404', '峄城区', '370401'); INSERT INTO `china` VALUES ('370405', '台儿庄区', '370401'); INSERT INTO `china` VALUES ('370406', '山亭区', '370401'); INSERT INTO `china` VALUES ('370481', '滕州市', '370400'); INSERT INTO `china` VALUES ('370500', '东营市', '370000'); INSERT INTO `china` VALUES ('370501', '市辖区', '370500'); INSERT INTO `china` VALUES ('370502', '东营区', '370501'); INSERT INTO `china` VALUES ('370503', '河口区', '370501'); INSERT INTO `china` VALUES ('370521', '垦利县', '370500'); INSERT INTO `china` VALUES ('370522', '利津县', '370500'); INSERT INTO `china` VALUES ('370523', '广饶县', '370500'); INSERT INTO `china` VALUES ('370600', '烟台市', '370000'); INSERT INTO `china` VALUES ('370601', '市辖区', '370600'); INSERT INTO `china` VALUES ('370602', '芝罘区', '370601'); INSERT INTO `china` VALUES ('370611', '福山区', '370601'); INSERT INTO `china` VALUES ('370612', '牟平区', '370601'); INSERT INTO `china` VALUES ('370613', '莱山区', '370601'); INSERT INTO `china` VALUES ('370634', '长岛县', '370600');