Transactions in SQL — a practical guide to SQL transactions with clear examples you can reuse in real projects.
SQL Tutorial Series (64/100). Prefer one article? Read the complete SQL tutorial.
Short description
Use transactions for money transfers, inventory, and multi-table writes.
Transaction idea
START TRANSACTION;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
COMMIT;