Transactions

Transactions ensure data integrity by treating multiple SQL statements as a single unit.

Example: Using Transactions

START TRANSACTION;
UPDATE employees SET salary = 75000 WHERE id = 1;
COMMIT;

Example: Rolling Back a Transaction

START TRANSACTION;
DELETE FROM employees WHERE id = 2;
ROLLBACK;