省/直辖市、市、区/县/地级市、街道/镇、社区/乡村五级联动sql
创建数据库及新增数据sql语句
DROP TABLE IF EXISTS `sys_area`;
CREATE TABLE `sys_area` (
`id` bigint(0) NOT NULL COMMENT '区划代码',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
`pid` bigint(0) NULL DEFAULT NULL COMMENT '父级区划代码',
`province_code` bigint(0) NULL DEFAULT NULL COMMENT '省/直辖市代码',
`city_code` bigint(0) NULL DEFAULT NULL COMMENT '市代码',
`area_code` bigint(0) NULL DEFAULT NULL COMMENT '区/县代码',
`street_code` bigint(0) NULL DEFAULT NULL COMMENT '街道/镇代码',
`committee_code` bigint(0) NULL DEFAULT NULL COMMENT '社区/乡村代码',
`committee_type` bigint(0) NULL DEFAULT NULL COMMENT '城乡分类代码',
`sort` int(0) NULL DEFAULT NULL COMMENT '排序',
`level` int(0) NULL DEFAULT NULL COMMENT '级别: 1-省/直辖市, 2-市, 3-区/县/地级市, 4-街道/镇, 5-社区/乡村',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
插入数据sql
全国数据较大,此处以北京市为例,需要全数据可以私我
INSERT INTO `sys_area` VALUES (110000000000, 0, '北京市', 11, NULL, NULL, NULL, NULL, NULL, 1, 1);
INSERT INTO `sys_area` VALUES (110100000000, 110000000000, '市辖区', 11, 1101, NULL, NULL, NULL, NULL, 1, 2);
INSERT INTO `sys_area` VALUES (110101000000, 110100000000, '东城区', 11, 1101, 110101, NULL, NULL, NULL, 1, 3);
INSERT INTO `sys_area` VALUES (110101001000, 110101000000, '东华门街道', 11, 1101, 110101, 110101001, NULL, NULL, 1, 4);
INSERT INTO `sys_area` VALUES (110101001001, 110101001000, '多福巷社区居委会', 11, 1101, 110101, 110101001, 110101001001, 111, 1, 5);
INSERT INTO `sys_area` VALUES (110101001002, 110101001000, '银闸社区居委会', 11, 1101, 110101, 110101001, 110101001002, 111, 2, 5);
INSERT INTO `sys_area` VALUES (110101001005, 110101001000, '东厂社区居委会', 11, 1101, 110101, 110101001, 110101001005, 111, 3, 5);
INSERT INTO `sys_area` VALUES (110101001006, 110101001000, '智德社区居委会', 11, 1101, 110101, 110101001, 110101001006, 111, 4, 5);
INSERT INTO `sys_area` VALUES (110101001007, 110101001000, '南池子社区居委会', 11, 1101, 110101, 110101001, 110101001007, 111, 5, 5);
INSERT INTO `sys_area` VALUES (110101001008, 110101001000, '黄图岗社区居委会', 11, 1101, 110101, 110101001, 110101001008, 111, 6, 5);
INSERT INTO `sys_area` VALUES (110101001009, 110101001000, '灯市口社区居委会', 11, 1101, 110101, 110101001, 110101001009, 111, 7, 5);
INSERT INTO `sys_area` VALUES (110101001010, 110101001000, '正义路社区居委会', 11, 1101, 110101, 110101001, 110101001010, 111, 8, 5);
INSERT INTO `sys_area` VALUES (110101001011, 110101001000, '甘雨社区居委会', 11, 1101, 110101, 110101001, 110101001011, 111, 9, 5);
INSERT INTO `sys_area` VALUES (110101001013, 110101001000, '台基厂社区居委会', 11, 1101, 110101, 110101001, 110101001013, 111, 10, 5);
INSERT INTO `sys_area` VALUES (110101001014, 110101001000, '韶九社区居委会', 11, 1101, 110101, 110101001, 110101001014, 111, 11, 5);
INSERT INTO `sys_area` VALUES (110101001015, 110101001000, '王府井社区居委会', 11, 1101, 110101, 110101001, 110101001015, 111, 12, 5);
INSERT INTO `sys_area` VALUES (110101002000, 110101000000, '景山街道', 11, 1101, 110101, 110101002, NULL, NULL, 2, 4);