中国省市区县大全mysql脚本含编码.docx

1、中国省市区县大全mysql脚本含编码中国省市区县大全mysql脚本（含省市区代码）/* Navicat Premium Data Transfer Target Server Type : MySQL Target Server Version : 80016 File Encoding : 65001 Date: 24/07/2019 15:04:17*/SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;- - Table structure for base_area- -DROP TABLE IF EXISTS base_area;CREATE T

2、ABLE base_area ( id int(11) NOT NULL AUTO_INCREMENT, area_no varchar(20) NOT NULL COMMENT 区县编码, area_name varchar(50) NOT NULL COMMENT 区县名称, city_no varchar(20) NOT NULL COMMENT 城市编码, PRIMARY KEY (id) ENGINE=MyISAM AUTO_INCREMENT=3145 DEFAULT CHARSET=utf8 COMMENT=行政区域县区信息表;- - Records of base_area-

3、-BEGIN;INSERT INTO base_area VALUES (1, 110101, 东城区, 110100);INSERT INTO base_area VALUES (2, 110102, 西城区, 110100);INSERT INTO base_area VALUES (3, 110103, 崇文区, 110100);INSERT INTO base_area VALUES (4, 110104, 宣武区, 110100);INSERT INTO base_area VALUES (5, 110105, 朝阳区, 110100);INSERT INTO base_area V

4、ALUES (6, 110106, 丰台区, 110100);INSERT INTO base_area VALUES (7, 110107, 石景山区, 110100);INSERT INTO base_area VALUES (8, 110108, 海淀区, 110100);INSERT INTO base_area VALUES (9, 110109, 门头沟区, 110100);INSERT INTO base_area VALUES (10, 110111, 房山区, 110100);INSERT INTO base_area VALUES (11, 110112, 通州区, 110

5、100);INSERT INTO base_area VALUES (12, 110113, 顺义区, 110100);INSERT INTO base_area VALUES (13, 110114, 昌平区, 110100);INSERT INTO base_area VALUES (14, 110115, 大兴区, 110100);INSERT INTO base_area VALUES (15, 110116, 怀柔区, 110100);INSERT INTO base_area VALUES (16, 110117, 平谷区, 110100);INSERT INTO base_are

6、a VALUES (17, 110228, 密云县, 110200);INSERT INTO base_area VALUES (18, 110229, 延庆县, 110200);INSERT INTO base_area VALUES (19, 120101, 和平区, 120100);INSERT INTO base_area VALUES (20, 120102, 河东区, 120100);INSERT INTO base_area VALUES (21, 120103, 河西区, 120100);INSERT INTO base_area VALUES (22, 120104, 南开区

7、, 120100);INSERT INTO base_area VALUES (23, 120105, 河北区, 120100);INSERT INTO base_area VALUES (24, 120106, 红桥区, 120100);INSERT INTO base_area VALUES (25, 120107, 塘沽区, 120100);INSERT INTO base_area VALUES (26, 120108, 汉沽区, 120100);INSERT INTO base_area VALUES (27, 120109, 大港区, 120100);INSERT INTO bas

8、e_area VALUES (28, 120110, 东丽区, 120100);INSERT INTO base_area VALUES (29, 120111, 西青区, 120100);INSERT INTO base_area VALUES (30, 120112, 津南区, 120100);INSERT INTO base_area VALUES (31, 120113, 北辰区, 120100);INSERT INTO base_area VALUES (32, 120114, 武清区, 120100);INSERT INTO base_area VALUES (33, 120115

9、, 宝坻区, 120100);INSERT INTO base_area VALUES (34, 120221, 宁河县, 120200);INSERT INTO base_area VALUES (35, 120223, 静海县, 120200);INSERT INTO base_area VALUES (36, 120225, 蓟县, 120200);INSERT INTO base_area VALUES (37, 130101, 市辖区, 130100);INSERT INTO base_area VALUES (38, 130102, 长安区, 130100);INSERT INTO

10、 base_area VALUES (39, 130103, 桥东区, 130100);INSERT INTO base_area VALUES (40, 130104, 桥西区, 130100);INSERT INTO base_area VALUES (41, 130105, 新华区, 130100);INSERT INTO base_area VALUES (42, 130107, 井陉矿区, 130100);INSERT INTO base_area VALUES (43, 130108, 裕华区, 130100);INSERT INTO base_area VALUES (44, 1

11、30121, 井陉县, 130100);INSERT INTO base_area VALUES (45, 130123, 正定县, 130100);INSERT INTO base_area VALUES (46, 130124, 栾城县, 130100);INSERT INTO base_area VALUES (47, 130125, 行唐县, 130100);INSERT INTO base_area VALUES (48, 130126, 灵寿县, 130100);INSERT INTO base_area VALUES (49, 130127, 高邑县, 130100);INSER

12、T INTO base_area VALUES (50, 130128, 深泽县, 130100);INSERT INTO base_area VALUES (51, 130129, 赞皇县, 130100);INSERT INTO base_area VALUES (52, 130130, 无极县, 130100);INSERT INTO base_area VALUES (53, 130131, 平山县, 130100);INSERT INTO base_area VALUES (54, 130132, 元氏县, 130100);INSERT INTO base_area VALUES (

13、55, 130133, 赵县, 130100);INSERT INTO base_area VALUES (56, 130181, 辛集市, 130100);INSERT INTO base_area VALUES (57, 130182, 藁城市, 130100);INSERT INTO base_area VALUES (58, 130183, 晋州市, 130100);INSERT INTO base_area VALUES (59, 130184, 新乐市, 130100);INSERT INTO base_area VALUES (60, 130185, 鹿泉市, 130100);I

14、NSERT INTO base_area VALUES (61, 130201, 市辖区, 130200);INSERT INTO base_area VALUES (62, 130202, 路南区, 130200);INSERT INTO base_area VALUES (63, 130203, 路北区, 130200);INSERT INTO base_area VALUES (64, 130204, 古冶区, 130200);INSERT INTO base_area VALUES (65, 130205, 开平区, 130200);INSERT INTO base_area VALU

15、ES (66, 130207, 丰南区, 130200);INSERT INTO base_area VALUES (67, 130208, 丰润区, 130200);INSERT INTO base_area VALUES (68, 130223, 滦县, 130200);INSERT INTO base_area VALUES (69, 130224, 滦南县, 130200);INSERT INTO base_area VALUES (70, 130225, 乐亭县, 130200);INSERT INTO base_area VALUES (71, 130227, 迁西县, 13020

16、0);INSERT INTO base_area VALUES (72, 130229, 玉田县, 130200);INSERT INTO base_area VALUES (73, 130230, 唐海县, 130200);INSERT INTO base_area VALUES (74, 130281, 遵化市, 130200);INSERT INTO base_area VALUES (75, 130283, 迁安市, 130200);INSERT INTO base_area VALUES (76, 130301, 市辖区, 130300);INSERT INTO base_area

17、VALUES (77, 130302, 海港区, 130300);INSERT INTO base_area VALUES (78, 130303, 山海关区, 130300);INSERT INTO base_area VALUES (79, 130304, 北戴河区, 130300);INSERT INTO base_area VALUES (80, 130321, 青龙满族自治县, 130300);INSERT INTO base_area VALUES (81, 130322, 昌黎县, 130300);INSERT INTO base_area VALUES (82, 130323,

18、 抚宁县, 130300);INSERT INTO base_area VALUES (83, 130324, 卢龙县, 130300);INSERT INTO base_area VALUES (84, 130401, 市辖区, 130400);INSERT INTO base_area VALUES (85, 130402, 邯山区, 130400);INSERT INTO base_area VALUES (86, 130403, 丛台区, 130400);INSERT INTO base_area VALUES (87, 130404, 复兴区, 130400);INSERT INTO

19、 base_area VALUES (88, 130406, 峰峰矿区, 130400);INSERT INTO base_area VALUES (89, 130421, 邯郸县, 130400);INSERT INTO base_area VALUES (90, 130423, 临漳县, 130400);INSERT INTO base_area VALUES (91, 130424, 成安县, 130400);INSERT INTO base_area VALUES (92, 130425, 大名县, 130400);INSERT INTO base_area VALUES (93, 1

20、30426, 涉县, 130400);INSERT INTO base_area VALUES (94, 130427, 磁县, 130400);INSERT INTO base_area VALUES (95, 130428, 肥乡县, 130400);INSERT INTO base_area VALUES (96, 130429, 永年县, 130400);INSERT INTO base_area VALUES (97, 130430, 邱县, 130400);INSERT INTO base_area VALUES (98, 130431, 鸡泽县, 130400);INSERT I

21、NTO base_area VALUES (99, 130432, 广平县, 130400);INSERT INTO base_area VALUES (100, 130433, 馆陶县, 130400);INSERT INTO base_area VALUES (101, 130434, 魏县, 130400);INSERT INTO base_area VALUES (102, 130435, 曲周县, 130400);INSERT INTO base_area VALUES (103, 130481, 武安市, 130400);INSERT INTO base_area VALUES (

22、104, 130501, 市辖区, 130500);INSERT INTO base_area VALUES (105, 130502, 桥东区, 130500);INSERT INTO base_area VALUES (106, 130503, 桥西区, 130500);INSERT INTO base_area VALUES (107, 130521, 邢台县, 130500);INSERT INTO base_area VALUES (108, 130522, 临城县, 130500);INSERT INTO base_area VALUES (109, 130523, 内丘县, 13

23、0500);INSERT INTO base_area VALUES (110, 130524, 柏乡县, 130500);INSERT INTO base_area VALUES (111, 130525, 隆尧县, 130500);INSERT INTO base_area VALUES (112, 130526, 任县, 130500);INSERT INTO base_area VALUES (113, 130527, 南和县, 130500);INSERT INTO base_area VALUES (114, 130528, 宁晋县, 130500);INSERT INTO bas

24、e_area VALUES (115, 130529, 巨鹿县, 130500);INSERT INTO base_area VALUES (116, 130530, 新河县, 130500);INSERT INTO base_area VALUES (117, 130531, 广宗县, 130500);INSERT INTO base_area VALUES (118, 130532, 平乡县, 130500);INSERT INTO base_area VALUES (119, 130533, 威县, 130500);INSERT INTO base_area VALUES (120, 1

25、30534, 清河县, 130500);INSERT INTO base_area VALUES (121, 130535, 临西县, 130500);INSERT INTO base_area VALUES (122, 130581, 南宫市, 130500);INSERT INTO base_area VALUES (123, 130582, 沙河市, 130500);INSERT INTO base_area VALUES (124, 130601, 市辖区, 130600);INSERT INTO base_area VALUES (125, 130602, 新市区, 130600);

26、INSERT INTO base_area VALUES (126, 130603, 北市区, 130600);INSERT INTO base_area VALUES (127, 130604, 南市区, 130600);INSERT INTO base_area VALUES (128, 130621, 满城县, 130600);INSERT INTO base_area VALUES (129, 130622, 清苑县, 130600);INSERT INTO base_area VALUES (130, 130623, 涞水县, 130600);INSERT INTO base_are

27、a VALUES (131, 130624, 阜平县, 130600);INSERT INTO base_area VALUES (132, 130625, 徐水县, 130600);INSERT INTO base_area VALUES (133, 130626, 定兴县, 130600);INSERT INTO base_area VALUES (134, 130627, 唐县, 130600);INSERT INTO base_area VALUES (135, 130628, 高阳县, 130600);INSERT INTO base_area VALUES (136, 130629, 容城县, 130600);INSERT INTO base_area VALUES (137, 130630, 涞源县, 130600);INSERT INTO base_area VALUES (138, 130631, 望都县, 130600);INSERT INTO base_area VALUES (139, 130632, 安新县, 130600);INSERT INTO base_area VALUES (140, 130633, 易县, 130600);INSERT INTO base_area VALUES (141, 130634, 曲阳县, 13060