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 )
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)