在mapper.xml中一般都是对表数据进行DML(增删改查)操作,很少通过MyBatis对数据库进行DDL(create, alter, drop)操作,下面就mybatis的DDL给大家做个简单介绍。
方法一、在相关mapper.xml文件中DDL的配置代码
@Update("alter table ${tableName} rename ${newTableName}")
void alterTableName(String tableName,String newTableName);
@Update("truncate table ${tableName}")
void truncateTable(String tableName);
@Update("create table ${newTableName} as select * from ${tableName}")
void createNewTableAndInsertData(String tableName,String newTableName);
方法二、在相关mapper.xml文件中DDL的配置代码
<update id="alterTableName">
alter table ${tableName} rename ${newTableName}
</update>
<update id="truncateTable">
truncate table ${tableName}
</update>
<update id="createNewTableAndInsertData">
create table ${newTableName} as select * from ${tableName}
</update>
更多推荐
mybatis中执行DDL语句
发布评论