Data Management
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.
Read more about this topic: Commit (data Management)
Famous quotes containing the words data and/or management:
“To write it, it took three months; to conceive it three minutes; to collect the data in itall my life.”
—F. Scott Fitzgerald (18961940)
“This we take it is the grand characteristic of our age. By our skill in Mechanism, it has come to pass, that in the management of external things we excel all other ages; while in whatever respects the pure moral nature, in true dignity of soul and character, we are perhaps inferior to most civilised ages.”
—Thomas Carlyle (17951881)