全国行政区划县级以上mysql版.docx

1、全国行政区划县级以上mysql版/*Navicat MySQL Data TransferSource Server : hlz-mysqlSource Server Version : 50619Source Host : localhost:3306Source Database : gyyTarget Server Type : MYSQLTarget Server Version : 50619File Encoding : 65001Date: 2014-09-19 00:11:37*/SET FOREIGN_KEY_CHECKS=0;- - Table structure for

2、sys_administrative- -DROP TABLE IF EXISTS sys_administrative;CREATE TABLE sys_administrative ( id int(11) NOT NULL DEFAULT 0, pid int(11) DEFAULT NULL, name varchar(60) DEFAULT NULL, stateid int(2) DEFAULT NULL, createdatetime datetime(6) DEFAULT NULL, PRIMARY KEY (id), KEY idx_pid (pid) USING BTREE

3、) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=行政区划信息表;- - Records of sys_administrative- -INSERT INTO sys_administrative VALUES (10, null, 行政区划, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110000, 10, 北京市, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES

4、(110100, 110000, 北京市, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110101, 110100, 东城区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110102, 110100, 西城区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110105, 110100, 朝阳区, 1, 20

5、14-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110106, 110100, 丰台区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110107, 110100, 石景山区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110108, 110100, 海淀区, 1, 2014-09-10 13:33:41.000000);

6、INSERT INTO sys_administrative VALUES (110109, 110100, 门头沟区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110111, 110100, 房山区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110112, 110100, 通州区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administra

7、tive VALUES (110113, 110100, 顺义区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110114, 110100, 昌平区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110115, 110100, 大兴区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110116, 110100

8、, 怀柔区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110117, 110100, 平谷区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110200, 110000, 北京县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (110228, 110200, 密云县, 1, 2014-09-10 13:33:

9、41.000000);INSERT INTO sys_administrative VALUES (110229, 110200, 延庆县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120000, 10, 天津市, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120100, 120000, 天津市, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_admi

10、nistrative VALUES (120101, 120100, 和平区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120102, 120100, 河东区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120103, 120100, 河西区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120104,

11、120100, 南开区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120105, 120100, 河北区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120106, 120100, 红桥区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120110, 120100, 东丽区, 1, 2014-09-10

12、13:33:41.000000);INSERT INTO sys_administrative VALUES (120111, 120100, 西青区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120112, 120100, 津南区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120113, 120100, 北辰区, 1, 2014-09-10 13:33:41.000000);INSERT INT

13、O sys_administrative VALUES (120114, 120100, 武清区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120115, 120100, 宝坻区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120116, 120100, 滨海新区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUE

14、S (120200, 120100, 天津县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120221, 120100, 宁河县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120223, 120100, 静海县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (120225, 120100, 蓟县, 1, 2

15、014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130000, 10, 河北省, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130100, 130000, 石家庄市, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130101, 130100, 市辖区, 1, 2014-09-10 13:33:41.000000);INS

16、ERT INTO sys_administrative VALUES (130102, 130100, 长安区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130103, 130100, 桥东区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130104, 130100, 桥西区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative

17、 VALUES (130105, 130100, 新华区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130107, 130100, 井陉矿区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130108, 130100, 裕华区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130121, 130100, 井

18、陉县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130123, 130100, 正定县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130124, 130100, 栾城县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130125, 130100, 行唐县, 1, 2014-09-10 13:33:41.

19、000000);INSERT INTO sys_administrative VALUES (130126, 130100, 灵寿县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130127, 130100, 高邑县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130128, 130100, 深泽县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_adm

20、inistrative VALUES (130129, 130100, 赞皇县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130130, 130100, 无极县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130131, 130100, 平山县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130132,

21、 130100, 元氏县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130133, 130100, 赵县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130181, 130100, 辛集市, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130182, 130100, 藁城市, 1, 2014-09-10

22、13:33:41.000000);INSERT INTO sys_administrative VALUES (130183, 130100, 晋州市, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130184, 130100, 新乐市, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130185, 130100, 鹿泉市, 1, 2014-09-10 13:33:41.000000);INSERT INT

23、O sys_administrative VALUES (130200, 130000, 唐山市, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130201, 130200, 市辖区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130202, 130200, 路南区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES

24、 (130203, 130200, 路北区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130204, 130200, 古冶区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130205, 130200, 开平区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130207, 130200, 丰南区, 1, 2

25、014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130208, 130200, 丰润区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130209, 130200, 曹妃甸区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130223, 130200, 滦县, 1, 2014-09-10 13:33:41.000000);

26、INSERT INTO sys_administrative VALUES (130224, 130200, 滦南县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130225, 130200, 乐亭县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130227, 130200, 迁西县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrat

27、ive VALUES (130229, 130200, 玉田县, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130281, 130200, 遵化市, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130283, 130200, 迁安市, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130300, 130000,

28、 秦皇岛市, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130301, 130300, 市辖区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130302, 130300, 海港区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130303, 130300, 山海关区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130304, 130300, 北戴河区, 1, 2014-09-10 13:33:41.000000);INSERT INTO sys_administrative VALUES (130321, 130300, 青龙满族自治县, 1, 2014-09-10 13:33:4