Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Generated Columns
(gencol.html)
2.3. Limitations
... The expression of a generated column may not directly reference
the ROWID, though it can reference the INTEGER PRIMARY KEY column,
which is often the same thing.
Every table must have at least one non-generated column.
It is not ...
|
|
VACUUM
(lang_vacuum.html)
... The VACUUM command may change the ROWIDs of entries in any
tables that do not have an explicit INTEGER PRIMARY KEY.
A VACUUM will fail if there is an open transaction on the database
connection that is attempting to run ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA index_info
... A value of -1 means rowid and a value of -2 means that an
expression is being used.
The name of the column being indexed. This columns is NULL
if the column is the rowid or an expression.
If there ...
|
|
SQL Language Expressions
(lang_expr.html)
... Table Column Names
A column name can be any of the names defined in the CREATE TABLE
statement or one of the following special identifiers: "ROWID",
"OID", or "_ROWID_".
The three special identifiers describe the
unique integer key (the rowid ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
4.2. Evaluating OR constraints separately and taking the UNION of the result
... rowid IN (SELECT rowid FROM table WHERE expr1
UNION SELECT rowid FROM table WHERE expr2
UNION SELECT rowid FROM table WHERE expr3)
The rewritten expression above is conceptual; WHERE clauses containing
OR are not really rewritten this way.
The actual ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.12. Th3 last_insert_rowid method
The "last_insert_rowid" method returns an integer which is the ROWID
of the most recently inserted database row.
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... The rowid of a table must be an integer. Attempt to set the rowid
to anything other than an integer (or a NULL which will be automatically
converted into the next available integer rowid) results in an
SQLITE_MISMATCH error.
(21 ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
2. Using The Geopoly Extension
... Every geopoly table contains a built-in integer "rowid" column
and a "_shape" column that contains
the polygon associated with that row of the table.
The example above also defines three auxiliary data columns
named "a", "b", and "c" that ...
|
|
Command Line Shell For SQLite
(cli.html)
10. Recover Data From a Corrupted Database
... id If the row comes from a WITHOUT ROWID table, this column
contains NULL. Otherwise, it contains the 64-bit integer rowid value for
the row.
c0, c1, c2... The values for each column of the row
are ...
|
|
The Spellfix1 Virtual Table
(spellfix1.html)
3. Virtual Table Details
Each row in the spellfix1 virtual table has a unique rowid
with seven columns plus five extra hidden columns.
The columns are as follows:
rowid
A unique integer number associated with each
vocabulary item in the table. This can be ...
|
Page generated by FTS5 in about 111.69 ms.