COMMIT (SQL)
From Infogalactic: the planetary knowledge core
Lua error in package.lua at line 80: module 'strict' not found. A COMMIT
statement in SQL ends a 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
statement, one or more SQL statements, and then the COMMIT
statement. Alternatively, a ROLLBACK
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 is to discard the tentative changes of a transaction, a rollback.
See also
<templatestyles src="Asbox/styles.css"></templatestyles>