DML / Data Manipulation Language
SQL DML: Data manipulation
Insert, update or delete table rows. Read the row-selection condition separately from the new values, and use TCL to study grouped changes.
Topics in this category
Insert rows
INSERT accepts explicit values or SELECT results. Check the target column order and types.
Syntax map
Update or merge matching rows
UPDATE sets values with SET and limits rows with WHERE. MERGE chooses actions based on matches with its source. Follow the function links for conversions and NULL handling in SET expressions.
Delete rows
DELETE removes matching rows. TRUNCATE removes all rows. To remove the table definition too, see DROP TABLE under DDL.