2017最新行政区划sql

/* SQLyog Ultimate v11.11 (64 bit) MySQL - 5.6.11 : Database - jichuang ********************************************************************* */ /*!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 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`jichuang` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `jichuang`; /*Table structure for table `aa26` */ DROP TABLE IF EXISTS `aa26`; CREATE TABLE `aa26` ( `aac031` int(6) NOT NULL COMMENT '行政区划代码', `aaa146` varchar(50) DEFAULT NULL COMMENT '行政区划名称', `aaa147` int(1) DEFAULT NULL COMMENT '行政区划等级', `aaa148` int(6) DEFAULT NULL COMMENT '上级行政区划', PRIMARY KEY (`aac031`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='行政区划'; /*Data for the table `aa26` */ insert into `aa26`(`aac031`,`aaa146`,`aaa147`,`aaa148`) values (110000,'北京市',1,0),(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,0),(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,0),(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,130200),(130182,'藁城市',3,130200),(130183,'晋州市',3,130200),(130184,'新乐市',3,130200),(130185,'鹿泉市',3,130200),(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,130300),(130283,'迁安市',3,130300),(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,130500),(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,130600),(130582,'沙河市',3,130600),(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,130700),(130682,'定州市',3,130700),(130683,'安国市',3,130700),(130684,'高碑店市',3,130700),(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,131000),(130982,'任丘市',3,131000),(130983,'黄骅市',3,131000),(130984,'河间市',3,131000),(131000,'廊坊市',2,130000),(131001,'市辖区',3,131000),(131002,'安次区',3,131000),(131003,'广阳区',3,131000),(131022,'固安县',3,131000),(131023,'永清县',3,131000),(131024,'香河县',3,131000),(131025,'大城县',3,131000),(131026,'文安县',3,131000),(131028,'大厂回族自治县',3,131000),(131081,'霸州市',3,131100),(131082,'三河市',3,131100),(131100,'衡水市',2,130000),(131101,'市辖区',3,131100),(131102,'桃城区',3,131100),(131121,'枣强县',3,131100),(131122,'武邑县',3,131100),(131123,'武强县',3,131100),(131124,'饶阳县'