<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-06-10 14:58:06 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)