SQL data manipulation language

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

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

Content:

(6.1.) INSERT statement

(6.2.) UPDATE statement

(6.3.) DELETE statement

DML INSERT UPDATE DELETE DML exercises

Previos [CASE statement]

[INSERT statement] Next

SQL Problems and solutions

S. I. Moiseenko

SQL data manipulation language

Data modification statements

Content: