Using an INSERT statement, you can insert rows from a values set
or from a subquery results table into a database table.
There might be variations in syntax depending upon the database
vendor that you are using. If you use the SQL builder to create the INSERT
statement, the tool attempts to create the correct syntax for the database
vendor that you are using.
If you insert a row from a set of values,
the default value that is shown for each column depends on how the column
was defined when the table was created.
- If the column was defined with a default value, the cell value is DEFAULT.
- If the column was not defined with a default value and the column is nullable,
the cell value is NULL.
- If the column was not defined with a default value and the column is non-nullable,
the cell value is a pair of single quotes.
Prerequisite: Before you specify an INSERT statement, create the statement in the SQL builder.