Block, SkipCaptcha, Upload, Automoderated users, Check users, delete, edit, Moderators, move, oversight, protect, ratelimit-exempt, rollback, Administrators
20,330
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − − − − −
a little choppy, but improved
'''SQL''', which stands for "Structured Query Language" is a [[computer language]] for [[relational database]] systems. It was first developed by EF Codd at [[IBM]].
'''SQL''', which stands for "Structured Query Language" is a [[computer language]] for [[relational database]] systems. It was first developed by EF Codd at [[IBM]]. In 1986 the American National Standards Institute ([[ANSI]]) promulgated standards for SQL, and since then revisions have been approved by the International Organization for Standardization ([[ISO]]). SQL was immensely successful, and is supported by a number of database systems, including [[MySQL]]. MySQL is one of the two databases supported by [[MediaWiki]] (the other being PostgreSQL),<ref>http://www.mediawiki.org/wiki/Manual:LocalSettings.php#Database_settings</ref> the software behind a number of wiki-based systems, including Conservapedia.
In 1986 the American National Standards Institute ([[ANSI]]) promulgated standards for SQL, and since then revisions have been approved by the International Organization for Standardization ([[ISO]]).
SQL was immensely successful, and is supported by a number of database systems, including [[MySQL]]. MySQL is one of the two databases supported by [[MediaWiki]] (the other being PostgreSQL),<ref>http://www.mediawiki.org/wiki/Manual:LocalSettings.php#Database_settings</ref> the software behind a number of wiki-based systems.
== Transactions ==
== Transactions ==
A transaction may include several SQL statements, and the sequence of statements are executed [[atomically]]. The transaction represents a logical unit work such as a customer purchasing a product. For example, the statements may include adding the purchase price to the customer's account, and subtracting the product from inventory. If either statement is executed, they must both be executed, and if either statement is aborted, they must both be aborted. This is achieved by using the COMMIT statement and the ROLLBACK statement. Once all of the statements to execute for the current transaction have been entered, the COMMIT statement is entered, and the transaction is committed to the database. If any of the statements in the transaction cannot be completed, the entire transaction is rolled back, and none of the statements take effect.
A transaction may include several SQL statements, and the sequence of statements are executed [[atomically]]. The transaction represents a logical unit work such as a customer purchasing a product. For example, the statements may include adding the purchase price to the customer's account, and subtracting the product from inventory. If either statement is executed, they must both be executed, and if either statement is aborted, they must both be aborted. This is achieved by using the COMMIT statement and the ROLLBACK statement. Once all of the statements to execute for the current transaction have been entered, the COMMIT statement is entered, and the transaction is committed to the database. If any of the statements in the transaction cannot be completed, the entire transaction is rolled back, and none of the statements take effect.