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.