1.查省
2.查市
3.查区
4.mysql脚本/* navicat mysql data transfer source server : mysql source server version : 50022 source host : 127.0.0.1:3306 source database : xlj target server type : mysql target server version : 50022 file encoding : 65001 date: 2014-07-19 21:22:47 */ set foreign_key_checks=0; -- ---------------------------- -- table structure for china -- ---------------------------- drop table if exists `china`; 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 ('120100', '和平区', '120000'); insert into `china` values ('120200', '河东区', '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 ('220100', '长春市', '220000'); insert into `china` values ('220101', '市辖区', '220100'); insert into `china` values ('220102', '南关区', '220101'); insert into `china` values ('220103', '宽城区', '220101'); insert into `china` values ('220104', '朝阳区', '220101'); insert into `china` values ('220105', '二道区', '220101'); insert into `china` values ('220106', '绿园区', '220101'); insert into `china` values ('220112', '双阳区', '220101'); insert into `china` values ('220122', '农安县', '220100'); insert into `china` values ('220181', '九台市', '220100'); insert into `china` values ('220182', '榆树市', '220100'); insert into `china` values ('220183', '德惠市', '220100'); insert into `china` values ('220200', '吉林市', '220000'); insert into `china` values ('220201', '市辖区', '220200'); insert into `china` values ('220202', '昌邑区', '220201'); insert into `china` values ('220203', '龙潭区', '220201'); insert into `china` values ('220204', '船营区', '220201'); insert into `china` values ('220211', '丰满区', '220201'); insert into `china` values ('220221', '永吉县', '220200'); insert into `china` values ('220281', '蛟河市', '220200'); insert into `china` values ('220282', '桦甸市', '220200'); insert into `china` values ('220283', '舒兰市', '220200'); insert into `china` values ('220284', '磐石市', '220200'); 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 ('320100', '南京市', '320000'); insert into `china` values ('320101', '市辖区', '320100'); insert into `china` values ('320102', '玄武区', '320101'); insert into `china` values ('320103', '白下区', '320101'); insert into `china` values ('320104', '秦淮区', '320101'); insert into `china` values ('320105', '建邺区', '320101'); insert into `china` values ('320106', '鼓楼区', '320101'); insert into `china` values ('320107', '下关区', '320101'); insert into `china` values ('320111', '浦口区', '320101'); insert into `china` values ('320113', '栖霞区', '320101'); insert into `china` values ('320114', '雨花台区', '320101'); insert into `china` values ('320115', '江宁区', '320101'); insert into `china` values ('320116', '六合区', '320101'); insert into `china` values ('320124', '溧水区', '320100'); insert into `china` values ('320125', '高淳区', '320100'); insert into `china` values ('320200', '无锡市', '320000'); insert into `china` values ('320201', '市辖区', '320200'); insert into `china` values ('320202', '崇安区', '320201'); insert into `china` values ('320203', '南长区', '320201'); insert into `china` values ('320204', '北塘区', '320201'); insert into `china` values ('320205', '锡山区', '320201'); insert into `china` values ('320206', '惠山区', '320201'); insert into `china` values ('320211', '滨湖区', '320201'); insert into `china` values ('320281', '江阴市', '320200'); insert into `china` values ('320282', '宜兴市', '320200'); 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` value