通过mybatis-plus实现动态创建数据表

堂前燕Tornado

于 2024-12-03 17:32:33 发布

阅读量684

点赞数

CC 4.0 BY-SA版权

分类专栏：项目实战总结文章标签： mybatis java 前端

本文链接：https://blog.youkuaiyun.com/EscapePlan/article/details/144220044

项目实战总结专栏收录该内容

26 篇文章 ¥29.90 ¥99.00

订阅专栏

超级会员免费看

@Mapper
public interface ApiLogMapper extends BaseMapper<ApiLog> {

    @Update("CREATE TABLE ${tableName}   (\n" +
            "  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,\n" +
            "  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志目录编号',\n" +
            "  `module_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '模块名称',\n" +
            "  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '名',\n" +
            "  `operate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作',\n" +
            "  `business_type` varchar(2) CHARACTER SET utf8mb4