社区微信群开通啦,扫一扫抢先加入社区官方微信群
社区微信群
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for town_zoning_code
-- ----------------------------
DROP TABLE IF EXISTS `town_zoning_code`;
CREATE TABLE `town_zoning_code` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主建索引号',
`province_code` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省份区划代码',
`province` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省份',
`city_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市区划代码',
`city_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市名称',
`county_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区县区划代码
',
`county_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区县名称
',
`town_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '乡镇区划代码
',
`town_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '乡镇名称
',
`committee_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '居委会村代码
',
`classify_code` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城乡分类代码
',
`committee_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '居委会区名称
',
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地址
',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24064 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
资源链接: https://download.csdn.net/download/qq_42711127/85093096
备注:
查询所有的省级:
SELECT
id,
province,
province_code
FROM
town_zoning_code
WHERE
id IN (
SELECT
min( id )
FROM
town_zoning_code
GROUP BY
province_code
)查询省级下所有的市:
SELECT
id,
province_code,
province,
city_code,
city_name
FROM
town_zoning_code
WHERE
id IN (
SELECT
min( id )
FROM
town_zoning_code
WHERE
province_code = ‘520000’
GROUP BY
city_code
)查询市下所有的区/县:
SELECT
id,
province_code,
province,
city_code,
city_name,
county_code,
county_name
FROM
town_zoning_code
WHERE
id IN (
SELECT
min( id )
FROM
town_zoning_code
WHERE
city_code = ‘520500’
GROUP BY
county_code
)查询区/县下所有的街道:
SELECT
id,
province_code,
province,
city_code,
city_name,
county_code,
county_name,
town_code,
town_name
FROM
town_zoning_code
WHERE
id IN (
SELECT
min(id)
FROM
town_zoning_code
WHERE
county_code = ‘520524’
GROUP BY
town_code
)
如果觉得我的文章对您有用,请随意打赏。你的支持将鼓励我继续创作!