W3cubDocs
/
SQLite
W3cubTools
Cheatsheets
About
3.44.2
SQLite
392
C Interface
52
C Interface: Session Module
1
CLI
2
Database File Format
2
Datatypes
1
Dynamic Memory Allocation
1
Foreign Key Constraints
2
Full-Text Search
13
Geopoly
1
How To Corrupt
1
JSON
149
Language
1
Limits
1
Locking and Concurrency
152
Miscellaneous
1
PRAGMA Statements
11
Query Planner
1
R*Tree Module
1
RBU Extension
72
Syntax Diagrams
SQLite Syntax: aggregate-function-invocation
SQLite Syntax: alter-table-stmt
SQLite Syntax: analyze-stmt
SQLite Syntax: attach-stmt
SQLite Syntax: begin-stmt
SQLite Syntax: column-constraint
SQLite Syntax: column-def
SQLite Syntax: column-name-list
SQLite Syntax: comment-syntax
SQLite Syntax: commit-stmt
SQLite Syntax: common-table-expression
SQLite Syntax: compound-operator
SQLite Syntax: compound-select-stmt
SQLite Syntax: conflict-clause
SQLite Syntax: create-index-stmt
SQLite Syntax: create-table-stmt
SQLite Syntax: create-trigger-stmt
SQLite Syntax: create-view-stmt
SQLite Syntax: create-virtual-table-stmt
SQLite Syntax: cte-table-name
SQLite Syntax: delete-stmt
SQLite Syntax: delete-stmt-limited
SQLite Syntax: detach-stmt
SQLite Syntax: drop-index-stmt
SQLite Syntax: drop-table-stmt
SQLite Syntax: drop-trigger-stmt
SQLite Syntax: drop-view-stmt
SQLite Syntax: expr
SQLite Syntax: factored-select-stmt
SQLite Syntax: filter-clause
SQLite Syntax: foreign-key-clause
SQLite Syntax: frame-spec
SQLite Syntax: function-arguments
SQLite Syntax: indexed-column
SQLite Syntax: insert-stmt
SQLite Syntax: join-clause
SQLite Syntax: join-constraint
SQLite Syntax: join-operator
SQLite Syntax: literal-value
SQLite Syntax: numeric-literal
SQLite Syntax: ordering-term
SQLite Syntax: over-clause
SQLite Syntax: pragma-stmt
SQLite Syntax: pragma-value
SQLite Syntax: qualified-table-name
SQLite Syntax: raise-function
SQLite Syntax: recursive-cte
SQLite Syntax: reindex-stmt
SQLite Syntax: release-stmt
SQLite Syntax: result-column
Show more… (22)
1
Tcl Interface
2
Virtual Table Mechanism
11
Write-Ahead Logging
expr
literal-value
bind-parameter
schema-name
.
table-name
.
column-name
unary-operator
expr
expr
binary-operator
expr
function-name
(
DISTINCT
expr
)
filter-clause
over-clause
,
*
(
expr
)
,
CAST
(
expr
AS
type-name
)
expr
COLLATE
collation-name
expr
NOT
LIKE
GLOB
REGEXP
MATCH
expr
expr
ESCAPE
expr
expr
ISNULL
NOTNULL
NOT
NULL
expr
IS
NOT
DISTINCT
FROM
expr
expr
NOT
BETWEEN
expr
AND
expr
expr
NOT
IN
(
select-stmt
)
expr
,
schema-name
.
table-function
(
expr
)
table-name
,
NOT
EXISTS
(
select-stmt
)
CASE
expr
WHEN
expr
THEN
expr
ELSE
expr
END
raise-function
Used by:
aggregate-function-invocation
attach-stmt
column-constraint
compound-select-stmt
create-index-stmt
create-trigger-stmt
delete-stmt
delete-stmt-limited
factored-select-stmt
filter-clause
frame-spec
indexed-column
insert-stmt
join-constraint
ordering-term
over-clause
result-column
returning-clause
select-core
select-stmt
simple-function-invocation
simple-select-stmt
table-constraint
table-or-subquery
update-stmt
update-stmt-limited
upsert-clause
window-defn
window-function-invocation
References:
filter-clause
literal-value
over-clause
raise-function
select-stmt
type-name
See also:
lang_aggfunc.html
lang_altertable.html
lang_attach.html
lang_createindex.html
lang_createtable.html
lang_createtrigger.html
lang_createview.html
lang_delete.html
lang_expr.html
lang_insert.html
lang_returning.html
lang_select.html
lang_update.html
lang_upsert.html
lang_with.html
partialindex.html
SQLite is in the Public Domain.
https://sqlite.org/syntax/expr.html