Persist all changes made in the current transaction.

Section: transactions

Commit a transaction

sql
sql
COMMIT;
Explanation

After `COMMIT`, changes become durable and visible according to isolation semantics.

Learn the surrounding workflow

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

Related commands

Same sheet · prioritizing transactions
Start a transaction
Begin a transaction explicitly.
OpenIn sheetsqlsame section
Rollback a transaction
Undo all uncommitted changes.
OpenIn sheetsqlsame section
Set and rollback to a savepoint
Undo only part of a transaction.
OpenIn sheetsqlsame section
Disable autocommit for the session
Keep statements in a transaction until you commit or rollback.
OpenIn sheetsqlsame section
Set transaction isolation level
Control read consistency and concurrency behavior.
OpenIn sheetsql1 tag match
Lock selected rows for update
Prevent concurrent modifications to matched rows inside a transaction.