MySQL中insert批量新增UUID

<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>

版权声明:本文为weixin_49785701原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。