Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Find all elements on the right-hand side of an IN constraint.
(c3ref/vtab_in_first.html)
sqlite3_vtab_in_first(), sqlite3_vtab_in_next()
... The X parameter in a call to sqlite3_vtab_in_first(X,P) or
sqlite3_vtab_in_next(X,P) should be one of the parameters to the
xFilter method which invokes these routines, and specifically
a parameter that was previously selected for all-at-once ...
|
|
The SQLite Zipfile Module
(zipfile.html)
3.3. The zipfile() Aggregate Function
... WITH contents(name, data) AS (
VALUES('a.txt', 'abc') UNION ALL
VALUES('b.txt', '123')
)
SELECT zipfile(name, data) FROM contents;
This page last modified on 2023-06-07 13:17:51 UTC
|
|
The Bytecode() And Tables_Used() Table-Valued Functions
(bytecodevtab.html)
2. Usage
... You use them
by mentioning them directly in the FROM clause of a SELECT statement.
They both require a single argument which is the SQL statement to be
analyzed. For example:
SELECT * FROM bytecode('SELECT * FROM bytecode(?1)');
The argument ...
|
|
Implementation Limits For SQLite
(limits.html)
... Maximum Number Of Terms In A Compound SELECT Statement
A compound SELECT statement is two or more SELECT statements connected
by operators UNION, UNION ALL, EXCEPT, or INTERSECT. We call each
individual SELECT statement within a compound SELECT a "term ...
|
|
The SQLITE_DBPAGE Virtual Table
(dbpage.html)
2.1. Using SQLITE_DBPAGE On ATTACH-ed Databases
... SELECT data FROM sqlite_dbpage('main') WHERE pgno=1;
SELECT data FROM sqlite_dbpage WHERE pgno=1;
The SQLITE_DBPAGE table can participate in a join just like any other
table. Hence, to see the content of the first page to all connected ...
|
|
The Spellfix1 Virtual Table
(spellfix1.html)
2. Search Refinements
... INSERT INTO demo(word,langid) SELECT word, 0 FROM en_vocabulary;
INSERT INTO demo(word,langid) SELECT word, 1 FROM de_vocabulary;
INSERT INTO demo(word,langid) SELECT word, 2 FROM fr_vocabulary;
INSERT INTO demo(word,langid) SELECT word, 3 FROM ru_vocabulary ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... 3 IN (1,2,NULL)
3 IN (SELECT * FROM x1)
Similarly, the following expressions have historically evaluated to
TRUE when in fact NULL is also the correct answer here:
3 NOT IN (1,2,NULL)
3 NOT IN (SELECT * FROM ...
|
|
Partial Indexes
(partialindex.html)
3. Queries Using Partial Indexes
... following
query could use the partial index:
SELECT * FROM tab2 WHERE b=456 AND c<>0; -- uses partial index
But the next query can not use the partial index:
SELECT * FROM tab2 WHERE b=456; -- cannot use partial ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
2.7. Materializations Of Views And Subqueries
... SELECT * FROM ex1 WHERE a IN (SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT 3);
A temporary index is always used to hold the values of the
right-hand side of an IN operator when that right-hand side ...
|
|
Query Planning
(queryplanner.html)
2.1. Sorting By Rowid
... output in rowid order, no sorting
will be done:
SELECT * FROM fruitsforsale ORDER BY rowid;
Figure 17: Sorting By Rowid
You can also request a reverse-order sort like this:
SELECT * FROM fruitsforsale ORDER BY rowid DESC;
SQLite will still ...
|
Page generated by FTS5 in about 183.56 ms.