Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Clarification of the "INSERT OR" and "REPLACE" forms of the INSERT statement. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
58895ad2010c65fc9944a824e1919253 |
| User & Date: | drh 2015-03-04 20:56:05 |
Context
|
2015-03-04
| ||
| 23:15 | Clarifications on INDEXED BY documentation. Syntax diagrams which are default visible are always requirements even if they occur multiple times, but syntax diagrams that are default hidden now have the "data-noreq" attribute which prevents them from being marked as requirements. check-in: 000660158c user: drh tags: trunk | |
| 20:56 | Clarification of the "INSERT OR" and "REPLACE" forms of the INSERT statement. check-in: 58895ad201 user: drh tags: trunk | |
| 20:19 | Add fts5.html. check-in: 519916c18a user: dan tags: trunk | |
Changes
Changes to pages/lang.in.
3115 3116 3117 3118 3119 3120 3121 3122 3123 3124 3125 3126 3127 3128 3129 3130 3131 3132 |
^(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. </ul> <p>^The optional conflict-clause allows the specification of an alternative constraint conflict resolution algorithm to use during this one INSERT command. See the section titled [ON CONFLICT] for additional information. For compatibility with MySQL, ^the parser allows the use of the single keyword <a href="lang_replace.html">REPLACE</a> as an alias for "INSERT OR REPLACE". <p>^(The optional "<i>database-name</i><b>.</b>" prefix on the <i>table-name</i> is support for top-level INSERT statements only.)^ ^The table name must be unqualified for INSERT statements that occur within [CREATE TRIGGER] statements. |
| < | |
3115 3116 3117 3118 3119 3120 3121 3122 3123 3124 3125 3126 3127 3128 3129 3130 3131 |
^(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. </ul> <p>^The "REPLACE" and "INSERT OR <i>action</i>" forms specify an alternative constraint conflict resolution algorithm to use during this one INSERT command. See the section titled [ON CONFLICT] for additional information. For compatibility with MySQL, ^the parser allows the use of the single keyword <a href="lang_replace.html">REPLACE</a> as an alias for "INSERT OR REPLACE". <p>^(The optional "<i>database-name</i><b>.</b>" prefix on the <i>table-name</i> is support for top-level INSERT statements only.)^ ^The table name must be unqualified for INSERT statements that occur within [CREATE TRIGGER] statements. |