Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix the INSERT documentation to describe the fact that the VALUES form of an INSERT can insert multiple rows. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
ee9ff30ec6bc39eab80f6c992dae3639 |
| User & Date: | drh 2012-10-15 20:39:02.505 |
Context
|
2012-10-19
| ||
| 22:24 | Add a script for pushing builds of the website out to all three servers. Take care that draft builds are pushed only in the draft directory. (check-in: ac603d6340 user: drh tags: trunk) | |
|
2012-10-15
| ||
| 20:39 | Fix the INSERT documentation to describe the fact that the VALUES form of an INSERT can insert multiple rows. (check-in: ee9ff30ec6 user: drh tags: trunk) | |
| 06:10 | Fix typo in the description of PRAGMA journal_mode. (check-in: 4eade435df user: mistachkin tags: trunk) | |
Changes
Changes to pages/lang.in.
| ︙ | ︙ | |||
2711 2712 2713 2714 2715 2716 2717 |
Section INSERT insert {INSERT *INSERTs}
BubbleDiagram insert-stmt 1
</tcl>
<p>The INSERT statement comes in three basic forms.
<ul>
| | > | > | | | > | > | 2711 2712 2713 2714 2715 2716 2717 2718 2719 2720 2721 2722 2723 2724 2725 2726 2727 2728 2729 2730 2731 2732 2733 2734 |
Section INSERT insert {INSERT *INSERTs}
BubbleDiagram insert-stmt 1
</tcl>
<p>The INSERT statement comes in three basic forms.
<ul>
<li><p>^The first form (with the "VALUES" keyword) creates one or more
new rows in
an existing table. ^If no column-list is specified then the number
of values inserted into each row
must be the same as the number of columns in the table. ^In this case
the result of evaluating the left-most expression in each term of
the VALUES list is inserted into the left-most column of the each new row,
and forth for each subsequent expression. ^If a
column-list is specified, then the number of values in each term of the
VALUS list must match the number of
specified columns. ^Each of the named columns of the new row is populated
with the results of evaluating the corresponding VALUES expression. ^Table
columns that do not appear in the column list are populated with the default
column value (specified as part of the CREATE TABLE statement), or with NULL if
no default value is specified.
<li><p>The second form of the INSERT statement contains a SELECT statement
|
| ︙ | ︙ |