SQLITE_SCANSTAT_NLOOP, SQLITE_SCANSTAT_NVISIT, SQLITE_SCANSTAT_EST, SQLITE_SCANSTAT_NAME, SQLITE_SCANSTAT_EXPLAIN, SQLITE_SCANSTAT_SELECTID ... 

 ... SQLITE_SCANSTAT_NAME The "const char *" variable pointed to by the V parameter will be set to a zero-terminated UTF-8 string containing the name of the index or table used for the X-th loop. SQLITE_SCANSTAT_EXPLAIN The "const char *" variable ... 

3. Aggregated Data  ... Column Normal meaning Aggregate-mode meaning name The name of the table or index that is implemented by the btree of the current row path See description above Always NULL pageno The page number of the database page for the ... 

7. Options To Enable Features Normally Turned Off  ... However, the use of a covering index for a full scan will cause results to appear in a different order from legacy, which could cause some (incorrectly-coded) legacy applications to break. Hence, the covering index scan option can be ... 

 ... The INDEXED BY and NOT INDEXED clauses are not allowed on UPDATE statements within triggers. The LIMIT and ORDER BY clauses for UPDATE are unsupported within triggers, regardless of the compilation options used to build SQLite. 2.2. UPDATE FROM ... 

sqlite3_blob_open()

 ... row iRow contains a value that is not a TEXT or BLOB value, Column zColumn is part of an index, PRIMARY KEY or UNIQUE constraint and the blob is being opened for read/write access, Foreign key constraints are enabled ... 

 ... The INDEXED BY and NOT INDEXED clauses are not supported for UPDATE and DELETE statements. The ORDER BY and LIMIT clauses on UPDATE and DELETE statements are not supported. ORDER BY and LIMIT are not normally supported for UPDATE or ... 

 ... Columns are zero-indexed from left to right. Note that this is different to parameters, which are indexed starting at one. The sqlite3_column_type() function returns the datatype for the value in the Nth column. The return value is one of ... 

sqlite3_prepare(), sqlite3_prepare_v2(), sqlite3_prepare_v3(), sqlite3_prepare16(), sqlite3_prepare16_v2(), sqlite3_prepare16_v3()

 ... The specific value of a WHERE-clause parameter might influence the choice of query plan if the parameter is the left-hand side of a LIKE or GLOB operator or if the parameter is compared to an indexed column and ... 

4. Invalid UTF in the database schema If a database schema contains names (table names, column names, index names, and so forth) that are invalid UTF, SQLite will continue to operate normally. As far as SQLite is concerned, those names are just byte sequences. SQLite does not ... 

sqlite3_preupdate_hook(), sqlite3_preupdate_old(), sqlite3_preupdate_count(), sqlite3_preupdate_depth(), sqlite3_preupdate_new(), sqlite3_preupdate_blobwrite()

 ... In this case, when a callback made with op==SQLITE_DELETE is actually a write using the sqlite3_blob_write() API, the sqlite3_preupdate_blobwrite() returns the index of the column being written. In other cases, where the pre-update hook is being invoked for ...