SQL INSERT statements add one or more new rows

The INSERT Statement

SQL INSERT statements add one or more new rows to a table The INSERT

statement has two variations The first variation adds one row by assigning

values to a specified list of columns m a specified table. The values you want

to insert follow a VALUES statement. You put parentheses around both the

field list and the values list.

For example:

INSERT INTO tablename (field1 [, field2] ...)

VALUES (value1 [, value2] ...)

You must provide a value for all fields that cannot accept a null value and do

not have a default value. You do not have to provide values for identity

columns.

The second variation lets you add multiple rows using a SELECT query in

place of the VALUES list, as follows:

INSERT INTO tablename (field1 [, field2] ...) SELECT query

If you're inserting data into all the columns in the target table, you can omit

the field list. The SELECT statement you use to obtain the data you want to

insert can include any clause or condition discussed in the previous section,

including calculated fields and a GROUP BY clause.