小巧。快速。可靠。
三选二。

SQLite 语法图

聚合函数调用

aggregate-func ( DISTINCT expr ) filter-clause , * ORDER BY ordering-term ,


引用：   expr   filter-clause   ordering-term

另请参见：   lang_aggfunc.html   lang_expr.html#*funcinexpr

修改表语句

ALTER TABLE schema-name . table-name RENAME TO new-table-name RENAME COLUMN column-name TO new-column-name ADD COLUMN column-def DROP COLUMN column-name
使用于：   sql-stmt

引用：   column-def

另请参见：   lang_altertable.html

分析语句

ANALYZE schema-name . table-or-index-name schema-name index-or-table-name
使用于：   sql-stmt

另请参见：   lang_analyze.html

附加语句

ATTACH DATABASE expr AS schema-name
使用于：   sql-stmt

引用：   expr

另请参见：   lang_attach.html

开始语句

BEGIN EXCLUSIVE TRANSACTION DEFERRED IMMEDIATE
使用于：   sql-stmt

另请参见：   lang_transaction.html

列约束

CONSTRAINT name PRIMARY KEY DESC conflict-clause AUTOINCREMENT ASC NOT NULL conflict-clause UNIQUE conflict-clause CHECK ( expr ) DEFAULT ( expr ) literal-value signed-number COLLATE collation-name foreign-key-clause GENERATED ALWAYS AS ( expr ) VIRTUAL STORED
使用于：   column-def

引用：   conflict-clause   expr   foreign-key-clause   literal-value   signed-number

另请参见：   gencol.html   lang_altertable.html   lang_createtable.html   lang_createtable.html#tablecoldef

列定义

column-name type-name column-constraint
使用于：   alter-table-stmt   create-table-stmt

引用：   column-constraint   type-name

另请参见：   lang_altertable.html   lang_altertable.html#altertabaddcol   lang_createtable.html   lang_createtable.html#tablecoldef

列名列表

( column-name ) ,
使用于：   update-stmt   update-stmt-limited   upsert-clause

另请参见：   lang_createtrigger.html   lang_insert.html   lang_update.html   lang_upsert.html

注释语法

-- anything-except-newline newline end-of-input /* anything-except-*/ */


另请参见：   lang_comment.html

提交语句

COMMIT TRANSACTION END
使用于：   sql-stmt

另请参见：   lang_transaction.html

通用表表达式

table-name ( column-name ) AS NOT MATERIALIZED ( select-stmt ) ,
使用于：   compound-select-stmt   delete-stmt   delete-stmt-limited   factored-select-stmt   insert-stmt   select-stmt   simple-select-stmt   update-stmt   update-stmt-limited

引用：   select-stmt

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

复合运算符

UNION UNION INTERSECT EXCEPT ALL
使用于：   factored-select-stmt   select-stmt

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

复合选择语句

WITH RECURSIVE common-table-expression , select-core ORDER BY LIMIT expr UNION UNION ALL select-core INTERSECT EXCEPT ordering-term , OFFSET expr , expr


引用：   common-table-expression   expr   ordering-term   select-core

另请参见：   lang_select.html#compound

冲突子句

ON CONFLICT ROLLBACK ABORT FAIL IGNORE REPLACE
使用于：   column-constraint   table-constraint

另请参见：   lang_altertable.html   lang_conflict.html   lang_createtable.html   lang_createtable.html#notnullconst

创建索引语句

CREATE UNIQUE INDEX IF NOT EXISTS schema-name . index-name ON table-name ( indexed-column ) , WHERE expr
使用于：   sql-stmt

引用：   expr   indexed-column

另请参见：   lang_createindex.html   partialindex.html

创建表语句

CREATE TEMP TEMPORARY TABLE IF NOT EXISTS schema-name . table-name ( column-def table-constraint , ) table-options , AS select-stmt
使用于：   sql-stmt

引用：   column-def   select-stmt   table-constraint   table-options

另请参见：   lang_createtable.html

创建触发器语句

CREATE TEMP TEMPORARY TRIGGER IF NOT EXISTS schema-name . trigger-name BEFORE AFTER INSTEAD OF DELETE INSERT UPDATE OF column-name , ON table-name FOR EACH ROW WHEN expr BEGIN update-stmt ; END insert-stmt delete-stmt select-stmt
使用于：   sql-stmt

引用：   delete-stmt   expr   insert-stmt   select-stmt   update-stmt

另请参见：   lang_createtrigger.html

创建视图语句

CREATE TEMP TEMPORARY VIEW IF NOT EXISTS schema-name . view-name ( column-name ) AS select-stmt ,
使用于：   sql-stmt

引用：   select-stmt

另请参见：   lang_createview.html

创建虚拟表语句

