省、市、地区三级级联菜单(读数据库那种,Ajax异步调用,局部刷新)

AJAX/Jquery 专栏收录该内容
16 篇文章 0 订阅

areas.sql(这是数据库,直接导入即可,其中有建库的语句)
--------------------------------------------------------------------
/*
SQLyog Enterprise - MySQL GUI v6.15
MySQL - 5.0.37-community-nt : Database - areas
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `areas`;

USE `areas`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `area` */

DROP TABLE IF EXISTS `area`;

CREATE TABLE `area` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `areaID` int(4) unsigned NOT NULL,
  `areaName` varchar(40) NOT NULL,
  `areaFather` int(4) unsigned NOT NULL,
  UNIQUE KEY `areaID` (`areaID`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `area` */

insert  into `area`(`id`,`areaID`,`areaName`,`areaFather`) values (1,110101,'东城区',110100),(2,110102,'西城区',110100),(3,110103,'崇文区',110100),(4,110104,'宣武区',110100),(5,110105,'朝阳区',110100),(6,110106,'丰台区',110100),(7,110107,'石景山区',110100),(8,110108,'海淀区',110100),(9,110109,'门头沟区',110100),(10,110111,'房山区',110100),(11,110112,'通州区',110100),(12,110113,'顺义区',110100),(13,110114,'昌平区',110100),(14,110115,'大兴区',110100),(15,110116,'怀柔区',110100),(16,110117,'平谷区',110100),(17,110228,'密云县',110200),(18,110229,'延庆县',110200),(19,120101,'和平区',120100),(20,120102,'河东区',120100),(21,120103,'河西区',120100),(22,120104,'南开区',120100),(23,120105,'河北区',120100),(24,120106,'红桥区',120100),(25,120107,'塘沽区',120100),(26,120108,'汉沽区',120100),(27,120109,'大港区',120100),(28,120110,'东丽区',120100),(29,120111,'西青区',120100),(30,120112,'津南区',120100),(31,120113,'北辰区',120100),(32,120114,'武清区',120100),(33,120115,'宝坻区',120100),(34,120221,'宁河县',120200),(35,120223,'静海县',120200),(36,120225,'蓟 县',120200),(37,130101,'市辖区',130100),(38,130102,'长安区',130100),(39,130103,'桥东区',130100),(40,130104,'桥西区',130100),(41,130105,'新华区',130100),(42,130107,'井陉矿区',130100),(43,130108,'裕华区',130100),(44,130121,'井陉县',130100),(45,130123,'正定县',130100),(46,130124,'栾城县',130100),(47,130125,'行唐县',130100),(48,130126,'灵寿县',130100),(49,130127,'高邑县',130100),(50,130128,'深泽县',130100),(51,130129,'赞皇县',130100),(52,130130,'无极县',130100),(53,130131,'平山县',130100),(54,130132,'元氏县',130100),(55,130133,'赵 县',130100),(56,130181,'辛集市',130100),(57,130182,'藁城市',130100),(58,130183,'晋州市',130100),(59,130184,'新乐市',130100),(60,130185,'鹿泉市',130100),(61,130201,'市辖区',130200),(62,130202,'路南区',130200),(63,130203,'路北区',130200),(64,130204,'古冶区',130200),(65,130205,'开平区',130200),(66,130207,'丰南区',130200),(67,130208,'丰润区',130200),(68,130223,'滦 县',130200),(69,130224,'滦南县',130200),(70,130225,'乐亭县',130200),(71,130227,'迁西县',130200),(72,130229,'玉田县',130200),(73,130230,'唐海县',130200),(74,130281,'遵化市',130200),(75,130283,'迁安市',130200),(76,130301,'市辖区',130300),(77,130302,'海港区',130300),(78,130303,'山海关区',130300),(79,130304,'北戴河区',130300),(80,130321,'青龙满族自治县',130300),(81,130322,'昌黎县',130300),(82,130323,'抚宁县',130300),(83,130324,'卢龙县',130300),(84,130401,'市辖区',130400),(85,130402,'邯山区',130400),(86,130403,'丛台区',130400),(87,130404,'复兴区',130400),(88,130406,'峰峰矿区',130400),(89,130421,'邯郸县',130400),(90,130423,'临漳县',130400),(91,130424,'成安县',130400),(92,130425,'大名县',130400),(93,130426,'涉 县',130400),(94,130427,'磁 县',130400),(95,130428,'肥乡县',130400),(96,130429,'永年县',130400),(97,130430,'邱 县',130400),(98,130431,'鸡泽县',130400),(99,130432,'广平县',130400),(100,130433,'馆陶县',130400),(101,130434,'魏 县',130400),(102,130435,'曲周县',130400),(103,130481,'武安市',130400),(104,130501,'市辖区',130500),(105,130502,'桥东区',130500),(106,130503,'桥西区',130500),(107,130521,'邢台县',130500),(108,130522,'临城县',130500),(109,130523,'内丘县',130500),(110,130524,'柏乡县',130500),(111,130525,'隆尧县',130500),(112,130526,'任 县',130500),(113,130527,'南和县',130500),(114,130528,'宁晋县',130500),(115,130529,'巨鹿县',130500),(116,130530,'新河县',130500),(117,130531,'广宗县',130500),(118,130532,'平乡县',130500),(119,130533,'威 县',130500),(120,130534,'清河县',130500),(121,130535,'临西县',130500),(122,130581,'南宫市',130500),(123,130582,'沙河市',130500),(124,130601,'市辖区',130600),(125,130602,'新市区',130600),(126,130603,'北市区',130600),(127,130604,'南市区',130600),(128,130621,'满城县',130600),(129,130622,'清苑县',130600),(130,130623,'涞水县',130600),(131,130624,'阜平县',130600),(132,130625,'徐水县',130600),(133,130626,'定兴县',130600),(134,130627,'唐 县',130600),(135,130628,'高阳县',130600),(136,130629,'容城县',130600),(137,130630,'涞源县',130600),(138,130631,'望都县',130600),(139,130632,'安新县',130600),(140,130633,'易 县',130600),(141,130634,'曲阳县',130600),(142,130635,'蠡 县',130600),(143,130636,'顺平县',130600),(144,130637,'博野县',130600),(145,130638,'雄 县',130600),(146,130681,'涿州市',130600),(147,130682,'定州市',130600),(148,130683,'安国市',130600),(149,130684,'高碑店市',130600),(150,130701,'市辖区',130700),(151,130702,'桥东区',130700),(152,130703,'桥西区',130700),(153,130705,'宣化区',130700),(154,130706,'下花园区',130700),(155,130721,'宣化县',130700),(156,130722,'张北县',130700),(157,130723,'康保县',130700),(158,130724,'沽源县',130700),(159,130725,'尚义县',130700),(160,130726,'蔚 县',130700),(161,130727,'阳原县',130700),(162,130728,'怀安县',130700),(163,130729,'万全县',130700),(164,130730,'怀来县',130700),(165,130731,'涿鹿县',130700),(166,130732,'赤城县',130700),(167,130733,'崇礼县',130700),(168,130801,'市辖区',130800),(169,130802,'双桥区',130800),(170,130803,'双滦区',130800),(171,130804,'鹰手营子矿区',130800),(172,130821,'承德县',130800),(173,130822,'兴隆县',130800),(174,130823,'平泉县',130800),(175,130824,'滦平县',130800),(176,130825,'隆化县',130800),(177,130826,'丰宁满族自治县',130800),(178,130827,'宽城满族自治县',130800),(179,130828,'围场满族蒙古族自治县',130800),(180,130901,'市辖区',130900),(181,130902,'新华区',130900),(182,130903,'运河区',130900),(183,130921,'沧 县',130900),(184,130922,'青 县',130900),(185,130923,'东光县',130900),(186,130924,'海兴县',130900),(187,130925,'盐山县',130900),(188,130926,'肃宁县',130900),(189,130927,'南皮县',130900),(190,130928,'吴桥县',130900),(191,130929,'献 县',130900),(192,130930,'孟村回族自治县',130900),(193,130981,'泊头市',130900),(194,130982,'任丘市',130900),(195,130983,'黄骅市',130900),(196,130984,'河间市',130900),(197,131001,'市辖区',131000),(198,131002,'安次区',131000),(199,131003,'广阳区',131000),(200,131022,'固安县',131000),(201,131023,'永清县',131000),(202,131024,'香河县',131000),(203,131025,'大城县',131000),(204,131026,'文安县',131000),(205,131028,'大厂回族自治县',131000),(206,131081,'霸州市',131000),(207,131082,'三河市',131000),(208,131101,'市辖区',131100),(209,131102,'桃城区',131100),(210,131121,'枣强县',131100),(211,131122,'武邑县',131100),(212,131123,'武强县',131100),(213,131124,'饶阳县',131100),(214,131125,'安平县',131100),(215,131126,'故城县',131100),(216,131127,'景 县',131100),(217,131128,'阜城县',131100),(218,131181,'冀州市',131100),(219,131182,'深州市',131100),(220,140101,'市辖区',140100),(221,140105,'小店区',140100),(222,140106,'迎泽区',140100),(223,140107,'杏花岭区',140100),(224,140108,'尖草坪区',140100),(225,140109,'万柏林区',140100),(226,140110,'晋源区',140100),(227,140121,'清徐县',140100),(228,140122,'阳曲县',140100),(229,140123,'娄烦县',140100),(230,140181,'古交市',140100),(231,140201,'市辖区',140200),(232,140202,'城 区',140200),(233,140203,'矿 区',140200),(234,140211,'南郊区',140200),(235,140212,'新荣区',140200),(236,140221,'阳高县',140200),(237,140222,'天镇县',140200),(238,140223,'广灵县',140200),(239,140224,'灵丘县',140200),(240,140225,'浑源县',140200),(241,140226,'左云县',140200),(242,140227,'大同县',140200),(243,140301,'市辖区',140300),(244,140302,'城 区',140300),(245,140303,'矿 区',140300),(246,140311,'郊 区',140300),(247,140321,'平定县',140300),(248,140322,'盂 县',140300),(249,140401,'市辖区',140400),(250,140402,'城 区',140400),(251,140411,'郊 区',140400),(252,140421,'长治县',140400),(253,140423,'襄垣县',140400),(254,140424,'屯留县',140400),(255,140425,'平顺县',140400),(256,140426,'黎城县',140400),(257,140427,'壶关县',140400),(258,140428,'长子县',140400),(259,140429,'武乡县',140400),(260,140430,'沁 县',140400),(261,140431,'沁源县',140400),(262,140481,'潞城市',140400),(263,140501,'市辖区',140500),(264,140502,'城 区',140500),(265,140521,'沁水县',140500),(266,140522,'阳城县',140500),(267,140524,'陵川县',140500),(268,140525,'泽州县',140500),(269,140581,'高平市',140500),(270,140601,'市辖区',140600),(271,140602,'朔城区',140600),(272,140603,'平鲁区',140600),(273,140621,'山阴县',140600),(274,140622,'应 县',140600),(275,140623,'右玉县',140600),(276,140624,'怀仁县',140600),(277,140701,'市辖区',140700),(278,140702,'榆次区',140700),(279,140721,'榆社县',140700),(280,140722,'左权县',140700),(281,140723,'和顺县',140700),(282,140724,'昔阳县',140700),(283,140725,'寿阳县',140700),(284,140726,'太谷县',140700),(285,140727,'祁 县',140700),(286,140728,'平遥县',140700),(287,140729,'灵石县',140700),(288,140781,'介休市',140700),(289,140801,'市辖区',140800),(290,140802,'盐湖区',140800),(291,140821,'临猗县',140800),(292,140822,'万荣县',140800),(293,140823,'闻喜县',140800),(294,140824,'稷山县',140800),(295,140825,'新绛县',140800),(296,140826,'绛 县',140800),(297,140827,'垣曲县',140800),(298,140828,'夏 县',140800),(299,140829,'平陆县',140800),(300,140830,'芮城县',140800),(301,140881,'永济市',140800),(302,140882,'河津市',140800),(303,140901,'市辖区',140900),(304,140902,'忻府区',140900),(305,140921,'定襄县',140900),(306,140922,'五台县',140900),(307,140923,'代 县',140900),(308,140924,'繁峙县',140900),(309,140925,'宁武县',140900),(310,140926,'静乐县',140900),(311,140927,'神池县',140900),(312,140928,'五寨县',140900),(313,140929,'岢岚县',140900),(314,140930,'河曲县',140900),(315,140931,'保德县',140900),(316,140932,'偏关县',140900),(317,140981,'原平市',140900),(318,141001,'市辖区',141000),(319,141002,'尧都区',141000),(320,141021,'曲沃县',141000),(321,141022,'翼城县',141000),(322,141023,'襄汾县',141000),(323,141024,'洪洞县',141000),(324,141025,'古 县',141000),(325,141026,'安泽县',141000),(326,141027,'浮山县',141000),(327,141028,'吉 县',141000),(328,141029,'乡宁县',141000),(329,141030,'大宁县',141000),(330,141031,'隰 县',141000),(331,141032,'永和县',141000),(332,141033,'蒲 县',141000),(333,141034,'汾西县',141000),(334,141081,'侯马市',141000),(335,141082,'霍州市',141000),(336,141101,'市辖区',141100),(337,141102,'离石区',141100),(338,141121,'文水县',141100),(339,141122,'交城县',141100),(340,141123,'兴 县',141100),(341,141124,'临 县',141100),(342,141125,'柳林县',141100),(343,141126,'石楼县',141100),(344,141127,'岚 县',141100),(345,141128,'方山县',141100),(346,141129,'中阳县',141100),(347,141130,'交口县',141100),(348,141181,'孝义市',141100),(349,141182,'汾阳市',141100),(350,150101,'市辖区',150100),(351,150102,'新城区',150100),(352,150103,'回民区',150100),(353,150104,'玉泉区',150100),(354,150105,'赛罕区',150100),(355,150121,'土默特左旗',150100),(356,150122,'托克托县',150100),(357,150123,'和林格尔县',150100),(358,150124,'清水河县',150100),(359,150125,'武川县',150100),(360,150201,'市辖区',150200),(361,150202,'东河区',150200),(362,150203,'昆都仑区',150200),(363,150204,'青山区',150200),(364,150205,'石拐区',150200),(365,150206,'白云矿区',150200),(366,150207,'九原区',150200),(367,150221,'土默特右旗',150200),(368,150222,'固阳县',150200),(369,150223,'达尔罕茂明安联合旗',150200),(370,150301,'市辖区',150300),(371,150302,'海勃湾区',150300),(372,150303,'海南区',150300),(373,150304,'乌达区',150300),(374,150401,'市辖区',150400),(375,150402,'红山区',150400),(376,150403,'元宝山区',150400),(377,150404,'松山区',150400),(378,150421,'阿鲁科尔沁旗',150400),(379,150422,'巴林左旗',150400),(380,150423,'巴林右旗',150400),(381,150424,'林西县',150400),(382,150425,'克什克腾旗',150400),(383,150426,'翁牛特旗',150400),(384,150428,'喀喇沁旗',150400),(385,150429,'宁城县',150400),(386,150430,'敖汉旗',150400),(387,150501,'市辖区',150500),(388,150502,'科尔沁区',150500),(389,150521,'科尔沁左翼中旗',150500),(390,150522,'科尔沁左翼后旗',150500),(391,150523,'开鲁县',150500),(392,150524,'库伦旗',150500),(393,150525,'奈曼旗',150500),(394,150526,'扎鲁特旗',150500),(395,150581,'霍林郭勒市',150500),(396,150602,'东胜区',150600),(397,150621,'达拉特旗',150600),(398,150622,'准格尔旗',150600),(399,150623,'鄂托克前旗',150600),(400,150624,'鄂托克旗',150600),(401,150625,'杭锦旗',150600),(402,150626,'乌审旗',150600),(403,150627,'伊金霍洛旗',150600),(404,150701,'市辖区',150700),(405,150702,'海拉尔区',150700),(406,150721,'阿荣旗',150700),(407,150722,'莫力达瓦达斡尔族自治旗',150700),(408,150723,'鄂伦春自治旗',150700),(409,150724,'鄂温克族自治旗',150700),(410,150725,'陈巴尔虎旗',150700),(411,150726,'新巴尔虎左旗',150700),(412,150727,'新巴尔虎右旗',150700),(413,150781,'满洲里市',150700),(414,150782,'牙克石市',150700),(415,150783,'扎兰屯市',150700),(416,150784,'额尔古纳市',150700),(417,150785,'根河市',150700),(418,150801,'市辖区',150800),(419,150802,'临河区',150800),(420,150821,'五原县',150800),(421,150822,'磴口县',150800),(422,150823,'乌拉特前旗',150800),(423,150824,'乌拉特中旗',150800),(424,150825,'乌拉特后旗',150800),(425,150826,'杭锦后旗',150800),(426,150901,'市辖区',150900),(427,150902,'集宁区',150900),(428,150921,'卓资县',150900),(429,150922,'化德县',150900),(430,150923,'商都县',150900),(431,150924,'兴和县',150900),(432,150925,'凉城县',150900),(433,150926,'察哈尔右翼前旗',150900),(434,150927,'察哈尔右翼中旗',150900),(435,150928,'察哈尔右翼后旗',150900),(436,150929,'四子王旗',150900),(437,150981,'丰镇市',150900),(438,152201,'乌兰浩特市',152200),(439,152202,'阿尔山市',152200),(440,152221,'科尔沁右翼前旗',152200),(441,152222,'科尔沁右翼中旗',152200),(442,152223,'扎赉特旗',152200),(443,152224,'突泉县',152200),(444,152501,'二连浩特市',152500),(445,152502,'锡林浩特市',152500),(446,152522,'阿巴嘎旗',152500),(447,152523,'苏尼特左旗',152500),(448,152524,'苏尼特右旗',152500),(449,152525,'东乌珠穆沁旗',152500),(450,152526,'西乌珠穆沁旗',152500),(451,152527,'太仆寺旗',152500),(452,152528,'镶黄旗',152500),(453,152529,'正镶白旗',152500),(454,152530,'正蓝旗',152500),(455,152531,'多伦县',152500),(456,152921,'阿拉善左旗',152900),(457,152922,'阿拉善右旗',152900),(458,152923,'额济纳旗',152900),(459,210101,'市辖区',210100),(460,210102,'和平区',210100),(461,210103,'沈河区',210100),(462,210104,'大东区',210100),(463,210105,'皇姑区',210100),(464,210106,'铁西区',210100),(465,210111,'苏家屯区',210100),(466,210112,'东陵区',210100),(467,210113,'新城子区',210100),(468,210114,'于洪区',210100),(469,210122,'辽中县',210100),(470,210123,'康平县',210100),(471,210124,'法库县',210100),(472,210181,'新民市',210100),(473,210201,'市辖区',210200),(474,210202,'中山区',210200),(475,210203,'西岗区',210200),(476,210204,'沙河口区',210200),(477,210211,'甘井子区',210200),(478,210212,'旅顺口区',210200),(479,210213,'金州区',210200),(480,210224,'长海县',210200),(481,210281,'瓦房店市',210200),(482,210282,'普兰店市',210200),(483,210283,'庄河市',210200),(484,210301,'市辖区',210300),(485,210302,'铁东区',210300),(486,210303,'铁西区',210300),(487,210304,'立山区',210300),(488,210311,'千山区',210300),(489,210321,'台安县',210300),(490,210323,'岫岩满族自治县',210300),(491,210381,'海城市',210300),(492,210401,'市辖区',210400),(493,210402,'新抚区',210400),(494,210403,'东洲区',210400),(495,210404,'望花区',210400),(496,210411,'顺城区',210400),(497,210421,'抚顺县',210400),(498,210422,'新宾满族自治县',210400),(499,210423,'清原满族自治县',210400),(500,210501,'市辖区',210500),(501,210502,'平山区',210500),(502,210503,'溪湖区',210500),(503,210504,'明山区',210500),(504,210505,'南芬区',210500),(505,210521,'本溪满族自治县',210500),(506,210522,'桓仁满族自治县',210500),(507,210601,'市辖区',210600),(508,210602,'元宝区',210600),(509,210603,'振兴区',210600),(510,210604,'振安区',210600),(511,210624,'宽甸满族自治县',210600),(512,210681,'东港市',210600),(513,210682,'凤城市',210600),(514,210701,'市辖区',210700),(515,210702,'古塔区',210700),(516,210703,'凌河区',210700),(517,210711,'太和区',210700),(518,210726,'黑山县',210700),(519,210727,'义 县',210700),(520,210781,'凌海市',210700),(521,210782,'北宁市',210700),(522,210801,'市辖区',210800),(523,210802,'站前区',210800),(524,210803,'西市区',210800),(525,210804,'鲅鱼圈区',210800),(526,210811,'老边区',210800),(527,210881,'盖州市',210800),(528,210882,'大石桥市',210800),(529,210901,'市辖区',210900),(530,210902,'海州区',210900),(531,210903,'新邱区',210900),(532,210904,'太平区',210900),(533,210905,'清河门区',210900),(534,210911,'细河区',210900),(535,210921,'阜新蒙古族自治县',210900),(536,210922,'彰武县',210900),(537,211001,'市辖区',211000),(538,211002,'白塔区',211000),(539,211003,'文圣区',211000),(540,211004,'宏伟区',211000),(541,211005,'弓长岭区',211000),(542,211011,'太子河区',211000),(543,211021,'辽阳县',211000),(544,211081,'灯塔市',211000),(545,211101,'市辖区',211100),(546,211102,'双台子区',211100),(547,211103,'兴隆台区',211100),(548,211121,'大洼县',211100),(549,211122,'盘山县',211100),(550,211201,'市辖区',211200),(551,211202,'银州区',211200),(552,211204,'清河区',211200),(553,211221,'铁岭县',211200),(554,211223,'西丰县',211200),(555,211224,'昌图县',211200),(556,211281,'调兵山市',211200),(557,211282,'开原市',211200),(558,211301,'市辖区',211300),(559,211302,'双塔区',211300),(560,211303,'龙城区',211300),(561,211321,'朝阳县',211300),(562,211322,'建平县',211300),(563,211324,'喀喇沁左翼蒙古族自治县',211300),(564,211381,'北票市',211300),(565,211382,'凌源市',211300),(566,211401,'市辖区',211400),(567,211402,'连山区',211400),(568,211403,'龙港区',211400),(569,211404,'南票区',211400),(570,211421,'绥中县',211400),(571,211422,'建昌县',211400),(572,211481,'兴城市',211400),(573,220101,'市辖区',220100),(574,220102,'南关区',220100),(575,220103,'宽城区',220100),(576,220104,'朝阳区',220100),(577,220105,'二道区',220100),(578,220106,'绿园区',220100),(579,220112,'双阳区',220100),(580,220122,'农安县',220100),(581,220181,'九台市',220100),(582,220182,'榆树市',220100),(583,220183,'德惠市',220100),(584,220201,'市辖区',220200),(585,220202,'昌邑区',220200),(586,220203,'龙潭区',220200),(587,220204,'船营区',220200),(588,220211,'丰满区',220200),(589,220221,'永吉县',220200),(590,220281,'蛟河市',220200),(591,220282,'桦甸市',220200),(592,220283,'舒兰市',220200),(593,220284,'磐石市',220200),(594,220301,'市辖区',220300),(595,220302,'铁西区',220300),(596,220303,'铁东区',220300),(597,220322,'梨树县',220300),(598,220323,'伊通满族自治县',220300),(599,220381,'公主岭市',220300),(600,220382,'双辽市',220300),(601,220401,'市辖区',220400),(602,220402,'龙山区',220400),(603,220403,'西安区',220400),(604,220421,'东丰县',220400),(605,220422,'东辽县',220400),(606,220501,'市辖区',220500),(607,220502,'东昌区',220500),(608,220503,'二道江区',220500),(609,220521,'通化县',220500),(610,220523,'辉南县',220500),(611,220524,'柳河县',220500),(612,220581,'梅河口市',220500),(613,220582,'集安市',220500),(614,220601,'市辖区',220600),(615,220602,'八道江区',220600),(616,220621,'抚松县',220600),(617,220622,'靖宇县',220600),(618,220623,'长白朝鲜族自治县',220600),(619,220625,'江源县',220600),(620,220681,'临江市',220600),(621,220701,'市辖区',220700),(622,220702,'宁江区',220700),(623,220721,'前郭尔罗斯蒙古族自治县',220700),(624,220722,'长岭县',220700),(625,220723,'乾安县',220700),(626,220724,'扶余县',220700),(627,220801,'市辖区',220800),(628,220802,'洮北区',220800),(629,220821,'镇赉县',220800),(630,220822,'通榆县',220800),(631,220881,'洮南市',220800),(632,220882,'大安市',220800),(633,222401,'延吉市',222400),(634,222402,'图们市',222400),(635,222403,'敦化市',222400),(636,222404,'珲春市',222400),(637,222405,'龙井市',222400),(638,222406,'和龙市',222400),(639,222424,'汪清县',222400),(640,222426,'安图县',222400),(641,230101,'市辖区',230100),(642,230102,'道里区',230100),(643,230103,'南岗区',230100),(644,230104,'道外区',230100),(645,230106,'香坊区',230100),(646,230107,'动力区',230100),(647,230108,'平房区',230100),(648,230109,'松北区',230100),(649,230111,'呼兰区',230100),(650,230123,'依兰县',230100),(651,230124,'方正县',230100),(652,230125,'宾 县',230100),(653,230126,'巴彦县',230100),(654,230127,'木兰县',230100),(655,230128,'通河县',230100),(656,230129,'延寿县',230100),(657,230181,'阿城市',230100),(658,230182,'双城市',230100),(659,230183,'尚志市',230100),(660,230184,'五常市',230100),(661,230201,'市辖区',230200),(662,230202,'龙沙区',230200),(663,230203,'建华区',230200),(664,230204,'铁锋区',230200),(665,230205,'昂昂溪区',230200),(666,230206,'富拉尔基区',230200),(667,230207,'碾子山区',230200),(668,230208,'梅里斯达斡尔族区',230200),(669,230221,'龙江县',230200),(670,230223,'依安县',230200),(671,230224,'泰来县',230200),(672,230225,'甘南县',230200),(673,230227,'富裕县',230200),(674,230229,'克山县',230200),(675,230230,'克东县',230200),(676,230231,'拜泉县',230200),(677,230281,'讷河市',230200),(678,230301,'市辖区',230300),(679,230302,'鸡冠区',230300),(680,230303,'恒山区',230300),(681,230304,'滴道区',230300),(682,230305,'梨树区',230300),(683,230306,'城子河区',230300),(684,230307,'麻山区',230300),(685,230321,'鸡东县',230300),(686,230381,'虎林市',230300),(687,230382,'密山市',230300),(688,230401,'市辖区',230400),(689,230402,'向阳区',230400),(690,230403,'工农区',230400),(691,230404,'南山区',230400),(692,230405,'兴安区',230400),(693,230406,'东山区',230400),(694,230407,'兴山区',230400),(695,230421,'萝北县',230400),(696,230422,'绥滨县',230400),(697,230501,'市辖区',230500),(698,230502,'尖山区',230500),(699,230503,'岭东区',230500),(700,230505,'四方台区',230500),(701,230506,'宝山区',230500),(702,230521,'集贤县',230500),(703,230522,'友谊县',230500),(704,230523,'宝清县',230500),(705,230524,'饶河县',230500),(706,230601,'市辖区',230600),(707,230602,'萨尔图区',230600),(708,230603,'龙凤区',230600),(709,230604,'让胡路区',230600),(710,230605,'红岗区',230600),(711,230606,'大同区',230600),(712,230621,'肇州县',230600),(713,230622,'肇源县',230600),(714,230623,'林甸县',230600),(715,230624,'杜尔伯特蒙古族自治县',230600),(716,230701,'市辖区',230700),(717,230702,'伊春区',230700),(718,230703,'南岔区',230700),(719,230704,'友好区',230700),(720,230705,'西林区',230700),(721,230706,'翠峦区',230700),(722,230707,'新青区',230700),(723,230708,'美溪区',230700),(724,230709,'金山屯区',230700),(725,230710,'五营区',230700),(726,230711,'乌马河区',230700),(727,230712,'汤旺河区',230700),(728,230713,'带岭区',230700),(729,230714,'乌伊岭区',230700),(730,230715,'红星区',230700),(731,230716,'上甘岭区',230700),(732,230722,'嘉荫县',230700),(733,230781,'铁力市',230700),(734,230801,'市辖区',230800),(735,230802,'永红区',230800),(736,230803,'向阳区',230800),(737,230804,'前进区',230800),(738,230805,'东风区',230800),(739,230811,'郊 区',230800),(740,230822,'桦南县',230800),(741,230826,'桦川县',230800),(742,230828,'汤原县',230800),(743,230833,'抚远县',230800),(744,230881,'同江市',230800),(745,230882,'富锦市',230800),(746,230901,'市辖区',230900),(747,230902,'新兴区',230900),(748,230903,'桃山区',230900),(749,230904,'茄子河区',230900),(750,230921,'勃利县',230900),(751,231001,'市辖区',231000),(752,231002,'东安区',231000),(753,231003,'阳明区',231000),(754,231004,'爱民区',231000),(755,231005,'西安区',231000),(756,231024,'东宁县',231000),(757,231025,'林口县',231000),(758,231081,'绥芬河市',231000),(759,231083,'海林市',231000),(760,231084,'宁安市',231000),(761,231085,'穆棱市',231000),(762,231101,'市辖区',231100),(763,231102,'爱辉区',231100),(764,231121,'嫩江县',231100),(765,231123,'逊克县',231100),(766,231124,'孙吴县',231100),(767,231181,'北安市',231100),(768,231182,'五大连池市',231100),(769,231201,'市辖区',231200),(770,231202,'北林区',231200),(771,231221,'望奎县',231200),(772,231222,'兰西县',231200),(773,231223,'青冈县',231200),(774,231224,'庆安县',231200),(775,231225,'明水县',231200),(776,231226,'绥棱县',231200),(777,231281,'安达市',231200),(778,231282,'肇东市',231200),(779,231283,'海伦市',231200),(780,232721,'呼玛县',232700),(781,232722,'塔河县',232700),(782,232723,'漠河县',232700),(783,310101,'黄浦区',310100),(784,310103,'卢湾区',310100),(785,310104,'徐汇区',310100),(786,310105,'长宁区',310100),(787,310106,'静安区',310100),(788,310107,'普陀区',310100),(789,310108,'闸北区',310100),(790,310109,'虹口区',310100),(791,310110,'杨浦区',310100),(792,310112,'闵行区',310100),(793,310113,'宝山区',310100),(794,310114,'嘉定区',310100),(795,310115,'浦东新区',310100),(796,310116,'金山区',310100),(797,310117,'松江区',310100),(798,310118,'青浦区',310100),(799,310119,'南汇区',310100),(800,310120,'奉贤区',310100),(801,310230,'崇明县',310200),(802,320101,'市辖区',320100),(803,320102,'玄武区',320100),(804,320103,'白下区',320100),(805,320104,'秦淮区',320100),(806,320105,'建邺区',320100),(807,320106,'鼓楼区',320100),(808,320107,'下关区',320100),(809,320111,'浦口区',320100),(810,320113,'栖霞区',320100),(811,320114,'雨花台区',320100),(812,320115,'江宁区',320100),(813,320116,'六合区',320100),(814,320124,'溧水县',320100),(815,320125,'高淳县',320100),(816,320201,'市辖区',320200),(817,320202,'崇安区',320200),(818,320203,'南长区',320200),(819,320204,'北塘区',320200),(820,320205,'锡山区',320200),(821,320206,'惠山区',320200),(822,320211,'滨湖区',320200),(823,320281,'江阴市',320200),(824,320282,'宜兴市',320200),(825,320301,'市辖区',320300),(826,320302,'鼓楼区',320300),(827,320303,'云龙区',320300),(828,320304,'九里区',320300),(829,320305,'贾汪区',320300),(830,320311,'泉山区',320300),(831,320321,'丰 县',320300),(832,320322,'沛 县',320300),(833,320323,'铜山县',320300),(834,320324,'睢宁县',320300),(835,320381,'新沂市',320300),(836,320382,'邳州市',320300),(837,320401,'市辖区',320400),(838,320402,'天宁区',320400),(839,320404,'钟楼区',320400),(840,320405,'戚墅堰区',320400),(841,320411,'新北区',320400),(842,320412,'武进区',320400),(843,320481,'溧阳市',320400),(844,320482,'金坛市',320400),(845,320501,'市辖区',320500),(846,320502,'沧浪区',320500),(847,320503,'平江区',320500),(848,320504,'金阊区',320500),(849,320505,'虎丘区',320500),(850,320506,'吴中区',320500),(851,320507,'相城区',320500),(852,320581,'常熟市',320500),(853,320582,'张家港市',320500),(854,320583,'昆山市',320500),(855,320584,'吴江市',320500),(856,320585,'太仓市',320500),(857,320601,'市辖区',320600),(858,320602,'崇川区',320600),(859,320611,'港闸区',320600),(860,320621,'海安县',320600),(861,320623,'如东县',320600),(862,320681,'启东市',320600),(863,320682,'如皋市',320600),(864,320683,'通州市',320600),(865,320684,'海门市',320600),(866,320701,'市辖区',320700),(867,320703,'连云区',320700),(868,320705,'新浦区',320700),(869,320706,'海州区',320700),(870,320721,'赣榆县',320700),(871,320722,'东海县',320700),(872,320723,'灌云县',320700),(873,320724,'灌南县',320700),(874,320801,'市辖区',320800),(875,320802,'清河区',320800),(876,320803,'楚州区',320800),(877,320804,'淮阴区',320800),(878,320811,'清浦区',320800),(879,320826,'涟水县',320800),(880,320829,'洪泽县',320800),(881,320830,'盱眙县',320800),(882,320831,'金湖县',320800),(883,320901,'市辖区',320900),(884,320902,'亭湖区',320900),(885,320903,'盐都区',320900),(886,320921,'响水县',320900),(887,320922,'滨海县',320900),(888,320923,'阜宁县',320900),(889,320924,'射阳县',320900),(890,320925,'建湖县',320900),(891,320981,'东台市',320900),(892,320982,'大丰市',320900),(893,321001,'市辖区',321000),(894,321002,'广陵区',321000),(895,321003,'邗江区',321000),(896,321011,'郊 区',321000),(897,321023,'宝应县',321000),(898,321081,'仪征市',321000),(899,321084,'高邮市',321000),(900,321088,'江都市',321000),(901,321101,'市辖区',321100),(902,321102,'京口区',321100),(903,321111,'润州区',321100),(904,321112,'丹徒区',321100),(905,321181,'丹阳市',321100),(906,321182,'扬中市',321100),(907,321183,'句容市',321100),(908,321201,'市辖区',321200),(909,321202,'海陵区',321200),(910,321203,'高港区',321200),(911,321281,'兴化市',321200),(912,321282,'靖江市',321200),(913,321283,'泰兴市',321200),(914,321284,'姜堰市',321200),(915,321301,'市辖区',321300),(916,321302,'宿城区',321300),(917,321311,'宿豫区',321300),(918,321322,'沭阳县',321300),(919,321323,'泗阳县',321300),(920,321324,'泗洪县',321300),(921,330101,'市辖区',330100),(922,330102,'上城区',330100),(923,330103,'下城区',330100),(924,330104,'江干区',330100),(925,330105,'拱墅区',330100),(926,330106,'西湖区',330100),(927,330108,'滨江区',330100),(928,330109,'萧山区',330100),(929,330110,'余杭区',330100),(930,330122,'桐庐县',330100),(931,330127,'淳安县',330100),(932,330182,'建德市',330100),(933,330183,'富阳市',330100),(934,330185,'临安市',330100),(935,330201,'市辖区',330200),(936,330203,'海曙区',330200),(937,330204,'江东区',330200),(938,330205,'江北区',330200),(939,330206,'北仑区',330200),(940,330211,'镇海区',330200),(941,330212,'鄞州区',330200),(942,330225,'象山县',330200),(943,330226,'宁海县',330200),(944,330281,'余姚市',330200),(945,330282,'慈溪市',330200),(946,330283,'奉化市',330200),(947,330301,'市辖区',330300),(948,330302,'鹿城区',330300),(949,330303,'龙湾区',330300),(950,330304,'瓯海区',330300),(951,330322,'洞头县',330300),(952,330324,'永嘉县',330300),(953,330326,'平阳县',330300),(954,330327,'苍南县',330300),(955,330328,'文成县',330300),(956,330329,'泰顺县',330300),(957,330381,'瑞安市',330300),(958,330382,'乐清市',330300),(959,330401,'市辖区',330400),(960,330402,'秀城区',330400),(961,330411,'秀洲区',330400),(962,330421,'嘉善县',330400),(963,330424,'海盐县',330400),(964,330481,'海宁市',330400),(965,330482,'平湖市',330400),(966,330483,'桐乡市',330400),(967,330501,'市辖区',330500),(968,330502,'吴兴区',330500),(969,330503,'南浔区',330500),(970,330521,'德清县',330500),(971,330522,'长兴县',330500),(972,330523,'安吉县',330500),(973,330601,'市辖区',330600),(974,330602,'越城区',330600),(975,330621,'绍兴县',330600),(976,330624,'新昌县',330600),(977,330681,'诸暨市',330600),(978,330682,'上虞市',330600),(979,330683,'嵊州市',330600),(980,330701,'市辖区',330700),(981,330702,'婺城区',330700),(982,330703,'金东区',330700),(983,330723,'武义县',330700),(984,330726,'浦江县',330700),(985,330727,'磐安县',330700),(986,330781,'兰溪市',330700),(987,330782,'义乌市',330700),(988,330783,'东阳市',330700),(989,330784,'永康市',330700),(990,330801,'市辖区',330800),(991,330802,'柯城区',330800),(992,330803,'衢江区',330800),(993,330822,'常山县',330800),(994,330824,'开化县',330800),(995,330825,'龙游县',330800),(996,330881,'江山市',330800),(997,330901,'市辖区',330900),(998,330902,'定海区',330900),(999,330903,'普陀区',330900),(1000,330921,'岱山县',330900),(1001,330922,'嵊泗县',330900),(1002,331001,'市辖区',331000),(1003,331002,'椒江区',331000),(1004,331003,'黄岩区',331000),(1005,331004,'路桥区',331000),(1006,331021,'玉环县',331000),(1007,331022,'三门县',331000),(1008,331023,'天台县',331000),(1009,331024,'仙居县',331000),(1010,331081,'温岭市',331000),(1011,331082,'临海市',331000),(1012,331101,'市辖区',331100),(1013,331102,'莲都区',331100),(1014,331121,'青田县',331100),(1015,331122,'缙云县',331100),(1016,331123,'遂昌县',331100),(1017,331124,'松阳县',331100),(1018,331125,'云和县',331100),(1019,331126,'庆元县',331100),(1020,331127,'景宁畲族自治县',331100),(1021,331181,'龙泉市',331100),(1022,340101,'市辖区',340100),(1023,340102,'瑶海区',340100),(1024,340103,'庐阳区',340100),(1025,340104,'蜀山区',340100),(1026,340111,'包河区',340100),(1027,340121,'长丰县',340100),(1028,340122,'肥东县',340100),(1029,340123,'肥西县',340100),(1030,340201,'市辖区',340200),(1031,340202,'镜湖区',340200),(1032,340203,'马塘区',340200),(1033,340204,'新芜区',340200),(1034,340207,'鸠江区',340200),(1035,340221,'芜湖县',340200),(1036,340222,'繁昌县',340200),(1037,340223,'南陵县',340200),(1038,340301,'市辖区',340300),(1039,340302,'龙子湖区',340300),(1040,340303,'蚌山区',340300),(1041,340304,'禹会区',340300),(1042,340311,'淮上区',340300),(1043,340321,'怀远县',340300),(1044,340322,'五河县',340300),(1045,340323,'固镇县',340300),(1046,340401,'市辖区',340400),(1047,340402,'大通区',340400),(1048,340403,'田家庵区',340400),(1049,340404,'谢家集区',340400),(1050,340405,'八公山区',340400),(1051,340406,'潘集区',340400),(1052,340421,'凤台县',340400),(1053,340501,'市辖区',340500),(1054,340502,'金家庄区',340500),(1055,340503,'花山区',340500),(1056,340504,'雨山区',340500),(1057,340521,'当涂县',340500),(1058,340601,'市辖区',340600),(1059,340602,'杜集区',340600),(1060,340603,'相山区',340600),(1061,340604,'烈山区',340600),(1062,340621,'濉溪县',340600),(1063,340701,'市辖区',340700),(1064,340702,'铜官山区',340700),(1065,340703,'狮子山区',340700),(1066,340711,'郊 区',340700),(1067,340721,'铜陵县',340700),(1068,340801,'市辖区',340800),(1069,340802,'迎江区',340800),(1070,340803,'大观区',340800),(1071,340811,'郊 区',340800),(1072,340822,'怀宁县',340800),(1073,340823,'枞阳县',340800),(1074,340824,'潜山县',340800),(1075,340825,'太湖县',340800),(1076,340826,'宿松县',340800),(1077,340827,'望江县',340800),(1078,340828,'岳西县',340800),(1079,340881,'桐城市',340800),(1080,341001,'市辖区',341000),(1081,341002,'屯溪区',341000),(1082,341003,'黄山区',341000),(1083,341004,'徽州区',341000),(1084,341021,'歙 县',341000),(1085,341022,'休宁县',341000),(1086,341023,'黟 县',341000),(1087,341024,'祁门县',341000),(1088,341101,'市辖区',341100),(1089,341102,'琅琊区',341100),(1090,341103,'南谯区',341100),(1091,341122,'来安县',341100),(1092,341124,'全椒县',341100),(1093,341125,'定远县',341100),(1094,341126,'凤阳县',341100),(1095,341181,'天长市',341100),(1096,341182,'明光市',341100),(1097,341201,'市辖区',341200),(1098,341202,'颍州区',341200),(1099,341203,'颍东区',341200),(1100,341204,'颍泉区',341200),(1101,341221,'临泉县',341200),(1102,341222,'太和县',341200),(1103,341225,'阜南县',341200),(1104,341226,'颍上县',341200),(1105,341282,'界首市',341200),(1106,341301,'市辖区',341300),(1107,341302,'墉桥区',341300),(1108,341321,'砀山县',341300),(1109,341322,'萧 县',341300),(1110,341323,'灵璧县',341300),(1111,341324,'泗 县',341300),(1112,341401,'市辖区',341400),(1113,341402,'居巢区',341400),(1114,341421,'庐江县',341400),(1115,341422,'无为县',341400),(1116,341423,'含山县',341400),(1117,341424,'和 县',341400),(1118,341501,'市辖区',341500),(1119,341502,'金安区',341500),(1120,341503,'裕安区',341500),(1121,341521,'寿 县',341500),(1122,341522,'霍邱县',341500),(1123,341523,'舒城县',341500),(1124,341524,'金寨县',341500),(1125,341525,'霍山县',341500),(1126,341601,'市辖区',341600),(1127,341602,'谯城区',341600),(1128,341621,'涡阳县',341600),(1129,341622,'蒙城县',341600),(1130,341623,'利辛县',341600),(1131,341701,'市辖区',341700),(1132,341702,'贵池区',341700),(1133,341721,'东至县',341700),(1134,341722,'石台县',341700),(1135,341723,'青阳县',341700),(1136,341801,'市辖区',341800),(1137,341802,'宣州区',341800),(1138,341821,'郎溪县',341800),(1139,341822,'广德县',341800),(1140,341823,'泾 县',341800),(1141,341824,'绩溪县',341800),(1142,341825,'旌德县',341800),(1143,341881,'宁国市',341800),(1144,350101,'市辖区',350100),(1145,350102,'鼓楼区',350100),(1146,350103,'台江区',350100),(1147,350104,'仓山区',350100),(1148,350105,'马尾区',350100),(1149,350111,'晋安区',350100),(1150,350121,'闽侯县',350100),(1151,350122,'连江县',350100),(1152,350123,'罗源县',350100),(1153,350124,'闽清县',350100),(1154,350125,'永泰县',350100),(1155,350128,'平潭县',350100),(1156,350181,'福清市',350100),(1157,350182,'长乐市',350100),(1158,350201,'市辖区',350200),(1159,350203,'思明区',350200),(1160,350205,'海沧区',350200),(1161,350206,'湖里区',350200),(1162,350211,'集美区',350200),(1163,350212,'同安区',350200),(1164,350213,'翔安区',350200),(1165,350301,'市辖区',350300),(1166,350302,'城厢区',350300),(1167,350303,'涵江区',350300),(1168,350304,'荔城区',350300),(1169,350305,'秀屿区',350300),(1170,350322,'仙游县',350300),(1171,350401,'市辖区',350400),(1172,350402,'梅列区',350400),(1173,350403,'三元区',350400),(1174,350421,'明溪县',350400),(1175,350423,'清流县',350400),(1176,350424,'宁化县',350400),(1177,350425,'大田县',350400),(1178,350426,'尤溪县',350400),(1179,350427,'沙 县',350400),(1180,350428,'将乐县',350400),(1181,350429,'泰宁县',350400),(1182,350430,'建宁县',350400),(1183,350481,'永安市',350400),(1184,350501,'市辖区',350500),(1185,350502,'鲤城区',350500),(1186,350503,'丰泽区',350500),(1187,350504,'洛江区',350500),(1188,350505,'泉港区',350500),(1189,350521,'惠安县',350500),(1190,350524,'安溪县',350500),(1191,350525,'永春县',350500),(1192,350526,'德化县',350500),(1193,350527,'金门县',350500),(1194,350581,'石狮市',350500),(1195,350582,'晋江市',350500),(1196,350583,'南安市',350500),(1197,350601,'市辖区',350600),(1198,350602,'芗城区',350600),(1199,350603,'龙文区',350600),(1200,350622,'云霄县',350600),(1201,350623,'漳浦县',350600),(1202,350624,'诏安县',350600),(1203,350625,'长泰县',350600),(1204,350626,'东山县',350600),(1205,350627,'南靖县',350600),(1206,350628,'平和县',350600),(1207,350629,'华安县',350600),(1208,350681,'龙海市',350600),(1209,350701,'市辖区',350700),(1210,350702,'延平区',350700),(1211,350721,'顺昌县',350700),(1212,350722,'浦城县',350700),(1213,350723,'光泽县',350700),(1214,350724,'松溪县',350700),(1215,350725,'政和县',350700),(1216,350781,'邵武市',350700),(1217,350782,'武夷山市',350700),(1218,350783,'建瓯市',350700),(1219,350784,'建阳市',350700),(1220,350801,'市辖区',350800),(1221,350802,'新罗区',350800),(1222,350821,'长汀县',350800),(1223,350822,'永定县',350800),(1224,350823,'上杭县',350800),(1225,350824,'武平县',350800),(1226,350825,'连城县',350800),(1227,350881,'漳平市',350800),(1228,350901,'市辖区',350900),(1229,350902,'蕉城区',350900),(1230,350921,'霞浦县',350900),(1231,350922,'古田县',350900),(1232,350923,'屏南县',350900),(1233,350924,'寿宁县',350900),(1234,350925,'周宁县',350900),(1235,350926,'柘荣县',350900),(1236,350981,'福安市',350900),(1237,350982,'福鼎市',350900),(1238,360101,'市辖区',360100),(1239,360102,'东湖区',360100),(1240,360103,'西湖区',360100),(1241,360104,'青云谱区',360100),(1242,360105,'湾里区',360100),(1243,360111,'青山湖区',360100),(1244,360121,'南昌县',360100),(1245,360122,'新建县',360100),(1246,360123,'安义县',360100),(1247,360124,'进贤县',360100),(1248,360201,'市辖区',360200),(1249,360202,'昌江区',360200),(1250,360203,'珠山区',360200),(1251,360222,'浮梁县',360200),(1252,360281,'乐平市',360200),(1253,360301,'市辖区',360300),(1254,360302,'安源区',360300),(1255,360313,'湘东区',360300),(1256,360321,'莲花县',360300),(1257,360322,'上栗县',360300),(1258,360323,'芦溪县',360300),(1259,360401,'市辖区',360400),(1260,360402,'庐山区',360400),(1261,360403,'浔阳区',360400),(1262,360421,'九江县',360400),(1263,360423,'武宁县',360400),(1264,360424,'修水县',360400),(1265,360425,'永修县',360400),(1266,360426,'德安县',360400),(1267,360427,'星子县',360400),(1268,360428,'都昌县',360400),(1269,360429,'湖口县',360400),(1270,360430,'彭泽县',360400),(1271,360481,'瑞昌市',360400),(1272,360501,'市辖区',360500),(1273,360502,'渝水区',360500),(1274,360521,'分宜县',360500),(1275,360601,'市辖区',360600),(1276,360602,'月湖区',360600),(1277,360622,'余江县',360600),(1278,360681,'贵溪市',360600),(1279,360701,'市辖区',360700),(1280,360702,'章贡区',360700),(1281,360721,'赣 县',360700),(1282,360722,'信丰县',360700),(1283,360723,'大余县',360700),(1284,360724,'上犹县',360700),(1285,360725,'崇义县',360700),(1286,360726,'安远县',360700),(1287,360727,'龙南县',360700),(1288,360728,'定南县',360700),(1289,360729,'全南县',360700),(1290,360730,'宁都县',360700),(1291,360731,'于都县',360700),(1292,360732,'兴国县',360700),(1293,360733,'会昌县',360700),(1294,360734,'寻乌县',360700),(1295,360735,'石城县',360700),(1296,360781,'瑞金市',360700),(1297,360782,'南康市',360700),(1298,360801,'市辖区',360800),(1299,360802,'吉州区',360800),(1300,360803,'青原区',360800),(1301,360821,'吉安县',360800),(1302,360822,'吉水县',360800),(1303,360823,'峡江县',360800),(1304,360824,'新干县',360800),(1305,360825,'永丰县',360800),(1306,360826,'泰和县',360800),(1307,360827,'遂川县',360800),(1308,360828,'万安县',360800),(1309,360829,'安福县',360800),(1310,360830,'永新县',360800),(1311,360881,'井冈山市',360800),(1312,360901,'市辖区',360900),(1313,360902,'袁州区',360900),(1314,360921,'奉新县',360900),(1315,360922,'万载县',360900),(1316,360923,'上高县',360900),(1317,360924,'宜丰县',360900),(1318,360925,'靖安县',360900),(1319,360926,'铜鼓县',360900),(1320,360981,'丰城市',360900),(1321,360982,'樟树市',360900),(1322,360983,'高安市',360900),(1323,361001,'市辖区',361000),(1324,361002,'临川区',361000),(1325,361021,'南城县',361000),(1326,361022,'黎川县',361000),(1327,361023,'南丰县',361000),(1328,361024,'崇仁县',361000),(1329,361025,'乐安县',361000),(1330,361026,'宜黄县',361000),(1331,361027,'金溪县',361000),(1332,361028,'资溪县',361000),(1333,361029,'东乡县',361000),(1334,361030,'广昌县',361000),(1335,361101,'市辖区',361100),(1336,361102,'信州区',361100),(1337,361121,'上饶县',361100),(1338,361122,'广丰县',361100),(1339,361123,'玉山县',361100),(1340,361124,'铅山县',361100),(1341,361125,'横峰县',361100),(1342,361126,'弋阳县',361100),(1343,361127,'余干县',361100),(1344,361128,'鄱阳县',361100),(1345,361129,'万年县',361100),(1346,361130,'婺源县',361100),(1347,361181,'德兴市',361100),(1348,370101,'市辖区',370100),(1349,370102,'历下区',370100),(1350,370103,'市中区',370100),(1351,370104,'槐荫区',370100),(1352,370105,'天桥区',370100),(1353,370112,'历城区',370100),(1354,370113,'长清区',370100),(1355,370124,'平阴县',370100),(1356,370125,'济阳县',370100),(1357,370126,'商河县',370100),(1358,370181,'章丘市',370100),(1359,370201,'市辖区',370200),(1360,370202,'市南区',370200),(1361,370203,'市北区',370200),(1362,370205,'四方区',370200),(1363,370211,'黄岛区',370200),(1364,370212,'崂山区',370200),(1365,370213,'李沧区',370200),(1366,370214,'城阳区',370200),(1367,370281,'胶州市',370200),(1368,370282,'即墨市',370200),(1369,370283,'平度市',370200),(1370,370284,'胶南市',370200),(1371,370285,'莱西市',370200),(1372,370301,'市辖区',370300),(1373,370302,'淄川区',370300),(1374,370303,'张店区',370300),(1375,370304,'博山区',370300),(1376,370305,'临淄区',370300),(1377,370306,'周村区',370300),(1378,370321,'桓台县',370300),(1379,370322,'高青县',370300),(1380,370323,'沂源县',370300),(1381,370401,'市辖区',370400),(1382,370402,'市中区',370400),(1383,370403,'薛城区',370400),(1384,370404,'峄城区',370400),(1385,370405,'台儿庄区',370400),(1386,370406,'山亭区',370400),(1387,370481,'滕州市',370400),(1388,370501,'市辖区',370500),(1389,370502,'东营区',370500),(1390,370503,'河口区',370500),(1391,370521,'垦利县',370500),(1392,370522,'利津县',370500),(1393,370523,'广饶县',370500),(1394,370601,'市辖区',370600),(1395,370602,'芝罘区',370600),(1396,370611,'福山区',370600),(1397,370612,'牟平区',370600),(1398,370613,'莱山区',370600),(1399,370634,'长岛县',370600),(1400,370681,'龙口市',370600),(1401,370682,'莱阳市',370600),(1402,370683,'莱州市',370600),(1403,370684,'蓬莱市',370600),(1404,370685,'招远市',370600),(1405,370686,'栖霞市',370600),(1406,370687,'海阳市',370600),(1407,370701,'市辖区',370700),(1408,370702,'潍城区',370700),(1409,370703,'寒亭区',370700),(1410,370704,'坊子区',370700),(1411,370705,'奎文区',370700),(1412,370724,'临朐县',370700),(1413,370725,'昌乐县',370700),(1414,370781,'青州市',370700),(1415,370782,'诸城市',370700),(1416,370783,'寿光市',370700),(1417,370784,'安丘市',370700),(1418,370785,'高密市',370700),(1419,370786,'昌邑市',370700),(1420,370801,'市辖区',370800),(1421,370802,'市中区',370800),(1422,370811,'任城区',370800),(1423,370826,'微山县',370800),(1424,370827,'鱼台县',370800),(1425,370828,'金乡县',370800),(1426,370829,'嘉祥县',370800),(1427,370830,'汶上县',370800),(1428,370831,'泗水县',370800),(1429,370832,'梁山县',370800),(1430,370881,'曲阜市',370800),(1431,370882,'兖州市',370800),(1432,370883,'邹城市',370800),(1433,370901,'市辖区',370900),(1434,370902,'泰山区',370900),(1435,370903,'岱岳区',370900),(1436,370921,'宁阳县',370900),(1437,370923,'东平县',370900),(1438,370982,'新泰市',370900),(1439,370983,'肥城市',370900),(1440,371001,'市辖区',371000),(1441,371002,'环翠区',371000),(1442,371081,'文登市',371000),(1443,371082,'荣成市',371000),(1444,371083,'乳山市',371000),(1445,371101,'市辖区',371100),(1446,371102,'东港区',371100),(1447,371103,'岚山区',371100),(1448,371121,'五莲县',371100),(1449,371122,'莒 县',371100),(1450,371201,'市辖区',371200),(1451,371202,'莱城区',371200),(1452,371203,'钢城区',371200),(1453,371301,'市辖区',371300),(1454,371302,'兰山区',371300),(1455,371311,'罗庄区',371300),(1456,371312,'河东区',371300),(1457,371321,'沂南县',371300),(1458,371322,'郯城县',371300),(1459,371323,'沂水县',371300),(1460,371324,'苍山县',371300),(1461,371325,'费 县',371300),(1462,371326,'平邑县',371300),(1463,371327,'莒南县',371300),(1464,371328,'蒙阴县',371300),(1465,371329,'临沭县',371300),(1466,371401,'市辖区',371400),(1467,371402,'德城区',371400),(1468,371421,'陵 县',371400),(1469,371422,'宁津县',371400),(1470,371423,'庆云县',371400),(1471,371424,'临邑县',371400),(1472,371425,'齐河县',371400),(1473,371426,'平原县',371400),(1474,371427,'夏津县',371400),(1475,371428,'武城县',371400),(1476,371481,'乐陵市',371400),(1477,371482,'禹城市',371400),(1478,371501,'市辖区',371500),(1479,371502,'东昌府区',371500),(1480,371521,'阳谷县',371500),(1481,371522,'莘 县',371500),(1482,371523,'茌平县',371500),(1483,371524,'东阿县',371500),(1484,371525,'冠 县',371500),(1485,371526,'高唐县',371500),(1486,371581,'临清市',371500),(1487,371601,'市辖区',371600),(1488,371602,'滨城区',371600),(1489,371621,'惠民县',371600),(1490,371622,'阳信县',371600),(1491,371623,'无棣县',371600),(1492,371624,'沾化县',371600),(1493,371625,'博兴县',371600),(1494,371626,'邹平县',371600),(1495,371701,'市辖区',371700),(1496,371702,'牡丹区',371700),(1497,371721,'曹 县',371700),(1498,371722,'单 县',371700),(1499,371723,'成武县',371700),(1500,371724,'巨野县',371700),(1501,371725,'郓城县',371700),(1502,371726,'鄄城县',371700),(1503,371727,'定陶县',371700),(1504,371728,'东明县',371700),(1505,410101,'市辖区',410100),(1506,410102,'中原区',410100),(1507,410103,'二七区',410100),(1508,410104,'管城回族区',410100),(1509,410105,'金水区',410100),(1510,410106,'上街区',410100),(1511,410108,'邙山区',410100),(1512,410122,'中牟县',410100),(1513,410181,'巩义市',410100),(1514,410182,'荥阳市',410100),(1515,410183,'新密市',410100),(1516,410184,'新郑市',410100),(1517,410185,'登封市',410100),(1518,410201,'市辖区',410200),(1519,410202,'龙亭区',410200),(1520,410203,'顺河回族区',410200),(1521,410204,'鼓楼区',410200),(1522,410205,'南关区',410200),(1523,410211,'郊 区',410200),(1524,410221,'杞 县',410200),(1525,410222,'通许县',410200),(1526,410223,'尉氏县',410200),(1527,410224,'开封县',410200),(1528,410225,'兰考县',410200),(1529,410301,'市辖区',410300),(1530,410302,'老城区',410300),(1531,410303,'西工区',410300),(1532,410304,'廛河回族区',410300),(1533,410305,'涧西区',410300),(1534,410306,'吉利区',410300),(1535,410307,'洛龙区',410300),(1536,410322,'孟津县',410300),(1537,410323,'新安县',410300),(1538,410324,'栾川县',410300),(1539,410325,'嵩 县',410300),(1540,410326,'汝阳县',410300),(1541,410327,'宜阳县',410300),(1542,410328,'洛宁县',410300),(1543,410329,'伊川县',410300),(1544,410381,'偃师市',410300),(1545,410401,'市辖区',410400),(1546,410402,'新华区',410400),(1547,410403,'卫东区',410400),(1548,410404,'石龙区',410400),(1549,410411,'湛河区',410400),(1550,410421,'宝丰县',410400),(1551,410422,'叶 县',410400),(1552,410423,'鲁山县',410400),(1553,410425,'郏 县',410400),(1554,410481,'舞钢市',410400),(1555,410482,'汝州市',410400),(1556,410501,'市辖区',410500),(1557,410502,'文峰区',410500),(1558,410503,'北关区',410500),(1559,410505,'殷都区',410500),(1560,410506,'龙安区',410500),(1561,410522,'安阳县',410500),(1562,410523,'汤阴县',410500),(1563,410526,'滑 县',410500),(1564,410527,'内黄县',410500),(1565,410581,'林州市',410500),(1566,410601,'市辖区',410600),(1567,410602,'鹤山区',410600),(1568,410603,'山城区',410600),(1569,410611,'淇滨区',410600),(1570,410621,'浚 县',410600),(1571,410622,'淇 县',410600),(1572,410701,'市辖区',410700),(1573,410702,'红旗区',410700),(1574,410703,'卫滨区',410700),(1575,410704,'凤泉区',410700),(1576,410711,'牧野区',410700),(1577,410721,'新乡县',410700),(1578,410724,'获嘉县',410700),(1579,410725,'原阳县',410700),(1580,410726,'延津县',410700),(1581,410727,'封丘县',410700),(1582,410728,'长垣县',410700),(1583,410781,'卫辉市',410700),(1584,410782,'辉县市',410700),(1585,410801,'市辖区',410800),(1586,410802,'解放区',410800),(1587,410803,'中站区',410800),(1588,410804,'马村区',410800),(1589,410811,'山阳区',410800),(1590,410821,'修武县',410800),(1591,410822,'博爱县',410800),(1592,410823,'武陟县',410800),(1593,410825,'温 县',410800),(1594,410881,'济源市',410800),(1595,410882,'沁阳市',410800),(1596,410883,'孟州市',410800),(1597,410901,'市辖区',410900),(1598,410902,'华龙区',410900),(1599,410922,'清丰县',410900),(1600,410923,'南乐县',410900),(1601,410926,'范 县',410900),(1602,410927,'台前县',410900),(1603,410928,'濮阳县',410900),(1604,411001,'市辖区',411000),(1605,411002,'魏都区',411000),(1606,411023,'许昌县',411000),(1607,411024,'鄢陵县',411000),(1608,411025,'襄城县',411000),(1609,411081,'禹州市',411000),(1610,411082,'长葛市',411000),(1611,411101,'市辖区',411100),(1612,411102,'源汇区',411100),(1613,411103,'郾城区',411100),(1614,411104,'召陵区',411100),(1615,411121,'舞阳县',411100),(1616,411122,'临颍县',411100),(1617,411201,'市辖区',411200),(1618,411202,'湖滨区',411200),(1619,411221,'渑池县',411200),(1620,411222,'陕 县',411200),(1621,411224,'卢氏县',411200),(1622,411281,'义马市',411200),(1623,411282,'灵宝市',411200),(1624,411301,'市辖区',411300),(1625,411302,'宛城区',411300),(1626,411303,'卧龙区',411300),(1627,411321,'南召县',411300),(1628,411322,'方城县',411300),(1629,411323,'西峡县',411300),(1630,411324,'镇平县',411300),(1631,411325,'内乡县',411300),(1632,411326,'淅川县',411300),(1633,411327,'社旗县',411300),(1634,411328,'唐河县',411300),(1635,411329,'新野县',411300),(1636,411330,'桐柏县',411300),(1637,411381,'邓州市',411300),(1638,411401,'市辖区',411400),(1639,411402,'梁园区',411400),(1640,411403,'睢阳区',411400),(1641,411421,'民权县',411400),(1642,411422,'睢 县',411400),(1643,411423,'宁陵县',411400),(1644,411424,'柘城县',411400),(1645,411425,'虞城县',411400),(1646,411426,'夏邑县',411400),(1647,411481,'永城市',411400),(1648,411501,'市辖区',411500),(1649,411502,'师河区',411500),(1650,411503,'平桥区',411500),(1651,411521,'罗山县',411500),(1652,411522,'光山县',411500),(1653,411523,'新 县',411500),(1654,411524,'商城县',411500),(1655,411525,'固始县',411500),(1656,411526,'潢川县',411500),(1657,411527,'淮滨县',411500),(1658,411528,'息 县',411500),(1659,411601,'市辖区',411600),(1660,411602,'川汇区',411600),(1661,411621,'扶沟县',411600),(1662,411622,'西华县',411600),(1663,411623,'商水县',411600),(1664,411624,'沈丘县',411600),(1665,411625,'郸城县',411600),(1666,411626,'淮阳县',411600),(1667,411627,'太康县',411600),(1668,411628,'鹿邑县',411600),(1669,411681,'项城市',411600),(1670,411701,'市辖区',411700),(1671,411702,'驿城区',411700),(1672,411721,'西平县',411700),(1673,411722,'上蔡县',411700),(1674,411723,'平舆县',411700),(1675,411724,'正阳县',411700),(1676,411725,'确山县',411700),(1677,411726,'泌阳县',411700),(1678,411727,'汝南县',411700),(1679,411728,'遂平县',411700),(1680,411729,'新蔡县',411700),(1681,420101,'市辖区',420100),(1682,420102,'江岸区',420100),(1683,420103,'江汉区',420100),(1684,420104,'乔口区',420100),(1685,420105,'汉阳区',420100),(1686,420106,'武昌区',420100),(1687,420107,'青山区',420100),(1688,420111,'洪山区',420100),(1689,420112,'东西湖区',420100),(1690,420113,'汉南区',420100),(1691,420114,'蔡甸区',420100),(1692,420115,'江夏区',420100),(1693,420116,'黄陂区',420100),(1694,420117,'新洲区',420100),(1695,420201,'市辖区',420200),(1696,420202,'黄石港区',420200),(1697,420203,'西塞山区',420200),(1698,420204,'下陆区',420200),(1699,420205,'铁山区',420200),(1700,420222,'阳新县',420200),(1701,420281,'大冶市',420200),(1702,420301,'市辖区',420300),(1703,420302,'茅箭区',420300),(1704,420303,'张湾区',420300),(1705,420321,'郧 县',420300),(1706,420322,'郧西县',420300),(1707,420323,'竹山县',420300),(1708,420324,'竹溪县',420300),(1709,420325,'房 县',420300),(1710,420381,'丹江口市',420300),(1711,420501,'市辖区',420500),(1712,420502,'西陵区',420500),(1713,420503,'伍家岗区',420500),(1714,420504,'点军区',420500),(1715,420505,'猇亭区',420500),(1716,420506,'夷陵区',420500),(1717,420525,'远安县',420500),(1718,420526,'兴山县',420500),(1719,420527,'秭归县',420500),(1720,420528,'长阳土家族自治县',420500),(1721,420529,'五峰土家族自治县',420500),(1722,420581,'宜都市',420500),(1723,420582,'当阳市',420500),(1724,420583,'枝江市',420500),(1725,420601,'市辖区',420600),(1726,420602,'襄城区',420600),(1727,420606,'樊城区',420600),(1728,420607,'襄阳区',420600),(1729,420624,'南漳县',420600),(1730,420625,'谷城县',420600),(1731,420626,'保康县',420600),(1732,420682,'老河口市',420600),(1733,420683,'枣阳市',420600),(1734,420684,'宜城市',420600),(1735,420701,'市辖区',420700),(1736,420702,'梁子湖区',420700),(1737,420703,'华容区',420700),(1738,420704,'鄂城区',420700),(1739,420801,'市辖区',420800),(1740,420802,'东宝区',420800),(1741,420804,'掇刀区',420800),(1742,420821,'京山县',420800),(1743,420822,'沙洋县',420800),(1744,420881,'钟祥市',420800),(1745,420901,'市辖区',420900),(1746,420902,'孝南区',420900),(1747,420921,'孝昌县',420900),(1748,420922,'大悟县',420900),(1749,420923,'云梦县',420900),(1750,420981,'应城市',420900),(1751,420982,'安陆市',420900),(1752,420984,'汉川市',420900),(1753,421001,'市辖区',421000),(1754,421002,'沙市区',421000),(1755,421003,'荆州区',421000),(1756,421022,'公安县',421000),(1757,421023,'监利县',421000),(1758,421024,'江陵县',421000),(1759,421081,'石首市',421000),(1760,421083,'洪湖市',421000),(1761,421087,'松滋市',421000),(1762,421101,'市辖区',421100),(1763,421102,'黄州区',421100),(1764,421121,'团风县',421100),(1765,421122,'红安县',421100),(1766,421123,'罗田县',421100),(1767,421124,'英山县',421100),(1768,421125,'浠水县',421100),(1769,421126,'蕲春县',421100),(1770,421127,'黄梅县',421100),(1771,421181,'麻城市',421100),(1772,421182,'武穴市',421100),(1773,421201,'市辖区',421200),(1774,421202,'咸安区',421200),(1775,421221,'嘉鱼县',421200),(1776,421222,'通城县',421200),(1777,421223,'崇阳县',421200),(1778,421224,'通山县',421200),(1779,421281,'赤壁市',421200),(1780,421301,'市辖区',421300),(1781,421302,'曾都区',421300),(1782,421381,'广水市',421300),(1783,422801,'恩施市',422800),(1784,422802,'利川市',422800),(1785,422822,'建始县',422800),(1786,422823,'巴东县',422800),(1787,422825,'宣恩县',422800),(1788,422826,'咸丰县',422800),(1789,422827,'来凤县',422800),(1790,422828,'鹤峰县',422800),(1791,429004,'仙桃市',429000),(1792,429005,'潜江市',429000),(1793,429006,'天门市',429000),(1794,429021,'神农架林区',429000),(1795,430101,'市辖区',430100),(1796,430102,'芙蓉区',430100),(1797,430103,'天心区',430100),(1798,430104,'岳麓区',430100),(1799,430105,'开福区',430100),(1800,430111,'雨花区',430100),(1801,430121,'长沙县',430100),(1802,430122,'望城县',430100),(1803,430124,'宁乡县',430100),(1804,430181,'浏阳市',430100),(1805,430201,'市辖区',430200),(1806,430202,'荷塘区',430200),(1807,430203,'芦淞区',430200),(1808,430204,'石峰区',430200),(1809,430211,'天元区',430200),(1810,430221,'株洲县',430200),(1811,430223,'攸 县',430200),(1812,430224,'茶陵县',430200),(1813,430225,'炎陵县',430200),(1814,430281,'醴陵市',430200),(1815,430301,'市辖区',430300),(1816,430302,'雨湖区',430300),(1817,430304,'岳塘区',430300),(1818,430321,'湘潭县',430300),(1819,430381,'湘乡市',430300),(1820,430382,'韶山市',430300),(1821,430401,'市辖区',430400),(1822,430405,'珠晖区',430400),(1823,430406,'雁峰区',430400),(1824,430407,'石鼓区',430400),(1825,430408,'蒸湘区',430400),(1826,430412,'南岳区',430400),(1827,430421,'衡阳县',430400),(1828,430422,'衡南县',430400),(1829,430423,'衡山县',430400),(1830,430424,'衡东县',430400),(1831,430426,'祁东县',430400),(1832,430481,'耒阳市',430400),(1833,430482,'常宁市',430400),(1834,430501,'市辖区',430500),(1835,430502,'双清区',430500),(1836,430503,'大祥区',430500),(1837,430511,'北塔区',430500),(1838,430521,'邵东县',430500),(1839,430522,'新邵县',430500),(1840,430523,'邵阳县',430500),(1841,430524,'隆回县',430500),(1842,430525,'洞口县',430500),(1843,430527,'绥宁县',430500),(1844,430528,'新宁县',430500),(1845,430529,'城步苗族自治县',430500),(1846,430581,'武冈市',430500),(1847,430601,'市辖区',430600),(1848,430602,'岳阳楼区',430600),(1849,430603,'云溪区',430600),(1850,430611,'君山区',430600),(1851,430621,'岳阳县',430600),(1852,430623,'华容县',430600),(1853,430624,'湘阴县',430600),(1854,430626,'平江县',430600),(1855,430681,'汨罗市',430600),(1856,430682,'临湘市',430600),(1857,430701,'市辖区',430700),(1858,430702,'武陵区',430700),(1859,430703,'鼎城区',430700),(1860,430721,'安乡县',430700),(1861,430722,'汉寿县',430700),(1862,430723,'澧 县',430700),(1863,430724,'临澧县',430700),(1864,430725,'桃源县',430700),(1865,430726,'石门县',430700),(1866,430781,'津市市',430700),(1867,430801,'市辖区',430800),(1868,430802,'永定区',430800),(1869,430811,'武陵源区',430800),(1870,430821,'慈利县',430800),(1871,430822,'桑植县',430800),(1872,430901,'市辖区',430900),(1873,430902,'资阳区',430900),(1874,430903,'赫山区',430900),(1875,430921,'南 县',430900),(1876,430922,'桃江县',430900),(1877,430923,'安化县',430900),(1878,430981,'沅江市',430900),(1879,431001,'市辖区',431000),(1880,431002,'北湖区',431000),(1881,431003,'苏仙区',431000),(1882,431021,'桂阳县',431000),(1883,431022,'宜章县',431000),(1884,431023,'永兴县',431000),(1885,431024,'嘉禾县',431000),(1886,431025,'临武县',431000),(1887,431026,'汝城县',431000),(1888,431027,'桂东县',431000),(1889,431028,'安仁县',431000),(1890,431081,'资兴市',431000),(1891,431101,'市辖区',431100),(1892,431102,'芝山区',431100),(1893,431103,'冷水滩区',431100),(1894,431121,'祁阳县',431100),(1895,431122,'东安县',431100),(1896,431123,'双牌县',431100),(1897,431124,'道 县',431100),(1898,431125,'江永县',431100),(1899,431126,'宁远县',431100),(1900,431127,'蓝山县',431100),(1901,431128,'新田县',431100),(1902,431129,'江华瑶族自治县',431100),(1903,431201,'市辖区',431200),(1904,431202,'鹤城区',431200),(1905,431221,'中方县',431200),(1906,431222,'沅陵县',431200),(1907,431223,'辰溪县',431200),(1908,431224,'溆浦县',431200),(1909,431225,'会同县',431200),(1910,431226,'麻阳苗族自治县',431200),(1911,431227,'新晃侗族自治县',431200),(1912,431228,'芷江侗族自治县',431200),(1913,431229,'靖州苗族侗族自治县',431200),(1914,431230,'通道侗族自治县',431200),(1915,431281,'洪江市',431200),(1916,431301,'市辖区',431300),(1917,431302,'娄星区',431300),(1918,431321,'双峰县',431300),(1919,431322,'新化县',431300),(1920,431381,'冷水江市',431300),(1921,431382,'涟源市',431300),(1922,433101,'吉首市',433100),(1923,433122,'泸溪县',433100),(1924,433123,'凤凰县',433100),(1925,433124,'花垣县',433100),(1926,433125,'保靖县',433100),(1927,433126,'古丈县',433100),(1928,433127,'永顺县',433100),(1929,433130,'龙山县',433100),(1930,440101,'市辖区',440100),(1931,440102,'东山区',440100),(1932,440103,'荔湾区',440100),(1933,440104,'越秀区',440100),(1934,440105,'海珠区',440100),(1935,440106,'天河区',440100),(1936,440107,'芳村区',440100),(1937,440111,'白云区',440100),(1938,440112,'黄埔区',440100),(1939,440113,'番禺区',440100),(1940,440114,'花都区',440100),(1941,440183,'增城市',440100),(1942,440184,'从化市',440100),(1943,440201,'市辖区',440200),(1944,440203,'武江区',440200),(1945,440204,'浈江区',440200),(1946,440205,'曲江区',440200),(1947,440222,'始兴县',440200),(1948,440224,'仁化县',440200),(1949,440229,'翁源县',440200),(1950,440232,'乳源瑶族自治县',440200),(1951,440233,'新丰县',440200),(1952,440281,'乐昌市',440200),(1953,440282,'南雄市',440200),(1954,440301,'市辖区',440300),(1955,440303,'罗湖区',440300),(1956,440304,'福田区',440300),(1957,440305,'南山区',440300),(1958,440306,'宝安区',440300),(1959,440307,'龙岗区',440300),(1960,440308,'盐田区',440300),(1961,440401,'市辖区',440400),(1962,440402,'香洲区',440400),(1963,440403,'斗门区',440400),(1964,440404,'金湾区',440400),(1965,440501,'市辖区',440500),(1966,440507,'龙湖区',440500),(1967,440511,'金平区',440500),(1968,440512,'濠江区',440500),(1969,440513,'潮阳区',440500),(1970,440514,'潮南区',440500),(1971,440515,'澄海区',440500),(1972,440523,'南澳县',440500),(1973,440601,'市辖区',440600),(1974,440604,'禅城区',440600),(1975,440605,'南海区',440600),(1976,440606,'顺德区',440600),(1977,440607,'三水区',440600),(1978,440608,'高明区',440600),(1979,440701,'市辖区',440700),(1980,440703,'蓬江区',440700),(1981,440704,'江海区',440700),(1982,440705,'新会区',440700),(1983,440781,'台山市',440700),(1984,440783,'开平市',440700),(1985,440784,'鹤山市',440700),(1986,440785,'恩平市',440700),(1987,440801,'市辖区',440800),(1988,440802,'赤坎区',440800),(1989,440803,'霞山区',440800),(1990,440804,'坡头区',440800),(1991,440811,'麻章区',440800),(1992,440823,'遂溪县',440800),(1993,440825,'徐闻县',440800),(1994,440881,'廉江市',440800),(1995,440882,'雷州市',440800),(1996,440883,'吴川市',440800),(1997,440901,'市辖区',440900),(1998,440902,'茂南区',440900),(1999,440903,'茂港区',440900),(2000,440923,'电白县',440900),(2001,440981,'高州市',440900),(2002,440982,'化州市',440900),(2003,440983,'信宜市',440900),(2004,441201,'市辖区',441200),(2005,441202,'端州区',441200),(2006,441203,'鼎湖区',441200),(2007,441223,'广宁县',441200),(2008,441224,'怀集县',441200),(2009,441225,'封开县',441200),(2010,441226,'德庆县',441200),(2011,441283,'高要市',441200),(2012,441284,'四会市',441200),(2013,441301,'市辖区',441300),(2014,441302,'惠城区',441300),(2015,441303,'惠阳区',441300),(2016,441322,'博罗县',441300),(2017,441323,'惠东县',441300),(2018,441324,'龙门县',441300),(2019,441401,'市辖区',441400),(2020,441402,'梅江区',441400),(2021,441421,'梅 县',441400),(2022,441422,'大埔县',441400),(2023,441423,'丰顺县',441400),(2024,441424,'五华县',441400),(2025,441426,'平远县',441400),(2026,441427,'蕉岭县',441400),(2027,441481,'兴宁市',441400),(2028,441501,'市辖区',441500),(2029,441502,'城 区',441500),(2030,441521,'海丰县',441500),(2031,441523,'陆河县',441500),(2032,441581,'陆丰市',441500),(2033,441601,'市辖区',441600),(2034,441602,'源城区',441600),(2035,441621,'紫金县',441600),(2036,441622,'龙川县',441600),(2037,441623,'连平县',441600),(2038,441624,'和平县',441600),(2039,441625,'东源县',441600),(2040,441701,'市辖区',441700),(2041,441702,'江城区',441700),(2042,441721,'阳西县',441700),(2043,441723,'阳东县',441700),(2044,441781,'阳春市',441700),(2045,441801,'市辖区',441800),(2046,441802,'清城区',441800),(2047,441821,'佛冈县',441800),(2048,441823,'阳山县',441800),(2049,441825,'连山壮族瑶族自治县',441800),(2050,441826,'连南瑶族自治县',441800),(2051,441827,'清新县',441800),(2052,441881,'英德市',441800),(2053,441882,'连州市',441800),(2054,445101,'市辖区',445100),(2055,445102,'湘桥区',445100),(2056,445121,'潮安县',445100),(2057,445122,'饶平县',445100),(2058,445201,'市辖区',445200),(2059,445202,'榕城区',445200),(2060,445221,'揭东县',445200),(2061,445222,'揭西县',445200),(2062,445224,'惠来县',445200),(2063,445281,'普宁市',445200),(2064,445301,'市辖区',445300),(2065,445302,'云城区',445300),(2066,445321,'新兴县',445300),(2067,445322,'郁南县',445300),(2068,445323,'云安县',445300),(2069,445381,'罗定市',445300),(2070,450101,'市辖区',450100),(2071,450102,'兴宁区',450100),(2072,450103,'青秀区',450100),(2073,450105,'江南区',450100),(2074,450107,'西乡塘区',450100),(2075,450108,'良庆区',450100),(2076,450109,'邕宁区',450100),(2077,450122,'武鸣县',450100),(2078,450123,'隆安县',450100),(2079,450124,'马山县',450100),(2080,450125,'上林县',450100),(2081,450126,'宾阳县',450100),(2082,450127,'横 县',450100),(2083,450201,'市辖区',450200),(2084,450202,'城中区',450200),(2085,450203,'鱼峰区',450200),(2086,450204,'柳南区',450200),(2087,450205,'柳北区',450200),(2088,450221,'柳江县',450200),(2089,450222,'柳城县',450200),(2090,450223,'鹿寨县',450200),(2091,450224,'融安县',450200),(2092,450225,'融水苗族自治县',450200),(2093,450226,'三江侗族自治县',450200),(2094,450301,'市辖区',450300),(2095,450302,'秀峰区',450300),(2096,450303,'叠彩区',450300),(2097,450304,'象山区',450300),(2098,450305,'七星区',450300),(2099,450311,'雁山区',450300),(2100,450321,'阳朔县',450300),(2101,450322,'临桂县',450300),(2102,450323,'灵川县',450300),(2103,450324,'全州县',450300),(2104,450325,'兴安县',450300),(2105,450326,'永福县',450300),(2106,450327,'灌阳县',450300),(2107,450328,'龙胜各族自治县',450300),(2108,450329,'资源县',450300),(2109,450330,'平乐县',450300),(2110,450331,'荔蒲县',450300),(2111,450332,'恭城瑶族自治县',450300),(2112,450401,'市辖区',450400),(2113,450403,'万秀区',450400),(2114,450404,'蝶山区',450400),(2115,450405,'长洲区',450400),(2116,450421,'苍梧县',450400),(2117,450422,'藤 县',450400),(2118,450423,'蒙山县',450400),(2119,450481,'岑溪市',450400),(2120,450501,'市辖区',450500),(2121,450502,'海城区',450500),(2122,450503,'银海区',450500),(2123,450512,'铁山港区',450500),(2124,450521,'合浦县',450500),(2125,450601,'市辖区',450600),(2126,450602,'港口区',450600),(2127,450603,'防城区',450600),(2128,450621,'上思县',450600),(2129,450681,'东兴市',450600),(2130,450701,'市辖区',450700),(2131,450702,'钦南区',450700),(2132,450703,'钦北区',450700),(2133,450721,'灵山县',450700),(2134,450722,'浦北县',450700),(2135,450801,'市辖区',450800),(2136,450802,'港北区',450800),(2137,450803,'港南区',450800),(2138,450804,'覃塘区',450800),(2139,450821,'平南县',450800),(2140,450881,'桂平市',450800),(2141,450901,'市辖区',450900),(2142,450902,'玉州区',450900),(2143,450921,'容 县',450900),(2144,450922,'陆川县',450900),(2145,450923,'博白县',450900),(2146,450924,'兴业县',450900),(2147,450981,'北流市',450900),(2148,451001,'市辖区',451000),(2149,451002,'右江区',451000),(2150,451021,'田阳县',451000),(2151,451022,'田东县',451000),(2152,451023,'平果县',451000),(2153,451024,'德保县',451000),(2154,451025,'靖西县',451000),(2155,451026,'那坡县',451000),(2156,451027,'凌云县',451000),(2157,451028,'乐业县',451000),(2158,451029,'田林县',451000),(2159,451030,'西林县',451000),(2160,451031,'隆林各族自治县',451000),(2161,451101,'市辖区',451100),(2162,451102,'八步区',451100),(2163,451121,'昭平县',451100),(2164,451122,'钟山县',451100),(2165,451123,'富川瑶族自治县',451100),(2166,451201,'市辖区',451200),(2167,451202,'金城江区',451200),(2168,451221,'南丹县',451200),(2169,451222,'天峨县',451200),(2170,451223,'凤山县',451200),(2171,451224,'东兰县',451200),(2172,451225,'罗城仫佬族自治县',451200),(2173,451226,'环江毛南族自治县',451200),(2174,451227,'巴马瑶族自治县',451200),(2175,451228,'都安瑶族自治县',451200),(2176,451229,'大化瑶族自治县',451200),(2177,451281,'宜州市',451200),(2178,451301,'市辖区',451300),(2179,451302,'兴宾区',451300),(2180,451321,'忻城县',451300),(2181,451322,'象州县',451300),(2182,451323,'武宣县',451300),(2183,451324,'金秀瑶族自治县',451300),(2184,451381,'合山市',451300),(2185,451401,'市辖区',451400),(2186,451402,'江洲区',451400),(2187,451421,'扶绥县',451400),(2188,451422,'宁明县',451400),(2189,451423,'龙州县',451400),(2190,451424,'大新县',451400),(2191,451425,'天等县',451400),(2192,451481,'凭祥市',451400),(2193,460101,'市辖区',460100),(2194,460105,'秀英区',460100),(2195,460106,'龙华区',460100),(2196,460107,'琼山区',460100),(2197,460108,'美兰区',460100),(2198,460201,'市辖区',460200),(2199,469001,'五指山市',469000),(2200,469002,'琼海市',469000),(2201,469003,'儋州市',469000),(2202,469005,'文昌市',469000),(2203,469006,'万宁市',469000),(2204,469007,'东方市',469000),(2205,469025,'定安县',469000),(2206,469026,'屯昌县',469000),(2207,469027,'澄迈县',469000),(2208,469028,'临高县',469000),(2209,469030,'白沙黎族自治县',469000),(2210,469031,'昌江黎族自治县',469000),(2211,469033,'乐东黎族自治县',469000),(2212,469034,'陵水黎族自治县',469000),(2213,469035,'保亭黎族苗族自治县',469000),(2214,469036,'琼中黎族苗族自治县',469000),(2215,469037,'西沙群岛',469000),(2216,469038,'南沙群岛',469000),(2217,469039,'中沙群岛的岛礁及其海域',469000),(2218,500101,'万州区',500100),(2219,500102,'涪陵区',500100),(2220,500103,'渝中区',500100),(2221,500104,'大渡口区',500100),(2222,500105,'江北区',500100),(2223,500106,'沙坪坝区',500100),(2224,500107,'九龙坡区',500100),(2225,500108,'南岸区',500100),(2226,500109,'北碚区',500100),(2227,500110,'万盛区',500100),(2228,500111,'双桥区',500100),(2229,500112,'渝北区',500100),(2230,500113,'巴南区',500100),(2231,500114,'黔江区',500100),(2232,500115,'长寿区',500100),(2233,500222,'綦江县',500200),(2234,500223,'潼南县',500200),(2235,500224,'铜梁县',500200),(2236,500225,'大足县',500200),(2237,500226,'荣昌县',500200),(2238,500227,'璧山县',500200),(2239,500228,'梁平县',500200),(2240,500229,'城口县',500200),(2241,500230,'丰都县',500200),(2242,500231,'垫江县',500200),(2243,500232,'武隆县',500200),(2244,500233,'忠 县',500200),(2245,500234,'开 县',500200),(2246,500235,'云阳县',500200),(2247,500236,'奉节县',500200),(2248,500237,'巫山县',500200),(2249,500238,'巫溪县',500200),(2250,500240,'石柱土家族自治县',500200),(2251,500241,'秀山土家族苗族自治县',500200),(2252,500242,'酉阳土家族苗族自治县',500200),(2253,500243,'彭水苗族土家族自治县',500200),(2254,500381,'江津市',500300),(2255,500382,'合川市',500300),(2256,500383,'永川市',500300),(2257,500384,'南川市',500300),(2258,510101,'市辖区',510100),(2259,510104,'锦江区',510100),(2260,510105,'青羊区',510100),(2261,510106,'金牛区',510100),(2262,510107,'武侯区',510100),(2263,510108,'成华区',510100),(2264,510112,'龙泉驿区',510100),(2265,510113,'青白江区',510100),(2266,510114,'新都区',510100),(2267,510115,'温江区',510100),(2268,510121,'金堂县',510100),(2269,510122,'双流县',510100),(2270,510124,'郫 县',510100),(2271,510129,'大邑县',510100),(2272,510131,'蒲江县',510100),(2273,510132,'新津县',510100),(2274,510181,'都江堰市',510100),(2275,510182,'彭州市',510100),(2276,510183,'邛崃市',510100),(2277,510184,'崇州市',510100),(2278,510301,'市辖区',510300),(2279,510302,'自流井区',510300),(2280,510303,'贡井区',510300),(2281,510304,'大安区',510300),(2282,510311,'沿滩区',510300),(2283,510321,'荣 县',510300),(2284,510322,'富顺县',510300),(2285,510401,'市辖区',510400),(2286,510402,'东 区',510400),(2287,510403,'西 区',510400),(2288,510411,'仁和区',510400),(2289,510421,'米易县',510400),(2290,510422,'盐边县',510400),(2291,510501,'市辖区',510500),(2292,510502,'江阳区',510500),(2293,510503,'纳溪区',510500),(2294,510504,'龙马潭区',510500),(2295,510521,'泸 县',510500),(2296,510522,'合江县',510500),(2297,510524,'叙永县',510500),(2298,510525,'古蔺县',510500),(2299,510601,'市辖区',510600),(2300,510603,'旌阳区',510600),(2301,510623,'中江县',510600),(2302,510626,'罗江县',510600),(2303,510681,'广汉市',510600),(2304,510682,'什邡市',510600),(2305,510683,'绵竹市',510600),(2306,510701,'市辖区',510700),(2307,510703,'涪城区',510700),(2308,510704,'游仙区',510700),(2309,510722,'三台县',510700),(2310,510723,'盐亭县',510700),(2311,510724,'安 县',510700),(2312,510725,'梓潼县',510700),(2313,510726,'北川羌族自治县',510700),(2314,510727,'平武县',510700),(2315,510781,'江油市',510700),(2316,510801,'市辖区',510800),(2317,510802,'市中区',510800),(2318,510811,'元坝区',510800),(2319,510812,'朝天区',510800),(2320,510821,'旺苍县',510800),(2321,510822,'青川县',510800),(2322,510823,'剑阁县',510800),(2323,510824,'苍溪县',510800),(2324,510901,'市辖区',510900),(2325,510903,'船山区',510900),(2326,510904,'安居区',510900),(2327,510921,'蓬溪县',510900),(2328,510922,'射洪县',510900),(2329,510923,'大英县',510900),(2330,511001,'市辖区',511000),(2331,511002,'市中区',511000),(2332,511011,'东兴区',511000),(2333,511024,'威远县',511000),(2334,511025,'资中县',511000),(2335,511028,'隆昌县',511000),(2336,511101,'市辖区',511100),(2337,511102,'市中区',511100),(2338,511111,'沙湾区',511100),(2339,511112,'五通桥区',511100),(2340,511113,'金口河区',511100),(2341,511123,'犍为县',511100),(2342,511124,'井研县',511100),(2343,511126,'夹江县',511100),(2344,511129,'沐川县',511100),(2345,511132,'峨边彝族自治县',511100),(2346,511133,'马边彝族自治县',511100),(2347,511181,'峨眉山市',511100),(2348,511301,'市辖区',511300),(2349,511302,'顺庆区',511300),(2350,511303,'高坪区',511300),(2351,511304,'嘉陵区',511300),(2352,511321,'南部县',511300),(2353,511322,'营山县',511300),(2354,511323,'蓬安县',511300),(2355,511324,'仪陇县',511300),(2356,511325,'西充县',511300),(2357,511381,'阆中市',511300),(2358,511401,'市辖区',511400),(2359,511402,'东坡区',511400),(2360,511421,'仁寿县',511400),(2361,511422,'彭山县',511400),(2362,511423,'洪雅县',511400),(2363,511424,'丹棱县',511400),(2364,511425,'青神县',511400),(2365,511501,'市辖区',511500),(2366,511502,'翠屏区',511500),(2367,511521,'宜宾县',511500),(2368,511522,'南溪县',511500),(2369,511523,'江安县',511500),(2370,511524,'长宁县',511500),(2371,511525,'高 县',511500),(2372,511526,'珙 县',511500),(2373,511527,'筠连县',511500),(2374,511528,'兴文县',511500),(2375,511529,'屏山县',511500),(2376,511601,'市辖区',511600),(2377,511602,'广安区',511600),(2378,511621,'岳池县',511600),(2379,511622,'武胜县',511600),(2380,511623,'邻水县',511600),(2381,511681,'华莹市',511600),(2382,511701,'市辖区',511700),(2383,511702,'通川区',511700),(2384,511721,'达 县',511700),(2385,511722,'宣汉县',511700),(2386,511723,'开江县',511700),(2387,511724,'大竹县',511700),(2388,511725,'渠 县',511700),(2389,511781,'万源市',511700),(2390,511801,'市辖区',511800),(2391,511802,'雨城区',511800),(2392,511821,'名山县',511800),(2393,511822,'荥经县',511800),(2394,511823,'汉源县',511800),(2395,511824,'石棉县',511800),(2396,511825,'天全县',511800),(2397,511826,'芦山县',511800),(2398,511827,'宝兴县',511800),(2399,511901,'市辖区',511900),(2400,511902,'巴州区',511900),(2401,511921,'通江县',511900),(2402,511922,'南江县',511900),(2403,511923,'平昌县',511900),(2404,512001,'市辖区',512000),(2405,512002,'雁江区',512000),(2406,512021,'安岳县',512000),(2407,512022,'乐至县',512000),(2408,512081,'简阳市',512000),(2409,513221,'汶川县',513200),(2410,513222,'理 县',513200),(2411,513223,'茂 县',513200),(2412,513224,'松潘县',513200),(2413,513225,'九寨沟县',513200),(2414,513226,'金川县',513200),(2415,513227,'小金县',513200),(2416,513228,'黑水县',513200),(2417,513229,'马尔康县',513200),(2418,513230,'壤塘县',513200),(2419,513231,'阿坝县',513200),(2420,513232,'若尔盖县',513200),(2421,513233,'红原县',513200),(2422,513321,'康定县',513300),(2423,513322,'泸定县',513300),(2424,513323,'丹巴县',513300),(2425,513324,'九龙县',513300),(2426,513325,'雅江县',513300),(2427,513326,'道孚县',513300),(2428,513327,'炉霍县',513300),(2429,513328,'甘孜县',513300),(2430,513329,'新龙县',513300),(2431,513330,'德格县',513300),(2432,513331,'白玉县',513300),(2433,513332,'石渠县',513300),(2434,513333,'色达县',513300),(2435,513334,'理塘县',513300),(2436,513335,'巴塘县',513300),(2437,513336,'乡城县',513300),(2438,513337,'稻城县',513300),(2439,513338,'得荣县',513300),(2440,513401,'西昌市',513400),(2441,513422,'木里藏族自治县',513400),(2442,513423,'盐源县',513400),(2443,513424,'德昌县',513400),(2444,513425,'会理县',513400),(2445,513426,'会东县',513400),(2446,513427,'宁南县',513400),(2447,513428,'普格县',513400),(2448,513429,'布拖县',513400),(2449,513430,'金阳县',513400),(2450,513431,'昭觉县',513400),(2451,513432,'喜德县',513400),(2452,513433,'冕宁县',513400),(2453,513434,'越西县',513400),(2454,513435,'甘洛县',513400),(2455,513436,'美姑县',513400),(2456,513437,'雷波县',513400),(2457,520101,'市辖区',520100),(2458,520102,'南明区',520100),(2459,520103,'云岩区',520100),(2460,520111,'花溪区',520100),(2461,520112,'乌当区',520100),(2462,520113,'白云区',520100),(2463,520114,'小河区',520100),(2464,520121,'开阳县',520100),(2465,520122,'息烽县',520100),(2466,520123,'修文县',520100),(2467,520181,'清镇市',520100),(2468,520201,'钟山区',520200),(2469,520203,'六枝特区',520200),(2470,520221,'水城县',520200),(2471,520222,'盘 县',520200),(2472,520301,'市辖区',520300),(2473,520302,'红花岗区',520300),(2474,520303,'汇川区',520300),(2475,520321,'遵义县',520300),(2476,520322,'桐梓县',520300),(2477,520323,'绥阳县',520300),(2478,520324,'正安县',520300),(2479,520325,'道真仡佬族苗族自治县',520300),(2480,520326,'务川仡佬族苗族自治县',520300),(2481,520327,'凤冈县',520300),(2482,520328,'湄潭县',520300),(2483,520329,'余庆县',520300),(2484,520330,'习水县',520300),(2485,520381,'赤水市',520300),(2486,520382,'仁怀市',520300),(2487,520401,'市辖区',520400),(2488,520402,'西秀区',520400),(2489,520421,'平坝县',520400),(2490,520422,'普定县',520400),(2491,520423,'镇宁布依族苗族自治县',520400),(2492,520424,'关岭布依族苗族自治县',520400),(2493,520425,'紫云苗族布依族自治县',520400),(2494,522201,'铜仁市',522200),(2495,522222,'江口县',522200),(2496,522223,'玉屏侗族自治县',522200),(2497,522224,'石阡县',522200),(2498,522225,'思南县',522200),(2499,522226,'印江土家族苗族自治县',522200),(2500,522227,'德江县',522200),(2501,522228,'沿河土家族自治县',522200),(2502,522229,'松桃苗族自治县',522200),(2503,522230,'万山特区',522200),(2504,522301,'兴义市',522300),(2505,522322,'兴仁县',522300),(2506,522323,'普安县',522300),(2507,522324,'晴隆县',522300),(2508,522325,'贞丰县',522300),(2509,522326,'望谟县',522300),(2510,522327,'册亨县',522300),(2511,522328,'安龙县',522300),(2512,522401,'毕节市',522400),(2513,522422,'大方县',522400),(2514,522423,'黔西县',522400),(2515,522424,'金沙县',522400),(2516,522425,'织金县',522400),(2517,522426,'纳雍县',522400),(2518,522427,'威宁彝族回族苗族自治县',522400),(2519,522428,'赫章县',522400),(2520,522601,'凯里市',522600),(2521,522622,'黄平县',522600),(2522,522623,'施秉县',522600),(2523,522624,'三穗县',522600),(2524,522625,'镇远县',522600),(2525,522626,'岑巩县',522600),(2526,522627,'天柱县',522600),(2527,522628,'锦屏县',522600),(2528,522629,'剑河县',522600),(2529,522630,'台江县',522600),(2530,522631,'黎平县',522600),(2531,522632,'榕江县',522600),(2532,522633,'从江县',522600),(2533,522634,'雷山县',522600),(2534,522635,'麻江县',522600),(2535,522636,'丹寨县',522600),(2536,522701,'都匀市',522700),(2537,522702,'福泉市',522700),(2538,522722,'荔波县',522700),(2539,522723,'贵定县',522700),(2540,522725,'瓮安县',522700),(2541,522726,'独山县',522700),(2542,522727,'平塘县',522700),(2543,522728,'罗甸县',522700),(2544,522729,'长顺县',522700),(2545,522730,'龙里县',522700),(2546,522731,'惠水县',522700),(2547,522732,'三都水族自治县',522700),(2548,530101,'市辖区',530100),(2549,530102,'五华区',530100),(2550,530103,'盘龙区',530100),(2551,530111,'官渡区',530100),(2552,530112,'西山区',530100),(2553,530113,'东川区',530100),(2554,530121,'呈贡县',530100),(2555,530122,'晋宁县',530100),(2556,530124,'富民县',530100),(2557,530125,'宜良县',530100),(2558,530126,'石林彝族自治县',530100),(2559,530127,'嵩明县',530100),(2560,530128,'禄劝彝族苗族自治县',530100),(2561,530129,'寻甸回族彝族自治县',530100),(2562,530181,'安宁市',530100),(2563,530301,'市辖区',530300),(2564,530302,'麒麟区',530300),(2565,530321,'马龙县',530300),(2566,530322,'陆良县',530300),(2567,530323,'师宗县',530300),(2568,530324,'罗平县',530300),(2569,530325,'富源县',530300),(2570,530326,'会泽县',530300),(2571,530328,'沾益县',530300),(2572,530381,'宣威市',530300),(2573,530401,'市辖区',530400),(2574,530402,'红塔区',530400),(2575,530421,'江川县',530400),(2576,530422,'澄江县',530400),(2577,530423,'通海县',530400),(2578,530424,'华宁县',530400),(2579,530425,'易门县',530400),(2580,530426,'峨山彝族自治县',530400),(2581,530427,'新平彝族傣族自治县',530400),(2582,530428,'元江哈尼族彝族傣族自治县',530400),(2583,530501,'市辖区',530500),(2584,530502,'隆阳区',530500),(2585,530521,'施甸县',530500),(2586,530522,'腾冲县',530500),(2587,530523,'龙陵县',530500),(2588,530524,'昌宁县',530500),(2589,530601,'市辖区',530600),(2590,530602,'昭阳区',530600),(2591,530621,'鲁甸县',530600),(2592,530622,'巧家县',530600),(2593,530623,'盐津县',530600),(2594,530624,'大关县',530600),(2595,530625,'永善县',530600),(2596,530626,'绥江县',530600),(2597,530627,'镇雄县',530600),(2598,530628,'彝良县',530600),(2599,530629,'威信县',530600),(2600,530630,'水富县',530600),(2601,530701,'市辖区',530700),(2602,530702,'古城区',530700),(2603,530721,'玉龙纳西族自治县',530700),(2604,530722,'永胜县',530700),(2605,530723,'华坪县',530700),(2606,530724,'宁蒗彝族自治县',530700),(2607,530801,'市辖区',530800),(2608,530802,'翠云区',530800),(2609,530821,'普洱哈尼族彝族自治县',530800),(2610,530822,'墨江哈尼族自治县',530800),(2611,530823,'景东彝族自治县',530800),(2612,530824,'景谷傣族彝族自治县',530800),(2613,530825,'镇沅彝族哈尼族拉祜族自治县',530800),(2614,530826,'江城哈尼族彝族自治县',530800),(2615,530827,'孟连傣族拉祜族佤族自治县',530800),(2616,530828,'澜沧拉祜族自治县',530800),(2617,530829,'西盟佤族自治县',530800),(2618,530901,'市辖区',530900),(2619,530902,'临翔区',530900),(2620,530921,'凤庆县',530900),(2621,530922,'云 县',530900),(2622,530923,'永德县',530900),(2623,530924,'镇康县',530900),(2624,530925,'双江拉祜族佤族布朗族傣族自治县',530900),(2625,530926,'耿马傣族佤族自治县',530900),(2626,530927,'沧源佤族自治县',530900),(2627,532301,'楚雄市',532300),(2628,532322,'双柏县',532300),(2629,532323,'牟定县',532300),(2630,532324,'南华县',532300),(2631,532325,'姚安县',532300),(2632,532326,'大姚县',532300),(2633,532327,'永仁县',532300),(2634,532328,'元谋县',532300),(2635,532329,'武定县',532300),(2636,532331,'禄丰县',532300),(2637,532501,'个旧市',532500),(2638,532502,'开远市',532500),(2639,532522,'蒙自县',532500),(2640,532523,'屏边苗族自治县',532500),(2641,532524,'建水县',532500),(2642,532525,'石屏县',532500),(2643,532526,'弥勒县',532500),(2644,532527,'泸西县',532500),(2645,532528,'元阳县',532500),(2646,532529,'红河县',532500),(2647,532530,'金平苗族瑶族傣族自治县',532500),(2648,532531,'绿春县',532500),(2649,532532,'河口瑶族自治县',532500),(2650,532621,'文山县',532600),(2651,532622,'砚山县',532600),(2652,532623,'西畴县',532600),(2653,532624,'麻栗坡县',532600),(2654,532625,'马关县',532600),(2655,532626,'丘北县',532600),(2656,532627,'广南县',532600),(2657,532628,'富宁县',532600),(2658,532801,'景洪市',532800),(2659,532822,'勐海县',532800),(2660,532823,'勐腊县',532800),(2661,532901,'大理市',532900),(2662,532922,'漾濞彝族自治县',532900),(2663,532923,'祥云县',532900),(2664,532924,'宾川县',532900),(2665,532925,'弥渡县',532900),(2666,532926,'南涧彝族自治县',532900),(2667,532927,'巍山彝族回族自治县',532900),(2668,532928,'永平县',532900),(2669,532929,'云龙县',532900),(2670,532930,'洱源县',532900),(2671,532931,'剑川县',532900),(2672,532932,'鹤庆县',532900),(2673,533102,'瑞丽市',533100),(2674,533103,'潞西市',533100),(2675,533122,'梁河县',533100),(2676,533123,'盈江县',533100),(2677,533124,'陇川县',533100),(2678,533321,'泸水县',533300),(2679,533323,'福贡县',533300),(2680,533324,'贡山独龙族怒族自治县',533300),(2681,533325,'兰坪白族普米族自治县',533300),(2682,533421,'香格里拉县',533400),(2683,533422,'德钦县',533400),(2684,533423,'维西傈僳族自治县',533400),(2685,540101,'市辖区',540100),(2686,540102,'城关区',540100),(2687,540121,'林周县',540100),(2688,540122,'当雄县',540100),(2689,540123,'尼木县',540100),(2690,540124,'曲水县',540100),(2691,540125,'堆龙德庆县',540100),(2692,540126,'达孜县',540100),(2693,540127,'墨竹工卡县',540100),(2694,542121,'昌都县',542100),(2695,542122,'江达县',542100),(2696,542123,'贡觉县',542100),(2697,542124,'类乌齐县',542100),(2698,542125,'丁青县',542100),(2699,542126,'察雅县',542100),(2700,542127,'八宿县',542100),(2701,542128,'左贡县',542100),(2702,542129,'芒康县',542100),(2703,542132,'洛隆县',542100),(2704,542133,'边坝县',542100),(2705,542221,'乃东县',542200),(2706,542222,'扎囊县',542200),(2707,542223,'贡嘎县',542200),(2708,542224,'桑日县',542200),(2709,542225,'琼结县',542200),(2710,542226,'曲松县',542200),(2711,542227,'措美县',542200),(2712,542228,'洛扎县',542200),(2713,542229,'加查县',542200),(2714,542231,'隆子县',542200),(2715,542232,'错那县',542200),(2716,542233,'浪卡子县',542200),(2717,542301,'日喀则市',542300),(2718,542322,'南木林县',542300),(2719,542323,'江孜县',542300),(2720,542324,'定日县',542300),(2721,542325,'萨迦县',542300),(2722,542326,'拉孜县',542300),(2723,542327,'昂仁县',542300),(2724,542328,'谢通门县',542300),(2725,542329,'白朗县',542300),(2726,542330,'仁布县',542300),(2727,542331,'康马县',542300),(2728,542332,'定结县',542300),(2729,542333,'仲巴县',542300),(2730,542334,'亚东县',542300),(2731,542335,'吉隆县',542300),(2732,542336,'聂拉木县',542300),(2733,542337,'萨嘎县',542300),(2734,542338,'岗巴县',542300),(2735,542421,'那曲县',542400),(2736,542422,'嘉黎县',542400),(2737,542423,'比如县',542400),(2738,542424,'聂荣县',542400),(2739,542425,'安多县',542400),(2740,542426,'申扎县',542400),(2741,542427,'索 县',542400),(2742,542428,'班戈县',542400),(2743,542429,'巴青县',542400),(2744,542430,'尼玛县',542400),(2745,542521,'普兰县',542500),(2746,542522,'札达县',542500),(2747,542523,'噶尔县',542500),(2748,542524,'日土县',542500),(2749,542525,'革吉县',542500),(2750,542526,'改则县',542500),(2751,542527,'措勤县',542500),(2752,542621,'林芝县',542600),(2753,542622,'工布江达县',542600),(2754,542623,'米林县',542600),(2755,542624,'墨脱县',542600),(2756,542625,'波密县',542600),(2757,542626,'察隅县',542600),(2758,542627,'朗 县',542600),(2759,610101,'市辖区',610100),(2760,610102,'新城区',610100),(2761,610103,'碑林区',610100),(2762,610104,'莲湖区',610100),(2763,610111,'灞桥区',610100),(2764,610112,'未央区',610100),(2765,610113,'雁塔区',610100),(2766,610114,'阎良区',610100),(2767,610115,'临潼区',610100),(2768,610116,'长安区',610100),(2769,610122,'蓝田县',610100),(2770,610124,'周至县',610100),(2771,610125,'户 县',610100),(2772,610126,'高陵县',610100),(2773,610201,'市辖区',610200),(2774,610202,'王益区',610200),(2775,610203,'印台区',610200),(2776,610204,'耀州区',610200),(2777,610222,'宜君县',610200),(2778,610301,'市辖区',610300),(2779,610302,'渭滨区',610300),(2780,610303,'金台区',610300),(2781,610304,'陈仓区',610300),(2782,610322,'凤翔县',610300),(2783,610323,'岐山县',610300),(2784,610324,'扶风县',610300),(2785,610326,'眉 县',610300),(2786,610327,'陇 县',610300),(2787,610328,'千阳县',610300),(2788,610329,'麟游县',610300),(2789,610330,'凤 县',610300),(2790,610331,'太白县',610300),(2791,610401,'市辖区',610400),(2792,610402,'秦都区',610400),(2793,610403,'杨凌区',610400),(2794,610404,'渭城区',610400),(2795,610422,'三原县',610400),(2796,610423,'泾阳县',610400),(2797,610424,'乾 县',610400),(2798,610425,'礼泉县',610400),(2799,610426,'永寿县',610400),(2800,610427,'彬 县',610400),(2801,610428,'长武县',610400),(2802,610429,'旬邑县',610400),(2803,610430,'淳化县',610400),(2804,610431,'武功县',610400),(2805,610481,'兴平市',610400),(2806,610501,'市辖区',610500),(2807,610502,'临渭区',610500),(2808,610521,'华 县',610500),(2809,610522,'潼关县',610500),(2810,610523,'大荔县',610500),(2811,610524,'合阳县',610500),(2812,610525,'澄城县',610500),(2813,610526,'蒲城县',610500),(2814,610527,'白水县',610500),(2815,610528,'富平县',610500),(2816,610581,'韩城市',610500),(2817,610582,'华阴市',610500),(2818,610601,'市辖区',610600),(2819,610602,'宝塔区',610600),(2820,610621,'延长县',610600),(2821,610622,'延川县',610600),(2822,610623,'子长县',610600),(2823,610624,'安塞县',610600),(2824,610625,'志丹县',610600),(2825,610626,'吴旗县',610600),(2826,610627,'甘泉县',610600),(2827,610628,'富 县',610600),(2828,610629,'洛川县',610600),(2829,610630,'宜川县',610600),(2830,610631,'黄龙县',610600),(2831,610632,'黄陵县',610600),(2832,610701,'市辖区',610700),(2833,610702,'汉台区',610700),(2834,610721,'南郑县',610700),(2835,610722,'城固县',610700),(2836,610723,'洋 县',610700),(2837,610724,'西乡县',610700),(2838,610725,'勉 县',610700),(2839,610726,'宁强县',610700),(2840,610727,'略阳县',610700),(2841,610728,'镇巴县',610700),(2842,610729,'留坝县',610700),(2843,610730,'佛坪县',610700),(2844,610801,'市辖区',610800),(2845,610802,'榆阳区',610800),(2846,610821,'神木县',610800),(2847,610822,'府谷县',610800),(2848,610823,'横山县',610800),(2849,610824,'靖边县',610800),(2850,610825,'定边县',610800),(2851,610826,'绥德县',610800),(2852,610827,'米脂县',610800),(2853,610828,'佳 县',610800),(2854,610829,'吴堡县',610800),(2855,610830,'清涧县',610800),(2856,610831,'子洲县',610800),(2857,610901,'市辖区',610900),(2858,610902,'汉滨区',610900),(2859,610921,'汉阴县',610900),(2860,610922,'石泉县',610900),(2861,610923,'宁陕县',610900),(2862,610924,'紫阳县',610900),(2863,610925,'岚皋县',610900),(2864,610926,'平利县',610900),(2865,610927,'镇坪县',610900),(2866,610928,'旬阳县',610900),(2867,610929,'白河县',610900),(2868,611001,'市辖区',611000),(2869,611002,'商州区',611000),(2870,611021,'洛南县',611000),(2871,611022,'丹凤县',611000),(2872,611023,'商南县',611000),(2873,611024,'山阳县',611000),(2874,611025,'镇安县',611000),(2875,611026,'柞水县',611000),(2876,620101,'市辖区',620100),(2877,620102,'城关区',620100),(2878,620103,'七里河区',620100),(2879,620104,'西固区',620100),(2880,620105,'安宁区',620100),(2881,620111,'红古区',620100),(2882,620121,'永登县',620100),(2883,620122,'皋兰县',620100),(2884,620123,'榆中县',620100),(2885,620201,'市辖区',620200),(2886,620301,'市辖区',620300),(2887,620302,'金川区',620300),(2888,620321,'永昌县',620300),(2889,620401,'市辖区',620400),(2890,620402,'白银区',620400),(2891,620403,'平川区',620400),(2892,620421,'靖远县',620400),(2893,620422,'会宁县',620400),(2894,620423,'景泰县',620400),(2895,620501,'市辖区',620500),(2896,620502,'秦城区',620500),(2897,620503,'北道区',620500),(2898,620521,'清水县',620500),(2899,620522,'秦安县',620500),(2900,620523,'甘谷县',620500),(2901,620524,'武山县',620500),(2902,620525,'张家川回族自治县',620500),(2903,620601,'市辖区',620600),(2904,620602,'凉州区',620600),(2905,620621,'民勤县',620600),(2906,620622,'古浪县',620600),(2907,620623,'天祝藏族自治县',620600),(2908,620701,'市辖区',620700),(2909,620702,'甘州区',620700),(2910,620721,'肃南裕固族自治县',620700),(2911,620722,'民乐县',620700),(2912,620723,'临泽县',620700),(2913,620724,'高台县',620700),(2914,620725,'山丹县',620700),(2915,620801,'市辖区',620800),(2916,620802,'崆峒区',620800),(2917,620821,'泾川县',620800),(2918,620822,'灵台县',620800),(2919,620823,'崇信县',620800),(2920,620824,'华亭县',620800),(2921,620825,'庄浪县',620800),(2922,620826,'静宁县',620800),(2923,620901,'市辖区',620900),(2924,620902,'肃州区',620900),(2925,620921,'金塔县',620900),(2926,620922,'安西县',620900),(2927,620923,'肃北蒙古族自治县',620900),(2928,620924,'阿克塞哈萨克族自治县',620900),(2929,620981,'玉门市',620900),(2930,620982,'敦煌市',620900),(2931,621001,'市辖区',621000),(2932,621002,'西峰区',621000),(2933,621021,'庆城县',621000),(2934,621022,'环 县',621000),(2935,621023,'华池县',621000),(2936,621024,'合水县',621000),(2937,621025,'正宁县',621000),(2938,621026,'宁 县',621000),(2939,621027,'镇原县',621000),(2940,621101,'市辖区',621100),(2941,621102,'安定区',621100),(2942,621121,'通渭县',621100),(2943,621122,'陇西县',621100),(2944,621123,'渭源县',621100),(2945,621124,'临洮县',621100),(2946,621125,'漳 县',621100),(2947,621126,'岷 县',621100),(2948,621201,'市辖区',621200),(2949,621202,'武都区',621200),(2950,621221,'成 县',621200),(2951,621222,'文 县',621200),(2952,621223,'宕昌县',621200),(2953,621224,'康 县',621200),(2954,621225,'西和县',621200),(2955,621226,'礼 县',621200),(2956,621227,'徽 县',621200),(2957,621228,'两当县',621200),(2958,622901,'临夏市',622900),(2959,622921,'临夏县',622900),(2960,622922,'康乐县',622900),(2961,622923,'永靖县',622900),(2962,622924,'广河县',622900),(2963,622925,'和政县',622900),(2964,622926,'东乡族自治县',622900),(2965,622927,'积石山保安族东乡族撒拉族自治县',622900),(2966,623001,'合作市',623000),(2967,623021,'临潭县',623000),(2968,623022,'卓尼县',623000),(2969,623023,'舟曲县',623000),(2970,623024,'迭部县',623000),(2971,623025,'玛曲县',623000),(2972,623026,'碌曲县',623000),(2973,623027,'夏河县',623000),(2974,630101,'市辖区',630100),(2975,630102,'城东区',630100),(2976,630103,'城中区',630100),(2977,630104,'城西区',630100),(2978,630105,'城北区',630100),(2979,630121,'大通回族土族自治县',630100),(2980,630122,'湟中县',630100),(2981,630123,'湟源县',630100),(2982,632121,'平安县',632100),(2983,632122,'民和回族土族自治县',632100),(2984,632123,'乐都县',632100),(2985,632126,'互助土族自治县',632100),(2986,632127,'化隆回族自治县',632100),(2987,632128,'循化撒拉族自治县',632100),(2988,632221,'门源回族自治县',632200),(2989,632222,'祁连县',632200),(2990,632223,'海晏县',632200),(2991,632224,'刚察县',632200),(2992,632321,'同仁县',632300),(2993,632322,'尖扎县',632300),(2994,632323,'泽库县',632300),(2995,632324,'河南蒙古族自治县',632300),(2996,632521,'共和县',632500),(2997,632522,'同德县',632500),(2998,632523,'贵德县',632500),(2999,632524,'兴海县',632500),(3000,632525,'贵南县',632500),(3001,632621,'玛沁县',632600),(3002,632622,'班玛县',632600),(3003,632623,'甘德县',632600),(3004,632624,'达日县',632600),(3005,632625,'久治县',632600),(3006,632626,'玛多县',632600),(3007,632721,'玉树县',632700),(3008,632722,'杂多县',632700),(3009,632723,'称多县',632700),(3010,632724,'治多县',632700),(3011,632725,'囊谦县',632700),(3012,632726,'曲麻莱县',632700),(3013,632801,'格尔木市',632800),(3014,632802,'德令哈市',632800),(3015,632821,'乌兰县',632800),(3016,632822,'都兰县',632800),(3017,632823,'天峻县',632800),(3018,640101,'市辖区',640100),(3019,640104,'兴庆区',640100),(3020,640105,'西夏区',640100),(3021,640106,'金凤区',640100),(3022,640121,'永宁县',640100),(3023,640122,'贺兰县',640100),(3024,640181,'灵武市',640100),(3025,640201,'市辖区',640200),(3026,640202,'大武口区',640200),(3027,640205,'惠农区',640200),(3028,640221,'平罗县',640200),(3029,640301,'市辖区',640300),(3030,640302,'利通区',640300),(3031,640323,'盐池县',640300),(3032,640324,'同心县',640300),(3033,640381,'青铜峡市',640300),(3034,640401,'市辖区',640400),(3035,640402,'原州区',640400),(3036,640422,'西吉县',640400),(3037,640423,'隆德县',640400),(3038,640424,'泾源县',640400),(3039,640425,'彭阳县',640400),(3040,640501,'市辖区',640500),(3041,640502,'沙坡头区',640500),(3042,640521,'中宁县',640500),(3043,640522,'海原县',640500),(3044,650101,'市辖区',650100),(3045,650102,'天山区',650100),(3046,650103,'沙依巴克区',650100),(3047,650104,'新市区',650100),(3048,650105,'水磨沟区',650100),(3049,650106,'头屯河区',650100),(3050,650107,'达坂城区',650100),(3051,650108,'东山区',650100),(3052,650121,'乌鲁木齐县',650100),(3053,650201,'市辖区',650200),(3054,650202,'独山子区',650200),(3055,650203,'克拉玛依区',650200),(3056,650204,'白碱滩区',650200),(3057,650205,'乌尔禾区',650200),(3058,652101,'吐鲁番市',652100),(3059,652122,'鄯善县',652100),(3060,652123,'托克逊县',652100),(3061,652201,'哈密市',652200),(3062,652222,'巴里坤哈萨克自治县',652200),(3063,652223,'伊吾县',652200),(3064,652301,'昌吉市',652300),(3065,652302,'阜康市',652300),(3066,652303,'米泉市',652300),(3067,652323,'呼图壁县',652300),(3068,652324,'玛纳斯县',652300),(3069,652325,'奇台县',652300),(3070,652327,'吉木萨尔县',652300),(3071,652328,'木垒哈萨克自治县',652300),(3072,652701,'博乐市',652700),(3073,652722,'精河县',652700),(3074,652723,'温泉县',652700),(3075,652801,'库尔勒市',652800),(3076,652822,'轮台县',652800),(3077,652823,'尉犁县',652800),(3078,652824,'若羌县',652800),(3079,652825,'且末县',652800),(3080,652826,'焉耆回族自治县',652800),(3081,652827,'和静县',652800),(3082,652828,'和硕县',652800),(3083,652829,'博湖县',652800),(3084,652901,'阿克苏市',652900),(3085,652922,'温宿县',652900),(3086,652923,'库车县',652900),(3087,652924,'沙雅县',652900),(3088,652925,'新和县',652900),(3089,652926,'拜城县',652900),(3090,652927,'乌什县',652900),(3091,652928,'阿瓦提县',652900),(3092,652929,'柯坪县',652900),(3093,653001,'阿图什市',653000),(3094,653022,'阿克陶县',653000),(3095,653023,'阿合奇县',653000),(3096,653024,'乌恰县',653000),(3097,653101,'喀什市',653100),(3098,653121,'疏附县',653100),(3099,653122,'疏勒县',653100),(3100,653123,'英吉沙县',653100),(3101,653124,'泽普县',653100),(3102,653125,'莎车县',653100),(3103,653126,'叶城县',653100),(3104,653127,'麦盖提县',653100),(3105,653128,'岳普湖县',653100),(3106,653129,'伽师县',653100),(3107,653130,'巴楚县',653100),(3108,653131,'塔什库尔干塔吉克自治县',653100),(3109,653201,'和田市',653200),(3110,653221,'和田县',653200),(3111,653222,'墨玉县',653200),(3112,653223,'皮山县',653200),(3113,653224,'洛浦县',653200),(3114,653225,'策勒县',653200),(3115,653226,'于田县',653200),(3116,653227,'民丰县',653200),(3117,654002,'伊宁市',654000),(3118,654003,'奎屯市',654000),(3119,654021,'伊宁县',654000),(3120,654022,'察布查尔锡伯自治县',654000),(3121,654023,'霍城县',654000),(3122,654024,'巩留县',654000),(3123,654025,'新源县',654000),(3124,654026,'昭苏县',654000),(3125,654027,'特克斯县',654000),(3126,654028,'尼勒克县',654000),(3127,654201,'塔城市',654200),(3128,654202,'乌苏市',654200),(3129,654221,'额敏县',654200),(3130,654223,'沙湾县',654200),(3131,654224,'托里县',654200),(3132,654225,'裕民县',654200),(3133,654226,'和布克赛尔蒙古自治县',654200),(3134,654301,'阿勒泰市',654300),(3135,654321,'布尔津县',654300),(3136,654322,'富蕴县',654300),(3137,654323,'福海县',654300),(3138,654324,'哈巴河县',654300),(3139,654325,'青河县',654300),(3140,654326,'吉木乃县',654300),(3141,659001,'石河子市',659000),(3142,659002,'阿拉尔市',659000),(3143,659003,'图木舒克市',659000),(3144,659004,'五家渠市',659000);

/*Table structure for table `city` */

DROP TABLE IF EXISTS `city`;

CREATE TABLE `city` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `cityID` int(4) unsigned NOT NULL,
  `cityName` varchar(40) NOT NULL,
  `cityFather` int(4) unsigned NOT NULL,
  UNIQUE KEY `cityID` (`cityID`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `city` */

insert  into `city`(`id`,`cityID`,`cityName`,`cityFather`) values (1,110100,'市辖区',110000),(2,110200,'县',110000),(3,120100,'市辖区',120000),(4,120200,'县',120000),(5,130100,'石家庄市',130000),(6,130200,'唐山市',130000),(7,130300,'秦皇岛市',130000),(8,130400,'邯郸市',130000),(9,130500,'邢台市',130000),(10,130600,'保定市',130000),(11,130700,'张家口市',130000),(12,130800,'承德市',130000),(13,130900,'沧州市',130000),(14,131000,'廊坊市',130000),(15,131100,'衡水市',130000),(16,140100,'太原市',140000),(17,140200,'大同市',140000),(18,140300,'阳泉市',140000),(19,140400,'长治市',140000),(20,140500,'晋城市',140000),(21,140600,'朔州市',140000),(22,140700,'晋中市',140000),(23,140800,'运城市',140000),(24,140900,'忻州市',140000),(25,141000,'临汾市',140000),(26,141100,'吕梁市',140000),(27,150100,'呼和浩特市',150000),(28,150200,'包头市',150000),(29,150300,'乌海市',150000),(30,150400,'赤峰市',150000),(31,150500,'通辽市',150000),(32,150600,'鄂尔多斯市',150000),(33,150700,'呼伦贝尔市',150000),(34,150800,'巴彦淖尔市',150000),(35,150900,'乌兰察布市',150000),(36,152200,'兴安盟',150000),(37,152500,'锡林郭勒盟',150000),(38,152900,'阿拉善盟',150000),(39,210100,'沈阳市',210000),(40,210200,'大连市',210000),(41,210300,'鞍山市',210000),(42,210400,'抚顺市',210000),(43,210500,'本溪市',210000),(44,210600,'丹东市',210000),(45,210700,'锦州市',210000),(46,210800,'营口市',210000),(47,210900,'阜新市',210000),(48,211000,'辽阳市',210000),(49,211100,'盘锦市',210000),(50,211200,'铁岭市',210000),(51,211300,'朝阳市',210000),(52,211400,'葫芦岛市',210000),(53,220100,'长春市',220000),(54,220200,'吉林市',220000),(55,220300,'四平市',220000),(56,220400,'辽源市',220000),(57,220500,'通化市',220000),(58,220600,'白山市',220000),(59,220700,'松原市',220000),(60,220800,'白城市',220000),(61,222400,'延边朝鲜族自治州',220000),(62,230100,'哈尔滨市',230000),(63,230200,'齐齐哈尔市',230000),(64,230300,'鸡西市',230000),(65,230400,'鹤岗市',230000),(66,230500,'双鸭山市',230000),(67,230600,'大庆市',230000),(68,230700,'伊春市',230000),(69,230800,'佳木斯市',230000),(70,230900,'七台河市',230000),(71,231000,'牡丹江市',230000),(72,231100,'黑河市',230000),(73,231200,'绥化市',230000),(74,232700,'大兴安岭地区',230000),(75,310100,'市辖区',310000),(76,310200,'县',310000),(77,320100,'南京市',320000),(78,320200,'无锡市',320000),(79,320300,'徐州市',320000),(80,320400,'常州市',320000),(81,320500,'苏州市',320000),(82,320600,'南通市',320000),(83,320700,'连云港市',320000),(84,320800,'淮安市',320000),(85,320900,'盐城市',320000),(86,321000,'扬州市',320000),(87,321100,'镇江市',320000),(88,321200,'泰州市',320000),(89,321300,'宿迁市',320000),(90,330100,'杭州市',330000),(91,330200,'宁波市',330000),(92,330300,'温州市',330000),(93,330400,'嘉兴市',330000),(94,330500,'湖州市',330000),(95,330600,'绍兴市',330000),(96,330700,'金华市',330000),(97,330800,'衢州市',330000),(98,330900,'舟山市',330000),(99,331000,'台州市',330000),(100,331100,'丽水市',330000),(101,340100,'合肥市',340000),(102,340200,'芜湖市',340000),(103,340300,'蚌埠市',340000),(104,340400,'淮南市',340000),(105,340500,'马鞍山市',340000),(106,340600,'淮北市',340000),(107,340700,'铜陵市',340000),(108,340800,'安庆市',340000),(109,341000,'黄山市',340000),(110,341100,'滁州市',340000),(111,341200,'阜阳市',340000),(112,341300,'宿州市',340000),(113,341400,'巢湖市',340000),(114,341500,'六安市',340000),(115,341600,'亳州市',340000),(116,341700,'池州市',340000),(117,341800,'宣城市',340000),(118,350100,'福州市',350000),(119,350200,'厦门市',350000),(120,350300,'莆田市',350000),(121,350400,'三明市',350000),(122,350500,'泉州市',350000),(123,350600,'漳州市',350000),(124,350700,'南平市',350000),(125,350800,'龙岩市',350000),(126,350900,'宁德市',350000),(127,360100,'南昌市',360000),(128,360200,'景德镇市',360000),(129,360300,'萍乡市',360000),(130,360400,'九江市',360000),(131,360500,'新余市',360000),(132,360600,'鹰潭市',360000),(133,360700,'赣州市',360000),(134,360800,'吉安市',360000),(135,360900,'宜春市',360000),(136,361000,'抚州市',360000),(137,361100,'上饶市',360000),(138,370100,'济南市',370000),(139,370200,'青岛市',370000),(140,370300,'淄博市',370000),(141,370400,'枣庄市',370000),(142,370500,'东营市',370000),(143,370600,'烟台市',370000),(144,370700,'潍坊市',370000),(145,370800,'济宁市',370000),(146,370900,'泰安市',370000),(147,371000,'威海市',370000),(148,371100,'日照市',370000),(149,371200,'莱芜市',370000),(150,371300,'临沂市',370000),(151,371400,'德州市',370000),(152,371500,'聊城市',370000),(153,371600,'滨州市',370000),(154,371700,'荷泽市',370000),(155,410100,'郑州市',410000),(156,410200,'开封市',410000),(157,410300,'洛阳市',410000),(158,410400,'平顶山市',410000),(159,410500,'安阳市',410000),(160,410600,'鹤壁市',410000),(161,410700,'新乡市',410000),(162,410800,'焦作市',410000),(163,410900,'濮阳市',410000),(164,411000,'许昌市',410000),(165,411100,'漯河市',410000),(166,411200,'三门峡市',410000),(167,411300,'南阳市',410000),(168,411400,'商丘市',410000),(169,411500,'信阳市',410000),(170,411600,'周口市',410000),(171,411700,'驻马店市',410000),(172,420100,'武汉市',420000),(173,420200,'黄石市',420000),(174,420300,'十堰市',420000),(175,420500,'宜昌市',420000),(176,420600,'襄樊市',420000),(177,420700,'鄂州市',420000),(178,420800,'荆门市',420000),(179,420900,'孝感市',420000),(180,421000,'荆州市',420000),(181,421100,'黄冈市',420000),(182,421200,'咸宁市',420000),(183,421300,'随州市',420000),(184,422800,'恩施土家族苗族自治州',420000),(185,429000,'省直辖行政单位',420000),(186,430100,'长沙市',430000),(187,430200,'株洲市',430000),(188,430300,'湘潭市',430000),(189,430400,'衡阳市',430000),(190,430500,'邵阳市',430000),(191,430600,'岳阳市',430000),(192,430700,'常德市',430000),(193,430800,'张家界市',430000),(194,430900,'益阳市',430000),(195,431000,'郴州市',430000),(196,431100,'永州市',430000),(197,431200,'怀化市',430000),(198,431300,'娄底市',430000),(199,433100,'湘西土家族苗族自治州',430000),(200,440100,'广州市',440000),(201,440200,'韶关市',440000),(202,440300,'深圳市',440000),(203,440400,'珠海市',440000),(204,440500,'汕头市',440000),(205,440600,'佛山市',440000),(206,440700,'江门市',440000),(207,440800,'湛江市',440000),(208,440900,'茂名市',440000),(209,441200,'肇庆市',440000),(210,441300,'惠州市',440000),(211,441400,'梅州市',440000),(212,441500,'汕尾市',440000),(213,441600,'河源市',440000),(214,441700,'阳江市',440000),(215,441800,'清远市',440000),(216,441900,'东莞市',440000),(217,442000,'中山市',440000),(218,445100,'潮州市',440000),(219,445200,'揭阳市',440000),(220,445300,'云浮市',440000),(221,450100,'南宁市',450000),(222,450200,'柳州市',450000),(223,450300,'桂林市',450000),(224,450400,'梧州市',450000),(225,450500,'北海市',450000),(226,450600,'防城港市',450000),(227,450700,'钦州市',450000),(228,450800,'贵港市',450000),(229,450900,'玉林市',450000),(230,451000,'百色市',450000),(231,451100,'贺州市',450000),(232,451200,'河池市',450000),(233,451300,'来宾市',450000),(234,451400,'崇左市',450000),(235,460100,'海口市',460000),(236,460200,'三亚市',460000),(237,469000,'省直辖县级行政单位',460000),(238,500100,'市辖区',500000),(239,500200,'县',500000),(240,500300,'市',500000),(241,510100,'成都市',510000),(242,510300,'自贡市',510000),(243,510400,'攀枝花市',510000),(244,510500,'泸州市',510000),(245,510600,'德阳市',510000),(246,510700,'绵阳市',510000),(247,510800,'广元市',510000),(248,510900,'遂宁市',510000),(249,511000,'内江市',510000),(250,511100,'乐山市',510000),(251,511300,'南充市',510000),(252,511400,'眉山市',510000),(253,511500,'宜宾市',510000),(254,511600,'广安市',510000),(255,511700,'达州市',510000),(256,511800,'雅安市',510000),(257,511900,'巴中市',510000),(258,512000,'资阳市',510000),(259,513200,'阿坝藏族羌族自治州',510000),(260,513300,'甘孜藏族自治州',510000),(261,513400,'凉山彝族自治州',510000),(262,520100,'贵阳市',520000),(263,520200,'六盘水市',520000),(264,520300,'遵义市',520000),(265,520400,'安顺市',520000),(266,522200,'铜仁地区',520000),(267,522300,'黔西南布依族苗族自治州',520000),(268,522400,'毕节地区',520000),(269,522600,'黔东南苗族侗族自治州',520000),(270,522700,'黔南布依族苗族自治州',520000),(271,530100,'昆明市',530000),(272,530300,'曲靖市',530000),(273,530400,'玉溪市',530000),(274,530500,'保山市',530000),(275,530600,'昭通市',530000),(276,530700,'丽江市',530000),(277,530800,'思茅市',530000),(278,530900,'临沧市',530000),(279,532300,'楚雄彝族自治州',530000),(280,532500,'红河哈尼族彝族自治州',530000),(281,532600,'文山壮族苗族自治州',530000),(282,532800,'西双版纳傣族自治州',530000),(283,532900,'大理白族自治州',530000),(284,533100,'德宏傣族景颇族自治州',530000),(285,533300,'怒江傈僳族自治州',530000),(286,533400,'迪庆藏族自治州',530000),(287,540100,'拉萨市',540000),(288,542100,'昌都地区',540000),(289,542200,'山南地区',540000),(290,542300,'日喀则地区',540000),(291,542400,'那曲地区',540000),(292,542500,'阿里地区',540000),(293,542600,'林芝地区',540000),(294,610100,'西安市',610000),(295,610200,'铜川市',610000),(296,610300,'宝鸡市',610000),(297,610400,'咸阳市',610000),(298,610500,'渭南市',610000),(299,610600,'延安市',610000),(300,610700,'汉中市',610000),(301,610800,'榆林市',610000),(302,610900,'安康市',610000),(303,611000,'商洛市',610000),(304,620100,'兰州市',620000),(305,620200,'嘉峪关市',620000),(306,620300,'金昌市',620000),(307,620400,'白银市',620000),(308,620500,'天水市',620000),(309,620600,'武威市',620000),(310,620700,'张掖市',620000),(311,620800,'平凉市',620000),(312,620900,'酒泉市',620000),(313,621000,'庆阳市',620000),(314,621100,'定西市',620000),(315,621200,'陇南市',620000),(316,622900,'临夏回族自治州',620000),(317,623000,'甘南藏族自治州',620000),(318,630100,'西宁市',630000),(319,632100,'海东地区',630000),(320,632200,'海北藏族自治州',630000),(321,632300,'黄南藏族自治州',630000),(322,632500,'海南藏族自治州',630000),(323,632600,'果洛藏族自治州',630000),(324,632700,'玉树藏族自治州',630000),(325,632800,'海西蒙古族藏族自治州',630000),(326,640100,'银川市',640000),(327,640200,'石嘴山市',640000),(328,640300,'吴忠市',640000),(329,640400,'固原市',640000),(330,640500,'中卫市',640000),(331,650100,'乌鲁木齐市',650000),(332,650200,'克拉玛依市',650000),(333,652100,'吐鲁番地区',650000),(334,652200,'哈密地区',650000),(335,652300,'昌吉回族自治州',650000),(336,652700,'博尔塔拉蒙古自治州',650000),(337,652800,'巴音郭楞蒙古自治州',650000),(338,652900,'阿克苏地区',650000),(339,653000,'克孜勒苏柯尔克孜自治州',650000),(340,653100,'喀什地区',650000),(341,653200,'和田地区',650000),(342,654000,'伊犁哈萨克自治州',650000),(343,654200,'塔城地区',650000),(344,654300,'阿勒泰地区',650000),(345,659000,'省直辖行政单位',650000);

/*Table structure for table `province` */

DROP TABLE IF EXISTS `province`;

CREATE TABLE `province` (
  `id` int(4) unsigned NOT NULL,
  `provinceID` int(4) unsigned NOT NULL,
  `provinceName` varchar(40) NOT NULL,
  UNIQUE KEY `provinceID` (`provinceID`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `province` */

insert  into `province`(`id`,`provinceID`,`provinceName`) values (1,110000,'北京市/r'),(2,120000,'天津市/r'),(3,130000,'河北省/r'),(4,140000,'山西省/r'),(5,150000,'内蒙古自治区/r'),(6,210000,'辽宁省/r'),(7,220000,'吉林省/r'),(8,230000,'黑龙江省/r'),(9,310000,'上海市/r'),(10,320000,'江苏省/r'),(11,330000,'浙江省/r'),(12,340000,'安徽省/r'),(13,350000,'福建省/r'),(14,360000,'江西省/r'),(15,370000,'山东省/r'),(16,410000,'河南省/r'),(17,420000,'湖北省/r'),(18,430000,'湖南省/r'),(19,440000,'广东省/r'),(20,450000,'广西壮族自治区/r'),(21,460000,'海南省/r'),(22,500000,'重庆市/r'),(23,510000,'四川省/r'),(24,520000,'贵州省/r'),(25,530000,'云南省/r'),(26,540000,'西藏自治区/r'),(27,610000,'陕西省/r'),(28,620000,'甘肃省/r'),(29,630000,'青海省/r'),(30,640000,'宁夏回族自治区/r'),(31,650000,'新疆维吾尔自治区/r'),(32,710000,'台湾省/r'),(33,810000,'香港特别行政区/r'),(34,820000,'澳门特别行政区/r');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;



 01.js
--------------------------------------------------------------------
<!--
var xmlHttp
var xmlHttp2
//函数showMenu(str) - 功能函数1
function showMenu(str)
{
xmlHttp=GetXmlHttpObject()        //调用GetXmlHttpObject()函数,创建XMLHttpRequest对象
if (xmlHttp==null)                //如果创建失败,则
 {
 alert ("Browser does not support HTTP Request")
 return
 }
 
var url="get.php"                //定义url , 其主要读取数据库
url=url+"?q="+str
url=url+"&sid="+Math.random()    //Math对象的random方法,取随机数
xmlHttp.onreadystatechange=stateChanged //设置当XMLHttpRequest对象xmlHttp状态改变时调用的函数,注意函数名后不要添加小括号
xmlHttp.open("GET",url,true)    //使用XMLHttpRequest对象的open()方法 , 创建HTTP请求
xmlHttp.send(null)                //使用XMLHttpRequest对象的open()方法 , 发送HTTP请求
}

//函数showMenu(str) - 功能函数1
function showMenu2(str)
{

xmlHttp2=GetXmlHttpObject()        //调用GetXmlHttpObject()函数,创建XMLHttpRequest对象
if (xmlHttp2==null)                //如果创建失败,则
 {
 alert ("Browser does not support HTTP Request")
 return
 }
 
var url="get.php"                //定义url , 其主要读取数据库
url=url+"?q2="+str

url=url+"&sid="+Math.random()    //Math对象的random方法,取随机数
xmlHttp2.onreadystatechange=stateChanged2 //设置当XMLHttpRequest对象xmlHttp状态改变时调用的函数,注意函数名后不要添加小括号
xmlHttp2.open("GET",url,true)    //使用XMLHttpRequest对象的open()方法 , 创建HTTP请求
xmlHttp2.send(null)                //使用XMLHttpRequest对象的open()方法 , 发送HTTP请求
}

//函数BuildSel() , 根据返回的的字串 , 重新构建新的下拉菜单控件Select  -  功能函数2
function BuildSel(str,sel)
{
    //先清空原来的数据.
    sel.options.length=0;
    //定义一个数组对象
    var arrstr = new Array();
    //以","号拆分传入的字串,并存入数组
    arrstr = str.split(",");
    if(str.length>0)  
    {
        //循环
        for(var i=0;i<arrstr.length;i++)
        {
            var subarrstr=new Array();
            //以"|"拆分
            subarrstr=arrstr[i].split("|");
            sel.options.add(new Option(subarrstr[1],subarrstr[0]));
        }
        sel.options[0].selected=true;
    }
}






//函数stateChanged() - 响应HTTP请求状态变化
function stateChanged()
{
//判断XMLHttpRequest对象的readyState属性值是否为4,如果为4表示异步调用完成(注意:异步调用完成 不代表 异步调用成功)
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
 {
//如果异步调用成功 --> XMLHttpRequest对象的status属性值为200 , html文件在本地运行,则xmlHttp.status的返回值为0,故应该加上xmlHttp.status==0
 if(xmlHttp.status==200 || xmlHttp.status==0)
     {
         //调用文档对象模型DOM的getElementById()方法查找html文件中的标签txtHint ,
         //innerHTML为IE浏览器中的属性,可以用来更改标签间文本的内容 ,
         //xmlHttp.responseText , 通过XMLHttpRequest的responseText属性来获取数据 responseText,结果为字符串;responseXML,结果为XML形式
//         document.getElementById("txtHint").innerHTML=xmlHttp.responseText
         BuildSel(xmlHttp.responseText,document.getElementsByTagName("*").sel2)
         showMenu2(document.getElementsByTagName("*").sel2.value);
     }
 }
}

//函数stateChanged() - 响应HTTP请求状态变化
function stateChanged2()
{
//判断XMLHttpRequest对象的readyState属性值是否为4,如果为4表示异步调用完成(注意:异步调用完成 不代表 异步调用成功)
if (xmlHttp2.readyState==4 || xmlHttp2.readyState=="complete")
 {
//如果异步调用成功 --> XMLHttpRequest对象的status属性值为200 , html文件在本地运行,则xmlHttp.status的返回值为0,故应该加上xmlHttp.status==0
 if(xmlHttp2.status==200 || xmlHttp2.status==0)
     {
         //调用文档对象模型DOM的getElementById()方法查找html文件中的标签txtHint ,
         //innerHTML为IE浏览器中的属性,可以用来更改标签间文本的内容 ,
         //xmlHttp.responseText , 通过XMLHttpRequest的responseText属性来获取数据 responseText,结果为字符串;responseXML,结果为XML形式
//         document.getElementById("txtHint").innerHTML=xmlHttp.responseText
         BuildSel(xmlHttp2.responseText,document.getElementsByTagName("*").sel3)
     }
 }
}




//函数GetXmlHttpObject() - 创建XMLHttpRequest对象,即创建一个异步调用对象
function GetXmlHttpObject()
{
var xmlHttp=null;
try
 {
 // Firefox, Opera 8.0+, Safari
 xmlHttp=new XMLHttpRequest();
 }
catch (e)
 {
 //Internet Explorer
 try
  {
  xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
  }
 catch (e)
  {
  xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
 }
return xmlHttp;
}
-->

01.php(测试时,即访问此文件)
-------------------------------------------------------------------
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Ajax联动菜单</title>
<script language="javascript" type="text/javascript" src="01.js"></script>
</head>
<body>

<form>
<label>
<select name="sel" id="sel" onChange="showMenu(this.value);">
  <option>--请选择省--</option>
<?
$conn = mysql_connect('localhost', 'root', '123456') or die('Could not connect: ' . mysql_error());
mysql_select_db('areas', $conn) or die ('Can/'t use database : ' . mysql_error());
mysql_query("set names 'gb2312'");
$str = "SELECT * FROM `province` GROUP BY `provinceID` ORDER BY `id` ASC";
$result = mysql_query($str) or die("Invalid query: " . mysql_error());
if($result)
{
    while ($arr = mysql_fetch_array($result)){
        echo <<<EOD
<option value={$arr["provinceID"]}>{$arr["provinceName"]}</option>
EOD;
    }
}
mysql_close($conn);
?>
</select>
</label>


<label>
<select name="sel2" id="sel2" onChange="showMenu2(this.value)">
  <option>--请选择市--</option>
  </select>
</label>



<label>
<select name="sel3" id="sel3">
  <option>--请选择地区--</option>
</select>
</label>
</form>
<input type=button value="send value" onClick="alert(document.getElementById('sel').options[document.getElementById('sel').selectedIndex].text + '-' + document.getElementById('sel2').options[document.getElementById('sel2').selectedIndex].text + '-' + document.getElementById('sel3').options[document.getElementById('sel3').selectedIndex].text)">
</body>
</html>


get.php (读数据库里数据的功能页)
-------------------------------------------------------------------
<?
//指定编码
header('Content-Type:text/html;charset=GB2312');
//连接、选择数据库,设置字符集
$conn = mysql_connect('localhost', 'root', '123456') or die('Could not connect: ' . mysql_error());
mysql_select_db('areas', $conn) or die ('Can/'t use database : ' . mysql_error());
mysql_query("set names 'gb2312'");

//如果传递过来q
if($_GET["q"]){
$str = "SELECT * FROM `city` WHERE `cityFather`= '".$_GET["q"]."' GROUP BY `cityID` ORDER BY `id` ASC";
//echo $str;
$result = mysql_query($str) or die("Invalid query: " . mysql_error());
if($result)
{
    while ($arr = mysql_fetch_array($result)){
        $string .= $arr["cityID"]."|".$arr["cityName"].",";
       
    }
    echo substr($string,0,strlen($string)-1);
}
}

//如果传递过来q2
if($_GET["q2"]){
$str = "SELECT * FROM `area` WHERE `areaFather`= '".$_GET["q2"]."' GROUP BY `areaID` ORDER BY `id` ASC";
//echo $str;
$result = mysql_query($str) or die("Invalid query: " . mysql_error());
if($result)
{
    while ($arr = mysql_fetch_array($result)){
        $string .= $arr["areaID"]."|".$arr["areaName"].",";
       
    }
    //去掉字串最后一个字符","
    echo substr($string,0,strlen($string)-1);
}
}
mysql_close($conn);
?>


  • 2
    点赞
  • 0
    评论
  • 0
    收藏
  • 打赏
    打赏
  • 扫一扫,分享海报

参与评论 您还未登录,请先 登录 后发表或查看评论
联动,-- Table structure for province -- ---------------------------- DROP TABLE IF EXISTS `province`; CREATE TABLE `province` ( `id` int(5) NOT NULL auto_increment, `name` varchar(255) default '', `pid` int(5) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of province -- ---------------------------- INSERT INTO `province` VALUES ('82', '北京', '0'); INSERT INTO `province` VALUES ('83', '天津', '0'); INSERT INTO `province` VALUES ('84', '河北', '0'); INSERT INTO `province` VALUES ('85', '山西', '0'); INSERT INTO `province` VALUES ('86', '内蒙古自治区', '0'); INSERT INTO `province` VALUES ('87', '辽宁', '0'); INSERT INTO `province` VALUES ('88', '吉林', '0'); INSERT INTO `province` VALUES ('89', '黑龙江', '0'); INSERT INTO `province` VALUES ('90', '上海', '0'); INSERT INTO `province` VALUES ('91', '江苏', '0'); INSERT INTO `province` VALUES ('92', '浙江', '0'); INSERT INTO `province` VALUES ('93', '安徽', '0'); INSERT INTO `province` VALUES ('94', '福建', '0'); INSERT INTO `province` VALUES ('95', '江西', '0'); INSERT INTO `province` VALUES ('96', '山东', '0'); INSERT INTO `province` VALUES ('97', '河南', '0'); INSERT INTO `province` VALUES ('98', '湖北', '0'); INSERT INTO `province` VALUES ('99', '湖南', '0'); INSERT INTO `province` VALUES ('100', '广东', '0'); INSERT INTO `province` VALUES ('101', '广西壮族自治区', '0'); INSERT INTO `province` VALUES ('102', '海南', '0'); INSERT INTO `province` VALUES ('103', '重庆', '0'); INSERT INTO `province` VALUES ('104', '四川', '0'); INSERT INTO `province` VALUES ('105', '贵州', '0'); INSERT INTO `province` VALUES ('106', '云南', '0'); INSERT INTO `province` VALUES ('107', '西藏自治区', '0'); INSERT INTO `province` VALUES ('108', '陕西', '0'); INSERT INTO `province` VALUES ('109', '甘肃', '0'); INSERT INTO `province` VALUES ('110', '青海', '0'); INSERT INTO `province` VALUES ('111', '宁夏回族自治区', '0'); INSERT INTO `province` VALUES ('112', '新疆维吾尔自治区', '0'); INSERT INTO `province` VALUES ('113', '台
©️2022 CSDN 皮肤主题:大白 设计师:CSDN官方博客 返回首页

打赏作者

我把金钱献给你

你的鼓励将是我创作的最大动力

¥2 ¥4 ¥6 ¥10 ¥20
输入1-500的整数
余额支付 (余额:-- )
扫码支付
扫码支付:¥2
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值