<insert id="saveGeofencing">
insert into organization_geofencing (id,organization_id,latitude,longitude,sort)
values
<foreach collection="geofencings" item="item" separator=",">
(REPLACE(UUID(),'-',''),#{item.organizationId},#{item.latitude},#{item.longitude},#{item.sort})
</foreach>
</insert>
```在id那里写入REPLACE(UUID(),'-','')即可
mybatis批量插入时生成UUID主键
最新推荐文章于 2022-10-26 23:22:35 发布