Begin, commit, and rollback

sql

BEGIN;

UPDATE accounts SET balance = balance - 100 WHERE account_id = 1;
UPDATE accounts SET balance = balance + 100 WHERE account_id = 2;

COMMIT;

Explanation

If something fails, use ROLLBACK instead of COMMIT.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Transactions

Create partial rollback points inside a transaction.

Open In sheetsqlsame section

Control how concurrent transactions interact.

Open In sheetsqlsame section

Define a new table with columns and constraints.

Mark a column as the main row identifier.

Add a single row to a table.

Modify an existing table by adding a new column.