COMMIT

The SQL statement that ends a transaction and makes all its changes permanent and visible to others.

In more detail

Commit is the point readers rely on. Before it, other sessions do not see the changes; after it, the changes survive a crash or power loss.

Example

In this course: code that commits its own transactions cannot be isolated by a rolled-back test transaction; give it a fresh schema or database instead.

Related terms

Taught in

References