Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Pickup the SQLite core library 3.29.0 docs from upstream. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
4deb290d232e58504861b16579fa7361 |
User & Date: | mistachkin 2019-07-13 18:31:10.706 |
Context
2019-07-13
| ||
18:35 | Update version history docs. check-in: 62de24d8a3 user: mistachkin tags: trunk | |
18:31 | Pickup the SQLite core library 3.29.0 docs from upstream. check-in: 4deb290d23 user: mistachkin tags: trunk | |
18:28 | Update SQLite core library to the 3.29.0 release. check-in: fe3c97a1d8 user: mistachkin tags: trunk | |
Changes
Changes to Doc/Extra/Core/lang.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>Query Language Understood by SQLite</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_UPSERT.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: upsert</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_aggfunc.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: Aggregate Functions</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_altertable.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: ALTER TABLE</title> <!-- path= --> </head> |
︙ | ︙ | |||
233 234 235 236 237 238 239 | <b>Compatibility Note:</b> The behavior of ALTER TABLE when renaming a table was enhanced in versions 3.25.0 (2018-09-15) and 3.26.0 (2018-12-01) in order to carry the rename operation forward into triggers and views that reference the renamed table. This is considered an improvement. Applications that depend on the older (and arguably buggy) behavior can use the | | > > | 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 | <b>Compatibility Note:</b> The behavior of ALTER TABLE when renaming a table was enhanced in versions 3.25.0 (2018-09-15) and 3.26.0 (2018-12-01) in order to carry the rename operation forward into triggers and views that reference the renamed table. This is considered an improvement. Applications that depend on the older (and arguably buggy) behavior can use the <a href="pragma.html#pragma_legacy_alter_table">PRAGMA legacy_alter_table=ON</a> statement or the <a href="c3ref/c_dbconfig_defensive.html#sqlitedbconfiglegacyaltertable">SQLITE_DBCONFIG_LEGACY_ALTER_TABLE</a> configuration parameter on <a href="c3ref/db_config.html">sqlite3_db_config()</a> interface to make ALTER TABLE RENAME behave as it did prior to version 3.25.0. </blockquote> <p> Beginning with release 3.25.0 (2018-09-15), references to the table within trigger bodies and view definitions are also renamed. </p> |
︙ | ︙ | |||
340 341 342 343 344 345 346 | <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> | | | > | | | | 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 | <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, triggers, and views 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>, <a href="lang_createtrigger.html">CREATE TRIGGER</a>, and <a href="lang_createview.html">CREATE VIEW</a> to reconstruct indexes, triggers, and views associated with table X. Perhaps use the old format of the triggers, indexes, and views 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> |
︙ | ︙ | |||
483 484 485 486 487 488 489 490 491 492 493 494 | <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. | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 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 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 | <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. <a name="altertableishard"></a> <h3>Why ALTER TABLE is such a problem for SQLite</h3> <p>Most SQL database engines store the schema already parsed into various system tables. On those database engines, ALTER TABLE merely has to make modifications to the corresponding system tables. <p>SQLite is different in that it stores the schema in the <a href="fileformat2.html#sqlite_master">sqlite_master</a> table as the original text of the CREATE statements that define the schema. Hence ALTER TABLE needs to revise the text of the CREATE statement. Doing so can be tricky for certain "creative" schema designs. <p>The SQLite approach of storing the schema as text has advantages for an embedded relational database. For one, it means that the schema takes up less space in the database file. This is important since a common SQLite usage pattern is to have many small, separate database files instead of putting everything in one big global database file, which is the usual approach for client/server database engines. Since the schema is duplicated in each separate database file, it is important to keep the schema representation compact. <p>Storing the schema as text rather than as parsed tables also give flexibility to the implementation. Since the internal parse of the schema is regenerated each time the database is opened, the internal representation of the schema can change from one release to the next. This is important, as sometimes new features require enhancements to the internal schema representation. Changing the internal schema representation would be much more difficult if the schema representation was exposed in the database file. So, in other words, storing the schema as text helps maintain backwards compatibility, and helps ensure that older database files can be read and written by newer versions of SQLite. <p>Storing the schema a text also makes the <a href="fileformat2.html">SQLite database file format</a> easier to define, document, and understand. This helps make SQLite database files a <a href="locrsf.html">recommended storage format</a> for long-term archiving of data. <p>The downside of storing schema a text is that it can make the schema tricky to modify. And for that reason, the ALTER TABLE support in SQLite has traditionally lagged behind other SQL database engines that store their schemas as parsed system tables that are easier to modify. |
Changes to Doc/Extra/Core/lang_analyze.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: ANALYZE</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_attach.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: ATTACH DATABASE</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_comment.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: comment</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_conflict.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: ON CONFLICT clause</title> <!-- path= --> </head> |
︙ | ︙ | |||
152 153 154 155 156 157 158 | resolution algorithm aborts the current SQL statement with an SQLITE_CONSTRAINT error. But the FAIL resolution does not back out prior changes of the SQL statement that failed nor does it end the transaction. For example, if an UPDATE statement encountered a constraint violation on the 100th row that it attempts to update, then the first 99 row changes are preserved | | > > > > | > | > > > | | | 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 | resolution algorithm aborts the current SQL statement with an SQLITE_CONSTRAINT error. But the FAIL resolution does not back out prior changes of the SQL statement that failed nor does it end the transaction. For example, if an UPDATE statement encountered a constraint violation on the 100th row that it attempts to update, then the first 99 row changes are preserved but changes to rows 100 and beyond never occur.</p> <p>The FAIL behavior only works for uniqueness, NOT NULL, and CHECK constraints. A <a href="foreignkeys.html">foreign key constraint</a> violation causes an ABORT. </p></dd> <dt><b>IGNORE</b></dt> <dd><p> When an applicable constraint violation occurs, the IGNORE resolution algorithm skips the one row that contains the constraint violation and continues processing subsequent rows of the SQL statement as if nothing went wrong. Other rows before and after the row that contained the constraint violation are inserted or updated normally. No error is returned for uniqueness, NOT NULL, and UNIQUE constraint errors when the IGNORE conflict resolution algorithm is used. However, the IGNORE conflict resolution algorithm works like ABORT for <a href="foreignkeys.html">foreign key constraint</a> errors. </p> </dd> <dt><b>REPLACE</b></dt> <dd><p> When a <a href="lang_createtable.html#uniqueconst">UNIQUE</a> or <a href="lang_createtable.html#primkeyconst">PRIMARY KEY</a> constraint violation occurs, the REPLACE algorithm deletes pre-existing rows that are causing the constraint violation prior to inserting or updating the current row and the command continues executing normally. If a <a href="lang_createtable.html#notnullconst">NOT NULL</a> constraint violation occurs, the REPLACE conflict resolution replaces the NULL value with the default value for that column, or if the column has no default value, then the ABORT algorithm is used. If a <a href="lang_createtable.html#ckconst">CHECK constraint</a> or <a href="foreignkeys.html">foreign key constraint</a> violation occurs, the REPLACE conflict resolution algorithm works like ABORT.</p> <p>When the REPLACE conflict resolution strategy deletes rows in order to satisfy a constraint, <a href="lang_createtrigger.html">delete triggers</a> fire if and only if <a href="pragma.html#pragma_recursive_triggers">recursive triggers</a> are enabled.</p> <p>The <a href="c3ref/update_hook.html">update hook</a> is not invoked for rows that are deleted by the REPLACE conflict resolution strategy. Nor does |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_corefunc.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: Core Functions</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_createindex.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: CREATE INDEX</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_createtable.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: CREATE TABLE</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_createtrigger.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: CREATE TRIGGER</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_createview.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: CREATE VIEW</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_createvtab.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: CREATE VIRTUAL TABLE</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_datefunc.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: Date And Time Functions</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_delete.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: DELETE</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_detach.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: DETACH DATABASE</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_dropindex.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: DROP INDEX</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_droptable.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: DROP TABLE</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_droptrigger.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: DROP TRIGGER</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_dropview.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: DROP VIEW</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_explain.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: EXPLAIN</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_expr.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: expression</title> <!-- path= --> </head> |
︙ | ︙ | |||
668 669 670 671 672 673 674 | <p>If the value of <i>expr</i> is NULL, then the result of the CAST expression is also NULL. Otherwise, the storage class of the result is determined by applying the <a href="datatype3.html#affname">rules for determining column affinity</a> to the <span class='yyterm'>type-name</span>. <table border=1> <tr> | | | 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 | <p>If the value of <i>expr</i> is NULL, then the result of the CAST expression is also NULL. Otherwise, the storage class of the result is determined by applying the <a href="datatype3.html#affname">rules for determining column affinity</a> to the <span class='yyterm'>type-name</span>. <table border=1> <tr> <th> Affinity of <span class='yyterm'><nobr>type-name</nobr></span> <th> Conversion Processing <tr> <td> NONE <td> Casting a value to a <span class='yyterm'>type-name</span> with no affinity causes the value to be converted into a BLOB. Casting to a BLOB consists of first casting the value to TEXT in the <a href="pragma.html#pragma_encoding">encoding</a> of the database connection, then |
︙ | ︙ | |||
739 740 741 742 743 744 745 | casting a REAL value greater than +9223372036854775807.0 into an integer resulted in the most negative integer, -9223372036854775808. This behavior was meant to emulate the behavior of x86/x64 hardware when doing the equivalent cast. <tr> <td> NUMERIC | | | | | | > > > > > > > > > | 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 | casting a REAL value greater than +9223372036854775807.0 into an integer resulted in the most negative integer, -9223372036854775808. This behavior was meant to emulate the behavior of x86/x64 hardware when doing the equivalent cast. <tr> <td> NUMERIC <td> Casting a TEXT or BLOB value into NUMERIC yields either an INTEGER or a REAL result. If the input text looks like an integer (there is no decimal point nor exponent) and the value is small enough to fit in a 64-bit signed integer, then the result will be INTEGER. Input text that looks like floating point (there is a decimal point and/or an exponent) and the text describes a value that can be losslessly converted back and forth between IEEE 754 64-bit float and a 51-bit signed integer, then the result is INTEGER. (In the previous sentence, a 51-bit integer is specified since that is one bit less than the length of the mantissa of an IEEE 754 64-bit float and thus provides a 1-bit of margin for the text-to-float conversion operation.) Any text input that describes a value outside the range of a 64-bit signed integer yields a REAL result. <p> Casting a REAL or INTEGER value to NUMERIC is a no-op, even if a real value could be losslessly converted to an integer. </tr> </table> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_indexedby.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: INDEXED BY</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_insert.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: INSERT</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_keywords.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: SQLite Keywords</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_naming.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: Database Object Name Resolution</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_reindex.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: REINDEX</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_replace.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: REPLACE</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_savepoint.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: SAVEPOINT</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_select.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: SELECT</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_transaction.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: BEGIN TRANSACTION</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_update.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: UPDATE</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_vacuum.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: VACUUM</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/lang_with.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>SQLite Query Language: WITH clause</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/pragma.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>Pragma statements supported by SQLite</title> <!-- path= --> </head> |
︙ | ︙ | |||
503 504 505 506 507 508 509 | <p>The default page cache implemention does not allocate the full amount of cache memory all at once. Cache memory is allocated in smaller chunks on an as-needed basis. The page_cache setting is a (suggested) upper bound on the amount of memory that the cache can use, not the amount of memory it will use all of the time. This is the behavior of the default page cache implementation, but an | | | 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 | <p>The default page cache implemention does not allocate the full amount of cache memory all at once. Cache memory is allocated in smaller chunks on an as-needed basis. The page_cache setting is a (suggested) upper bound on the amount of memory that the cache can use, not the amount of memory it will use all of the time. This is the behavior of the default page cache implementation, but an <a href="c3ref/pcache_methods2.html">application defined page cache</a> is free to behave differently if it wants. <a name="pragma_cache_spill"></a> <h _id=pragma_cache_spill style="display:none"> PRAGMA cache_spill</h><hr> <p><b>PRAGMA cache_spill; <br>PRAGMA cache_spill=</b><i>boolean</i><b>; <br>PRAGMA </b><i>schema.</i><b>cache_spill=<i>N</i>;</b></p> |
︙ | ︙ | |||
1050 1051 1052 1053 1054 1055 1056 | journal to delete. The OFF journaling mode disables the atomic commit and rollback capabilities of SQLite. The <a href="lang_transaction.html">ROLLBACK</a> command no longer works; it behaves in an undefined way. Applications must avoid using the <a href="lang_transaction.html">ROLLBACK</a> command when the journal mode is OFF. If the application crashes in the middle of a transaction when the OFF journaling mode is set, then the database file will very likely | | > > > > > > > > | 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 | journal to delete. The OFF journaling mode disables the atomic commit and rollback capabilities of SQLite. The <a href="lang_transaction.html">ROLLBACK</a> command no longer works; it behaves in an undefined way. Applications must avoid using the <a href="lang_transaction.html">ROLLBACK</a> command when the journal mode is OFF. If the application crashes in the middle of a transaction when the OFF journaling mode is set, then the database file will very likely <a href="howtocorrupt.html#cfgerr">go corrupt</a>. Without a journal, there is no way for a statement to unwind partially completed operations following a constraint error. This might also leave the database in a corrupted state. For example, if a duplicate entry causes a <a href="lang_createindex.html">CREATE UNIQUE INDEX</a> statement to fail half-way through, it will leave behind a partially created, and hence corrupt, index. Because OFF journaling mode allows the database file to be corrupted using ordinary SQL, it is disabled when <a href="c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive">SQLITE_DBCONFIG_DEFENSIVE</a> is enabled.</p> <p>Note that the journal_mode for an <a href="inmemorydb.html">in-memory database</a> 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> |
︙ | ︙ | |||
1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 | contain code that expect the incomplete behavior of <a href="lang_altertable.html#altertabrename">ALTER TABLE RENAME</a> found in older versions of SQLite. New applications should leave this flag turned off. <p>For compatibility with older <a href="vtab.html">virtual table</a> implementations, this flag is turned on temporarily while the <a href="vtab.html#xrename">sqlite3_module.xRename</a> method is being run. The value of this flag is restore after the <a href="vtab.html#xrename">sqlite3_module.xRename</a> method finishes. <a name="pragma_legacy_file_format"></a> <h _id=pragma_legacy_file_format style="display:none"> PRAGMA legacy_file_format</h><hr> <p><b>PRAGMA legacy_file_format; <br>PRAGMA legacy_file_format = <i>boolean</i></b></p> <p>This pragma sets or queries the value of the legacy_file_format flag. When this flag is on, new SQLite databases are created in a file format that is readable and writable by all versions of | > > > | 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 | contain code that expect the incomplete behavior of <a href="lang_altertable.html#altertabrename">ALTER TABLE RENAME</a> found in older versions of SQLite. New applications should leave this flag turned off. <p>For compatibility with older <a href="vtab.html">virtual table</a> implementations, this flag is turned on temporarily while the <a href="vtab.html#xrename">sqlite3_module.xRename</a> method is being run. The value of this flag is restore after the <a href="vtab.html#xrename">sqlite3_module.xRename</a> method finishes. <p>The legacy alter table behavior can also be toggled on and off using the <a href="c3ref/c_dbconfig_defensive.html#sqlitedbconfiglegacyaltertable">SQLITE_DBCONFIG_LEGACY_ALTER_TABLE</a> option to the <a href="c3ref/db_config.html">sqlite3_db_config()</a> interface. <a name="pragma_legacy_file_format"></a> <h _id=pragma_legacy_file_format style="display:none"> PRAGMA legacy_file_format</h><hr> <p><b>PRAGMA legacy_file_format; <br>PRAGMA legacy_file_format = <i>boolean</i></b></p> <p>This pragma sets or queries the value of the legacy_file_format flag. When this flag is on, new SQLite databases are created in a file format that is readable and writable by all versions of |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>List of SQLite Syntax Diagrams</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/alter-table-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: alter-table-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/analyze-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: analyze-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/attach-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: attach-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/begin-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: begin-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/column-constraint.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: column-constraint</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/column-def.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: column-def</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/column-name-list.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: column-name-list</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/comment-syntax.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: comment-syntax</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/commit-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: commit-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/common-table-expression.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: common-table-expression</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/compound-operator.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: compound-operator</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/compound-select-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: compound-select-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/conflict-clause.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: conflict-clause</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/create-index-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: create-index-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/create-table-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: create-table-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/create-trigger-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: create-trigger-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/create-view-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: create-view-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/create-virtual-table-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: create-virtual-table-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/cte-table-name.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: cte-table-name</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/delete-stmt-limited.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: delete-stmt-limited</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/delete-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: delete-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/detach-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: detach-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/drop-index-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: drop-index-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/drop-table-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: drop-table-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/drop-trigger-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: drop-trigger-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/drop-view-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: drop-view-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/expr.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: expr</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/factored-select-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: factored-select-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/foreign-key-clause.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: foreign-key-clause</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/indexed-column.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: indexed-column</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/insert-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: insert-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/join-clause.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: join-clause</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/join-constraint.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: join-constraint</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/join-operator.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: join-operator</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/literal-value.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: literal-value</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/numeric-literal.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: numeric-literal</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/ordering-term.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: ordering-term</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/pragma-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: pragma-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/pragma-value.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: pragma-value</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/qualified-table-name.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: qualified-table-name</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/raise-function.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: raise-function</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/recursive-cte.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: recursive-cte</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/reindex-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: reindex-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/release-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: release-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/result-column.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: result-column</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/rollback-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: rollback-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/savepoint-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: savepoint-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/select-core.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: select-core</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/select-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: select-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/signed-number.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: signed-number</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/simple-select-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: simple-select-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/sql-stmt-list.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: sql-stmt-list</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/sql-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: sql-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/table-constraint.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: table-constraint</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/table-or-subquery.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: table-or-subquery</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/type-name.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: type-name</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/update-stmt-limited.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: update-stmt-limited</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/update-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: update-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/vacuum-stmt.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: vacuum-stmt</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntax/with-clause.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="../sqlite.css" rel="stylesheet"> <title>SQLite Syntax: with-clause</title> <!-- path=../ --> </head> |
︙ | ︙ |
Changes to Doc/Extra/Core/syntaxdiagrams.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>Syntax Diagrams For SQLite</title> <!-- path= --> </head> |
︙ | ︙ |
Changes to Doc/Special/Core/vtab.html.
|
| | | 1 2 3 4 5 6 7 8 | <!DOCTYPE html> <html><head> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <link href="sqlite.css" rel="stylesheet"> <title>The Virtual Table Mechanism Of SQLite</title> <!-- path= --> </head> |
︙ | ︙ |