on duplicate key update

JPA 存在即更新 on duplicate key update

@Modifying
@Transactional
@Query(value = "insert into tb_reward_statistics (target_id, username, amount, update_time) values (?1, ?2, ?3, ?4) " +
        "on duplicate key update amount = amount + ?3, update_time = ?4", nativeQuery = true)
int insert(String liveId, String username, int amount, Long updateTime);