Data modification statements

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:

StatementFunction
INSERTInserts rows into database table
UPDATEChanges values in columns of database table
DELETEDeletes rows from database table

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