Command INSERT - SQL Foundation
Inserts one or more records into a table.
INSERT INTO <cTableName> [(<cFieldName> [, <cFieldName>, ...])] | VALUES (<Expression> [, <Expression>, ...]) | SELECT <SubSelectExpression> | FROM MEMVAR | FROM ARRAY <aExpression> | FROM OBJECT|NAME <oExpression> [VIA (<coSession>)]
INSERT inserts new records into a table. The commands inserts as many records as specified in the VALUES clause, or via an SQL SELECT statement. Note that in the latter case, no record may be inserted if the corresponding result set is empty. If the FROM clause is used, one record is inserted.
The target column names can be listed in any order. If no list of column names is given at all, the default is all the columns of the table in their declared order; or the first N column names, if there are only N columns supplied by the VALUES clause or query. The values supplied by the VALUES clause or query are associated with the explicit or implicit column list left-to-right.
Each column not present in the explicit or implicit column list will be filled with a default value, either its declared default value or null if there is none.
If the expression for any column is not of the correct data type, automatic type conversion will be attempted.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.