📄 syntaxdiagrams.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><html><head><title>SQLite SQL Language Syntax Diagrams</title><style type="text/css">body { margin: auto; font-family: "Verdana" "sans-serif"; padding: 8px 1%;}a { color: #45735f }a:visited { color: #734559 }.logo { position:absolute; margin:3px; }.tagline { float:right; text-align:right; font-style:italic; width:240px; margin:12px; margin-top:58px;}.toolbar { font-variant: small-caps; text-align: center; line-height: 1.6em; margin: 0; padding:1px 8px;}.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }.toolbar a:visited { color: white; }.toolbar a:hover { color: #80a796; background: white; }.content { margin: 5%; }.content dt { font-weight:bold; }.content dd { margin-bottom: 25px; margin-left:20%; }.content ul { padding:0px; padding-left: 15px; margin:0px; }/* rounded corners */.se { background: url(images/se.png) 100% 100% no-repeat #80a796}.sw { background: url(images/sw.png) 0% 100% no-repeat }.ne { background: url(images/ne.png) 100% 0% no-repeat }.nw { background: url(images/nw.png) 0% 0% no-repeat }</style><meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head><body><div><!-- container div to satisfy validator --><a href="index.html"><img class="logo" src="images/SQLite.gif" alt="SQLite Logo" border="0"></a><div><!-- IE hack to prevent disappearing logo--></div><div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div><table width=100% style="clear:both"><tr><td> <div class="se"><div class="sw"><div class="ne"><div class="nw"> <div class="toolbar"> <a href="about.html">About</a> <a href="sitemap.html">Sitemap</a> <a href="docs.html">Documentation</a> <a href="download.html">Download</a> <a href="copyright.html">License</a> <a href="news.html">News</a> <a href="http://www.sqlite.org/cvstrac/index">Developers</a> <a href="support.html">Support</a> </div></div></div></div></div></td></tr></table> <h1>SQLite SQL Language Syntax Diagrams</h1><a name="sql-stmt-list"></a><h4>sql-stmt-list:</h4><blockquote><img src="images/syntax/sql-stmt-list.gif"></img><br></br><br></br>References: <a href="#sql-stmt">sql-stmt</a></blockquote><a name="sql-stmt"></a><h4>sql-stmt:</h4><blockquote><img src="images/syntax/sql-stmt.gif"></img><br></br>Used by: <a href="#sql-stmt-list">sql-stmt-list</a><br></br>References: <a href="#alter-table-stmt">alter-table-stmt</a> <a href="#analyze-stmt">analyze-stmt</a> <a href="#attach-stmt">attach-stmt</a> <a href="#begin-stmt">begin-stmt</a> <a href="#commit-stmt">commit-stmt</a> <a href="#create-index-stmt">create-index-stmt</a> <a href="#create-table-stmt">create-table-stmt</a> <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#create-view-stmt">create-view-stmt</a> <a href="#create-virtual-table-stmt">create-virtual-table-stmt</a> <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#detach-stmt">detach-stmt</a> <a href="#drop-index-stmt">drop-index-stmt</a> <a href="#drop-table-stmt">drop-table-stmt</a> <a href="#drop-trigger-stmt">drop-trigger-stmt</a> <a href="#drop-view-stmt">drop-view-stmt</a> <a href="#insert-stmt">insert-stmt</a> <a href="#pragma-stmt">pragma-stmt</a> <a href="#reindex-stmt">reindex-stmt</a> <a href="#rollback-stmt">rollback-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a> <a href="#vacuum-stmt">vacuum-stmt</a></blockquote><a name="alter-table-stmt"></a><h4>alter-table-stmt:</h4><blockquote><img src="images/syntax/alter-table-stmt.gif"></img><br></br>Used by: <a href="#sql-stmt">sql-stmt</a><br></br>References: <a href="#column-def">column-def</a></blockquote><a name="analyze-stmt"></a><h4>analyze-stmt:</h4><blockquote><img src="images/syntax/analyze-stmt.gif"></img><br></br>Used by: <a href="#sql-stmt">sql-stmt</a></blockquote><a name="attach-stmt"></a><h4>attach-stmt:</h4><blockquote><img src="images/syntax/attach-stmt.gif"></img><br></br>Used by: <a href="#sql-stmt">sql-stmt</a><br></br>References: <a href="#expr">expr</a></blockquote><a name="begin-stmt"></a><h4>begin-stmt:</h4><blockquote><img src="images/syntax/begin-stmt.gif"></img><br></br>Used by: <a href="#sql-stmt">sql-stmt</a></blockquote><a name="commit-stmt"></a><h4>commit-stmt:</h4><blockquote><img src="images/syntax/commit-stmt.gif"></img><br></br>Used by: <a href="#sql-stmt">sql-stmt</a></blockquote><a name="rollback-stmt"></a><h4>rollback-stmt:</h4><blockquote><img src="images/syntax/rollback-stmt.gif"></img><br></br>Used by: <a href="#sql-stmt">sql-stmt</a></blockquote><a name="create-index-stmt"></a><h4>create-index-stmt:</h4><blockquote><img src="images/syntax/create-index-stmt.gif"></img><br></br>Used by: <a href="#sql-stmt">sql-stmt</a><br></br>References: <a href="#indexed-column">indexed-column</a></blockquote><a name="indexed-column"></a><h4>indexed-column:</h4><blockquote><img src="images/syntax/indexed-column.gif"></img><br></br>Used by: <a href="#create-index-stmt">create-index-stmt</a> <a href="#table-constraint">table-constraint</a></blockquote><a name="create-table-stmt"></a><h4>create-table-stmt:</h4><blockquote><img src="images/syntax/create-table-stmt.gif"></img><br></br>Used by: <a href="#sql-stmt">sql-stmt</a><br></br>References: <a href="#column-def">column-def</a> <a href="#select-stmt">select-stmt</a> <a href="#table-constraint">table-constraint</a></blockquote><a name="column-def"></a><h4>column-def:</h4><blockquote><img src="images/syntax/column-def.gif"></img><br></br>Used by: <a href="#alter-table-stmt">alter-table-stmt</a> <a href="#create-table-stmt">create-table-stmt</a><br></br>References: <a href="#column-constraint">column-constraint</a> <a href="#type-name">type-name</a></blockquote><a name="type-name"></a><h4>type-name:</h4><blockquote><img src="images/syntax/type-name.gif"></img><br></br>Used by: <a href="#column-def">column-def</a> <a href="#expr">expr</a><br></br>References: <a href="#signed-number">signed-number</a></blockquote><a name="column-constraint"></a><h4>column-constraint:</h4><blockquote><img src="images/syntax/column-constraint.gif"></img><br></br>Used by: <a href="#column-def">column-def</a><br></br>References: <a href="#conflict-clause">conflict-clause</a> <a href="#expr">expr</a> <a href="#foreign-key-clause">foreign-key-clause</a> <a href="#literal-value">literal-value</a> <a href="#signed-number">signed-number</a></blockquote><a name="signed-number"></a><h4>signed-number:</h4><blockquote><img src="images/syntax/signed-number.gif"></img><br></br>Used by: <a href="#column-constraint">column-constraint</a> <a href="#pragma-value">pragma-value</a> <a href="#type-name">type-name</a></blockquote><a name="table-constraint"></a><h4>table-constraint:</h4><blockquote><img src="images/syntax/table-constraint.gif"></img><br></br>Used by: <a href="#create-table-stmt">create-table-stmt</a><br></br>References: <a href="#conflict-clause">conflict-clause</a> <a href="#expr">expr</a> <a href="#foreign-key-clause">foreign-key-clause</a> <a href="#indexed-column">indexed-column</a></blockquote><a name="foreign-key-clause"></a><h4>foreign-key-clause:</h4><blockquote><img src="images/syntax/foreign-key-clause.gif"></img><br></br>Used by: <a href="#column-constraint">column-constraint</a> <a href="#table-constraint">table-constraint</a></blockquote><a name="conflict-clause"></a><h4>conflict-clause:</h4><blockquote><img src="images/syntax/conflict-clause.gif"></img><br></br>Used by: <a href="#column-constraint">column-constraint</a> <a href="#table-constraint">table-constraint</a></blockquote><a name="create-trigger-stmt"></a><h4>create-trigger-stmt:</h4><blockquote><img src="images/syntax/create-trigger-stmt.gif"></img><br></br>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -