Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Prepared Statement Scan Status Opcodes
(c3ref/c_scanstat_est.html)
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 ...
|
|
Compile-time Options
(compile.html)
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 DBSTAT Virtual Table
(dbstat.html)
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 ...
|
|
UPDATE
(lang_update.html)
... 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 ...
|
|
C API: Open A BLOB For Incremental I/O
(c3ref/blob_open.html)
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 ...
|
|
CREATE TRIGGER
(lang_createtrigger.html)
... 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 ...
|
|
Recent SQLite News
(news.html)
... These problems could results in incorrect query results or corrupt
indexes. See the associated forum threads for details.
Other trifling fixes are also included in the patch.
2024-01-30 - Version 3.45.1
Version 3.45.1 is a ...
|
|
C API: Compiling An SQL Statement
(c3ref/prepare.html)
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 ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... dbcmd preupdate count
dbcmd preupdate depth
dbcmd preupdate new INDEX
dbcmd preupdate old INDEX
The count submethod returns the number ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... 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 ...
|
Page generated by FTS5 in about 92.11 ms.