ABA典型银行存取款问题描述

错误的SQL：

1
2
update account set amount=amount-${wanted}
where user_id=${user_id} and amount=${amount}

修改之后的SQL:

1
2
3
update account set amount=amount-${wanted}
where user_id=${user_id} and amount=${amount}
and version=${prev_version}