COMMIT (SQL)
From HandWiki
A COMMIT statement in SQL ends a transaction within a relational database management system (RDBMS) and makes all changes visible to other users.[1][2] The general format is to issue a BEGIN WORK statement, one or more SQL statements, and then the COMMIT statement. A COMMIT statement will also release any existing savepoints that may be in use. This means that once a COMMIT statement is issued, you can not rollback the transaction.[1]
In terms of transactions, the opposite of commit is to discard the tentative changes of a transaction, a rollback.
The transaction, commit and rollback concepts are key to the ACID property of databases.[3]
See also
References
- ↑ 1.0 1.1 BYHAM. "COMMIT TRANSACTION (Transact-SQL)" (in en-us). https://docs.microsoft.com/en-us/sql/t-sql/language-elements/commit-transaction-transact-sql.
- ↑ "Database SQL Reference" (in en). https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4010.htm.
- ↑ "What is ACID (atomicity, consistency, isolation, and durability)? - Definition from WhatIs.com" (in en). https://www.techtarget.com/searchdatamanagement/definition/ACID.
 |
