mysql回滚事务语句

ROLLBACK [TO SAVEPOINT savepoint_name];

START TRANSACTION;

-- 从账户A扣除金额
UPDATE accounts SET balance = balance - 100 WHERE account_id = 1;

-- 向账户B增加金额
UPDATE accounts SET balance = balance + 100 WHERE account_id = 2;

-- 检查账户A是否有足够的余额
SELECT balance FROM accounts WHERE account_id = 1;

-- 如果账户A余额不足，回滚事务
IF (SELECT balance FROM accounts WHERE account_id = 1) < 0 THEN
    ROLLBACK;
ELSE
    COMMIT;
END IF;

SET innodb_lock_wait_timeout = 5; -- 设置锁等待超时时间为5秒

START TRANSACTION;

-- 从账户A扣除金额
UPDATE accounts SET balance = balance - 100 WHERE account_id = 1;

-- 向账户B增加金额
UPDATE accounts SET balance = balance + 100 WHERE account_id = 2;

-- 如果发生死锁，事务将自动回滚
COMMIT;