插入&更新sql-mybatis(insertOrUpdate)
loading...
<insert id="insertOrUpdate">
insert into book_user_counts(urg_user_id, user_id, total_counts, used_counts)
values
(#{urgUserId}, #{userId}, #{totalCounts}, #{usedCounts})
on duplicate key update total_counts= VALUES(total_counts),used_counts= VALUES(used_counts)
</insert>