Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SELECT
(lang_select.html)
... Simple Select Processing
The core of a SELECT statement is a "simple SELECT" shown by the
and syntax diagrams below.
In practice, most SELECT statements are simple SELECT statements.
Generating the results of a simple SELECT
statement is presented as ...
|
|
C API: Authorizer Action Codes
(c3ref/c_alter_table.html)
... SQLITE_PRAGMA, SQLITE_READ, SQLITE_SELECT, SQLITE_TRANSACTION, SQLITE_UPDATE, SQLITE_ATTACH ...
The sqlite3_set_authorizer() interface registers a callback function
that is invoked to authorize certain SQL statement actions. The
second parameter to the callback is an integer code that specifies
what action is being authorized. These are the integer action codes that ...
|
|
Many Small Queries Are Efficient In SQLite
(np1queryprob.html)
4. The Need For Over 200 SQL Statements Per Webpage
... The following is a log of all SQL used to generate one particular
timeline (captured on 2016-09-16):
-- sqlite3_open: /home/drh/sqlite/sqlite/.fslckout
PRAGMA foreign_keys=OFF;
SELECT sql FROM localdb.sqlite_schema WHERE name=='vfile';
-- sqlite3_open: /home/drh/.fossil ...
|
|
The WITH Clause
(lang_with.html)
... One or more of the SELECT statements in the compound must be
non-recursive.
All non-recursive SELECT statements must occur before any
recursive SELECT statements.
The recursive SELECT statements must be separated from the
non-recursive SELECT statements
and ...
|
|
EXPLAIN QUERY PLAN
(eqp.html)
1.3. Subqueries
In all the examples above, there has only been a single SELECT statement.
If a query contains sub-selects, those are shown as being children of
the outer SELECT. For example:
sqlite> EXPLAIN QUERY PLAN SELECT (SELECT b FROM ...
|
|
NULL Handling in SQLite
(nulls.html)
... This involved making NULLs
indistinct for the purposes of the SELECT DISTINCT statement and
for the UNION operator in a SELECT. NULLs are still distinct
in a UNIQUE column. This seems somewhat arbitrary, but the desire
to be compatible with ...
|
|
List of SQLite Syntax Diagrams
(syntax.html)
List of SQLite Syntax Diagrams
aggregate-function-invocation
alter-table-stmt
analyze-stmt
attach-stmt
begin-stmt
column-constraint
column-def
column-name-list
comment-syntax
commit-stmt
common-table-expression
compound-operator
compound-select-stmt
conflict-clause
create-index ...
|
|
The generate_series Table-Valued Function
(series.html)
2. Usage Examples
... SELECT customer.name
FROM customer, generate_series(10000,20000,100)
WHERE customer.id=value;
/* or */
SELECT name FROM customer
WHERE id IN (SELECT value
FROM generate_series(10000,20000,200));
This page last modified on 2023-05-01 21:49:55 UTC
|
|
INSERT
(lang_insert.html)
... Otherwise, if no column-list is
specified, the number of columns in the result of the SELECT must be the same
as the number of columns in the table. Any SELECT statement, including
compound SELECTs and SELECT statements with ORDER ...
|
|
Syntax Diagrams For SQLite
(syntaxdiagrams.html)
... Used by: compound-select-stmt delete-stmt delete-stmt-limited factored-select-stmt insert-stmt select-stmt simple-select-stmt update-stmt ...
|
Page generated by FTS5 in about 170.46 ms.