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. Joins
The ON and USING clauses of an inner join are converted into additional
terms of the WHERE clause prior to WHERE clause analysis described
above in paragraph 2.0.
Thus with SQLite, there is no computational
advantage to use the ...
|
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 ...
|
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 ...
|
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 ...
|
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 ...
|
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 ...
|
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 ...
|
Page generated by FTS5 in about 44.29 ms.