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;

资源链接: 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
  )