-- 开始事务 START TRANSACTION; -- 转账操作示例 UPDATE accounts SET balance = balance - 1000 WHERE user_id = 1; UPDATE accounts SET balance = balance + 1000 WHERE user_id = 2; -- 提交事务 COMMIT; -- 事务回滚示例 START
-- 开始事务 START TRANSACTION; -- 转账操作示例 UPDATE accounts SET balance = balance - 1000 WHERE user_id = 1; UPDATE accounts SET balance = balance + 1000 WHERE user_id = 2; -- 提交事务 COMMIT; -- 事务回滚示例 START