<insert id="batchInsert" parameterType="java.util.List">
<selectKey keyProperty="id" resultType="String" order="BEFORE">
SELECT REPLACE(UUID(), '-', '') AS id from dual
</selectKey>
insert into rc_gzrw(
id,
gs_id,
rwmc,
csr_id
)
values
(
#{id},
#{item.gsId},
#{item.rwmc},
#{item.csrId}
)
</insert>
Mybatis sql插入uuid
最新推荐文章于 2022-04-11 23:02:45 发布