CREATE VIRTUAL TABLE IF NOT EXISTS schema-name . table-name USING module-name ( module-argument ) ,
使用于：   sql-stmt

另请参见：   lang_createvtab.html

CTE 表名

table-name ( column-name ) ,
使用于：   recursive-cte   with-clause

另请参见：   lang_with.html   lang_with.html#recursivecte

删除语句

WITH RECURSIVE common-table-expression , DELETE FROM qualified-table-name returning-clause expr WHERE
使用于：   create-trigger-stmt   sql-stmt

引用：   common-table-expression   expr   qualified-table-name   returning-clause

另请参见：   lang_createtrigger.html   lang_delete.html

受限删除语句

WITH RECURSIVE common-table-expression , DELETE FROM qualified-table-name WHERE expr returning-clause ORDER BY ordering-term , LIMIT expr OFFSET expr , expr
使用于：   sql-stmt

引用：   common-table-expression   expr   ordering-term   qualified-table-name   returning-clause

另请参见：   lang_delete.html

分离语句

DETACH DATABASE schema-name
使用于：   sql-stmt

另请参见：   lang_detach.html

删除索引语句

DROP INDEX IF EXISTS schema-name . index-name
使用于：   sql-stmt

另请参见：   lang_dropindex.html

删除表语句

DROP TABLE IF EXISTS schema-name . table-name
使用于：   sql-stmt

另请参见：   lang_droptable.html

删除触发器语句

DROP TRIGGER IF EXISTS schema-name . trigger-name
使用于：   sql-stmt

另请参见：   lang_droptrigger.html

删除视图语句

DROP VIEW IF EXISTS schema-name . view-name
使用于：   sql-stmt

另请参见：   lang_dropview.html

表达式

literal-value bind-parameter schema-name . table-name . column-name unary-operator expr expr binary-operator expr function-name ( function-arguments ) 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
使用于：   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   function-arguments   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

引用：   filter-clause   function-arguments   literal-value   over-clause   raise-function   select-stmt   type-name

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

分解选择语句

WITH RECURSIVE common-table-expression , select-core ORDER BY LIMIT expr compound-operator ordering-term , OFFSET expr , expr


引用：   common-table-expression   compound-operator   expr   ordering-term   select-core

另请参见：   lang_select.html

过滤子句

FILTER ( WHERE expr )
使用于：   aggregate-function-invocation   expr   window-function-invocation

引用：   expr

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

外键子句

REFERENCES foreign-table ( column-name ) , ON DELETE SET NULL UPDATE SET DEFAULT CASCADE RESTRICT NO ACTION MATCH name NOT DEFERRABLE INITIALLY DEFERRED INITIALLY IMMEDIATE
使用于：   column-constraint   table-constraint

另请参见：   lang_altertable.html   lang_altertable.html#altertabaddcol   lang_createtable.html

窗口规范

GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING RANGE ROWS UNBOUNDED PRECEDING expr PRECEDING CURRENT ROW expr PRECEDING CURRENT ROW expr FOLLOWING expr PRECEDING CURRENT ROW expr FOLLOWING EXCLUDE CURRENT ROW EXCLUDE GROUP EXCLUDE TIES EXCLUDE NO OTHERS
使用于：   over-clause   window-defn

引用：   expr

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

函数参数

DISTINCT expr , * ORDER BY ordering-term ,
使用于：   expr

引用：   expr   ordering-term

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

索引列

column-name COLLATE collation-name DESC expr ASC
使用于：   create-index-stmt   table-constraint   upsert-clause

引用：   expr

另请参见：   lang_createindex.html   lang_createtable.html   lang_createtable.html#primkeyconst   lang_createtable.html#uniqueconst   lang_createtrigger.html   lang_insert.html   lang_upsert.html   partialindex.html

插入语句

WITH RECURSIVE common-table-expression , REPLACE INSERT OR ROLLBACK INTO ABORT FAIL IGNORE REPLACE schema-name . table-name AS alias ( column-name ) , VALUES ( expr ) , , upsert-clause select-stmt upsert-clause DEFAULT VALUES returning-clause
使用于：   create-trigger-stmt   sql-stmt

引用：   common-table-expression   expr   returning-clause   select-stmt   upsert-clause

另请参见：   lang_createtrigger.html   lang_insert.html

连接子句

table-or-subquery join-operator table-or-subquery join-constraint
使用于：   select-core   select-stmt   table-or-subquery   update-stmt   update-stmt-limited

引用：   join-constraint   join-operator   table-or-subquery

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

连接约束

USING ( column-name ) , ON expr
使用于：   join-clause

引用：   expr

另请参见：   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_select.html#compound   lang_select.html#fromclause   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

连接运算符

