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 '区县区划代码\r\n',
  `county_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区县名称\r\n',
  `town_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '乡镇区划代码\r\n',
  `town_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '乡镇名称\r\n',
  `committee_code` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '居委会村代码\r\n',
  `classify_code` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城乡分类代码\r\n',
  `committee_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '居委会区名称\r\n',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地址\r\n',
  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 
	)