====== Transactions and Concurrency Control ======


==== Using Transactions ====

<code>
START TRANSACTION;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
COMMIT;
</code>

Ensures atomicity of multiple related updates.

==== Rolling Back Changes ====

<code>
START TRANSACTION;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
ROLLBACK;
</code>
Reverts changes made in the transaction.