NATURAL LEFT OUTER JOIN , RIGHT FULL INNER CROSS
使用于：   join-clause

另请参见：   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_select.html#compound   lang_select.html#fromclause   lang_select.html#nonstd   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

字面量值

CURRENT_TIMESTAMP numeric-literal string-literal blob-literal NULL TRUE FALSE CURRENT_TIME CURRENT_DATE
使用于：   column-constraint   expr

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

数值字面量

digit _ . E e digit _ . digit _ - digit _ + 0x 0X hexdigit _


另请参见：   lang_expr.html#litvalue

排序项

expr COLLATE collation-name DESC ASC NULLS FIRST NULLS LAST
用于：   aggregate-function-invocation   compound-select-stmt   delete-stmt-limited   factored-select-stmt   function-arguments   over-clause   select-stmt   simple-select-stmt   update-stmt-limited   window-defn

引用：   expr

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

over-clause

OVER window-name ( base-window-name PARTITION BY expr , ORDER BY ordering-term , frame-spec )
使用于：   expr

引用：   expr   frame-spec   ordering-term

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

pragma-stmt

PRAGMA schema-name . pragma-name ( pragma-value ) = pragma-value
使用于：   sql-stmt

引用：   pragma-value

另请参阅：   pragma.html#syntax

pragma-value

signed-number name signed-literal
用于：   pragma-stmt

引用：   signed-number

另请参阅：   pragma.html#syntax

qualified-table-name

schema-name . table-name AS alias INDEXED BY index-name NOT INDEXED
用于：   delete-stmt   delete-stmt-limited   update-stmt   update-stmt-limited

另请参阅：   lang_createtrigger.html   lang_delete.html   lang_indexedby.html   lang_update.html

raise-function

RAISE ( ROLLBACK , error-message ) IGNORE ABORT FAIL
使用于：   expr

另请参阅：   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createtrigger.html#raise   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

recursive-cte

cte-table-name AS ( initial-select UNION ALL recursive-select ) UNION


引用：   cte-table-name

另请参阅：   lang_with.html#recursivecte

reindex-stmt

REINDEX schema-name . index-name table-name collation-name
使用于：   sql-stmt

另请参阅：   lang_reindex.html

release-stmt

RELEASE SAVEPOINT savepoint-name
使用于：   sql-stmt

另请参阅：   lang_savepoint.html

result-column

expr AS column-alias * table-name . *
用于：   select-core   select-stmt

引用：   expr

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

returning-clause

RETURNING expr AS column-alias * ,
用于：   delete-stmt   delete-stmt-limited   insert-stmt   update-stmt   update-stmt-limited

引用：   expr

另请参阅：   lang_createtrigger.html   lang_delete.html   lang_insert.html   lang_returning.html   lang_update.html

rollback-stmt

ROLLBACK TRANSACTION TO SAVEPOINT savepoint-name
使用于：   sql-stmt

另请参阅：   lang_savepoint.html   lang_transaction.html

savepoint-stmt

SAVEPOINT savepoint-name
使用于：   sql-stmt

另请参阅：   lang_savepoint.html

select-core

SELECT DISTINCT result-column , ALL FROM table-or-subquery join-clause , WHERE expr GROUP BY expr HAVING expr , WINDOW window-name AS window-defn , VALUES ( expr ) , ,
用于：   compound-select-stmt   factored-select-stmt   simple-select-stmt

引用：   expr   join-clause   result-column   table-or-subquery   window-defn

另请参阅：   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect

select-stmt

WITH RECURSIVE common-table-expression , SELECT DISTINCT result-column , ALL FROM table-or-subquery join-clause , WHERE expr GROUP BY expr HAVING expr , WINDOW window-name AS window-defn , VALUES ( expr ) , , compound-operator select-core ORDER BY LIMIT expr ordering-term , OFFSET expr , expr
用于：   common-table-expression   create-table-stmt   create-trigger-stmt   create-view-stmt   expr   insert-stmt   sql-stmt   table-or-subquery   with-clause

引用：   common-table-expression   compound-operator   expr   join-clause   ordering-term   result-column   table-or-subquery   window-defn

另请参阅：   changes.html#version_3_35_3   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html   releaselog/3_35_3.html   releaselog/3_35_4.html   releaselog/3_35_5.html

signed-number

+ numeric-literal -
用于：   column-constraint   pragma-value   type-name

另请参阅：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html   pragma.html#syntax

simple-function-invocation

simple-func ( expr ) , *


引用：   expr

另请参阅：   lang_corefunc.html   lang_expr.html#*funcinexpr

simple-select-stmt

WITH RECURSIVE common-table-expression , select-core ORDER BY LIMIT expr ordering-term , OFFSET expr , expr


