Commit

How it is used

Also a noun: 'after the commit'. Many tools work in autocommit mode, where every statement is committed automatically. In a manual transaction, forgetting to commit means your changes are lost or still holding locks. Do not mix it up with a Git commit.

Example sentences

1. I ran the update but forgot to commit, so nobody else could see the new prices.

2. The changes are committed only after both inserts succeed.

Common collocations

• commit a transaction
• commit the changes
• autocommit
• commit or roll back

Related terms

• transactionA group of database operations that are treated as one unit: either all of them succeed together or none of them is applied.
• rollbackThe act of cancelling a transaction so that all of its changes are undone and the data returns to how it was before the transaction began.
• ACIDAtomicity, Consistency, Isolation, Durability: the four guarantees that make database transactions reliable even with errors, crashes and many users at once.
• lockA mark the database places on a row, page or table so that other transactions cannot change it, or sometimes read it, until the current transaction ends.

This word in other fields

The same English word can have a different meaning in another field:

• commit · Software Engineering

More terms: Transactions and Concurrency

• isolation level
• deadlock