The INSERT Statement

The INSERT statement has two different forms:

INSERT INTO <table> (<field>, <field>,...)
VALUES (<constant>, <constant>,...);

or:

INSERT INTO <table> (<field>, <field>,...)
SELECT ...;

The first form inserts a new record into the specified table. The specified fields are given the specified values; all other fields are set to NULL. If the list of fields is omitted, the values are matched to fields in their default (sequence number) order.

The second form is the same, except that the field values are taken from the output of the SELECT statement. In this case, as many records will be inserted as there are records output by the SELECT statement.

Note
All the records being inserted must be new records. If any one of the records already exists, an error occurs and none of the records is inserted.

Also, the COMMIT WORK statement must be executed before the insertions are finally made.