【mybatis】mybatis中update更新原来的值加1

2024-08-24 06:49:48

示例代码： floor的值 = floor原来的值+要更新的差距值

 <update id="updateFloor" parameterType="com.pisen.cloud.luna.ms.goods.base.common.UpdateGoodsTypeFloorBean">

        update goods_type

        set floor = floor+#{floorGap}

        where uid in

        <foreach collection="list" item="item" index="index" open="(" separator="," close=")">

            #{item}

        </foreach>

    </update>

最新文章

热门文章