Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Schema Table
(schematab.html)
3. Interpretation Of The Schema Table
... The "sqlite_autoindex_TABLE_N" name is never allocated for an
INTEGER PRIMARY KEY, either in rowid tables or WITHOUT ROWID tables.
tbl_name
The sqlite_schema.tbl_name column holds the name of a table or view
that the object is associated with. For a ...
|
|
SQLite FTS5 Extension
(fts5.html)
9.2.1. The %_data Table Rowid Space
... table to store any given segment b-tree
leaf or doclist index leaf or node is composed as follows:
Rowid Bits Contents
38..43 (16 bit) Segment b-tree id value.
37 (1 bit) Doclist index flag. Set for ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.1.3. WITHOUT ROWID Virtual Tables
Beginning with SQLite version 3.14.0 (2016-08-08),
the CREATE TABLE statement that
is passed into sqlite3_declare_vtab() may contain a WITHOUT ROWID clause.
This is useful for cases where the virtual table rows
cannot easily be mapped into ...
|
|
C API: Open A BLOB For Incremental I/O
(c3ref/blob_open.html)
sqlite3_blob_open()
... SELECT zColumn FROM zDb.zTable WHERE rowid = iRow;
Parameter zDb is not the filename that contains the database, but
rather the symbolic name of the database. For attached databases, this is
the name that appears after the AS keyword in ...
|
|
C API: Move a BLOB Handle to a New Row
(c3ref/blob_reopen.html)
sqlite3_blob_reopen()
... The new row is identified
by the rowid value passed as the second argument. Only the row can be
changed. The database, table and column on which the blob handle is open
remain the same. Moving an existing BLOB handle ...
|
|
C API: Virtual Table Constraint Operator Codes
(c3ref/c_index_constraint_eq.html)
SQLITE_INDEX_CONSTRAINT_EQ, SQLITE_INDEX_CONSTRAINT_GT, SQLITE_INDEX_CONSTRAINT_LE, SQLITE_INDEX_CONSTRAINT_LT, SQLITE_INDEX_CONSTRAINT_GE, SQLITE_INDEX_CONSTRAINT_MATCH ...
... An iColumn of -1 indicates the left-hand
operand is the rowid.
The SQLITE_INDEX_CONSTRAINT_LIMIT and SQLITE_INDEX_CONSTRAINT_OFFSET
operators have no left-hand operand, and so for those operators the
corresponding aConstraint[].iColumn is meaningless and should not be
used.
All operator ...
|
|
The RBU Extension
(rbu.html)
2.1. RBU Update Limitations
... UPDATE and DELETE statements must identify the target rows
by rowid or by non-NULL PRIMARY KEY values.
UPDATE statements may not modify PRIMARY KEY or rowid values.
RBU updates cannot be applied to any tables that contain a column ...
|
|
The DBSTAT Virtual Table
(dbstat.html)
4. Example uses of the dbstat virtual table
... CREATE TEMP TABLE s(rowid INTEGER PRIMARY KEY, pageno INT);
INSERT INTO s(pageno) SELECT pageno FROM dbstat ORDER BY path;
SELECT sum(s1.pageno+1==s2.pageno)*1.0/count(*)
FROM s AS s1, s AS s2
WHERE s1 ...
|
|
The Session Extension
(sessionintro.html)
1.3. Limitations
Prior to SQLite version 3.17.0, the session extension only worked with
rowid tables, not WITHOUT ROWID tables. As of 3.17.0, both
rowid and WITHOUT ROWID tables are supported. However, extra steps are
needed to record primary ...
|
|
The generate_series Table-Valued Function
(series.html)
1. Overview
... It also has a rowid, accessible by its usual names.
Omitted parameters take on default values. STEP defaults to 1.
STOP defaults to 4294967295. The START parameter is required
as of version 3.37.0 (2021-11-27) and later ...
|
Page generated by FTS5 in about 132.04 ms.