MySQL 中國省市區SQL表數據_ZenDei技術網路在線

1.查省SELECT * FROM china WHERE china.Pid=02.查市SELECT * FROM chinaWHERE china.Pid=3300003.查區SELECT * FROM china WHERE china.Pid = 3301004.Mysql腳本 DROP T ...

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腳本

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')