Managing Transactions in MySQL
Published September 30, 2026
By Sai Sree Ram Gundepudi
Transaction Block
START TRANSACTION;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
COMMIT;Rollback Example
ROLLBACK;Savepoint
SAVEPOINT sp1;