Commit (data management) |
In the context of computer science and data management, commit refers to the idea of making permanent a set of tentative changes, such as at the end of a database transaction. To commit (changes) is to make tentative changes permanent. A commit is the act of committing.
A COMMIT statement in SQL ends a database transaction within a relational database management system (RDBMS) and makes all changes visible to other users. The general format is to issue a Begin work (SQL) statement, one or more SQL statements, and then the COMMIT statement. Alternatively, a Rollback (data management) statement can be issued, which undoes all the work performed since BEGIN WORK was issued. A COMMIT statement will also release any existing Savepoints that may be in use.
In terms of transactions, the opposite of commit to discard the tentative changes of a transaction, a rollback (data management).
=Related articles=
|
|