mybatis动态创建临时表

时间:2021-11-04 12:15:38
<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >  
<mapper namespace="com.mapper.TmpMapper" >  
    <update id="createTmpTable" parameterType="String">  
create temporary table ${tableName} (  
id int not null generated by default as identity,  
age int not null,  
name varchar(255),  
primary key (id))  
    </update>  
</mapper>
欢迎访问我们的技术交流群425783133