EXPLAIN QUERY PLAN
(eqp.html)
1. The EXPLAIN QUERY PLAN Command
... command to turn automatic EXPLAIN QUERY PLAN mode back off.
EXPLAIN QUERY PLAN is most useful on a SELECT statement,
but may also appear with other statements that read data from database
tables (e.g. UPDATE, DELETE, INSERT INTO ... SELECT).
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
2. Differences From Ordinary Rowid Tables
... Hence, the update hook is not invoked when a WITHOUT ROWID table changes.
|
Dynamic Memory Allocation In SQLite
(malloc.html)
5. Stability Of Memory Interfaces
Update: As of SQLite version 3.7.0 (2010-07-21),
all of SQLite memory allocation interfaces
are considered stable and will be supported in future releases.
This page last modified on 2025-05-31 13:08:22 UTC
|
SQL Language Expressions
(lang_expr.html)
... A subquery that returns two or more columns is a row value
subquery and can only be used as an operand of a comparison operator or as
the value in an UPDATE SET clause whose column name list has the ...
|
JSON Functions And Operators
(json1.html)
3.2. JSONB
... By storing SQLite's internal
binary representation of JSON directly in the database, applications
can bypass the overhead of parsing and rendering JSON when reading and
updating JSON values. The internal JSONB format also uses slightly
less disk space then ...
|
Database File Format
(fileformat.html)
2.6.3. The sqlite_sequence table
... The sqlite_sequence.seq field is automatically updated if required when
new entries are inserted to an AUTOINCREMENT table.
The sqlite_sequence row for an AUTOINCREMENT table is automatically deleted
when the table is dropped.
If the sqlite_sequence row for an AUTOINCREMENT ...
|
Implementation Limits For SQLite
(limits.html)
... The number of columns in a table
The number of columns in an index
The number of columns in a view
The number of terms in the SET clause of an UPDATE statement
The number of columns in the result ...
|
The Advantages Of Flexible Typing
(flextypegood.html)
3.1. Attribute tables
... Flexible typing
of the "value" column makes the table conceptually simpler, more
space-efficient, and easier to access and update.
In the Fossil version control system, each
repository has a CONFIG table that is used to store all kinds of ...
|
The Virtual Database Engine of SQLite
(vdbe.html)
... The values of aggregate functions are updated by the instructions
between 11 and 21. Instructions 14 through 18 update memory
slot 1 to hold the next value "min(three+four)". Then the sum of the
"four" column is updated by ...
|
C API: Standard File Control Opcodes
(c3ref/c_fcntl_begin_atomic_write.html)
SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ...
... The SQLITE_FCNTL_CKPT_DONE opcode is invoked from within a checkpoint
in wal mode after the client has finished copying pages from the wal
file to the database file, but before the *-shm file is updated to
record the fact that the ...
|
Page generated by FTS5 in about 129.24 ms.