Data Manipulation Language DML

Data Manipulation Language DML: Data manipulation statements.

INSERT INTO basic_table_name (column_name[, column_name]...)
    VALUES(constant[, constant]...)
INSERT INTO basic_table_name (column_name[, column_name]...)
    SELECT query_statement

Updating data

UPDATE basic_table_name
SET column_name=value_expression(, column_name=value_expression...)
[WHERE condition_expression]

Deleting data

DELETE FROM basic_table_name
[WHERE condition_expression]