mapper
<!--批量添加上架商品-->
<insert id="insertMultiGis" parameterType="java.util.List" useGeneratedKeys="true" keyProperty="gis_id" keyColumn="gis_id">
INSERT INTO goodinstore
(goodid,businessid,retailprice,min_stock,stock)
values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.good.id},#{item.businessid},#{item.retailPrice},#{item.min_stock},#{item.stock})
</foreach>
ON DUPLICATE KEY UPDATE
retailprice = values(retailprice),
min_stock = values(min_stock),
stock = values(stock)
</insert>
其中下方代碼的含義用途是什么？
ON DUPLICATE KEY UPDATE
retailprice = values(retailprice),
min_stock = values(min_stock),
stock = values(stock)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/177305.html
標籤：其他
下一篇：求助js騙贊腳本