Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update the included core library documentation. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
ba3097cbdb1211d5ff87421762928d52 |
User & Date: | mistachkin 2015-04-08 18:30:45.083 |
Context
2015-04-08
| ||
21:36 | Update Eagle script library in externals to the latest trunk code. check-in: 85b231175b user: mistachkin tags: trunk | |
18:30 | Update the included core library documentation. check-in: ba3097cbdb user: mistachkin tags: trunk | |
18:29 | Update SQLite core library to the 3.8.9 release. check-in: 40495eae0b user: mistachkin tags: trunk | |
Changes
Changes to Doc/Extra/Core/lang.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_aggfunc.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_altertable.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
306 307 308 309 310 311 312 313 314 | "rename table" and "add column" commands shown above. However, applications can make other arbitrary changes to the format of a table using a simple sequence of operations. The steps to make arbitrary changes to the schema design of some table X are as follows: <ol> <li><p> Remember the format of all indexes and triggers associated with table X. | > > > > > > > | < < < < | < < < < < < < > > > > > > > > > > > > > | | 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 | "rename table" and "add column" commands shown above. However, applications can make other arbitrary changes to the format of a table using a simple sequence of operations. The steps to make arbitrary changes to the schema design of some table X are as follows: <ol> <li><p> If foreign key constraints are enabled, disable them using <a href="pragma.html#pragma_foreign_keys">PRAGMA foreign_keys=OFF</a>. <li><p> Start a transaction. <li><p> Remember the format of all indexes and triggers associated with table X. This information will be needed in step 8 below. One way to do this is to run a query like the following: SELECT type, sql FROM sqlite_master WHERE tbl_name='X'. <li><p> Use <a href="lang_createtable.html">CREATE TABLE</a> to construct a new table "new_X" that is in the desired revised format of table X. Make sure that the name "new_X" does not collide with any existing table name, of course. <li><p> Transfer content from X into new_X using a statement like: INSERT INTO new_X SELECT ... FROM X. <li><p> Drop the old table X: <a href="lang_droptable.html">DROP TABLE X</a>. <li><p> Change the name of new_X to X using: ALTER TABLE new_X RENAME TO X. <li><p> Use <a href="lang_createindex.html">CREATE INDEX</a> and <a href="lang_createtrigger.html">CREATE TRIGGER</a> to reconstruct indexes and triggers associated with table X. Perhaps use the old format of the triggers and indexes saved from step 3 above as a guide, making changes as appropriate for the alteration. <li><p>If any views refer to table X in a way that is affected by the schema change, then drop those views using <a href="lang_dropview.html">DROP VIEW</a> and recreate them with whatever changes are necessary to accommodate the schema change using <a href="lang_createview.html">CREATE VIEW</a>. <li><p> If foreign key constraints were originally enabled then run <a href="pragma.html#pragma_foreign_key_check">PRAGMA foreign_key_check</a> to verify that the schema change did not break any foreign key constraints. <li><p> Commit the transaction started in step 2. <li><p> If foreign keys constraints were originally enabled, reenable them now. </ol> <p>The procedure above is completely general and will work even if the schema change causes the information stored in the table to change. So the full procedure above is appropriate for dropping a column, changing the order of columns, adding or removing a UNIQUE constraint or PRIMARY KEY, adding CHECK or FOREIGN KEY or NOT NULL constraints, or changing the datatype for a column, for example. However, a simpler and faster procedure can optionally be used for some changes that do no affect the on-disk content in any way. The following simpler procedure is appropriate for removing CHECK or FOREIGN KEY or NOT NULL constraints, renaming columns, or adding or removing or changing default values on a column. <ol> <lI><p> Start a transaction. <li><p> Run <a href="pragma.html#pragma_schema_version">PRAGMA schema_version</a> to determine the current schema version number. This number will be needed for step 6 below. <li><p> Activate schema editing using <a href="pragma.html#pragma_writable_schema">PRAGMA writable_schema=ON</a>. <li><p> Run an <a href="lang_update.html">UPDATE</a> statement to change the definition of table X in the <a href="fileformat2.html#sqlite_master">sqlite_master table</a>: UPDATE sqlite_master SET sql=... WHERE type='table' AND name='X'; |
︙ | ︙ | |||
401 402 403 404 405 406 407 | more than the old schema version number found in step 2 above. <li><p> Disable schema editing using <a href="pragma.html#pragma_writable_schema">PRAGMA writable_schema=OFF</a>. <li><p> (Optional) Run <a href="pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> to verify that the schema changes did not damage the database. | < < | < > | 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 | more than the old schema version number found in step 2 above. <li><p> Disable schema editing using <a href="pragma.html#pragma_writable_schema">PRAGMA writable_schema=OFF</a>. <li><p> (Optional) Run <a href="pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> to verify that the schema changes did not damage the database. <li><p> Commit the transaction started on step 1 above. </ol> <p>If some future version of SQLite adds new ALTER TABLE capabilities, those capabilities will very likely use one of the two procedures outlined above. |
Changes to Doc/Extra/Core/lang_analyze.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_attach.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_comment.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_conflict.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_corefunc.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
138 139 140 141 142 143 144 | the <a href="c3ref/create_function.html">sqlite3_create_function()</a> API.</p> <table border=0 cellpadding=10> <tr><td valign="top" align="right" width="120"><a name="abs"></a> abs(<i>X</i>)</td><td valign="top"> The abs(X) function returns the absolute value of the numeric argument X. Abs(X) returns NULL if X is NULL. | | | 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 | the <a href="c3ref/create_function.html">sqlite3_create_function()</a> API.</p> <table border=0 cellpadding=10> <tr><td valign="top" align="right" width="120"><a name="abs"></a> abs(<i>X</i>)</td><td valign="top"> The abs(X) function returns the absolute value of the numeric argument X. Abs(X) returns NULL if X is NULL. Abs(X) returns 0.0 if X is a string or blob that cannot be converted to a numeric value. If X is the integer -9223372036854775808 then abs(X) throws an integer overflow error since there is no equivalent positive 64-bit two complement value. </td></tr><tr><td valign="top" align="right" width="120"><a name="changes"></a> changes()</td><td valign="top"> The changes() function returns the number of database rows that were changed or inserted or deleted by the most recently completed INSERT, DELETE, |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_createindex.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_createtable.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_createtrigger.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
354 355 356 357 358 359 360 361 362 363 364 365 366 367 | The ORDER BY and LIMIT clauses on <a href="lang_update.html">UPDATE</a> and <a href="lang_delete.html">DELETE</a> statements are not supported. ORDER BY and LIMIT are not normally supported for <a href="lang_update.html">UPDATE</a> or <a href="lang_delete.html">DELETE</a> in any context but can be enabled for top-level statements using the <a href="compile.html#enable_update_delete_limit">SQLITE_ENABLE_UPDATE_DELETE_LIMIT</a> compile-time option. However, that compile-time option only applies to top-level <a href="lang_update.html">UPDATE</a> and <a href="lang_delete.html">DELETE</a> statements, not <a href="lang_update.html">UPDATE</a> and <a href="lang_delete.html">DELETE</a> statements within triggers. </p></li> </ul> <a name="instead_of_trigger"></a> <h3>INSTEAD OF triggers</h3> <p>Triggers may be created on <a href="lang_createview.html">views</a>, as well as ordinary tables, by | > > > > > | 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 | The ORDER BY and LIMIT clauses on <a href="lang_update.html">UPDATE</a> and <a href="lang_delete.html">DELETE</a> statements are not supported. ORDER BY and LIMIT are not normally supported for <a href="lang_update.html">UPDATE</a> or <a href="lang_delete.html">DELETE</a> in any context but can be enabled for top-level statements using the <a href="compile.html#enable_update_delete_limit">SQLITE_ENABLE_UPDATE_DELETE_LIMIT</a> compile-time option. However, that compile-time option only applies to top-level <a href="lang_update.html">UPDATE</a> and <a href="lang_delete.html">DELETE</a> statements, not <a href="lang_update.html">UPDATE</a> and <a href="lang_delete.html">DELETE</a> statements within triggers. </p></li> <li><p> <a href="syntax/common-table-expression.html">Common table expression</a> are not supported for statements inside of triggers. </p></li> </ul> <a name="instead_of_trigger"></a> <h3>INSTEAD OF triggers</h3> <p>Triggers may be created on <a href="lang_createview.html">views</a>, as well as ordinary tables, by |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_createview.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
209 210 211 212 213 214 215 | <a href="lang_select.html">SELECT</a> statement. Once the view is created, it can be used in the FROM clause of another <a href="lang_select.html">SELECT</a> in place of a table name. </p> <p>If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and "VIEW" then the view that is created is only visible to the | | | | 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 | <a href="lang_select.html">SELECT</a> statement. Once the view is created, it can be used in the FROM clause of another <a href="lang_select.html">SELECT</a> in place of a table name. </p> <p>If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and "VIEW" then the view that is created is only visible to the <a href="c3ref/sqlite3.html">database connection</a> that created it and is automatically deleted when the database connection is closed.</p> <p> If a <database-name> is specified, then the view is created in the named database. It is an error to specify both a <database-name> and the TEMP keyword on a VIEW, unless the <database-name> is "temp". If no database name is specified, and the TEMP keyword is not present, the VIEW is created in the main database.</p> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_createvtab.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_datefunc.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
292 293 294 295 296 297 298 299 300 301 302 303 304 305 | <li> localtime <li> utc </ol> <p>The first six modifiers (1 through 6) simply add the specified amount of time to the date and time specified by the preceding timestring and modifiers. Note that "±NNN months" works by rendering the original date into the YYYY-MM-DD format, adding the ±NNN to the MM month value, then normalizing the result. Thus, for example, the data 2001-03-31 modified by '+1 month' initially yields 2001-04-31, but April only has 30 days so the date is normalized to 2001-05-01. A similar effect occurs when the original date is February 29 of a leapyear and the modifier is ±N years where N is not a multiple of four.</p> | > | 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 | <li> localtime <li> utc </ol> <p>The first six modifiers (1 through 6) simply add the specified amount of time to the date and time specified by the preceding timestring and modifiers. The 's' character at the end of the modifier names is optional. Note that "±NNN months" works by rendering the original date into the YYYY-MM-DD format, adding the ±NNN to the MM month value, then normalizing the result. Thus, for example, the data 2001-03-31 modified by '+1 month' initially yields 2001-04-31, but April only has 30 days so the date is normalized to 2001-05-01. A similar effect occurs when the original date is February 29 of a leapyear and the modifier is ±N years where N is not a multiple of four.</p> |
︙ | ︙ | |||
320 321 322 323 324 325 326 327 328 329 330 331 332 333 | of seconds since 1970 or if other modifiers separate the "unixepoch" modifier from prior DDDDDDDDDD then the behavior is undefined. Due to precision limitations imposed by the implementations use of 64-bit integers, the "unixepoch" modifier only works for dates between 0000-01-01 00:00:00 and 5352-11-01 10:52:47 (unix times of -62167219200 through 10675199167).</p> <p>The "localtime" modifier (12) assumes the time string to its left is in Universal Coordinated Time (UTC) and adjusts the time string so that it displays localtime. If "localtime" follows a time that is not UTC, then the behavior is undefined. The "utc" is the opposite of "localtime". "utc" assumes that the string to its left is in the local timezone and adjusts that string to be in UTC. | > > | 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 | of seconds since 1970 or if other modifiers separate the "unixepoch" modifier from prior DDDDDDDDDD then the behavior is undefined. Due to precision limitations imposed by the implementations use of 64-bit integers, the "unixepoch" modifier only works for dates between 0000-01-01 00:00:00 and 5352-11-01 10:52:47 (unix times of -62167219200 through 10675199167).</p> <a name="localtime"></a> <p>The "localtime" modifier (12) assumes the time string to its left is in Universal Coordinated Time (UTC) and adjusts the time string so that it displays localtime. If "localtime" follows a time that is not UTC, then the behavior is undefined. The "utc" is the opposite of "localtime". "utc" assumes that the string to its left is in the local timezone and adjusts that string to be in UTC. |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_delete.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_detach.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_dropindex.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_droptable.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_droptrigger.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_dropview.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_explain.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_expr.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_indexedby.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
127 128 129 130 131 132 133 | </table> <div class=startsearch></div> <h1 align="center">SQL As Understood By SQLite</h1><p><a href="lang.html">[Top]</a></p><h2>INDEXED BY</h2> <p>The INDEXED BY phrase forces the <a href="optoverview.html">SQLite query planner</a> to use a particular named index on a <a href="lang_delete.html">DELETE</a>, <a href="lang_select.html">SELECT</a>, or <a href="lang_update.html">UPDATE</a> statement. | | | < < | | 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 | </table> <div class=startsearch></div> <h1 align="center">SQL As Understood By SQLite</h1><p><a href="lang.html">[Top]</a></p><h2>INDEXED BY</h2> <p>The INDEXED BY phrase forces the <a href="optoverview.html">SQLite query planner</a> to use a particular named index on a <a href="lang_delete.html">DELETE</a>, <a href="lang_select.html">SELECT</a>, or <a href="lang_update.html">UPDATE</a> statement. The INDEXED BY phrase is an SQLite extension and is not portable to other SQL database engines.</p> <p><b><a href="syntax/qualified-table-name.html">qualified-table-name:</a></b> <button id='x1433' onclick='hideorshow("x1433","x1434")'>hide</button></p> <blockquote id='x1434'> <img alt="syntax diagram qualified-table-name" src="images/syntax/qualified-table-name.gif" /> </blockquote> <p>The "INDEXED BY index-name" phrase specifies that the named index must be used in order to look up values on the preceding table. If index-name does not exist or cannot be used for the query, then the preparation of the SQL statement fails. The "NOT INDEXED" clause specifies that no index shall be used when accessing the preceding table, including implied indices create by UNIQUE and PRIMARY KEY constraints. However, the <a href="lang_createtable.html#rowid">rowid</a> can still be used to look up entries even when "NOT INDEXED" is specified.</p> <p>Some SQL database engines provide non-standard "hint" mechanisms which can be used to give the query optimizer clues about what indices it should use for a particular statement. The INDEX BY clause of SQLite is <em>not</em> a hinting mechanism and it should not be used as such. The INDEXED BY clause does not give the optimizer hints about which index |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_insert.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
247 248 249 250 251 252 253 | 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> | | < | | 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 | 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 <a href="lang_conflict.html">ON CONFLICT</a> 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 <a href="lang_createtrigger.html">CREATE TRIGGER</a> 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. <p> |
Changes to Doc/Extra/Core/lang_keywords.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_naming.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_reindex.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_replace.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_savepoint.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_select.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
1110 1111 1112 1113 1114 1115 1116 | <h3>The VALUES clause</h3> <p>The phrase "VALUES(<i>expr-list</i>)" means the same thing as "SELECT <i>expr-list</i>". The phrase "VALUES(<i>expr-list-1</i>),...,(<i>expr-list-N</i>)" means the same thing as "SELECT <i>expr-list-1</i> UNION ALL ... UNION ALL | | | | > | < | | 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 | <h3>The VALUES clause</h3> <p>The phrase "VALUES(<i>expr-list</i>)" means the same thing as "SELECT <i>expr-list</i>". The phrase "VALUES(<i>expr-list-1</i>),...,(<i>expr-list-N</i>)" means the same thing as "SELECT <i>expr-list-1</i> UNION ALL ... UNION ALL SELECT <i>expr-list-N</i>". Both forms are the same, except that the number of SELECT statements in a compound is limited by <a href="c3ref/c_limit_attached.html#sqlitelimitcompoundselect">SQLITE_LIMIT_COMPOUND_SELECT</a> whereas the number of rows in a VALUES clause has no arbitrary limit. <p>There are some restrictions on the use of a VALUES clause that are not shown on the syntax diagrams: <ul> <li><p> A VALUES clause cannot be followed by <a href="lang_select.html#orderby">ORDER BY</a>. <li><p> A VALUES clause cannot be followed by <a href="lang_select.html#limitoffset">LIMIT</a>. </ul> <h3>The WITH Clause</h3> <p>SELECT statements may be optionally preceded by a single <a href="lang_with.html">WITH clause</a> that defines one or more <a href="lang_with.html">common table expressions</a> for use within the SELECT statement. |
Changes to Doc/Extra/Core/lang_transaction.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
230 231 232 233 234 235 236 | if an another thread or process has a <a href="lockingv3.html#shared_lock">shared lock</a> on the database that prevented the database from being updated. When COMMIT fails in this way, the transaction remains active and the COMMIT can be retried later after the reader has had a chance to clear. </p> <p> | > | < | > | > > > < < | 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 | if an another thread or process has a <a href="lockingv3.html#shared_lock">shared lock</a> on the database that prevented the database from being updated. When COMMIT fails in this way, the transaction remains active and the COMMIT can be retried later after the reader has had a chance to clear. </p> <p> In very old versions of SQLite (before version 3.7.11 circa 2012-03-20) the ROLLBACK will fail with an error code <a href="rescode.html#busy">SQLITE_BUSY</a> if there are any pending queries. In more recent versions of SQLite, the ROLLBACK will proceed and pending statements will often be aborted, causing them to return an <a href="rescode.html#abort">SQLITE_ABORT</a> or <a href="rescode.html#abort_rollback">SQLITE_ABORT_ROLLBACK</a> error. In SQLite version 3.8.8 and later, a pending read will continue functioning after the ROLLBACK as long as the ROLLBACK does not modify the database schema. </p> <p> If <a href="pragma.html#pragma_journal_mode">PRAGMA journal_mode</a> is set to OFF (thus disabling the rollback journal file) then the behavior of the ROLLBACK command is undefined. </p> <h3>Response To Errors Within A Transaction</h3> <p> If certain kinds of errors occur within a transaction, the transaction may or may not be rolled back automatically. The errors that can cause an automatic rollback include:</p> <ul> <li> <a href="rescode.html#full">SQLITE_FULL</a>: database or disk full <li> <a href="rescode.html#ioerr">SQLITE_IOERR</a>: disk I/O error <li> <a href="rescode.html#busy">SQLITE_BUSY</a>: database in use by another process <li> <a href="rescode.html#nomem">SQLITE_NOMEM</a>: out or memory </ul> <p> For all of these errors, SQLite attempts to undo just the one statement it was working on and leave changes from prior statements within the same transaction intact and continue with the transaction. However, depending on the statement being evaluated and the point at which the |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_update.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_vacuum.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_with.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
631 632 633 634 635 636 637 | <h4>Outlandish Recursive Query Examples</h4> <p>The following query computes an approximation of the Mandelbrot Set and outputs the result as ASCII-art: <blockquote><pre> WITH RECURSIVE | | | | | 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 | <h4>Outlandish Recursive Query Examples</h4> <p>The following query computes an approximation of the Mandelbrot Set and outputs the result as ASCII-art: <blockquote><pre> WITH RECURSIVE xaxis(x) AS (VALUES(-2.0) UNION ALL SELECT x+0.05 FROM xaxis WHERE x<1.2), yaxis(y) AS (VALUES(-1.0) UNION ALL SELECT y+0.1 FROM yaxis WHERE y<1.0), m(iter, cx, cy, x, y) AS ( SELECT 0, x, y, 0.0, 0.0 FROM xaxis, yaxis UNION ALL SELECT iter+1, cx, cy, x*x-y*y + cx, 2.0*x*y + cy FROM m WHERE (x*x + y*y) < 4.0 AND iter<28 ), m2(iter, cx, cy) AS ( SELECT max(iter), cx, cy FROM m GROUP BY cx, cy ), a(t) AS ( SELECT group_concat( substr(' .+*#', 1+min(iter/7,4), 1), '') FROM m2 GROUP BY cy |
︙ | ︙ | |||
728 729 730 731 732 733 734 | WITH RECURSIVE input(sud) AS ( VALUES('53..7....6..195....98....6.8...6...34..8.3..17...2...6.6....28....419..5....8..79') ), digits(z, lp) AS ( VALUES('1', 1) UNION ALL SELECT | | | 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 | WITH RECURSIVE input(sud) AS ( VALUES('53..7....6..195....98....6.8...6...34..8.3..17...2...6.6....28....419..5....8..79') ), digits(z, lp) AS ( VALUES('1', 1) UNION ALL SELECT CAST(lp+1 AS TEXT), lp+1 FROM digits WHERE lp<9 ), x(s, ind) AS ( SELECT sud, instr(sud, '.') FROM input UNION ALL SELECT substr(s, 1, ind-1) || z || substr(s, ind+1), instr( substr(s, 1, ind-1) || z || substr(s, ind+1), '.' ) |
︙ | ︙ |
Changes to Doc/Extra/Core/pragma.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
202 203 204 205 206 207 208 | When querying the value of a setting, many pragmas return the number rather than the keyword.</p> <p>A pragma may have an optional database name before the pragma name. The database name is the name of an <a href="lang_attach.html">ATTACH</a>-ed database or it can be "main" or "temp" for the main and the TEMP databases. If the optional database name is omitted, "main" is assumed. In some pragmas, the database | | > > > > < > > > < | 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 | When querying the value of a setting, many pragmas return the number rather than the keyword.</p> <p>A pragma may have an optional database name before the pragma name. The database name is the name of an <a href="lang_attach.html">ATTACH</a>-ed database or it can be "main" or "temp" for the main and the TEMP databases. If the optional database name is omitted, "main" is assumed. In some pragmas, the database name is meaningless and is simply ignored. In the documentation below, pragmas for which the database name is meaningful are shown with a "<i>database.</i>" prefix.</p> <hr /><a name="toc"></a> <h2>List Of PRAGMAs</h2> <table border=0 width="100%" cellpadding=10> <tr><td valign="top" align="left"><ul> <li><a href="#pragma_application_id">application_id</a> <li><a href="#pragma_auto_vacuum">auto_vacuum</a> <li><a href="#pragma_automatic_index">automatic_index</a> <li><a href="#pragma_busy_timeout">busy_timeout</a> <li><a href="#pragma_cache_size">cache_size</a> <li><a href="#pragma_cache_spill">cache_spill</a> <li><a href="#pragma_case_sensitive_like">case_sensitive_like</a> <li><a href="#pragma_checkpoint_fullfsync">checkpoint_fullfsync</a> <li><a href="#pragma_collation_list">collation_list</a> <li><a href="#pragma_compile_options">compile_options</a> <li><a href="#pragma_count_changes"><s>count_changes</s></a>¹ <li><a href="#pragma_data_store_directory"><s>data_store_directory</s></a>¹ <li><a href="#pragma_data_version">data_version</a> <li><a href="#pragma_database_list">database_list</a> <li><a href="#pragma_default_cache_size"><s>default_cache_size</s></a>¹ <li><a href="#pragma_defer_foreign_keys">defer_foreign_keys</a> <li><a href="#pragma_empty_result_callbacks"><s>empty_result_callbacks</s></a>¹ <li><a href="#pragma_encoding">encoding</a> <li><a href="#pragma_foreign_key_check">foreign_key_check</a> <li><a href="#pragma_foreign_key_list">foreign_key_list</a> <li><a href="#pragma_foreign_keys">foreign_keys</a> </ul></td><td valign="top" align="left"><ul> <li><a href="#pragma_freelist_count">freelist_count</a> <li><a href="#pragma_full_column_names"><s>full_column_names</s></a>¹ <li><a href="#pragma_fullfsync">fullfsync</a> <li><a href="#pragma_ignore_check_constraints">ignore_check_constraints</a> <li><a href="#pragma_incremental_vacuum">incremental_vacuum</a> <li><a href="#pragma_index_info">index_info</a> <li><a href="#pragma_index_list">index_list</a> <li><a href="#pragma_index_xinfo">index_xinfo</a> <li><a href="#pragma_integrity_check">integrity_check</a> <li><a href="#pragma_journal_mode">journal_mode</a> <li><a href="#pragma_journal_size_limit">journal_size_limit</a> <li><a href="#pragma_legacy_file_format">legacy_file_format</a> <li><a href="#pragma_locking_mode">locking_mode</a> <li><a href="#pragma_max_page_count">max_page_count</a> <li><a href="#pragma_mmap_size">mmap_size</a> <li><a href="#pragma_page_count">page_count</a> <li><a href="#pragma_page_size">page_size</a> <li><a href="#pragma_parser_trace"><i>parser_trace</i></a>² <li><a href="#pragma_query_only">query_only</a> <li><a href="#pragma_quick_check">quick_check</a> <li><a href="#pragma_read_uncommitted">read_uncommitted</a> </ul></td><td valign="top" align="left"><ul> <li><a href="#pragma_recursive_triggers">recursive_triggers</a> <li><a href="#pragma_reverse_unordered_selects">reverse_unordered_selects</a> <li><a href="#pragma_schema_version">schema_version</a> <li><a href="#pragma_secure_delete">secure_delete</a> <li><a href="#pragma_short_column_names"><s>short_column_names</s></a>¹ <li><a href="#pragma_shrink_memory">shrink_memory</a> <li><a href="#pragma_soft_heap_limit">soft_heap_limit</a> <li><a href="#pragma_stats"><i>stats</i></a>³ <li><a href="#pragma_synchronous">synchronous</a> |
︙ | ︙ | |||
289 290 291 292 293 294 295 | from existing applications at your earliest opportunity.</blockquote> <li>These pragmas are used for debugging SQLite and are only available when SQLite is compiled using <a href="compile.html#debug">SQLITE_DEBUG</a>. <li>These pragmas are used for testing SQLite and are not recommended for use in application programs.</ol></p> <a name="pragma_application_id"></a> <hr> | | | | | | 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 | from existing applications at your earliest opportunity.</blockquote> <li>These pragmas are used for debugging SQLite and are only available when SQLite is compiled using <a href="compile.html#debug">SQLITE_DEBUG</a>. <li>These pragmas are used for testing SQLite and are not recommended for use in application programs.</ol></p> <a name="pragma_application_id"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>application_id; <br>PRAGMA </b><i>database.</i><b>application_id = </b><i>integer </i><b>;</b> <p> The application_id PRAGMA is used to query or set the 32-bit unsigned big-endian "Application ID" integer located at offset 68 into the <a href="fileformat2.html#database_header">database header</a>. Applications that use SQLite as their <a href="appfileformat.html">application file-format</a> should set the Application ID integer to a unique integer so that utilities such as <a href="http://www.darwinsys.com/file/">file(1)</a> can determine the specific file type rather than just reporting "SQLite3 Database". A list of assigned application IDs can be seen by consulting the <a href="http://www.sqlite.org/src/artifact?ci=trunk&filename=magic.txt">magic.txt</a> file in the SQLite source repository. <a name="pragma_auto_vacuum"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>auto_vacuum;<br> PRAGMA </b><i>database.</i><b>auto_vacuum = </b> <i>0 | NONE | 1 | FULL | 2 | INCREMENTAL</i><b>;</b></p> <p>Query or set the auto-vacuum status in the database.</p> <p>The default setting for auto-vacuum is 0 or "none", unless the <a href="compile.html#default_autovacuum">SQLITE_DEFAULT_AUTOVACUUM</a> compile-time option is used. The "none" setting means that auto-vacuum is disabled. |
︙ | ︙ | |||
380 381 382 383 384 385 386 | bindings that do not provide direct access to <a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a>. <p>Each database connection can only have a single <a href="c3ref/busy_handler.html">busy handler</a>. This PRAGMA sets the busy handler for the process, possibly overwriting any previously set busy handler. <a name="pragma_cache_size"></a> <hr> | | | | | > > > | | 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 | bindings that do not provide direct access to <a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a>. <p>Each database connection can only have a single <a href="c3ref/busy_handler.html">busy handler</a>. This PRAGMA sets the busy handler for the process, possibly overwriting any previously set busy handler. <a name="pragma_cache_size"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>cache_size; <br>PRAGMA </b><i>database.</i><b>cache_size = </b><i>pages</i><b>; <br>PRAGMA </b><i>database.</i><b>cache_size = -</b><i>kibibytes</i><b>;</b></p> <p>Query or change the suggested maximum number of database disk pages that SQLite will hold in memory at once per open database file. Whether or not this suggestion is honored is at the discretion of the <a href="c3ref/pcache_methods2.html">Application Defined Page Cache</a>. The default page cache that is built into SQLite honors the request, however alternative application-defined page cache implementations may choose to interpret the suggested cache size in different ways or to ignore it all together. The default suggested cache size is 2000 pages. The default suggested cache size can be altered using the <a href="compile.html#default_cache_size">SQLITE_DEFAULT_CACHE_SIZE</a> compile-time options. The TEMP database has a default suggested cache size of 0 pages.</p> <p>If the argument N is positive then the suggested cache size is set to N. If the argument N is negative, then the number of cache pages is adjusted to use approximately abs(N*1024) bytes of memory. <i>Backwards compatibility note:</i> The behavior of cache_size with a negative N was different in SQLite versions prior to 3.7.10. In version 3.7.9 and earlier, the number of pages in the cache was set to the absolute value of N.</p> |
︙ | ︙ | |||
498 499 500 501 502 503 504 | use of this pragma at the earliest opportunity. This pragma may be omitted from the build when SQLite is compiled using <a href="compile.html#omit_deprecated">SQLITE_OMIT_DEPRECATED</a>. </p> <a name="pragma_data_store_directory"></a> <hr> <p><b>PRAGMA data_store_directory; | | | 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 | use of this pragma at the earliest opportunity. This pragma may be omitted from the build when SQLite is compiled using <a href="compile.html#omit_deprecated">SQLITE_OMIT_DEPRECATED</a>. </p> <a name="pragma_data_store_directory"></a> <hr> <p><b>PRAGMA data_store_directory; <br>PRAGMA data_store_directory = '</b><i>directory-name</i><b>';</b></p> <p>Query or change the value of the <a href="c3ref/data_directory.html">sqlite3_data_directory</a> global variable, which windows operating-system interface backends use to determine where to store database files specified using a relative pathname.</p> <p>Changing the data_store_directory setting is <u>not</u> threadsafe. Never change the data_store_directory setting if another thread |
︙ | ︙ | |||
525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 | <b>This pragma is deprecated</b> and exists for backwards compatibility only. New applications should avoid using this pragma. Older applications should discontinue use of this pragma at the earliest opportunity. This pragma may be omitted from the build when SQLite is compiled using <a href="compile.html#omit_deprecated">SQLITE_OMIT_DEPRECATED</a>. </p> <a name="pragma_database_list"></a> <hr> <p><b>PRAGMA database_list;</b></p> <p>This pragma works like a query to return one row for each database attached to the current database connection. The second column is the "main" for the main database file, "temp" for the database file used to store TEMP objects, or the name of the ATTACHed database for other database files. The third column is the name of the database file itself, or an empty string if the database is not associated with a file.</p> <a name="pragma_default_cache_size"></a> <hr> | > > > > > > > > > > > > > > > > > > > > > > > > > > > | > | | 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 | <b>This pragma is deprecated</b> and exists for backwards compatibility only. New applications should avoid using this pragma. Older applications should discontinue use of this pragma at the earliest opportunity. This pragma may be omitted from the build when SQLite is compiled using <a href="compile.html#omit_deprecated">SQLITE_OMIT_DEPRECATED</a>. </p> <a name="pragma_data_version"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>data_version;</b></p> <p>The "PRAGMA data_version" command provides an indication that the database file has been modified. Interactive programs that hold database content in memory or that display database content on-screen can use the PRAGMA data_version command to determine if they need to flush and reload their memory or update the screen display.</p> <p>The integer values returned by two invocations of "PRAGMA data_version" from the same connection will be different if changes were committed to the database by any other connection in the interim. The "PRAGMA data_version" value is unchanged for commits made on the same database connection. The behavior of "PRAGMA data_version" is the same for all database connections, including database connections in separate processes and <a href="sharedcache.html">shared cache</a> database connections. <p>The "PRAGMA data_version" value is a local property of each database connection and so values returned by two concurrent invocations of "PRAGMA data_version" on separate database connections are often different even though the underlying database is identical. It is only meaningful to compare the "PRAGMA data_version" values returned by the same database connection at two different points in time. <a name="pragma_database_list"></a> <hr> <p><b>PRAGMA database_list;</b></p> <p>This pragma works like a query to return one row for each database attached to the current database connection. The second column is the "main" for the main database file, "temp" for the database file used to store TEMP objects, or the name of the ATTACHed database for other database files. The third column is the name of the database file itself, or an empty string if the database is not associated with a file.</p> <a name="pragma_default_cache_size"></a> <hr> <b>PRAGMA </b><i>database.</i><b>default_cache_size; <br>PRAGMA </b><i>database.</i><b>default_cache_size = </b><i>Number-of-pages</i><b>;</b></p> <p>This pragma queries or sets the suggested maximum number of pages of disk cache that will be allocated per open database file. The difference between this pragma and <a href="pragma.html#pragma_cache_size">cache_size</a> is that the value set here persists across database connections. The value of the default cache size is stored in the 4-byte big-endian integer located at offset 48 in the header of the |
︙ | ︙ | |||
629 630 631 632 633 634 635 | <p>Once an encoding has been set for a database, it cannot be changed.</p> <p>Databases created by the <a href="lang_attach.html">ATTACH</a> command always use the same encoding as the main database. An attempt to <a href="lang_attach.html">ATTACH</a> a database with a different text encoding from the "main" database will fail.</p> <a name="pragma_foreign_key_check"></a> <hr> | | | | 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 | <p>Once an encoding has been set for a database, it cannot be changed.</p> <p>Databases created by the <a href="lang_attach.html">ATTACH</a> command always use the same encoding as the main database. An attempt to <a href="lang_attach.html">ATTACH</a> a database with a different text encoding from the "main" database will fail.</p> <a name="pragma_foreign_key_check"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>foreign_key_check; <br>PRAGMA </b><i>database.</i><b>foreign_key_check(</b><i>table-name</i><b>);</b></b></p> <p>The foreign_key_check pragma checks the database, or the table called "<i>table-name</i>", for <a href="foreignkeys.html">foreign key constraints</a> that are violated and returns one row of output for each violation. There are four columns in each result row. The first column is the name of the table that contains the REFERENCES clause. The second column is the <a href="lang_createtable.html#rowid">rowid</a> of the row that |
︙ | ︙ | |||
679 680 681 682 683 684 685 | release of SQLite. The default setting for foreign key enforcement can be specified at compile-time using the <a href="compile.html#default_foreign_keys">SQLITE_DEFAULT_FOREIGN_KEYS</a> preprocessor macro. To minimize future problems, applications should set the foreign key enforcement flag as required by the application and not depend on the default setting. <a name="pragma_freelist_count"></a> <hr> | | | 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 | release of SQLite. The default setting for foreign key enforcement can be specified at compile-time using the <a href="compile.html#default_foreign_keys">SQLITE_DEFAULT_FOREIGN_KEYS</a> preprocessor macro. To minimize future problems, applications should set the foreign key enforcement flag as required by the application and not depend on the default setting. <a name="pragma_freelist_count"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>freelist_count;</b></p> <p>Return the number of unused pages in the database file.</p> <a name="pragma_full_column_names"></a> <hr> <p><b>PRAGMA full_column_names; <br>PRAGMA full_column_names = </b><i>boolean</i><b>;</b></p> <p>Query or change the full_column_names flag. This flag together |
︙ | ︙ | |||
734 735 736 737 738 739 740 | <p><b>PRAGMA ignore_check_constraints = </b><i>boolean</i><b>;</b></p> <p>This pragma enables or disables the enforcement of CHECK constraints. The default setting is off, meaning that CHECK constraints are enforced by default.</p> <a name="pragma_incremental_vacuum"></a> <hr> | | | | > > > > > > > > > | | | | | > > > > | | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | | < | < < | | < < < < < | | | 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 | <p><b>PRAGMA ignore_check_constraints = </b><i>boolean</i><b>;</b></p> <p>This pragma enables or disables the enforcement of CHECK constraints. The default setting is off, meaning that CHECK constraints are enforced by default.</p> <a name="pragma_incremental_vacuum"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>incremental_vacuum</b><i>(N)</i><b>;</b></p> <p>The incremental_vacuum pragma causes up to <i>N</i> pages to be removed from the <a href="fileformat2.html#freelist">freelist</a>. The database file is truncated by the same amount. The incremental_vacuum pragma has no effect if the database is not in <a href="#pragma_auto_vacuum">auto_vacuum=incremental</a> mode or if there are no pages on the freelist. If there are fewer than <i>N</i> pages on the freelist, or if <i>N</i> is less than 1, or if <i>N</i> is omitted entirely, then the entire freelist is cleared.</p> <a name="pragma_index_info"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>index_info(</b><i>index-name</i><b>);</b></p> <p>This pragma returns one row for each key column in the named index. A key column is a column that is actually named in the <a href="lang_createindex.html">CREATE INDEX</a> index statement or <a href="lang_createtable.html#uniqueconst">UNIQUE constraint</a> or <a href="lang_createtable.html#primkeyconst">PRIMARY KEY constraint</a> that created the index. Index entries also usually contain auxiliary columns that point back to the table row being indexed. The auxiliary index-columns are not shown by the index_info pragma, but they are listed by the <a href="pragma.html#pragma_index_xinfo">index_xinfo pragma</a>.</p> <p>Output columns from the index_info pragma are as follows: <ol> <li>The rank of the column within the index. (0 means left-most.) <li>The rank of the column within the table being indexed. <li>The name of the column being indexed. </ol> <a name="pragma_index_list"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>index_list(</b><i>table-name</i><b>);</b></p> <p>This pragma returns one row for each index associated with the given table. <p>Output columns from the index_list pragma are as follows: <ol> <li>A sequence number assigned to each index for internal tracking purposes. <li>The name of the index. <li>"1" if the index is UNIQUE and "0" if not. <li>"c" if the index was created by a <a href="lang_createindex.html">CREATE INDEX</a> statement, "u" if the index was created by a <a href="lang_createtable.html#uniqueconst">UNIQUE constraint</a>, or "pk" if the index was created by a <a href="lang_createtable.html#primkeyconst">PRIMARY KEY constraint</a>. <li>"1" if the index is a <a href="partialindex.html">partial index</a> and "0" if not. </ol> </p> <a name="pragma_index_xinfo"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>index_xinfo(</b><i>index-name</i><b>);</b></p> <p>This pragma returns information about every column in an index. Unlike this <a href="pragma.html#pragma_index_info">index_info pragma</a>, this pragma returns information about every column in the index, not just the key columns. (A key column is a column that is actually named in the <a href="lang_createindex.html">CREATE INDEX</a> index statement or <a href="lang_createtable.html#uniqueconst">UNIQUE constraint</a> or <a href="lang_createtable.html#primkeyconst">PRIMARY KEY constraint</a> that created the index. Auxiliary columns are additional columns needed to locate the table entry that corresponds to each index entry.) <p>Output columns from the index_xinfo pragma are as follows: <ol> <li>The rank of the column within the index. (0 means left-most. Key columns come before auxiliary columns.) <li>The rank of the column within the table being indexed, or -1 if the index-column is the <a href="lang_createtable.html#rowid">rowid</a> of the table being indexed. <li>The name of the column being indexed, or NULL if the index-column is the <a href="lang_createtable.html#rowid">rowid</a> of the table being indexed. <li>1 if the index-column is sorted in reverse (DESC) order by the index and 0 otherwise. <li>The name for the <a href="datatype3.html#collation">collating sequence</a> used to compare values in the index-column. <li>1 if the index-column is a key column and 0 if the index-column is an auxiliary column. </ol> <a name="pragma_integrity_check"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>integrity_check; <br>PRAGMA </b><i>database.</i><b>integrity_check(</b><i>N</i><b>)</b></p> <p>This pragma does an integrity check of the entire database. The integrity_check pragma looks for out-of-order records, missing pages, malformed records, missing index entries, and UNIQUE and NOT NULL constraint errors. If the integrity_check pragma finds problems, strings are returned (as multiple rows with a single column per row) which describe the problems. Pragma integrity_check will return at most <i>N</i> errors before the analysis quits, with N defaulting to 100. If pragma integrity_check finds no errors, a single row with the value 'ok' is returned.</p> <p>PRAGMA integrity_check does not find <a href="foreignkeys.html">FOREIGN KEY</a> errors. Use the <a href="pragma.html#pragma_foreign_key_check">PRAGMA foreign_key_check</a> command for to find errors in FOREIGN KEY constraints.</p> <p>See also the <a href="pragma.html#pragma_quick_check">PRAGMA quick_check</a> command which does most of the checking of PRAGMA integrity_check but runs much faster.</p> <a name="pragma_journal_mode"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>journal_mode; <br>PRAGMA </b><i>database.</i><b>journal_mode = <i>DELETE | TRUNCATE | PERSIST | MEMORY | WAL | OFF</i></b></p> <p>This pragma queries or sets the journal mode for databases associated with the current <a href="c3ref/sqlite3.html">database connection</a>.</p> <p>The first form of this pragma queries the current journaling mode for <i>database</i>. When <i>database</i> is omitted, the "main" database is queried.</p> <p>The second form changes the journaling mode for "<i>database</i>" or for all attached databases if "<i>database</i>" is omitted. The new journal mode is returned. If the journal mode could not be changed, the original journal mode is returned.</p> <p>The DELETE journaling mode is the normal behavior. In the DELETE mode, the rollback journal is deleted at the conclusion of each transaction. Indeed, the delete operation is the action that causes the transaction to commit. |
︙ | ︙ | |||
859 860 861 862 863 864 865 | is either MEMORY or OFF and can not be changed to a different value. An attempt to change the journal_mode of an <a href="inmemorydb.html">in-memory database</a> to any setting other than MEMORY or OFF is ignored. Note also that the journal_mode cannot be changed while a transaction is active.</p> <a name="pragma_journal_size_limit"></a> <hr> <p><b> | | | | 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 | is either MEMORY or OFF and can not be changed to a different value. An attempt to change the journal_mode of an <a href="inmemorydb.html">in-memory database</a> to any setting other than MEMORY or OFF is ignored. Note also that the journal_mode cannot be changed while a transaction is active.</p> <a name="pragma_journal_size_limit"></a> <hr> <p><b> PRAGMA </b><i>database.</i><b>journal_size_limit<br> PRAGMA </b><i>database.</i><b>journal_size_limit = </b><i>N</i> <b>;</b> <p>If a database connection is operating in <a href="pragma.html#pragma_locking_mode">exclusive locking mode</a> or in <a href="pragma.html#pragma_journal_mode">persistent journal mode</a> (PRAGMA journal_mode=persist) then after committing a transaction the <a href="lockingv3.html#rollback">rollback journal</a> file may remain in the file-system. This increases performance for subsequent transactions |
︙ | ︙ | |||
924 925 926 927 928 929 930 | <p>The legacy_file_format pragma is initialized to OFF when an existing database in the newer file format is first opened.</p> <p>The default file format is set by the <a href="compile.html#default_file_format">SQLITE_DEFAULT_FILE_FORMAT</a> compile-time option.</p> <a name="pragma_locking_mode"></a> <hr> | | > | | 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 | <p>The legacy_file_format pragma is initialized to OFF when an existing database in the newer file format is first opened.</p> <p>The default file format is set by the <a href="compile.html#default_file_format">SQLITE_DEFAULT_FILE_FORMAT</a> compile-time option.</p> <a name="pragma_locking_mode"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>locking_mode; <br>PRAGMA </b><i>database.</i><b>locking_mode = <i>NORMAL | EXCLUSIVE</i></b></p> <p>This pragma sets or queries the database connection locking-mode. The locking-mode is either NORMAL or EXCLUSIVE. <p>In NORMAL locking-mode (the default unless overridden at compile-time using <a href="compile.html#default_locking_mode">SQLITE_DEFAULT_LOCKING_MODE</a>), a database connection unlocks the database file at the conclusion of each read or write transaction. When the locking-mode is set to EXCLUSIVE, the |
︙ | ︙ | |||
985 986 987 988 989 990 991 | NORMAL until after exiting WAL journal mode. If the locking mode is NORMAL when first entering WAL journal mode, then the locking mode can be changed between NORMAL and EXCLUSIVE and back again at any time and without needing to exit WAL journal mode.</p> <a name="pragma_max_page_count"></a> <hr> | | | | | | 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 | NORMAL until after exiting WAL journal mode. If the locking mode is NORMAL when first entering WAL journal mode, then the locking mode can be changed between NORMAL and EXCLUSIVE and back again at any time and without needing to exit WAL journal mode.</p> <a name="pragma_max_page_count"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>max_page_count; <br>PRAGMA </b><i>database.</i><b>max_page_count = </b><i>N</i><b>;</b></p> <p>Query or set the maximum number of pages in the database file. Both forms of the pragma return the maximum page count. The second form attempts to modify the maximum page count. The maximum page count cannot be reduced below the current database size. </p> <a name="pragma_mmap_size"></a> <hr> <p><br><b>PRAGMA </b><i>database.</i><b>mmap_size; <br>PRAGMA </b><i>database.</i><b>mmap_size=</b><i>N</i></p> <p>Query or change the maximum number of bytes that are set aside for memory-mapped I/O on a single database. The first form (without an argument) queries the current limit. The second form (with a numeric argument) sets the limit for the specified database, or for all databases if the optional database name is omitted. In the second form, if the database name is omitted, the |
︙ | ︙ | |||
1029 1030 1031 1032 1033 1034 1035 | the memory-mapped I/O region is in active use, to avoid unmapping memory out from under running SQL statements. For this reason, the mmap_size pragma may be a no-op if the prior mmap_size is non-zero and there are other SQL statements running concurrently on the same <a href="c3ref/sqlite3.html">database connection</a>.</p> <a name="pragma_page_count"></a> <hr> | | | | | 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 | the memory-mapped I/O region is in active use, to avoid unmapping memory out from under running SQL statements. For this reason, the mmap_size pragma may be a no-op if the prior mmap_size is non-zero and there are other SQL statements running concurrently on the same <a href="c3ref/sqlite3.html">database connection</a>.</p> <a name="pragma_page_count"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>page_count;</b></p> <p>Return the total number of pages in the database file.</p> <a name="pragma_page_size"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>page_size; <br>PRAGMA </b><i>database.</i><b>page_size = </b><i>bytes</i><b>;</b></p> <p>Query or set the page size of the database. The page size must be a power of two between 512 and 65536 inclusive. </p> <p>When a new database is created, SQLite assigned a default page size based on information received from the xSectorSize and xDeviceCharacteristics methods of the <a href="c3ref/io_methods.html">sqlite3_io_methods</a> object |
︙ | ︙ | |||
1091 1092 1093 1094 1095 1096 1097 | This pragma is intended for use when debugging SQLite itself. It is only available when the <a href="compile.html#debug">SQLITE_DEBUG</a> compile-time option is used.</p> <a name="pragma_query_only"></a> <hr> <p><b>PRAGMA query_only; | | | | | 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 | This pragma is intended for use when debugging SQLite itself. It is only available when the <a href="compile.html#debug">SQLITE_DEBUG</a> compile-time option is used.</p> <a name="pragma_query_only"></a> <hr> <p><b>PRAGMA query_only; <br>PRAGMA query_only = </b><i>boolean</i><b>;</b></p> <p>The query_only pragma prevents all changes to database files when enabled.</p> <a name="pragma_quick_check"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>quick_check; <br>PRAGMA </b><i>database.</i><b>quick_check(</b><i>N</i><b>)</b></p> <p>The pragma is like <a href="pragma.html#pragma_integrity_check">integrity_check</a> except that it does not verify UNIQUE and NOT NULL constraints and does not verify that index content matches table content. By skipping UNIQUE and NOT NULL and index consistency checks, quick_check is able to run much faster than integrity_check. Otherwise the two pragmas are the same. </p> <a name="pragma_read_uncommitted"></a> |
︙ | ︙ | |||
1145 1146 1147 1148 1149 1150 1151 | <p>The depth of recursion for triggers has a hard upper limit set by the <a href="limits.html#max_trigger_depth">SQLITE_MAX_TRIGGER_DEPTH</a> compile-time option and a run-time limit set by <a href="c3ref/limit.html">sqlite3_limit</a>(db,<a href="c3ref/c_limit_attached.html#sqlitelimittriggerdepth">SQLITE_LIMIT_TRIGGER_DEPTH</a>,...).</p> <a name="pragma_reverse_unordered_selects"></a> <hr> <p><b>PRAGMA reverse_unordered_selects; <br>PRAGMA reverse_unordered_selects = </b><i>boolean</i><b>;</b></p> | | | | > > > > > | | | | | 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 | <p>The depth of recursion for triggers has a hard upper limit set by the <a href="limits.html#max_trigger_depth">SQLITE_MAX_TRIGGER_DEPTH</a> compile-time option and a run-time limit set by <a href="c3ref/limit.html">sqlite3_limit</a>(db,<a href="c3ref/c_limit_attached.html#sqlitelimittriggerdepth">SQLITE_LIMIT_TRIGGER_DEPTH</a>,...).</p> <a name="pragma_reverse_unordered_selects"></a> <hr> <p><b>PRAGMA reverse_unordered_selects; <br>PRAGMA reverse_unordered_selects = </b><i>boolean</i><b>;</b></p> <p>When enabled, this PRAGMA causes many <a href="lang_select.html">SELECT</a> statements without an ORDER BY clause to emit their results in the reverse order from what they normally would. This can help debug applications that are making invalid assumptions about the result order. The reverse_unordered_selects pragma works for most SELECT statements, however the query planner may sometimes choose an algorithm that is not easily reversed, in which case the output will appear in the same order regardless of the reverse_unordered_selects setting. <p>SQLite makes no guarantees about the order of results if a SELECT omits the ORDER BY clause. Even so, the order of results does not change from one run to the next, and so many applications mistakenly come to depend on the arbitrary output order whatever that order happens to be. However, sometimes new versions of SQLite will contain optimizer enhancements that will cause the output order of queries without ORDER BY clauses to shift. When that happens, applications that depend on a certain output order might malfunction. By running the application multiple times with this pragma both disabled and enabled, cases where the application makes faulty assumptions about output order can be identified and fixed early, reducing problems that might be caused by linking against a different version of SQLite. </p> <a name="pragma_schema_version"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>schema_version; <br>PRAGMA </b><i>database.</i><b>schema_version = </b><i>integer </i><b>; <br>PRAGMA </b><i>database.</i><b>user_version; <br>PRAGMA </b><i>database.</i><b>user_version = </b><i>integer </i><b>;</b> <p> The pragmas schema_version and user_version are used to set or get the value of the schema-version and user-version, respectively. The schema-version and the user-version are big-endian 32-bit signed integers stored in the database header at offsets 40 and 60, respectively.</p> |
︙ | ︙ | |||
1190 1191 1192 1193 1194 1195 1196 | to modify the schema-version is potentially dangerous and may lead to program crashes or database corruption. Use with caution!</p> <p> The user-version is not used internally by SQLite. It may be used by applications for any purpose.</p> <a name="pragma_secure_delete"></a> <hr> | < | < | < | 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 | to modify the schema-version is potentially dangerous and may lead to program crashes or database corruption. Use with caution!</p> <p> The user-version is not used internally by SQLite. It may be used by applications for any purpose.</p> <a name="pragma_secure_delete"></a> <hr> <p>PRAGMA </b><i>database.</i><b>secure_delete; <br>PRAGMA </b><i>database.</i><b>secure_delete = </b><i>boolean</i></p> <p>Query or change the secure-delete setting. When secure-delete on, SQLite overwrites deleted content with zeros. The default setting is determined by the <a href="compile.html#secure_delete">SQLITE_SECURE_DELETE</a> compile-time option. <p> When there are <a href="lang_attach.html">attached databases</a> and no database |
︙ | ︙ | |||
1256 1257 1258 1259 1260 1261 1262 | </p> <a name="pragma_stats"></a> <hr> <p><b>PRAGMA stats;</b> </p> <p>This pragma returns auxiliary information about tables and indices. The returned information is used during testing to help verify that the query planner is operating correctly. The format | | | | | 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 | </p> <a name="pragma_stats"></a> <hr> <p><b>PRAGMA stats;</b> </p> <p>This pragma returns auxiliary information about tables and indices. The returned information is used during testing to help verify that the query planner is operating correctly. The format and meaning of this pragma will likely change from one release to the next. Because of its volatility, the behavior and output format of this pragma are deliberately undocumented.</p> <p style='background-color: #f0e0ff;'> The intended use of this pragma is only for testing and validation of SQLite. This pragma is subject to change without notice and is not recommended for use by application programs.</p> <a name="pragma_synchronous"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>synchronous; <br>PRAGMA </b><i>database.</i><b>synchronous = </b> <i>0 | OFF | 1 | NORMAL | 2 | FULL</i><b>;</b></p> <p>Query or change the setting of the "synchronous" flag. The first (query) form will return the synchronous setting as an integer. When synchronous is FULL (2), the SQLite database engine will use the xSync method of the <a href="vfs.html">VFS</a> to ensure that all content is safely written to the disk surface prior to continuing. |
︙ | ︙ | |||
1314 1315 1316 1317 1318 1319 1320 | all one needs in WAL mode.</p> <p>The default setting is synchronous=FULL.</p> <p>See also the <a href="pragma.html#pragma_fullfsync">fullfsync</a> and <a href="pragma.html#pragma_checkpoint_fullfsync">checkpoint_fullfsync</a> pragmas.</p> <a name="pragma_table_info"></a> <hr> | | | | 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 | all one needs in WAL mode.</p> <p>The default setting is synchronous=FULL.</p> <p>See also the <a href="pragma.html#pragma_fullfsync">fullfsync</a> and <a href="pragma.html#pragma_checkpoint_fullfsync">checkpoint_fullfsync</a> pragmas.</p> <a name="pragma_table_info"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>table_info(</b><i>table-name</i><b>);</b></p> <p>This pragma returns one row for each column in the named table. Columns in the result set include the column name, data type, whether or not the column can be NULL, and the default value for the column. The "pk" column in the result set is zero for columns that are not part of the primary key, and is the index of the column in the primary key for columns that are part of the primary key.</p> <p>The table named in the table_info pragma can also be a view.</p> <a name="pragma_temp_store"></a> <hr> <p><b>PRAGMA temp_store; <br>PRAGMA temp_store = </b> <i>0 | DEFAULT | 1 | FILE | 2 | MEMORY</i><b>;</b></p> <p>Query or change the setting of the "<b>temp_store</b>" parameter. When temp_store is DEFAULT (0), the compile-time C preprocessor macro <a href="compile.html#temp_store">SQLITE_TEMP_STORE</a> is used to determine where temporary tables and indices are stored. When temp_store is MEMORY (2) <a href="inmemorydb.html#temp_db">temporary tables</a> and indices are kept in |
︙ | ︙ | |||
1382 1383 1384 1385 1386 1387 1388 | <td align="center"><em>any</em></td> <td align="center">memory</td></tr> </table> </blockquote> <a name="pragma_temp_store_directory"></a> <hr> <p><b>PRAGMA temp_store_directory; | | | 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 | <td align="center"><em>any</em></td> <td align="center">memory</td></tr> </table> </blockquote> <a name="pragma_temp_store_directory"></a> <hr> <p><b>PRAGMA temp_store_directory; <br>PRAGMA temp_store_directory = '</b><i>directory-name</i><b>';</b></p> <p>Query or change the value of the <a href="c3ref/temp_directory.html">sqlite3_temp_directory</a> global variable, which many operating-system interface backends use to determine where to store <a href="inmemorydb.html#temp_db">temporary tables</a> and indices.</p> <p>When the temp_store_directory setting is changed, all existing temporary tables, indices, triggers, and viewers in the database connection that issued the pragma are immediately deleted. In |
︙ | ︙ | |||
1426 1427 1428 1429 1430 1431 1432 | use of this pragma at the earliest opportunity. This pragma may be omitted from the build when SQLite is compiled using <a href="compile.html#omit_deprecated">SQLITE_OMIT_DEPRECATED</a>. </p> <a name="pragma_threads"></a> <hr> <p><b>PRAGMA threads; | | | 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 | use of this pragma at the earliest opportunity. This pragma may be omitted from the build when SQLite is compiled using <a href="compile.html#omit_deprecated">SQLITE_OMIT_DEPRECATED</a>. </p> <a name="pragma_threads"></a> <hr> <p><b>PRAGMA threads; <br>PRAGMA threads = </b><i>N</i><b>;</b></p> <p>Query or change the value of the <a href="c3ref/limit.html">sqlite3_limit</a>(db,<a href="c3ref/c_limit_attached.html#sqlitelimitworkerthreads">SQLITE_LIMIT_WORKER_THREADS</a>,...) limit for the current database connection. This limit sets an upper bound on the number of auxiliary threads that a <a href="c3ref/stmt.html">prepared statement</a> is allowed to launch to assist with a query. The default limit is 0 unless it is changed using the <a href="compile.html#default_worker_threads">SQLITE_DEFAULT_WORKER_THREADS</a> compile-time option. When the limit is zero, that means no |
︙ | ︙ | |||
1514 1515 1516 1517 1518 1519 1520 | This pragma is intended for use when debugging SQLite itself. It is only available when the <a href="compile.html#debug">SQLITE_DEBUG</a> compile-time option is used.</p> <a name="pragma_wal_autocheckpoint"></a> <hr> <p><b>PRAGMA wal_autocheckpoint;<br> | | | | | | > | | | > | | | | | | > > > > > | | 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 | This pragma is intended for use when debugging SQLite itself. It is only available when the <a href="compile.html#debug">SQLITE_DEBUG</a> compile-time option is used.</p> <a name="pragma_wal_autocheckpoint"></a> <hr> <p><b>PRAGMA wal_autocheckpoint;<br> PRAGMA wal_autocheckpoint=</b><i>N</i><b>;</b></p> <p>This pragma queries or sets the <a href="wal.html">write-ahead log</a> <a href="wal.html#ckpt">auto-checkpoint</a> interval. When the <a href="wal.html">write-ahead log</a> is enabled (via the <a href="pragma.html#pragma_journal_mode">journal_mode pragma</a>) a checkpoint will be run automatically whenever the write-ahead log equals or exceeds <i>N</i> pages in length. Setting the auto-checkpoint size to zero or a negative value turns auto-checkpointing off.</p> <p>This pragma is a wrapper around the <a href="c3ref/wal_autocheckpoint.html">sqlite3_wal_autocheckpoint()</a> C interface. All automatic checkpoints are <a href="c3ref/wal_checkpoint_v2.html">PASSIVE</a>.</p> <p>Autocheckpointing is enabled by default with an interval of 1000 or <a href="compile.html#default_wal_autocheckpoint">SQLITE_DEFAULT_WAL_AUTOCHECKPOINT</a>.</p> <a name="pragma_wal_checkpoint"></a> <hr> <p><b>PRAGMA </b><i>database.</i><b>wal_checkpoint;</b><br> <b>PRAGMA </b><i>database.</i><b>wal_checkpoint(PASSIVE);</b><br> <b>PRAGMA </b><i>database.</i><b>wal_checkpoint(FULL);</b><br> <b>PRAGMA </b><i>database.</i><b>wal_checkpoint(RESTART);</b><br> <b>PRAGMA </b><i>database.</i><b>wal_checkpoint(TRUNCATE);</b> </p> <p>If the <a href="wal.html">write-ahead log</a> is enabled (via the <a href="pragma.html#pragma_journal_mode">journal_mode pragma</a>), this pragma causes a <a href="wal.html#ckpt">checkpoint</a> operation to run on database <i>database</i>, or on all attached databases if <i>database</i> is omitted. If <a href="wal.html">write-ahead log</a> mode is disabled, this pragma is a harmless no-op.</p> <p>Invoking this pragma without an argument is equivalent to calling the <a href="c3ref/wal_checkpoint.html">sqlite3_wal_checkpoint()</a> C interface.</p> Invoking this pragma with an argument is equivalent to calling the <a href="c3ref/wal_checkpoint_v2.html">sqlite3_wal_checkpoint_v2()</a> C interface with a <a href="c3ref/c_checkpoint_full.html">3rd parameter</a> corresponding to the argument: <dl> <dt>PASSIVE<dd> Checkpoint as many frames as possible without waiting for any database readers or writers to finish. Sync the db file if all frames in the log are checkpointed. This mode is the same as calling the <a href="c3ref/wal_checkpoint.html">sqlite3_wal_checkpoint()</a> C interface. The <a href="c3ref/busy_handler.html">busy-handler callback</a> is never invoked in this mode. <dt>FULL<dd> This mode blocks (invokes the <a href="c3ref/busy_handler.html">busy-handler callback</a>) until there is no database writer and all readers are reading from the most recent database snapshot. It then checkpoints all frames in the log file and syncs the database file. FULL blocks concurrent writers while it is running, but readers can proceed. <dt>RESTART<dd> This mode works the same way as FULL with the addition that after checkpointing the log file it blocks (calls the <a href="c3ref/busy_handler.html">busy-handler callback</a>) until all readers are finished with the log file. This ensures that the next client to write to the database file restarts the log file from the beginning. RESTART blocks concurrent writers while it is running, but allowed readers to proceed. <dt>TRUNCATE<dd> This mode works the same way as RESTART with the addition that the WAL file is truncated to zero bytes upon successful completion. </dl> <p>The wal_checkpoint pragma returns a single row with three integer columns. The first column is usually 0 but will be 1 if a RESTART or FULL or TRUNCATE checkpoint was blocked from completing, for example because another thread or process was actively using the database. In other words, the first column is 0 if the equivalent call to <a href="c3ref/wal_checkpoint_v2.html">sqlite3_wal_checkpoint_v2()</a> would have returned <a href="rescode.html#ok">SQLITE_OK</a> or 1 if the equivalent call would have returned <a href="rescode.html#busy">SQLITE_BUSY</a>. The second column is the number of modified pages that have been written to the write-ahead log file. The third column is the number of pages in the write-ahead log file |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/alter-table-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>alter-table-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>alter-table-stmt</h1> <blockquote> <img alt="syntax diagram alter-table-stmt" src="../images/syntax/alter-table-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> References: <a href='./column-def.html'>column-def</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/analyze-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>analyze-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>analyze-stmt</h1> <blockquote> <img alt="syntax diagram analyze-stmt" src="../images/syntax/analyze-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_analyze.html'>lang_analyze.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/attach-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>attach-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>attach-stmt</h1> <blockquote> <img alt="syntax diagram attach-stmt" src="../images/syntax/attach-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> References: <a href='./expr.html'>expr</a><br></br> See also: <a href='../lang_attach.html'>lang_attach.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/begin-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>begin-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>begin-stmt</h1> <blockquote> <img alt="syntax diagram begin-stmt" src="../images/syntax/begin-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_transaction.html'>lang_transaction.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/column-constraint.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>column-constraint</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>column-constraint</h1> <blockquote> <img alt="syntax diagram column-constraint" src="../images/syntax/column-constraint.gif"></img><br> Used by: <a href='./column-def.html'>column-def</a><br></br> References: <a href='./conflict-clause.html'>conflict-clause</a> <a href='./expr.html'>expr</a> <a href='./foreign-key-clause.html'>foreign-key-clause</a> <a href='./literal-value.html'>literal-value</a> <a href='./signed-number.html'>signed-number</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/column-def.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>column-def</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>column-def</h1> <blockquote> <img alt="syntax diagram column-def" src="../images/syntax/column-def.gif"></img><br> Used by: <a href='./alter-table-stmt.html'>alter-table-stmt</a> <a href='./create-table-stmt.html'>create-table-stmt</a><br></br> References: <a href='./column-constraint.html'>column-constraint</a> <a href='./type-name.html'>type-name</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/comment-syntax.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>comment-syntax</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 | </div> </table> <div class=startsearch></div> <h1 align='center'>comment-syntax</h1> <blockquote> <img alt="syntax diagram comment-syntax" src="../images/syntax/comment-syntax.gif"></img><br> <br></br> See also: <a href='../lang_comment.html'>lang_comment.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/commit-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>commit-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>commit-stmt</h1> <blockquote> <img alt="syntax diagram commit-stmt" src="../images/syntax/commit-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_transaction.html'>lang_transaction.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/common-table-expression.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>common-table-expression</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>common-table-expression</h1> <blockquote> <img alt="syntax diagram common-table-expression" src="../images/syntax/common-table-expression.gif"></img><br> Used by: <a href='./compound-select-stmt.html'>compound-select-stmt</a> <a href='./factored-select-stmt.html'>factored-select-stmt</a> <a href='./select-stmt.html'>select-stmt</a> <a href='./simple-select-stmt.html'>simple-select-stmt</a><br></br> References: <a href='./select-stmt.html'>select-stmt</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/compound-operator.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>compound-operator</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>compound-operator</h1> <blockquote> <img alt="syntax diagram compound-operator" src="../images/syntax/compound-operator.gif"></img><br> Used by: <a href='./factored-select-stmt.html'>factored-select-stmt</a> <a href='./select-stmt.html'>select-stmt</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/compound-select-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>compound-select-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>compound-select-stmt</h1> <blockquote> <img alt="syntax diagram compound-select-stmt" src="../images/syntax/compound-select-stmt.gif"></img><br> <br></br> References: <a href='./common-table-expression.html'>common-table-expression</a> <a href='./expr.html'>expr</a> <a href='./ordering-term.html'>ordering-term</a> <a href='./select-core.html'>select-core</a><br></br> See also: <a href='../lang_select.html'>lang_select.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/conflict-clause.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>conflict-clause</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>conflict-clause</h1> <blockquote> <img alt="syntax diagram conflict-clause" src="../images/syntax/conflict-clause.gif"></img><br> Used by: <a href='./column-constraint.html'>column-constraint</a> <a href='./table-constraint.html'>table-constraint</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_conflict.html'>lang_conflict.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/create-index-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>create-index-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>create-index-stmt</h1> <blockquote> <img alt="syntax diagram create-index-stmt" src="../images/syntax/create-index-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> References: <a href='./expr.html'>expr</a> <a href='./indexed-column.html'>indexed-column</a><br></br> See also: <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/create-table-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>create-table-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>create-table-stmt</h1> <blockquote> <img alt="syntax diagram create-table-stmt" src="../images/syntax/create-table-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> References: <a href='./column-def.html'>column-def</a> <a href='./select-stmt.html'>select-stmt</a> <a href='./table-constraint.html'>table-constraint</a><br></br> See also: <a href='../lang_createtable.html'>lang_createtable.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/create-trigger-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>create-trigger-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>create-trigger-stmt</h1> <blockquote> <img alt="syntax diagram create-trigger-stmt" src="../images/syntax/create-trigger-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> References: <a href='./delete-stmt.html'>delete-stmt</a> <a href='./expr.html'>expr</a> <a href='./insert-stmt.html'>insert-stmt</a> <a href='./select-stmt.html'>select-stmt</a> <a href='./update-stmt.html'>update-stmt</a><br></br> See also: <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/create-view-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>create-view-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>create-view-stmt</h1> <blockquote> <img alt="syntax diagram create-view-stmt" src="../images/syntax/create-view-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> References: <a href='./select-stmt.html'>select-stmt</a><br></br> See also: <a href='../lang_createview.html'>lang_createview.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/create-virtual-table-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>create-virtual-table-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>create-virtual-table-stmt</h1> <blockquote> <img alt="syntax diagram create-virtual-table-stmt" src="../images/syntax/create-virtual-table-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_createvtab.html'>lang_createvtab.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/cte-table-name.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>cte-table-name</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>cte-table-name</h1> <blockquote> <img alt="syntax diagram cte-table-name" src="../images/syntax/cte-table-name.gif"></img><br> Used by: <a href='./recursive-cte.html'>recursive-cte</a> <a href='./with-clause.html'>with-clause</a><br></br> See also: <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/delete-stmt-limited.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>delete-stmt-limited</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>delete-stmt-limited</h1> <blockquote> <img alt="syntax diagram delete-stmt-limited" src="../images/syntax/delete-stmt-limited.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> References: <a href='./expr.html'>expr</a> <a href='./ordering-term.html'>ordering-term</a> <a href='./qualified-table-name.html'>qualified-table-name</a> <a href='./with-clause.html'>with-clause</a><br></br> See also: <a href='../lang_delete.html'>lang_delete.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/delete-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>delete-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>delete-stmt</h1> <blockquote> <img alt="syntax diagram delete-stmt" src="../images/syntax/delete-stmt.gif"></img><br> Used by: <a href='./create-trigger-stmt.html'>create-trigger-stmt</a> <a href='./sql-stmt.html'>sql-stmt</a><br></br> References: <a href='./expr.html'>expr</a> <a href='./qualified-table-name.html'>qualified-table-name</a> <a href='./with-clause.html'>with-clause</a><br></br> See also: <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_delete.html'>lang_delete.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/detach-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>detach-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>detach-stmt</h1> <blockquote> <img alt="syntax diagram detach-stmt" src="../images/syntax/detach-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_detach.html'>lang_detach.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/drop-index-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>drop-index-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>drop-index-stmt</h1> <blockquote> <img alt="syntax diagram drop-index-stmt" src="../images/syntax/drop-index-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_dropindex.html'>lang_dropindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/drop-table-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>drop-table-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>drop-table-stmt</h1> <blockquote> <img alt="syntax diagram drop-table-stmt" src="../images/syntax/drop-table-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_droptable.html'>lang_droptable.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/drop-trigger-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>drop-trigger-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>drop-trigger-stmt</h1> <blockquote> <img alt="syntax diagram drop-trigger-stmt" src="../images/syntax/drop-trigger-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_droptrigger.html'>lang_droptrigger.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/drop-view-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>drop-view-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>drop-view-stmt</h1> <blockquote> <img alt="syntax diagram drop-view-stmt" src="../images/syntax/drop-view-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_dropview.html'>lang_dropview.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/expr.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>expr</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>expr</h1> <blockquote> <img alt="syntax diagram expr" src="../images/syntax/expr.gif"></img><br> Used by: <a href='./attach-stmt.html'>attach-stmt</a> <a href='./column-constraint.html'>column-constraint</a> <a href='./compound-select-stmt.html'>compound-select-stmt</a> <a href='./create-index-stmt.html'>create-index-stmt</a> <a href='./create-trigger-stmt.html'>create-trigger-stmt</a> <a href='./delete-stmt.html'>delete-stmt</a> <a href='./delete-stmt-limited.html'>delete-stmt-limited</a> <a href='./factored-select-stmt.html'>factored-select-stmt</a> <a href='./insert-stmt.html'>insert-stmt</a> <a href='./join-constraint.html'>join-constraint</a> <a href='./ordering-term.html'>ordering-term</a> <a href='./result-column.html'>result-column</a> <a href='./select-core.html'>select-core</a> <a href='./select-stmt.html'>select-stmt</a> <a href='./simple-select-stmt.html'>simple-select-stmt</a> <a href='./table-constraint.html'>table-constraint</a> <a href='./update-stmt.html'>update-stmt</a> <a href='./update-stmt-limited.html'>update-stmt-limited</a><br></br> References: <a href='./literal-value.html'>literal-value</a> <a href='./raise-function.html'>raise-function</a> <a href='./select-stmt.html'>select-stmt</a> <a href='./type-name.html'>type-name</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/factored-select-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>factored-select-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>factored-select-stmt</h1> <blockquote> <img alt="syntax diagram factored-select-stmt" src="../images/syntax/factored-select-stmt.gif"></img><br> <br></br> References: <a href='./common-table-expression.html'>common-table-expression</a> <a href='./compound-operator.html'>compound-operator</a> <a href='./expr.html'>expr</a> <a href='./ordering-term.html'>ordering-term</a> <a href='./select-core.html'>select-core</a><br></br> See also: <a href='../lang_select.html'>lang_select.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/foreign-key-clause.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>foreign-key-clause</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>foreign-key-clause</h1> <blockquote> <img alt="syntax diagram foreign-key-clause" src="../images/syntax/foreign-key-clause.gif"></img><br> Used by: <a href='./column-constraint.html'>column-constraint</a> <a href='./table-constraint.html'>table-constraint</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/indexed-column.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>indexed-column</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>indexed-column</h1> <blockquote> <img alt="syntax diagram indexed-column" src="../images/syntax/indexed-column.gif"></img><br> Used by: <a href='./create-index-stmt.html'>create-index-stmt</a> <a href='./table-constraint.html'>table-constraint</a><br></br> See also: <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/insert-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>insert-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>insert-stmt</h1> <blockquote> <img alt="syntax diagram insert-stmt" src="../images/syntax/insert-stmt.gif"></img><br> Used by: <a href='./create-trigger-stmt.html'>create-trigger-stmt</a> <a href='./sql-stmt.html'>sql-stmt</a><br></br> References: <a href='./expr.html'>expr</a> <a href='./select-stmt.html'>select-stmt</a> <a href='./with-clause.html'>with-clause</a><br></br> See also: <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_insert.html'>lang_insert.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/join-clause.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>join-clause</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>join-clause</h1> <blockquote> <img alt="syntax diagram join-clause" src="../images/syntax/join-clause.gif"></img><br> Used by: <a href='./select-core.html'>select-core</a> <a href='./select-stmt.html'>select-stmt</a> <a href='./table-or-subquery.html'>table-or-subquery</a><br></br> References: <a href='./join-constraint.html'>join-constraint</a> <a href='./join-operator.html'>join-operator</a> <a href='./table-or-subquery.html'>table-or-subquery</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/join-constraint.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>join-constraint</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>join-constraint</h1> <blockquote> <img alt="syntax diagram join-constraint" src="../images/syntax/join-constraint.gif"></img><br> Used by: <a href='./join-clause.html'>join-clause</a><br></br> References: <a href='./expr.html'>expr</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/join-operator.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>join-operator</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>join-operator</h1> <blockquote> <img alt="syntax diagram join-operator" src="../images/syntax/join-operator.gif"></img><br> Used by: <a href='./join-clause.html'>join-clause</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/literal-value.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>literal-value</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>literal-value</h1> <blockquote> <img alt="syntax diagram literal-value" src="../images/syntax/literal-value.gif"></img><br> Used by: <a href='./column-constraint.html'>column-constraint</a> <a href='./expr.html'>expr</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/numeric-literal.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>numeric-literal</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 | </div> </table> <div class=startsearch></div> <h1 align='center'>numeric-literal</h1> <blockquote> <img alt="syntax diagram numeric-literal" src="../images/syntax/numeric-literal.gif"></img><br> <br></br> See also: <a href='../lang_expr.html'>lang_expr.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/ordering-term.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>ordering-term</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>ordering-term</h1> <blockquote> <img alt="syntax diagram ordering-term" src="../images/syntax/ordering-term.gif"></img><br> Used by: <a href='./compound-select-stmt.html'>compound-select-stmt</a> <a href='./delete-stmt-limited.html'>delete-stmt-limited</a> <a href='./factored-select-stmt.html'>factored-select-stmt</a> <a href='./select-stmt.html'>select-stmt</a> <a href='./simple-select-stmt.html'>simple-select-stmt</a> <a href='./update-stmt-limited.html'>update-stmt-limited</a><br></br> References: <a href='./expr.html'>expr</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/pragma-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>pragma-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>pragma-stmt</h1> <blockquote> <img alt="syntax diagram pragma-stmt" src="../images/syntax/pragma-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> References: <a href='./pragma-value.html'>pragma-value</a><br></br> See also: <a href='../pragma.html'>pragma.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/pragma-value.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>pragma-value</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>pragma-value</h1> <blockquote> <img alt="syntax diagram pragma-value" src="../images/syntax/pragma-value.gif"></img><br> Used by: <a href='./pragma-stmt.html'>pragma-stmt</a><br></br> References: <a href='./signed-number.html'>signed-number</a><br></br> See also: <a href='../pragma.html'>pragma.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/qualified-table-name.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>qualified-table-name</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>qualified-table-name</h1> <blockquote> <img alt="syntax diagram qualified-table-name" src="../images/syntax/qualified-table-name.gif"></img><br> Used by: <a href='./delete-stmt.html'>delete-stmt</a> <a href='./delete-stmt-limited.html'>delete-stmt-limited</a> <a href='./update-stmt.html'>update-stmt</a> <a href='./update-stmt-limited.html'>update-stmt-limited</a><br></br> See also: <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_indexedby.html'>lang_indexedby.html</a> <a href='../lang_update.html'>lang_update.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/raise-function.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>raise-function</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>raise-function</h1> <blockquote> <img alt="syntax diagram raise-function" src="../images/syntax/raise-function.gif"></img><br> Used by: <a href='./expr.html'>expr</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/recursive-cte.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>recursive-cte</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>recursive-cte</h1> <blockquote> <img alt="syntax diagram recursive-cte" src="../images/syntax/recursive-cte.gif"></img><br> <br></br> References: <a href='./cte-table-name.html'>cte-table-name</a><br></br> See also: <a href='../lang_with.html'>lang_with.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/reindex-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>reindex-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>reindex-stmt</h1> <blockquote> <img alt="syntax diagram reindex-stmt" src="../images/syntax/reindex-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_reindex.html'>lang_reindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/release-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>release-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>release-stmt</h1> <blockquote> <img alt="syntax diagram release-stmt" src="../images/syntax/release-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_savepoint.html'>lang_savepoint.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/result-column.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>result-column</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>result-column</h1> <blockquote> <img alt="syntax diagram result-column" src="../images/syntax/result-column.gif"></img><br> Used by: <a href='./select-core.html'>select-core</a> <a href='./select-stmt.html'>select-stmt</a><br></br> References: <a href='./expr.html'>expr</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/rollback-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>rollback-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>rollback-stmt</h1> <blockquote> <img alt="syntax diagram rollback-stmt" src="../images/syntax/rollback-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_savepoint.html'>lang_savepoint.html</a> <a href='../lang_transaction.html'>lang_transaction.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/savepoint-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>savepoint-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>savepoint-stmt</h1> <blockquote> <img alt="syntax diagram savepoint-stmt" src="../images/syntax/savepoint-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_savepoint.html'>lang_savepoint.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/select-core.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>select-core</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>select-core</h1> <blockquote> <img alt="syntax diagram select-core" src="../images/syntax/select-core.gif"></img><br> Used by: <a href='./compound-select-stmt.html'>compound-select-stmt</a> <a href='./factored-select-stmt.html'>factored-select-stmt</a> <a href='./simple-select-stmt.html'>simple-select-stmt</a><br></br> References: <a href='./expr.html'>expr</a> <a href='./join-clause.html'>join-clause</a> <a href='./result-column.html'>result-column</a> <a href='./table-or-subquery.html'>table-or-subquery</a><br></br> See also: <a href='../lang_select.html'>lang_select.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/select-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>select-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>select-stmt</h1> <blockquote> <img alt="syntax diagram select-stmt" src="../images/syntax/select-stmt.gif"></img><br> Used by: <a href='./common-table-expression.html'>common-table-expression</a> <a href='./create-table-stmt.html'>create-table-stmt</a> <a href='./create-trigger-stmt.html'>create-trigger-stmt</a> <a href='./create-view-stmt.html'>create-view-stmt</a> <a href='./expr.html'>expr</a> <a href='./insert-stmt.html'>insert-stmt</a> <a href='./sql-stmt.html'>sql-stmt</a> <a href='./table-or-subquery.html'>table-or-subquery</a> <a href='./with-clause.html'>with-clause</a><br></br> References: <a href='./common-table-expression.html'>common-table-expression</a> <a href='./compound-operator.html'>compound-operator</a> <a href='./expr.html'>expr</a> <a href='./join-clause.html'>join-clause</a> <a href='./ordering-term.html'>ordering-term</a> <a href='./result-column.html'>result-column</a> <a href='./table-or-subquery.html'>table-or-subquery</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/signed-number.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>signed-number</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>signed-number</h1> <blockquote> <img alt="syntax diagram signed-number" src="../images/syntax/signed-number.gif"></img><br> Used by: <a href='./column-constraint.html'>column-constraint</a> <a href='./pragma-value.html'>pragma-value</a> <a href='./type-name.html'>type-name</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> <a href='../pragma.html'>pragma.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/simple-select-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>simple-select-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>simple-select-stmt</h1> <blockquote> <img alt="syntax diagram simple-select-stmt" src="../images/syntax/simple-select-stmt.gif"></img><br> <br></br> References: <a href='./common-table-expression.html'>common-table-expression</a> <a href='./expr.html'>expr</a> <a href='./ordering-term.html'>ordering-term</a> <a href='./select-core.html'>select-core</a><br></br> See also: <a href='../lang_select.html'>lang_select.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/sql-stmt-list.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>sql-stmt-list</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>sql-stmt-list</h1> <blockquote> <img alt="syntax diagram sql-stmt-list" src="../images/syntax/sql-stmt-list.gif"></img><br> <br></br> References: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang.html'>lang.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/sql-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>sql-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>sql-stmt</h1> <blockquote> <img alt="syntax diagram sql-stmt" src="../images/syntax/sql-stmt.gif"></img><br> Used by: <a href='./sql-stmt-list.html'>sql-stmt-list</a><br></br> References: <a href='./alter-table-stmt.html'>alter-table-stmt</a> <a href='./analyze-stmt.html'>analyze-stmt</a> <a href='./attach-stmt.html'>attach-stmt</a> <a href='./begin-stmt.html'>begin-stmt</a> <a href='./commit-stmt.html'>commit-stmt</a> <a href='./create-index-stmt.html'>create-index-stmt</a> <a href='./create-table-stmt.html'>create-table-stmt</a> <a href='./create-trigger-stmt.html'>create-trigger-stmt</a> <a href='./create-view-stmt.html'>create-view-stmt</a> <a href='./create-virtual-table-stmt.html'>create-virtual-table-stmt</a> <a href='./delete-stmt.html'>delete-stmt</a> <a href='./delete-stmt-limited.html'>delete-stmt-limited</a> <a href='./detach-stmt.html'>detach-stmt</a> <a href='./drop-index-stmt.html'>drop-index-stmt</a> <a href='./drop-table-stmt.html'>drop-table-stmt</a> <a href='./drop-trigger-stmt.html'>drop-trigger-stmt</a> <a href='./drop-view-stmt.html'>drop-view-stmt</a> <a href='./insert-stmt.html'>insert-stmt</a> <a href='./pragma-stmt.html'>pragma-stmt</a> <a href='./reindex-stmt.html'>reindex-stmt</a> <a href='./release-stmt.html'>release-stmt</a> <a href='./rollback-stmt.html'>rollback-stmt</a> <a href='./savepoint-stmt.html'>savepoint-stmt</a> <a href='./select-stmt.html'>select-stmt</a> <a href='./update-stmt.html'>update-stmt</a> <a href='./update-stmt-limited.html'>update-stmt-limited</a> <a href='./vacuum-stmt.html'>vacuum-stmt</a><br></br> See also: <a href='../lang.html'>lang.html</a> <a href='../lang_explain.html'>lang_explain.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/table-constraint.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>table-constraint</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>table-constraint</h1> <blockquote> <img alt="syntax diagram table-constraint" src="../images/syntax/table-constraint.gif"></img><br> Used by: <a href='./create-table-stmt.html'>create-table-stmt</a><br></br> References: <a href='./conflict-clause.html'>conflict-clause</a> <a href='./expr.html'>expr</a> <a href='./foreign-key-clause.html'>foreign-key-clause</a> <a href='./indexed-column.html'>indexed-column</a><br></br> See also: <a href='../lang_createtable.html'>lang_createtable.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/table-or-subquery.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>table-or-subquery</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>table-or-subquery</h1> <blockquote> <img alt="syntax diagram table-or-subquery" src="../images/syntax/table-or-subquery.gif"></img><br> Used by: <a href='./join-clause.html'>join-clause</a> <a href='./select-core.html'>select-core</a> <a href='./select-stmt.html'>select-stmt</a><br></br> References: <a href='./join-clause.html'>join-clause</a> <a href='./select-stmt.html'>select-stmt</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/type-name.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>type-name</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>type-name</h1> <blockquote> <img alt="syntax diagram type-name" src="../images/syntax/type-name.gif"></img><br> Used by: <a href='./column-def.html'>column-def</a> <a href='./expr.html'>expr</a><br></br> References: <a href='./signed-number.html'>signed-number</a><br></br> See also: <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_attach.html'>lang_attach.html</a> <a href='../lang_createindex.html'>lang_createindex.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a> <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_createview.html'>lang_createview.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_expr.html'>lang_expr.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_select.html'>lang_select.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> <a href='../partialindex.html'>partialindex.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/update-stmt-limited.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>update-stmt-limited</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>update-stmt-limited</h1> <blockquote> <img alt="syntax diagram update-stmt-limited" src="../images/syntax/update-stmt-limited.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> References: <a href='./expr.html'>expr</a> <a href='./ordering-term.html'>ordering-term</a> <a href='./qualified-table-name.html'>qualified-table-name</a> <a href='./with-clause.html'>with-clause</a><br></br> See also: <a href='../lang_update.html'>lang_update.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/update-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>update-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>update-stmt</h1> <blockquote> <img alt="syntax diagram update-stmt" src="../images/syntax/update-stmt.gif"></img><br> Used by: <a href='./create-trigger-stmt.html'>create-trigger-stmt</a> <a href='./sql-stmt.html'>sql-stmt</a><br></br> References: <a href='./expr.html'>expr</a> <a href='./qualified-table-name.html'>qualified-table-name</a> <a href='./with-clause.html'>with-clause</a><br></br> See also: <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_update.html'>lang_update.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/vacuum-stmt.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>vacuum-stmt</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 | </div> </table> <div class=startsearch></div> <h1 align='center'>vacuum-stmt</h1> <blockquote> <img alt="syntax diagram vacuum-stmt" src="../images/syntax/vacuum-stmt.gif"></img><br> Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> See also: <a href='../lang_vacuum.html'>lang_vacuum.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntax/with-clause.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </div> </table> <div class=startsearch></div> <h1 align='center'>with-clause</h1> <blockquote> | | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 | </div> </table> <div class=startsearch></div> <h1 align='center'>with-clause</h1> <blockquote> <img alt="syntax diagram with-clause" src="../images/syntax/with-clause.gif"></img><br> Used by: <a href='./delete-stmt.html'>delete-stmt</a> <a href='./delete-stmt-limited.html'>delete-stmt-limited</a> <a href='./insert-stmt.html'>insert-stmt</a> <a href='./update-stmt.html'>update-stmt</a> <a href='./update-stmt-limited.html'>update-stmt-limited</a><br></br> References: <a href='./cte-table-name.html'>cte-table-name</a> <a href='./select-stmt.html'>select-stmt</a><br></br> See also: <a href='../lang_createtrigger.html'>lang_createtrigger.html</a> <a href='../lang_delete.html'>lang_delete.html</a> <a href='../lang_insert.html'>lang_insert.html</a> <a href='../lang_update.html'>lang_update.html</a> <a href='../lang_with.html'>lang_with.html</a> </blockquote> |
Changes to Doc/Extra/Core/syntaxdiagrams.html.
︙ | ︙ | |||
56 57 58 59 60 61 62 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | .fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top} .fancy #toc a { color: darkblue ; text-decoration: none } .fancy .todo { color: #AA3333 ; font-style : italic } .fancy .todo:before { content: 'TODO:' } .fancy p.todo { border: solid #AA3333 1px; padding: 1ex } .fancy img { display:block; } .fancy :link:hover, .fancy :visited:hover { background: wheat } .fancy p,.fancy ul,.fancy ol,.fancy dl { margin: 1em 5ex } .fancy li p { margin: 1em 0 } /* End of "fancyformat" specific rules. */ </style> </head> <body> |
︙ | ︙ | |||
129 130 131 132 133 134 135 | <div class=startsearch></div> <h1 align=center>Syntax Diagrams For SQLite</h1> | | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | < | 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 | <div class=startsearch></div> <h1 align=center>Syntax Diagrams For SQLite</h1> <a name="sql-stmt-list"></a><h4>sql-stmt-list:</h4><blockquote> <img src="images/syntax/sql-stmt-list.gif"></img><br></br><br></br> References: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang.html">lang.html</a> </blockquote> <a name="sql-stmt"></a><h4>sql-stmt:</h4><blockquote> <img src="images/syntax/sql-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt-list">sql-stmt-list</a><br></br> References: <a href="#alter-table-stmt">alter-table-stmt</a> <a href="#analyze-stmt">analyze-stmt</a> <a href="#attach-stmt">attach-stmt</a> <a href="#begin-stmt">begin-stmt</a> <a href="#commit-stmt">commit-stmt</a> <a href="#create-index-stmt">create-index-stmt</a> <a href="#create-table-stmt">create-table-stmt</a> <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#create-view-stmt">create-view-stmt</a> <a href="#create-virtual-table-stmt">create-virtual-table-stmt</a> <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#detach-stmt">detach-stmt</a> <a href="#drop-index-stmt">drop-index-stmt</a> <a href="#drop-table-stmt">drop-table-stmt</a> <a href="#drop-trigger-stmt">drop-trigger-stmt</a> <a href="#drop-view-stmt">drop-view-stmt</a> <a href="#insert-stmt">insert-stmt</a> <a href="#pragma-stmt">pragma-stmt</a> <a href="#reindex-stmt">reindex-stmt</a> <a href="#release-stmt">release-stmt</a> <a href="#rollback-stmt">rollback-stmt</a> <a href="#savepoint-stmt">savepoint-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a> <a href="#vacuum-stmt">vacuum-stmt</a><br></br> See also: <a href="lang.html">lang.html</a> <a href="lang_explain.html">lang_explain.html</a> </blockquote> <a name="alter-table-stmt"></a><h4>alter-table-stmt:</h4><blockquote> <img src="images/syntax/alter-table-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> References: <a href="#column-def">column-def</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> </blockquote> <a name="analyze-stmt"></a><h4>analyze-stmt:</h4><blockquote> <img src="images/syntax/analyze-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_analyze.html">lang_analyze.html</a> </blockquote> <a name="attach-stmt"></a><h4>attach-stmt:</h4><blockquote> <img src="images/syntax/attach-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> References: <a href="#expr">expr</a><br></br> See also: <a href="lang_attach.html">lang_attach.html</a> </blockquote> <a name="begin-stmt"></a><h4>begin-stmt:</h4><blockquote> <img src="images/syntax/begin-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_transaction.html">lang_transaction.html</a> </blockquote> <a name="commit-stmt"></a><h4>commit-stmt:</h4><blockquote> <img src="images/syntax/commit-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_transaction.html">lang_transaction.html</a> </blockquote> <a name="rollback-stmt"></a><h4>rollback-stmt:</h4><blockquote> <img src="images/syntax/rollback-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_savepoint.html">lang_savepoint.html</a> <a href="lang_transaction.html">lang_transaction.html</a> </blockquote> <a name="savepoint-stmt"></a><h4>savepoint-stmt:</h4><blockquote> <img src="images/syntax/savepoint-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_savepoint.html">lang_savepoint.html</a> </blockquote> <a name="release-stmt"></a><h4>release-stmt:</h4><blockquote> <img src="images/syntax/release-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_savepoint.html">lang_savepoint.html</a> </blockquote> <a name="create-index-stmt"></a><h4>create-index-stmt:</h4><blockquote> <img src="images/syntax/create-index-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> References: <a href="#expr">expr</a> <a href="#indexed-column">indexed-column</a><br></br> See also: <a href="lang_createindex.html">lang_createindex.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="indexed-column"></a><h4>indexed-column:</h4><blockquote> <img src="images/syntax/indexed-column.gif"></img><br></br> Used by: <a href="#create-index-stmt">create-index-stmt</a> <a href="#table-constraint">table-constraint</a><br></br> See also: <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="create-table-stmt"></a><h4>create-table-stmt:</h4><blockquote> <img src="images/syntax/create-table-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> References: <a href="#column-def">column-def</a> <a href="#select-stmt">select-stmt</a> <a href="#table-constraint">table-constraint</a><br></br> See also: <a href="lang_createtable.html">lang_createtable.html</a> </blockquote> <a name="column-def"></a><h4>column-def:</h4><blockquote> <img src="images/syntax/column-def.gif"></img><br></br> Used by: <a href="#alter-table-stmt">alter-table-stmt</a> <a href="#create-table-stmt">create-table-stmt</a><br></br> References: <a href="#column-constraint">column-constraint</a> <a href="#type-name">type-name</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#tablecoldef">lang_createtable.html#tablecoldef</a> </blockquote> <a name="type-name"></a><h4>type-name:</h4><blockquote> <img src="images/syntax/type-name.gif"></img><br></br> Used by: <a href="#column-def">column-def</a> <a href="#expr">expr</a><br></br> References: <a href="#signed-number">signed-number</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="column-constraint"></a><h4>column-constraint:</h4><blockquote> <img src="images/syntax/column-constraint.gif"></img><br></br> Used by: <a href="#column-def">column-def</a><br></br> References: <a href="#conflict-clause">conflict-clause</a> <a href="#expr">expr</a> <a href="#foreign-key-clause">foreign-key-clause</a> <a href="#literal-value">literal-value</a> <a href="#signed-number">signed-number</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#tablecoldef">lang_createtable.html#tablecoldef</a> </blockquote> <a name="signed-number"></a><h4>signed-number:</h4><blockquote> <img src="images/syntax/signed-number.gif"></img><br></br> Used by: <a href="#column-constraint">column-constraint</a> <a href="#pragma-value">pragma-value</a> <a href="#type-name">type-name</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> <a href="pragma.html#syntax">pragma.html#syntax</a> </blockquote> <a name="table-constraint"></a><h4>table-constraint:</h4><blockquote> <img src="images/syntax/table-constraint.gif"></img><br></br> Used by: <a href="#create-table-stmt">create-table-stmt</a><br></br> References: <a href="#conflict-clause">conflict-clause</a> <a href="#expr">expr</a> <a href="#foreign-key-clause">foreign-key-clause</a> <a href="#indexed-column">indexed-column</a><br></br> See also: <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#primkeyconst">lang_createtable.html#primkeyconst</a> <a href="lang_createtable.html#tablecoldef">lang_createtable.html#tablecoldef</a> </blockquote> <a name="foreign-key-clause"></a><h4>foreign-key-clause:</h4><blockquote> <img src="images/syntax/foreign-key-clause.gif"></img><br></br> Used by: <a href="#column-constraint">column-constraint</a> <a href="#table-constraint">table-constraint</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_createtable.html">lang_createtable.html</a> </blockquote> <a name="conflict-clause"></a><h4>conflict-clause:</h4><blockquote> <img src="images/syntax/conflict-clause.gif"></img><br></br> Used by: <a href="#column-constraint">column-constraint</a> <a href="#table-constraint">table-constraint</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_conflict.html">lang_conflict.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#notnullconst">lang_createtable.html#notnullconst</a> </blockquote> <a name="create-trigger-stmt"></a><h4>create-trigger-stmt:</h4><blockquote> <img src="images/syntax/create-trigger-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> References: <a href="#delete-stmt">delete-stmt</a> <a href="#expr">expr</a> <a href="#insert-stmt">insert-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#update-stmt">update-stmt</a><br></br> See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> </blockquote> <a name="create-view-stmt"></a><h4>create-view-stmt:</h4><blockquote> <img src="images/syntax/create-view-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> References: <a href="#select-stmt">select-stmt</a><br></br> See also: <a href="lang_createview.html">lang_createview.html</a> </blockquote> <a name="create-virtual-table-stmt"></a><h4>create-virtual-table-stmt:</h4><blockquote> <img src="images/syntax/create-virtual-table-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_createvtab.html">lang_createvtab.html</a> </blockquote> <a name="with-clause"></a><h4>with-clause:</h4><blockquote> <img src="images/syntax/with-clause.gif"></img><br></br> Used by: <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#insert-stmt">insert-stmt</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br> References: <a href="#cte-table-name">cte-table-name</a> <a href="#select-stmt">select-stmt</a><br></br> See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> </blockquote> <a name="cte-table-name"></a><h4>cte-table-name:</h4><blockquote> <img src="images/syntax/cte-table-name.gif"></img><br></br> Used by: <a href="#recursive-cte">recursive-cte</a> <a href="#with-clause">with-clause</a><br></br> See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="lang_with.html#recursivecte">lang_with.html#recursivecte</a> </blockquote> <a name="recursive-cte"></a><h4>recursive-cte:</h4><blockquote> <img src="images/syntax/recursive-cte.gif"></img><br></br><br></br> References: <a href="#cte-table-name">cte-table-name</a><br></br> See also: <a href="lang_with.html#recursivecte">lang_with.html#recursivecte</a> </blockquote> <a name="common-table-expression"></a><h4>common-table-expression:</h4><blockquote> <img src="images/syntax/common-table-expression.gif"></img><br></br> Used by: <a href="#compound-select-stmt">compound-select-stmt</a> <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#simple-select-stmt">simple-select-stmt</a><br></br> References: <a href="#select-stmt">select-stmt</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="delete-stmt"></a><h4>delete-stmt:</h4><blockquote> <img src="images/syntax/delete-stmt.gif"></img><br></br> Used by: <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#sql-stmt">sql-stmt</a><br></br> References: <a href="#expr">expr</a> <a href="#qualified-table-name">qualified-table-name</a> <a href="#with-clause">with-clause</a><br></br> See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_delete.html">lang_delete.html</a> </blockquote> <a name="delete-stmt-limited"></a><h4>delete-stmt-limited:</h4><blockquote> <img src="images/syntax/delete-stmt-limited.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> References: <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#qualified-table-name">qualified-table-name</a> <a href="#with-clause">with-clause</a><br></br> See also: <a href="lang_delete.html">lang_delete.html</a> </blockquote> <a name="detach-stmt"></a><h4>detach-stmt:</h4><blockquote> <img src="images/syntax/detach-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_detach.html">lang_detach.html</a> </blockquote> <a name="drop-index-stmt"></a><h4>drop-index-stmt:</h4><blockquote> <img src="images/syntax/drop-index-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_dropindex.html">lang_dropindex.html</a> </blockquote> <a name="drop-table-stmt"></a><h4>drop-table-stmt:</h4><blockquote> <img src="images/syntax/drop-table-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_droptable.html">lang_droptable.html</a> </blockquote> <a name="drop-trigger-stmt"></a><h4>drop-trigger-stmt:</h4><blockquote> <img src="images/syntax/drop-trigger-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_droptrigger.html">lang_droptrigger.html</a> </blockquote> <a name="drop-view-stmt"></a><h4>drop-view-stmt:</h4><blockquote> <img src="images/syntax/drop-view-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_dropview.html">lang_dropview.html</a> </blockquote> <a name="expr"></a><h4>expr:</h4><blockquote> <img src="images/syntax/expr.gif"></img><br></br> Used by: <a href="#attach-stmt">attach-stmt</a> <a href="#column-constraint">column-constraint</a> <a href="#compound-select-stmt">compound-select-stmt</a> <a href="#create-index-stmt">create-index-stmt</a> <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#insert-stmt">insert-stmt</a> <a href="#join-constraint">join-constraint</a> <a href="#ordering-term">ordering-term</a> <a href="#result-column">result-column</a> <a href="#select-core">select-core</a> <a href="#select-stmt">select-stmt</a> <a href="#simple-select-stmt">simple-select-stmt</a> <a href="#table-constraint">table-constraint</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br> References: <a href="#literal-value">literal-value</a> <a href="#raise-function">raise-function</a> <a href="#select-stmt">select-stmt</a> <a href="#type-name">type-name</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="raise-function"></a><h4>raise-function:</h4><blockquote> <img src="images/syntax/raise-function.gif"></img><br></br> Used by: <a href="#expr">expr</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createtrigger.html#raise">lang_createtrigger.html#raise</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="literal-value"></a><h4>literal-value:</h4><blockquote> <img src="images/syntax/literal-value.gif"></img><br></br> Used by: <a href="#column-constraint">column-constraint</a> <a href="#expr">expr</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="numeric-literal"></a><h4>numeric-literal:</h4><blockquote> <img src="images/syntax/numeric-literal.gif"></img><br></br><br></br> See also: <a href="lang_expr.html#litvalue">lang_expr.html#litvalue</a> </blockquote> <a name="insert-stmt"></a><h4>insert-stmt:</h4><blockquote> <img src="images/syntax/insert-stmt.gif"></img><br></br> Used by: <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#sql-stmt">sql-stmt</a><br></br> References: <a href="#expr">expr</a> <a href="#select-stmt">select-stmt</a> <a href="#with-clause">with-clause</a><br></br> See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_insert.html">lang_insert.html</a> </blockquote> <a name="pragma-stmt"></a><h4>pragma-stmt:</h4><blockquote> <img src="images/syntax/pragma-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> References: <a href="#pragma-value">pragma-value</a><br></br> See also: <a href="pragma.html#syntax">pragma.html#syntax</a> </blockquote> <a name="pragma-value"></a><h4>pragma-value:</h4><blockquote> <img src="images/syntax/pragma-value.gif"></img><br></br> Used by: <a href="#pragma-stmt">pragma-stmt</a><br></br> References: <a href="#signed-number">signed-number</a><br></br> See also: <a href="pragma.html#syntax">pragma.html#syntax</a> </blockquote> <a name="reindex-stmt"></a><h4>reindex-stmt:</h4><blockquote> <img src="images/syntax/reindex-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_reindex.html">lang_reindex.html</a> </blockquote> <a name="select-stmt"></a><h4>select-stmt:</h4><blockquote> <img src="images/syntax/select-stmt.gif"></img><br></br> Used by: <a href="#common-table-expression">common-table-expression</a> <a href="#create-table-stmt">create-table-stmt</a> <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#create-view-stmt">create-view-stmt</a> <a href="#expr">expr</a> <a href="#insert-stmt">insert-stmt</a> <a href="#sql-stmt">sql-stmt</a> <a href="#table-or-subquery">table-or-subquery</a> <a href="#with-clause">with-clause</a><br></br> References: <a href="#common-table-expression">common-table-expression</a> <a href="#compound-operator">compound-operator</a> <a href="#expr">expr</a> <a href="#join-clause">join-clause</a> <a href="#ordering-term">ordering-term</a> <a href="#result-column">result-column</a> <a href="#table-or-subquery">table-or-subquery</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="lang_with.html#recursivecte">lang_with.html#recursivecte</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="join-clause"></a><h4>join-clause:</h4><blockquote> <img src="images/syntax/join-clause.gif"></img><br></br> Used by: <a href="#select-core">select-core</a> <a href="#select-stmt">select-stmt</a> <a href="#table-or-subquery">table-or-subquery</a><br></br> References: <a href="#join-constraint">join-constraint</a> <a href="#join-operator">join-operator</a> <a href="#table-or-subquery">table-or-subquery</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="select-core"></a><h4>select-core:</h4><blockquote> <img src="images/syntax/select-core.gif"></img><br></br> Used by: <a href="#compound-select-stmt">compound-select-stmt</a> <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#simple-select-stmt">simple-select-stmt</a><br></br> References: <a href="#expr">expr</a> <a href="#join-clause">join-clause</a> <a href="#result-column">result-column</a> <a href="#table-or-subquery">table-or-subquery</a><br></br> See also: <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> </blockquote> <a name="factored-select-stmt"></a><h4>factored-select-stmt:</h4><blockquote> <img src="images/syntax/factored-select-stmt.gif"></img><br></br><br></br> References: <a href="#common-table-expression">common-table-expression</a> <a href="#compound-operator">compound-operator</a> <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#select-core">select-core</a><br></br> See also: <a href="lang_select.html">lang_select.html</a> </blockquote> <a name="simple-select-stmt"></a><h4>simple-select-stmt:</h4><blockquote> <img src="images/syntax/simple-select-stmt.gif"></img><br></br><br></br> References: <a href="#common-table-expression">common-table-expression</a> <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#select-core">select-core</a><br></br> See also: <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> </blockquote> <a name="compound-select-stmt"></a><h4>compound-select-stmt:</h4><blockquote> <img src="images/syntax/compound-select-stmt.gif"></img><br></br><br></br> References: <a href="#common-table-expression">common-table-expression</a> <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#select-core">select-core</a><br></br> See also: <a href="lang_select.html#compound">lang_select.html#compound</a> </blockquote> <a name="table-or-subquery"></a><h4>table-or-subquery:</h4><blockquote> <img src="images/syntax/table-or-subquery.gif"></img><br></br> Used by: <a href="#join-clause">join-clause</a> <a href="#select-core">select-core</a> <a href="#select-stmt">select-stmt</a><br></br> References: <a href="#join-clause">join-clause</a> <a href="#select-stmt">select-stmt</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="result-column"></a><h4>result-column:</h4><blockquote> <img src="images/syntax/result-column.gif"></img><br></br> Used by: <a href="#select-core">select-core</a> <a href="#select-stmt">select-stmt</a><br></br> References: <a href="#expr">expr</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="join-operator"></a><h4>join-operator:</h4><blockquote> <img src="images/syntax/join-operator.gif"></img><br></br> Used by: <a href="#join-clause">join-clause</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#fromclause">lang_select.html#fromclause</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="join-constraint"></a><h4>join-constraint:</h4><blockquote> <img src="images/syntax/join-constraint.gif"></img><br></br> Used by: <a href="#join-clause">join-clause</a><br></br> References: <a href="#expr">expr</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#fromclause">lang_select.html#fromclause</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="ordering-term"></a><h4>ordering-term:</h4><blockquote> <img src="images/syntax/ordering-term.gif"></img><br></br> Used by: <a href="#compound-select-stmt">compound-select-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#simple-select-stmt">simple-select-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br> References: <a href="#expr">expr</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="compound-operator"></a><h4>compound-operator:</h4><blockquote> <img src="images/syntax/compound-operator.gif"></img><br></br> Used by: <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#select-stmt">select-stmt</a><br></br> See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="lang_with.html#recursivecte">lang_with.html#recursivecte</a> <a href="partialindex.html">partialindex.html</a> </blockquote> <a name="update-stmt"></a><h4>update-stmt:</h4><blockquote> <img src="images/syntax/update-stmt.gif"></img><br></br> Used by: <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#sql-stmt">sql-stmt</a><br></br> References: <a href="#expr">expr</a> <a href="#qualified-table-name">qualified-table-name</a> <a href="#with-clause">with-clause</a><br></br> See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_update.html">lang_update.html</a> </blockquote> <a name="update-stmt-limited"></a><h4>update-stmt-limited:</h4><blockquote> <img src="images/syntax/update-stmt-limited.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> References: <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#qualified-table-name">qualified-table-name</a> <a href="#with-clause">with-clause</a><br></br> See also: <a href="lang_update.html">lang_update.html</a> </blockquote> <a name="qualified-table-name"></a><h4>qualified-table-name:</h4><blockquote> <img src="images/syntax/qualified-table-name.gif"></img><br></br> Used by: <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br> See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_indexedby.html">lang_indexedby.html</a> <a href="lang_update.html">lang_update.html</a> </blockquote> <a name="vacuum-stmt"></a><h4>vacuum-stmt:</h4><blockquote> <img src="images/syntax/vacuum-stmt.gif"></img><br></br> Used by: <a href="#sql-stmt">sql-stmt</a><br></br> See also: <a href="lang_vacuum.html">lang_vacuum.html</a> </blockquote> <a name="comment-syntax"></a><h4>comment-syntax:</h4><blockquote> <img src="images/syntax/comment-syntax.gif"></img><br></br><br></br> See also: <a href="lang_comment.html">lang_comment.html</a> </blockquote> |