省市县（区）三级级联

/* SQLyog Ultimate v11.24 (32 bit) MySQL - 5.6.23-log : Database - test ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!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' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*Table structure for table `t_city_area` */ DROP TABLE IF EXISTS `t_city_area`; CREATE TABLE `t_city_area` ( `code` varchar(6) NOT NULL, `name` varchar(60) NOT NULL, `level` int(11) DEFAULT NULL, `parent` varchar(6) DEFAULT NULL, PRIMARY KEY (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `t_city_area` */ insert into `t_city_area`(`code`,`name`,`level`,`parent`) values ('110000','北京市',1,NULL),('110100','市辖区',2,'110000'),('110101','东城区',3,'110100'),('110102','西城区',3,'110100'),('110105','朝阳区',3,'110100'),('110106','丰台区',3,'110100'),('110107','石景山区',3,'110100'),('110108','海淀区',3,'110100'),('110109','门头沟区',3,'110100'),('110111','房山区',3,'110100'),('110112','通州区',3,'110100'),('110113','顺义区',3,'110100'),('110114','昌平区',3,'110100'),('110115','大兴区',3,'110100'),('110116','怀柔区',3,'110100'),('110117','平谷区',3,'110100'),('110200','县',2,'110000'),('110228','密云县',3,'110200'),('110229','延庆县',3,'110200'),('120000','天津市',1,NULL),('120100','市辖区',2,'120000'),('120101','和平区',3,'120100'),('120102','河东区',3,'120100'),('120103','河西区',3,'120100'),('120104','南开区',3,'120100'),('120105','河北区',3,'120100'),('120106','红桥区',3,'120100'),('120110','东丽区',3,'120100'),('120111','西青区',3,'120100'),('120112','津南区',3,'120100'),('120113','北辰区',3,'120100'),('120114','武清区',3,'120100'),('120115','宝坻区',3,'120100'),('120116','滨海新区',3,'120100'),('120200','县',2,'120000'),('120221','宁河县',3,'120200'),('120223','静海县',3,'120200'),('120225','蓟县',3,'120200'),('130000','河北省',1,NULL),('130100','石家庄市',2,'130000'),('130101','市辖区',3,'130100'),('130102','长安区',3,'130100'),('130103','桥东区',3,'130100'),('130104','桥西区',3,'130100'),('130105','新华区',3,'130100'),('130107','井陉矿区',3,'130100'),('130108','裕华区',3,'130100'),('130121','井陉县',3,'130100'),('130123','正定县',3,'130100'),('130124','栾城县',3,'130100'),('130125','行唐县',3,'130100'),('130126','灵寿县',3,'130100'),('130127','高邑县',3,'130100'),('130128','深泽县',3,'130100'),('130129','赞皇县',3,'130100'),('130130','无极县',3,'130100'),('130131','平山县',3,'130100'),('130132','元氏县',3,'130100'),('130133','赵县',3,'130100'),('130181','辛集市',3,'130100'),('130182','藁城市',3,'130100'),('130183','晋州市',3,'130100'),('130184','新乐市',3,'130100'),('130185','鹿泉市',3,'130100'),('130200','唐山市',2,'130000'),('130201','市辖区',3,'130200'),('130202','路南区',3,'130200'),('130203','路北区',3,'130200'),('130204','古冶区',3,'130200'),('130205','开平区',3,'130200'),('130207','丰南区',3,'130200'),('130208','丰润区',3,'130200'),('130209','曹妃甸区',3,'130200'),('130223','滦县',3,'130200'),('130224','滦南县',3,'130200'),('130225','乐亭县',3,'130200'),('130227','迁西县',3,'130200'),('130229','玉田县',3,'130200'),('130281','遵化市',3,'130200'),('130283','迁安市',3,'130200'),('130300','秦皇岛市',2,'130000'),('130301','市辖区',3,'130300'),('130302','海港区',3,'130300'),('130303','山海关区',3,'130300'),('130304','北戴河区',3,'130300'),('130321','青龙满族自治县',3,'130300'),('130322','昌黎县',3,'130300'),('130323','抚宁县',3,'130300'),('130324','卢龙县',3,'130300'),('130400','邯郸市',2,'130000'),('130401','市辖区',3,'130400'),('130402','邯山区',3,'130400'),('130403','丛台区',3,'130400'),('130404','复兴区',3,'130400'),('130406','峰峰矿区',3,'130400'),('130421','邯郸县',3,'130400'),('130423','临漳县',3,'130400'),('130424','成安县',3,'130400'),('130425','大名县',3,'130400'),('130426','涉县',3,'130400'),('130427','磁县',3,'130400'),('130428','肥乡县',3,'130400'),('130429','永年县',3,'130400'),('130430','邱县',3,'130400'),('130431','鸡泽县',3,'130400'),('130432','广平县',3,'130400'),('130433','馆陶县',3,'130400'),('130434','魏县',3,'130400'),('130435','曲周县',3,'130400'),('130481','武安市',3,'130400'),('130500','邢台市',2,'130000'),('130501','市辖区',3,'130500'),('130502','桥东区',3,'130500'),('130503','桥西区',3,'130500'),('130521','邢台县',3,'130500'),('130522','临城县',3,'130500'),('130523','内丘县',3,'130500'),('130524','柏乡县',3,'130500'),('130525','隆尧县',3,'130500'),('130526','任县',3,'130500'),('130527','南和县',3,'130500'),('130528','宁晋县',3,'130500'),('130529','巨鹿县',3,'130500'),('130530','新河县',3,'130500'),('130531','广宗县',3,'130500'),('130532','平乡县',3,'130500'),('130533','威县',3,'130500'),('130534','清河县',3,'130500'),('130535','临西县',3,'130500'),('130581','南宫市',3,'130500'),('130582','沙河市',3,'130500'),('130600','保定市',2,'130000'),('130601','市辖区',3,'130600'),('130602','新市区',3,'130600'),('130603','北市区',3,'130600'),('130604','南市区',3,'130600'),('130621','满城县',3,'130600'),('130622','清苑县',3,'130600'),('130623','涞水县',3,'130600'),('130624','阜平县',3,'130600'),('130625','徐水县',3,'130600'),('130626','定兴县',3,'130600'),('130627','唐县',3,'130600'),('130628','高阳县',3,'130600'),('130629','容城县',3,'130600'),('130630','涞源县',3,'130600'),('130631','望都县',3,'130600'),('130632','安新县',3,'130600'),('130633','易县',3,'130600'),('130634','曲阳县',3,'130600'),('130635','蠡县',3,'130600'),('130636','顺平县',3,'130600'),('130637','博野县',3,'130600'),('130638','雄县',3,'130600'),('130681','涿州市',3,'130600'),('130682','定州市',3,'130600'),('130683','安国市',3,'130600'),('130684','高碑店市',3,'130600'),('130700','张家口市',2,'130000'),('130701','市辖区',3,'130700'),('130702','桥东区',3,'130700'),('130703','桥西区',3,'130700'),('130705','宣化区',3,'130700'),('130706','下花园区',3,'130700'),('130721','宣化县',3,'130700'),('130722','张北县',3,'130700'),('130723','康保县',3,'130700'),('130724','沽源县',3,'130700'),('130725','尚义县',3,'130700'),('130726','蔚县',3,'130700'),('130727','阳原县',3,'130700'),('130728','怀安县',3,'130700'),('130729','万全县',3,'130700'),('130730','怀来县',3,'130700'),('130731','涿鹿县',3,'130700'),('130732','赤城县',3,'130700'),('130733','崇礼县',3,'130700'),('130800','承德市',2,'130000'),('130801','市辖区',3,'130800'),('130802','双桥区',3,'130800'),('130803','双滦区',3,'130800'),('130804','鹰手营子矿区',3,'130800'),('130821','承德县',3,'130800'),('130822','兴隆县',3,'130800'),('130823','平泉县',3,'130800'),('130824','滦平县',3,'130800'),('130825','隆化县',3,'130800'),('130826','丰宁满族自治县',3,'130800'),('130827','宽城满族自治县',3,'130800'),('130828','围场满族蒙古族自治县',3,'130800'),('130900','沧州市',2,'130000'),('130901','市辖区',3,'130900'),('130902','新华区',3,'130900'),('130903','运河区',3,'130900'),('130921','沧县',3,'130900'),('130922','青县',3,'130900'),('130923','东光县',3,'130900'),('130924','海兴县',3,'130900'),('130925','盐山县',3,'130900'),('130926','肃宁县',3,'130900'),('130927','南皮县',3,'130900'),('130928','吴桥县',3,'130900'),('130929','献县',3,'130900'),('130930','孟村回族自治县',3,'130900'),('130981','泊头市',3,'130900'),('130982','任丘市',3,'130900'),('130983','黄骅市',3,'130