2022年最新全国各省五级行政区划代码及mysql数据库代码（省市区县乡镇村）
2022年最新全国各省五级行政区划代码及mysql数据库代码（省/市/区县/乡镇/村）
“原创不易，如有遗漏请留言”
1、全国统计用区划代码和城乡划分代码更新维护的标准时点为2021年10月31日。
2、全国31省、多达 61W + 行数据。
3、mysql 数据结构：
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;
资源链接: <>
备注：
查询所有的省级：
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
)