First page Back Continue Last page Graphics
DML Statements
INSERT
- Add rows of data to a table
DELETE
- Delete rows of data from a table
UPDATE
SELECT
- Retrieve rows of data from one or more tables or views
Notes:
DML statements manipulate the data within the database. All changes are made as part of a transaction and are tentative until a COMMIT is executed.
Numerous examples of all these SQL commands can be found throughout the course.