Syntax Diagrams For SQLite
sql-stmt-list:
![](https://ask.qcloudimg.com/http-save/devdocs/6so5g5bpb6.gif)
参考: sql-stmt
另请参阅:lang.html
sql-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/ls407lzv15.gif)
使用者: 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
alter-table-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/762v6lzwts.gif)
使用者:sql-stmt
参考文献:column-def
另请参阅:lang_altertable.html
analyze-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/bupx2r0bf1.gif)
使用者:sql-stmt
另请参阅:lang_analyze.html
attach-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/goh2rqj3ss.gif)
使用者:sql-stmt
参考文献:expr
另请参阅:lang_attach.html
begin-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/kj1ga3qk6i.gif)
使用者:sql-stmt
另请参阅:lang_transaction.html
commit-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/madrq31rrh.gif)
使用者:sql-stmt
另请参阅:lang_transaction.html
rollback-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/jvusq5hha6.gif)
使用者:sql-stmt
另请参阅:lang_savepoint.html lang_transaction.html
savepoint-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/psi4k0a721.gif)
使用者:sql-stmt
另请参阅:lang_savepoint.html
release-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/f07x1pt7xy.gif)
使用者:sql-stmt
另请参阅:lang_savepoint.html
create-index-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/83ep4zl33h.gif)
使用者:sql-stmt
参考:expr indexed-column
另请参阅:lang_createindex.html partialindex.html
indexed-column:
![](https://ask.qcloudimg.com/http-save/devdocs/j262bjwmlt.gif)
使用者:create-index-stmt table-constraint
参考:expr
另请参阅:lang_createindex.html lang_createtable.html lang_createtable.html#primkeyconst lang_createtable.html#uniqueconst partialindex.html
create-table-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/if77qt7rkf.gif)
使用者:sql-stmt
引用:column-def select-stmt table-constraint
另请参阅:lang_createtable.html
column-def:
![](https://ask.qcloudimg.com/http-save/devdocs/bafyhnmk1w.gif)
使用者:alter-table-stmt create-table-stmt
参考:column-constraint type-name
另请参阅:lang_altertable.html lang_createtable.html lang_createtable.html#tablecoldef
type-name:
![](https://ask.qcloudimg.com/http-save/devdocs/iba0mi3ib5.gif)
使用者:column-def expr
参考文献:signed-number
另见: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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html partialindex html
column-constraint:
![](https://ask.qcloudimg.com/http-save/devdocs/yrzv3l6pbd.gif)
使用者:column-def
引用:conflict-clause expr foreign-key-clause literal-value signed-number
另请参阅:lang_altertable.html lang_createtable.html lang_createtable.html#tablecoldef
signed-number:
![](https://ask.qcloudimg.com/http-save/devdocs/io5g34mly8.gif)
使用者:column-constraint pragma-value type-name
另见: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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html partialindex .html pragma.html#syntax
table-constraint:
![](https://ask.qcloudimg.com/http-save/devdocs/riqvg44gpe.gif)
使用者: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
foreign-key-clause:
![](https://ask.qcloudimg.com/http-save/devdocs/h7vohztljy.gif)
用于:column-constraint table-constraint
另请参阅:lang_altertable.html lang_createtable.html
conflict-clause:
![](https://ask.qcloudimg.com/http-save/devdocs/giuy2tbz7i.gif)
使用者:column-constraint table-constraint
另请参阅:lang_altertable.html lang_conflict.html lang_createtable.html lang_createtable.html#notnullconst
create-trigger-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/7k5qfnljwm.gif)
使用者:sql-stmt
参考:delete-stmt expr insert-stmt select -stmt update-stmt
另请参阅:lang_createtrigger.html
create-view-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/bfbtnw3yhg.gif)
使用者:sql-stmt
参考:select-stmt
另请参阅:lang_createview.html
create-virtual-table-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/yap1fook3s.gif)
使用者:sql-stmt
另请参阅:lang_createvtab.html
with-clause:
![](https://ask.qcloudimg.com/http-save/devdocs/de7yetopc2.gif)
使用者:delete-stmt delete-stmt-limited insert-stmt update-stmt update-stmt-limited
参考文献:cte-table-name select-stmt
另请参阅:lang_createtrigger.html lang_delete.html lang_insert.html lang_update.html lang_with.html
cte-table-name:
![](https://ask.qcloudimg.com/http-save/devdocs/2pyqxhx4ax.gif)
使用者:recursive-cte with-clause
另请参阅:lang_createtrigger.html lang_delete.html lang_insert.html lang_update.html lang_with.html lang_with.html#recursivecte
recursive-cte:
![](https://ask.qcloudimg.com/http-save/devdocs/l0ey33sr1t.gif)
References: cte-table-name
另见:lang_with.html#recursivecte
common-table-expression:
![](https://ask.qcloudimg.com/http-save/devdocs/mgtbzdybgm.gif)
使用者:compound-select-stmt factored-select-stmt select-stmt simple-select-stmt
参考:select-stmt
另见: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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html partialindex html
delete-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/ylx6mx3niq.gif)
使用者:create-trigger-stmt sql-stmt
参考文献:expr qualified-table-name with-clause
另请参阅:lang_createtrigger.html lang_delete.html
delete-stmt-limited:
![](https://ask.qcloudimg.com/http-save/devdocs/qgm61tdslu.gif)
使用者:sql-stmt
参考文献:expr order-term qualified-table-name with-clause
另请参阅:lang_delete.html
detach-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/vi03svqkng.gif)
使用者:sql-stmt
另请参阅:lang_detach.html
drop-index-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/u7oj31cgee.gif)
使用者:sql-stmt
另请参阅:lang_dropindex.html
drop-table-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/hlwamm9w87.gif)
使用者:sql-stmt
另请参阅:lang_droptable.html
drop-trigger-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/8ohj0ev9js.gif)
使用者:sql-stmt
另请参阅:lang_droptrigger.html
drop-view-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/xmur4yjwai.gif)
使用者:sql-stmt
另请参阅:lang_dropview.html
expr:
![](https://ask.qcloudimg.com/http-save/devdocs/a80wuqcumx.gif)
使用者:attach-stmt column-constraint compound-select-stmt create-index-stmt create-trigger-stmt delete-stmt delete-stmt-limited factored-select-stmt indexed-column insert-stmt join-constraint ordering-term result-column select-core select-stmt simple-select-stmt table-constraint table-or-subquery update-stmt update-stmt-limited
引用:literal-value raise-function select-stmt type-name
另见: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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html partialindex html
raise-function:
![](https://ask.qcloudimg.com/http-save/devdocs/whrkks3r8.gif)
使用者:expr
另请参阅: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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update。 html lang_with.html partialindex.html
literal-value:
![](https://ask.qcloudimg.com/http-save/devdocs/ymxrf9se5i.gif)
使用者:column-constraint expr
另见: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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html partialindex html
numeric-literal:
![](https://ask.qcloudimg.com/http-save/devdocs/ipzic0c7xm.gif)
另请参阅:lang_expr.html#litvalue
insert-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/gawjvo8wjk.gif)
使用者:create-trigger-stmt sql-stmt
参考:expr select-stmt with-clause
另请参阅:lang_createtrigger.html lang_insert.html
pragma-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/x9ui8ny5h6.gif)
使用者:sql-stmt
参考文献:pragma-value
另请参阅:pragma.html#syntax
pragma-value:
![](https://ask.qcloudimg.com/http-save/devdocs/n89nee3kqi.gif)
使用者:pragma-stmt
参考文献:signed-number
另请参阅:pragma.html#syntax
reindex-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/c5wq62k0e9.gif)
使用者:sql-stmt
另请参阅:lang_reindex.html
select-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/fvnyiljfks.gif)
使用方法: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
另请参见: 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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html lang_with.html#recursivecte partialindex.html
join-clause:
![](https://ask.qcloudimg.com/http-save/devdocs/fs7rt71d0m.gif)
使用者:select-core select -stmt table-or-subquery
引用:join-constraint join-operator table-or-subquery
另见: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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html partialindex html
select-core:
![](https://ask.qcloudimg.com/http-save/devdocs/h4dbgf34yy.gif)
使用者:compound-select-stmt factored-select-stmt simple-select-stmt
参考:expr join-clause result-column table-or-subquery
另请参阅:lang_select.html lang_select.html#compound lang_select.html#simpleselect
factored-select-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/mxevc5k9hu.gif)
参考文献:common-table-expression compound-operator expr ordering-term select-core
另请参阅:lang_select.html
simple-select-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/2ywk08gtu1.gif)
参考文献:common-table-expression expr order-term select-core
另请参阅:lang_select.html#simpleselect
compound-select-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/zzriuhkxhi.gif)
参考文献:common-table-expression expr order-term select-core
另请参阅:lang_select.html#compound
table-or-subquery:
![](https://ask.qcloudimg.com/http-save/devdocs/depc0enjdx.gif)
使用者:join-clause select-core select-stmt
引用:expr join-clause select-stmt
另见: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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html partialindex.html
result-column:
![](https://ask.qcloudimg.com/http-save/devdocs/7cbj2lr4lv.gif)
使用者:select-core select-stmt
参考文献:expr
另见: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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html partialindex.html
join-operator:
![](https://ask.qcloudimg.com/http-save/devdocs/nib4ujv6vx.gif)
使用者:join-clause
另请参见: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_select.html lang_select.html#compound lang_select.html#fromclause lang_select.html#simpleselect lang_update.html lang_with.html partialindex.html
join-constraint:
![](https://ask.qcloudimg.com/http-save/devdocs/uteyzkbg6y.gif)
使用者:join-clause
参考文献:expr
另请参见: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_select.html lang_select.html#compound lang_select.html#fromclause lang_select.html#simpleselect lang_update.html lang_with.html partialindex.html
ordering-term:
![](https://ask.qcloudimg.com/http-save/devdocs/fj4duema2o.gif)
使用者:compound-select-stmt delete -stmt -restricored-select -stmt select -stmt simple-select-stmt update-stmt-limited
参考文献:expr
另见: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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html partialindex html的
compound-operator:
![](https://ask.qcloudimg.com/http-save/devdocs/68rkdzilef.gif)
使用者:factored-select-stmt select-stmt
另请参见: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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html lang_with.html#recursivecte partialindex.html
update-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/u30jk31654.gif)
使用者:create-trigger-stmt sql-stmt
参考:column-name-list expr qualified-table-name with-clause
另请参阅:lang_createtrigger.html lang_update.html
column-name-list:
![](https://ask.qcloudimg.com/http-save/devdocs/qv0quzfzsm.gif)
使用者:update-stmt update-stmt-limited
另请参阅:lang_createtrigger.html lang_update.html
update-stmt-limited:
![](https://ask.qcloudimg.com/http-save/devdocs/zomfeuvmxk.gif)
使用者:sql-stmt
参考:column-name-list expr order-term qualified-table-name with-clause
另请参阅:lang_update.html
qualified-table-name:
![](https://ask.qcloudimg.com/http-save/devdocs/eq8pd0tptb.gif)
使用者:delete -stmt delete -stmt -required -stmt update-stmt-limited
vacuum-stmt:
![](https://ask.qcloudimg.com/http-save/devdocs/v5mr3hq5fi.gif)
使用者:sql-stmt
comment-syntax:
![](https://ask.qcloudimg.com/http-save/devdocs/ilyvujtj5f.gif)
本文档系腾讯云开发者社区成员共同维护,如有问题请联系 cloudcommunity@tencent.com