mysql批量添加的SQL语句

SQL语句批量插入技巧

最新推荐文章于 2025-09-23 21:36:15 发布

原创最新推荐文章于 2025-09-23 21:36:15 发布 · 5k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#sql语句 #批量插入

SQL 专栏收录该内容

1 篇文章

订阅专栏

<insert id="batchInsertOwner" parameterType="java.util.List">
  insert into owner
  (owner_id,owner_name, owner_phone, owner_sex,owner_status, owner_building)
  <foreach collection="list" item="item" index="index" separator="UNION ALL">
     select #{item.ownerId},#{item.ownerName},#{item.ownerPhone},#{item.ownerSex},#{item.ownerStatus},#{owner.ownerBuilding}
     from dual where not exists (select owner_phone from owner where owner_phone = #{item.ownerPhone})
  </foreach>
</insert>