The INSERT statement comes in three basic forms. -
^The first form (with the "VALUES" keyword) creates one or more +
INSERT INTO table VALUES(...); +
^The first form (with the "VALUES" keyword) creates one or more
new rows in
an existing table. ^If the
The second form of the INSERT statement contains a [SELECT] statement +
INSERT INTO table SELECT ...; +
The second form of the INSERT statement contains a [SELECT] statement instead of a VALUES clause. ^A new entry is inserted into the table for each row of data returned by executing the SELECT statement. ^If a column-list is specified, the number of columns in the result of the SELECT must be the same as the number of items in the column-list. ^Otherwise, if no column-list is specified, the number of columns in the result of the SELECT must be the same as the number of columns in the table. ^Any SELECT statement, including [compound SELECTs] and SELECT statements with [ORDER BY] and/or [LIMIT] clauses, may be used in an INSERT statement of this form. -
The third form of an INSERT statement is with DEFAULT VALUES. +
INSERT INTO table DEFAULT VALUES; +
The third form of an INSERT statement is with DEFAULT VALUES. ^(The INSERT ... DEFAULT VALUES statement inserts a single new row into the named table.)^ ^Each column of the new row is populated with its [default value], or with a NULL if no default value is specified as part of the column definition in the [CREATE TABLE] statement. -
^The "REPLACE" and "INSERT OR action" forms specify an alternative -constraint conflict resolution algorithm to use during this one INSERT command. -See the section titled [ON CONFLICT] for additional information. +
+^The initial "INSERT" keyword can be replaced by +"REPLACE" and "INSERT OR action" to specify an alternative +constraint [ON CONFLICT|conflict resolution algorithm] to use during +that one INSERT command. For compatibility with MySQL, ^the parser allows the use of the single keyword REPLACE as an alias for "INSERT OR REPLACE".
^(The optional "schema-name." prefix on the