Data modification statements

Data Manipulation Language (DML) besides of the SELECT statement that retrieves information from databases includes also statements modifying data state. These statements are:

Statement	Function
INSERT	Inserts rows into database table
UPDATE	Changes values in columns of database table
DELETE	Deletes rows from database table
MERGE	Performs different modification operations on the target table depending on the results of the join with the target table

You can take practice with these statements when trying to solve DML exercises on SQL-EX.RU.

INSERT statement
Table-values constructor
UPDATE statement
DELETE statement

#DML #INSERT #UPDATE #DELETE #DML Exercises