The INSERT statement is the DML one providing a way to create new records.


Syntax of the INSERT statement

INSERT INTO table_name[ {attribute}] values ({attr_value})



table_name The name of a table new record is to be inserted.
{attribute} This comma separated list is used when not all attributes are to be entered. Otherwise values for all attributes must be entered.
attr_value The comma separated list of attribute values. Strings must be surrounded by apostrophes.