mysql 行锁操作值

?

1 2 3 4

update sup_payment_setting            set paid_amount = paid_amount + #{amount}         where id = #{id} and status = 1 and is_deleted = 0           and sum_amount >= paid_amount + #{amount}