How do I use SQL transactions?

What are SQL transactions and why are they important?

SQL transactions are sequences of operations performed as a single logical unit of work. They ensure data integrity.

How do I start a transaction in SQL?

You can start a transaction using the BEGIN TRANSACTION statement. After that, you can execute your SQL commands.

What happens if I don't commit a transaction?

If you don't commit a transaction, all changes made during the transaction will be rolled back, and no changes will be saved.

Can you give me an example of a transaction?

Sure! Here's a simple example: BEGIN TRANSACTION; UPDATE accounts SET balance = balance - 100 WHERE id = 1; UPDATE accounts SET balance = balance + 100 WHERE id = 2; COMMIT; This transfers money between two accounts.