Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SELECT
(lang_select.html)
... Special handling of CROSS JOIN.
There is no difference between the "INNER JOIN", "JOIN" and "," join
operators. They are completely interchangeable in SQLite.
The "CROSS JOIN" join operator produces the same result as the
"INNER JOIN", "JOIN" and "," operators, but ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
7.1.2. Manual Control of Query Plans using CROSS JOIN
Programmers can force SQLite to use a particular loop nesting order
for a join by using the CROSS JOIN operator instead of just JOIN,
INNER JOIN, NATURAL JOIN, or a "," join. Though CROSS JOINs are
commutative in theory, SQLite chooses ...
|
|
List of SQLite Syntax Diagrams
(syntax.html)
... expr
factored-select-stmt
filter-clause
foreign-key-clause
frame-spec
function-arguments
indexed-column
insert-stmt
join-clause
join-constraint
join-operator
literal-value
numeric-literal
ordering-term
over-clause
pragma-stmt
pragma-value
qualified-table-name
raise-function ...
|
|
UPDATE
(lang_update.html)
... The target table is not included in the FROM clause, unless the intent
is to do a self-join against the target table. In the event of a self-join,
the table in the FROM clause must be aliased to ...
|
|
C API: Status Parameters for prepared statements
(c3ref/c_stmtstatus_counter.html)
SQLITE_STMTSTATUS_FULLSCAN_STEP, SQLITE_STMTSTATUS_SORT, SQLITE_STMTSTATUS_AUTOINDEX, SQLITE_STMTSTATUS_VM_STEP, SQLITE_STMTSTATUS_REPREPARE, SQLITE_STMTSTATUS_RUN ...
... SQLITE_STMTSTATUS_AUTOINDEX
This is the number of rows inserted into transient indices that
were created automatically in order to help joins run faster.
A non-zero value in this counter may indicate an opportunity to
improvement performance by adding permanent indices ...
|
|
Full-Featured SQL
(fullsql.html)
... ACID transactions using BEGIN, COMMIT, and ROLLBACK
Nested transactions using SAVEPOINT, RELEASE, and
ROLLBACK TO
Subqueries, including correlated subqueries
Up to 64-way joins
LEFT, RIGHT, and FULL OUTER JOINs
DISTINCT, ORDER BY, GROUP BY, HAVING, LIMIT, and OFFSET
UNION ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
4.2. Fixing The Problem
... For this reason, the query was modified to use the CROSS JOIN operator
instead of the plain JOIN operator.
SQLite will not reorder the tables of a CROSS JOIN.
This is a long-standing feature of SQLite that is specifically ...
|
|
Syntax Diagrams For SQLite
(syntaxdiagrams.html)
... Used by: select-core select-stmt table-or-subquery update-stmt update-stmt-limited
References: join-constraint join-operator table-or-subquery
See also ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
14. SQLite Gets The Precedence Of Comma-Joins Wrong
SQLite gives all join operators equal precedence and processes them
from left to right. But this is not quite correct. It should be that
comma-joins have lower precedence than all others join operators.
In other words, a FROM clause ...
|
|
Row Values
(rowvalue.html)
3.4. Update multiple columns of a table based on a query
... But the three columns "label", "url", and "mtime" all require
a join query against the "event" and "blob" tables. Without row values,
the equivalent UPDATE would require that the join be repeated three times,
once for each column to be ...
|
Page generated by FTS5 in about 41.15 ms.