mysql批量添加的SQL语句

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