清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>>

START TRANSACTION;  -- 事务开始
SELECT balance FROM cheaking where cid=123;
UPDATE cheaking set balance=balance-200 where cid=123;
UPDATE asving set balance=balance+200 WHERE aid=123;
COMMIT;  -- 事务提交