Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Foreign Key Support
(foreignkeys.html)
3. Required and Suggested Database Indexes
... SELECT rowid FROM track WHERE trackartist = ?
where ? in the above is replaced with the value of the artistid
column of the record being deleted from the artist table (recall
that the trackartist column is the child key and the artistid ...
|
|
The SQLite Zipfile Module
(zipfile.html)
3.2.1. Adding Entries to a Zip Archive
... Specifying an explicit value for the rowid field as part of an INSERT
statement is not supported. Any value supplied is ignored.
|
|
EXPLAIN QUERY PLAN
(eqp.html)
1.1. Table and Index Scans
... It may scan through all the records in
a table (a full-table scan), scan a contiguous subset of the records in a
table based on the rowid index, scan a contiguous subset of the entries in a
database index ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
3.1. Attribute tables
... CREATE TABLE attribute(name TEXT PRIMARY KEY, value) WITHOUT ROWID;
Without flexible typing, such a table would need to be more complex,
with separate columns for each possible type of data. Flexible typing
of the "value" column makes the table ...
|
|
SQLite Older News
(oldnews.html)
... Version 3.8.2 adds support for WITHOUT ROWID tables. This is a
significant extension to SQLite. Database files that contain WITHOUT ROWID
tables are not readable or writable by prior versions of SQLite, however
databases that do not use ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... 3.1 The ROWID of the most recent insert
Every row of an SQLite table has a unique integer key. If the
table has a column labeled INTEGER PRIMARY KEY, then that column
serves as the key. If there is ...
|
|
JSON Functions And Operators
(json1.html)
4.23.1. Examples using json_each() and json_tree()
... SELECT big.rowid, fullkey, value
FROM big, json_tree(big.json)
WHERE json_tree.type NOT IN ('object','array');
In the previous, the "type NOT IN ('object','array')" term of the
WHERE clause suppresses containers and only lets through leaf elements.
The ...
|
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... last_insert_rowid()
The last_insert_rowid() function returns the ROWID
of the last row insert from the database connection which invoked the
function.
The last_insert_rowid() SQL function is a wrapper around the
sqlite3_last_insert_rowid() C/C++ interface function.
length(X)
For a string value ...
|
|
The WITH Clause
(lang_with.html)
... CREATE TABLE org(
name TEXT PRIMARY KEY,
boss TEXT REFERENCES org
) WITHOUT ROWID;
INSERT INTO org VALUES('Alice',NULL);
INSERT INTO org VALUES('Bob','Alice');
INSERT INTO org VALUES('Cindy','Alice');
INSERT INTO org VALUES('Dave','Bob');
INSERT INTO org ...
|
|
Compile-time Options
(compile.html)
7. Options To Enable Features Normally Turned Off
... SQLITE_ENABLE_PREUPDATE_HOOK
This option enables
several new APIs that provide callbacks
prior to any change to a rowid table. The callbacks can be used
to record the state of the row before the change occurs.
The action of the preupdate hook ...
|
Page generated by FTS5 in about 113.89 ms.