<insert id="insertBatch" parameterType="java.util.List">
INSERT INTO rsv_verifier (id,svs_id, user_id, user_key_id, user_name, tel, sex, comment, is_use, create_time,
update_time)
VALUES
<foreach collection="rsvList" item="item" index="index" separator=",">
(
(SELECT REPLACE(UUID(), '-', '') AS id),
#{item.svsId},
#{item.userId},
#{item.userKeyId},
#{item.userName},
#{item.tel},
#{item.sex},
#{item.comment},
#{item.isUse},
#{item.createTime},
#{item.updateTime}
)
</foreach>
</insert>
MySQL中insert批量新增UUID
最新推荐文章于 2024-05-06 18:00:52 发布