Begin
transaction
update
A
set
amount=amount-10000
where
userId=1;
insert
into
message(userId, amount,status)
values
(1, 10000, 1);
End
commit
;
来源: http://www.bubuko.com/infodetail-1985769.html