Transactions in SQL

 Transactions in SQL

A transaction is a sequence of SQL statements that are executed as a single unit of work. Transactions ensure that a group of statements are either all executed or none of them are executed. Here's an example:

sql

BEGIN TRANSACTION;

UPDATE accounts SET balance = balance - 500 WHERE id = 1;

UPDATE accounts SET balance = balance + 500 WHERE id = 2;

COMMIT;

In this example, we're transferring 500 units of currency from account 1 to account 2. We're using a transaction to ensure that both updates are executed together as a single unit of work. If any of the updates fail, the entire transaction will be rolled back.