mybatis动态创建临时表

来源:互联网 发布:淘宝人群标签是什么 编辑:程序博客网 时间:2024/06/05 03:04
<?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