关于mysql插入或更新操作 mybatis


    
        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)