The Insert Statement
The general form of the insert statement is:
insert into
table [( columns )]
values
(valuelist);
To insert a new sales person row, we would use:
insert into salesp (id, name)
values ('NEW', 'New salesp');
Column List
The optional column list defines the columns that will be assigned a value. The columns do not need to be in any specific order as long as the column and value lists match.
The column list can be omitted; in that case, the value list must be in the order in which the columns are defined in the table. In general, it is good practice to always specify a column list. If the table is restructured and the order of the columns changes, the insert statement will still work.
Value List
The value list specifies all values that must be inserted in the row.