mybatis批量插入或更新

  <insert id="batchInsertOrUpdate">
    insert into yz_business_user_shop(userid,shopid)
    values
    <foreach collection="list" index="index" item="item" separator=",">
      (#{item.userid},#{item.shopid})
    </foreach>
    ON DUPLICATE KEY UPDATE
    userid =VALUES(userid),
    shopid=VALUES(shopid)
  </insert>