SQL Modification keywords

D

DELETE

The SQL DELETE statement removes rows from a table.

I

INSERT

The SQL INSERT statement adds new rows to a table.

INSERT INTO SELECT

The SQL INSERT INTO SELECT statement copies data from one table into another.

U

UPDATE

The SQL UPDATE statement modifies existing rows in a table.

UPSERT

UPSERT inserts a new row or updates an existing row if a conflict occurs (syntax depends on the database).