点击文件名下载附件
编辑界面无法联动
mysql 8 版本 数据库有两张表如下：
CREATE TABLE `target` (
`id` int NOT NULL AUTO_INCREMENT,
`city` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '城市',
`city_area` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '区域',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
CREATE TABLE `wb` (
`city` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '城市',
`city_area` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '区域'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
INSERT INTO `wb` (`city`, `city_area`) VALUES ('深圳', '南山区');
INSERT INTO `wb` (`city`, `city_area`) VALUES ('深圳', '宝安区');
INSERT INTO `wb` (`city`, `city_area`) VALUES ('武汉', '高新区');
INSERT INTO `wb` (`city`, `city_area`) VALUES ('武汉', '汉阳区');