mysql db中数据存在就更新,不存在就插入

     insert into result(userId,year,month,increaseRate,decreaseRate,autoRate,finishRate,createTime,modifyTime)
     values(
     #{userId},#{year},#{month},#{increaseRate},#{decreaseRate},#{autoRate},#{finishRate},#{createTime},#{modifyTime}
     )
     on duplicate key update
increaseRate
=#{increasRate},decreaseRate=#{decreaseRate},autoRate=#{autoRate},finishRate=#{finishRate}, modifyTime=#{modifyTime}

 

posted @ 2023-06-30 17:32  苹果芒  阅读(58)  评论(0编辑  收藏  举报