<!--创建/删除临时表-->
<update id="createAREASHIP_SOURCE">
drop TABLE IF EXISTS AREASHIP_SOURCE;
CREATE TEMPORARY TABLE AREASHIP_SOURCE (
YEA_ID Integer,
PERIOD_NAME CHAR(10),
THIS_FLAG Integer,
LAST_FLAG Integer,
QTY Integer
)
</update>
<!--插入-->
<insert id="addSAL_AREASHIP_SOURCE" parameterType="java.util.HashMap">
INSERT INTO SAL_AREASHIP_SOURCE
VALUES
<foreach collection="p.values" item="value" open="(" close=")" separator=",">
#{value}
</foreach>
</insert>
mybatis-plus XML 临时表的增删改查(更新中)
最新推荐文章于 2024-04-08 09:53:15 发布