mybatis--插入&更新sql-(采用mysql数据库计算)

插入&更新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>