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. Wikibooks has more about this subject: SQL Headline text Hello BTEC Group! History A seminal paper, A Relational Model of Data for Large Shared Data Banks, by Dr. Edgar F. Codd, was published in June, 1970 in the Association for Computing Machinery (ACM) journal, Communications of the ACM. Codds... A database transaction is a unit of interaction with a database management system or similar system that is treated in a coherent and reliable way independent of other transactions. ... A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by Edgar F. Codd. ... A BEGIN WORK statement in SQL starts a transaction within a relational database management system (RDBMS). ... In database technologies, a rollback is an operation which returns the database to some previous state. ...
A COMMIT statement will also release any existing savepoints that may be in use.
SQL is commonly spoken in initialism-style ess-cue-el (see English alphabet) — regarded as more formal — or in a phonetically-amalgamated form that mirrors the English word sequel.
SQL was adopted as a standard by ANSI (American National Standards Institute) in 1986 and ISO (International Organization for Standardization) in 1987.
One joke about SQL is that "SQL is not structured, nor is it limited to queries, nor is it a language." This is founded on the notion that pure SQL is not a classic programming language since it is not Turing-complete.
Feeds |
Contact