关于mysql插入或更新操作 mybatis

    <insert id="addRelationSingle">
        insert into t_ai_price_task_and_cabinet_goods_relation
            (price_task_pk, cabinet_goods_relation_pk, sell_price)
        values (#{param1}, #{param2}, #{param3})
        ON DUPLICATE KEY UPDATE least_sell_price=sell_price,
                                price_task_pk=VALUES(price_task_pk),
                                cabinet_goods_relation_pk=VALUES(cabinet_goods_relation_pk),
                                sell_price=VALUES(sell_price)
    </insert>
posted @ 2022-04-11 16:29  ukyo--BlackJesus  阅读(33)  评论(1编辑  收藏  举报