Managing Transactions in MySQL

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;