INSERT

 

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})

 

Comments

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.

 

Examples