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 Query 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 Query Builder.