引用：   common-table-expression   expr   ordering-term   select-core

另请参阅：   lang_select.html#simpleselect

sql-stmt

EXPLAIN QUERY PLAN alter-table-stmt analyze-stmt attach-stmt begin-stmt commit-stmt create-index-stmt create-table-stmt create-trigger-stmt create-view-stmt create-virtual-table-stmt delete-stmt delete-stmt-limited detach-stmt drop-index-stmt drop-table-stmt drop-trigger-stmt drop-view-stmt insert-stmt pragma-stmt reindex-stmt release-stmt rollback-stmt savepoint-stmt select-stmt update-stmt update-stmt-limited vacuum-stmt
用于：   sql-stmt-list

引用：   alter-table-stmt   analyze-stmt   attach-stmt   begin-stmt   commit-stmt   create-index-stmt   create-table-stmt   create-trigger-stmt   create-view-stmt   create-virtual-table-stmt   delete-stmt   delete-stmt-limited   detach-stmt   drop-index-stmt   drop-table-stmt   drop-trigger-stmt   drop-view-stmt   insert-stmt   pragma-stmt   reindex-stmt   release-stmt   rollback-stmt   savepoint-stmt   select-stmt   update-stmt   update-stmt-limited   vacuum-stmt

另请参阅：   lang.html   lang_explain.html

sql-stmt-list

sql-stmt ;


引用：   sql-stmt

另请参阅：   lang.html

table-constraint

CONSTRAINT name PRIMARY KEY ( indexed-column ) conflict-clause , UNIQUE CHECK ( expr ) FOREIGN KEY ( column-name ) foreign-key-clause ,
用于：   create-table-stmt

引用：   conflict-clause   expr   foreign-key-clause   indexed-column

另请参阅：   lang_createtable.html   lang_createtable.html#primkeyconst   lang_createtable.html#tablecoldef   lang_createtable.html#uniqueconst

table-options

WITHOUT ROWID STRICT ,
用于：   create-table-stmt

另请参见：   lang_createtable.html

table-or-subquery

schema-name . table-name AS table-alias INDEXED BY index-name NOT INDEXED table-function-name ( expr ) , AS table-alias ( select-stmt ) ( table-or-subquery ) , join-clause
用于：   join-clause   select-core   select-stmt   update-stmt   update-stmt-limited

引用：   expr   join-clause   select-stmt

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

type-name

name ( signed-number , signed-number ) ( signed-number )
用于：   column-def   expr

引用：   signed-number

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

update-stmt

WITH RECURSIVE common-table-expression , UPDATE OR ROLLBACK qualified-table-name OR REPLACE OR IGNORE OR FAIL OR ABORT SET column-name-list = expr column-name , FROM table-or-subquery , join-clause WHERE expr returning-clause
使用于：   create-trigger-stmt   sql-stmt

引用：   column-name-list   common-table-expression   expr   join-clause   qualified-table-name   returning-clause   table-or-subquery

另请参阅：   lang_createtrigger.html   lang_update.html

update-stmt-limited

WITH RECURSIVE common-table-expression , UPDATE OR ROLLBACK qualified-table-name OR REPLACE OR IGNORE OR FAIL OR ABORT SET column-name-list = expr column-name , FROM table-or-subquery , join-clause WHERE expr returning-clause ORDER BY ordering-term , LIMIT expr OFFSET expr , expr
使用于：   sql-stmt

引用：   column-name-list   common-table-expression   expr   join-clause   ordering-term   qualified-table-name   returning-clause   table-or-subquery

另请参阅：   lang_update.html#upfrom

upsert-clause

ON CONFLICT ( indexed-column ) WHERE expr DO , conflict target UPDATE SET column-name-list = expr WHERE expr NOTHING , column-name
用于：   insert-stmt

引用：   column-name-list   expr   indexed-column

另请参阅：   lang_createtrigger.html   lang_insert.html   lang_upsert.html

vacuum-stmt

VACUUM schema-name INTO filename
使用于：   sql-stmt

另请参阅：   lang_vacuum.html

window-defn

( base-window-name PARTITION BY expr , ORDER BY ordering-term , frame-spec )
用于：   select-core   select-stmt   window-function-invocation

引用：   expr   frame-spec   ordering-term

另请参见：   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_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

window-function-invocation

window-func ( expr ) filter-clause OVER window-name window-defn , *


引用：   expr   filter-clause   window-defn

另请参阅：   lang_expr.html#*funcinexpr

with-clause

WITH RECURSIVE cte-table-name AS NOT MATERIALIZED ( select-stmt ) MATERIALIZED ,


引用：   cte-table-name   select-stmt

另请参阅：   lang_with.html

此页面上次修改于 2022-01-08 05:02:57 UTC