BEGIN; UPDATE accounts SET balance=balance-100 WHERE id='A'; COMMIT; UPDATE accounts SET balance=balance+100 WHERE id='B';
BEGIN; SAVEPOINT s1; UPDATE... ROLLBACK TO s1;
BEGIN; UPDATE accounts SET balance=balance-100 WHERE id='A'; UPDATE accounts SET balance=balance+100 WHERE id='B'; COMMIT;
SET autocommit=0; UPDATE... WHERE id='A'; UPDATE... WHERE id='B';