Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Tweaks to lang_insert.html. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
15cc2204a5ed314ed00be3720ec39871 |
User & Date: | dan 2010-09-18 18:52:32.000 |
Context
2010-09-20
| ||
19:09 | Changes to lang_update.html to make it more testable. (check-in: 5df6adc2a9 user: dan tags: trunk) | |
2010-09-18
| ||
18:52 | Tweaks to lang_insert.html. (check-in: 15cc2204a5 user: dan tags: trunk) | |
15:03 | Remove the tags from a couple of untestable statements in lang_select.html. (check-in: 0df9f2d381 user: dan tags: trunk) | |
Changes
Changes to pages/lang.in.
︙ | ︙ | |||
2401 2402 2403 2404 2405 2406 2407 | <tcl> ############################################################################## Section INSERT insert {INSERT *INSERTs} BubbleDiagram insert-stmt 1 </tcl> | | > | | | > > | > > | | | < | > > | > | | < < | > | | > > > | > < | 2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413 2414 2415 2416 2417 2418 2419 2420 2421 2422 2423 2424 2425 2426 2427 2428 2429 2430 2431 2432 2433 2434 2435 2436 2437 2438 2439 2440 2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 | <tcl> ############################################################################## 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 a single new row in an existing table. ^If no column-list is specified then the number of values must be the same as the number of columns in the table. ^In this case the result of evaluting the left-most expression in the VALUES list is inserted into the left-most column of the new row, and so on. ^If a column-list is specified, then the number of values 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 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. <li><p>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. </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. ^Similarly, the "DEFAULT VALUES" form of the INSERT statement is supported for top-level INSERT statements only and not for INSERT statements within triggers. |
︙ | ︙ |