SQL: Difference between revisions
Jump to navigation
Jump to search
Line 21: | Line 21: | ||
=SQL Data Statements (DML)= | =SQL Data Statements (DML)= | ||
==<tt>INSERT</tt>== | |||
==<tt>UPDATE</tt>== | |||
<font color=darkkhaki>UPDATE WHERE</font> | |||
==<tt>DELETE</tt>== | |||
<font color=darkkhaki>DELETE WHERE</font> | |||
==<tt>SELECT</tt>== | |||
Query execution. SQL optimizer. | Query execution. SQL optimizer. | ||
Revision as of 20:50, 22 May 2024
External
- Learning SQL, 3rd Edition by Alan Beaulieu
Internal
Overview
This article documents standard SQL. For database-specific extensions, we'll link to the databases-specific DML operations page.
SQL is a non-procedural language TODO: this
Terms
Result Set
SQL Schema Statements (DDL)
CREATE
CREATE TABLE
ALTER TABLE
SQL Data Statements (DML)
INSERT
UPDATE
UPDATE WHERE
DELETE
DELETE WHERE
SELECT
Query execution. SQL optimizer.
SQL Transaction Statements
Transactions.