Sqlite SQL基本语法汇总

  • b9_735083
    了解作者
  • 14KB
    文件大小
  • rar
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-04-11 01:52
    上传日期
Sqlite SQL基本语法汇总,在其官方网站及网络整理的。
SQLITE语法.rar
  • SQLITE语法.doc
    101KB
内容介绍
<html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta charset="utf-8"> <meta name="generator" content="pdf2htmlEX"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <link rel="stylesheet" href="https://static.pudn.com/base/css/base.min.css"> <link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css"> <link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/62763e37bc4cdc30ab11a45d/raw.css"> <script src="https://static.pudn.com/base/js/compatibility.min.js"></script> <script src="https://static.pudn.com/base/js/pdf2htmlEX.min.js"></script> <script> try{ pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({}); }catch(e){} </script> <title></title> </head> <body> <div id="sidebar" style="display: none"> <div id="outline"> </div> </div> <div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/62763e37bc4cdc30ab11a45d/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">ALTER TABLE</div><div class="t m0 x2 h4 y3 ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">&#58881;::=</span></div><div class="t m0 x3 h5 y4 ff4 fs1 fc2 sc0 ls0 ws0">&#58881;&#58882;<span class="_ _0"></span>&#58883;&#58884;&#58885;&#58886;&#58883;<span class="_ _0"></span>&#58881;&#58887;&#58882;&#58884;&#58886;<span class="ff3 fc0">[<span class="ff2 fc1">database-name</span></span>&#58886;<span class="fs2">&#58888;</span><span class="ff3 fc0">]</span>&#58886;<span class="ff2 fc1">table-name<span class="_ _1"></span></span>&#58886;<span class="ff2 fc1">alteration</span></div><div class="t m0 x4 h4 y5 ff2 fs1 fc1 sc0 ls0 ws0">alteration<span class="ff3 fc0">&#58881;::=<span class="_ _2"> </span><span class="ff4 fc2">&#58885;&#58884;&#58889;&#58881;&#58890;&#58884;&#58886;&#58883;<span class="_ _3"></span>&#58891;&#58886;<span class="ff2 fc1">new-table-name</span></span></span></div><div class="t m0 x4 h4 y6 ff2 fs1 fc1 sc0 ls0 ws0">alteration<span class="ff3 fc0">&#58881;::=<span class="_ _2"> </span><span class="ff4 fc2">&#58881;&#58892;&#58892;&#58886;</span>[<span class="ff4 fc2">&#58893;&#58891;&#58882;&#58894;&#58890;&#58889;</span>]<span class="ff4 fc2">&#58886;</span></span>column-def</div><div class="t m0 x1 h6 y7 ff1 fs3 fc0 sc0 ls0 ws0">ATTACH DATABASE</div><div class="t m0 x2 h4 y8 ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">&#58881;::=<span class="_ _2"> </span><span class="ff4 fc2">&#58881;<span class="_ _0"></span>&#58883;&#58883;<span class="_ _3"></span>&#58881;&#58893;&#58895;&#58886;<span class="ff3 fc0">[</span>&#58892;&#58881;<span class="_ _0"></span>&#58883;<span class="_ _4"></span>&#58881;&#58887;&#58881;&#58896;&#58884;<span class="ff3 fc0">]</span>&#58886;<span class="ff2 fc1">database-filename</span>&#58886;<span class="_ _4"></span>&#58881;&#58896;&#58886;<span class="ff2 fc1">database-name</span></span></span></div><div class="t m0 x1 h6 y9 ff1 fs3 fc0 sc0 ls0 ws0">BEGIN TRANSACTION</div><div class="t m0 x2 h4 ya ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">&#58881;::=</span></div><div class="t m0 x3 h7 yb ff4 fs1 fc2 sc0 ls0 ws0">&#58887;&#58884;&#58897;&#58898;&#58889;<span class="_ _5"> </span>&#58886;<span class="ff3 fc0">[</span>&#58886;<span class="_ _5"> </span>&#58892;&#58884;&#58899;&#58884;&#58885;&#58885;&#58884;&#58892;<span class="_ _5"> </span>&#58886;<span class="ff3 fs2 fc0">|</span>&#58886;<span class="_ _5"> </span>&#58898;&#58890;&#58890;&#58884;&#58892;&#58898;&#58881;<span class="_ _0"></span>&#58883;&#58884;<span class="_ _6"> </span>&#58886;<span class="ff3 fs2 fc0">|</span>&#58886;<span class="_ _5"> </span>&#58884;&#58900;&#58893;&#58882;&#58894;&#58896;&#58898;&#58901;&#58884;<span class="_ _5"> </span>&#58886;<span class="ff3 fc0">]</span></div><div class="t m0 x3 h4 yc ff3 fs1 fc0 sc0 ls0 ws0">[<span class="ff4 fc2">&#58883;&#58885;&#58881;&#58889;&#58896;&#58881;&#58893;&#58883;&#58898;&#58891;&#58889;&#58886;</span>[<span class="ff2 fc1">name</span>]]</div><div class="t m0 x2 h4 yd ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">&#58881;::=<span class="_ _2"> </span><span class="ff4 fc2">&#58884;&#58889;&#58892;&#58886;</span>[<span class="ff4 fc2">&#58883;&#58885;&#58881;&#58889;&#58896;&#58881;&#58893;&#58883;&#58898;&#58891;&#58889;&#58886;</span>[</span>name<span class="ff3 fc0">]]</span></div><div class="t m0 x2 h4 ye ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">&#58881;::=<span class="_ _2"> </span><span class="ff4 fc2">&#58893;&#58891;&#58890;&#58890;&#58898;&#58883;&#58886;</span>[<span class="ff4 fc2">&#58883;&#58885;&#58881;&#58889;&#58896;&#58881;&#58893;&#58883;&#58898;&#58891;&#58889;&#58886;</span>[</span>name<span class="ff3 fc0">]]</span></div><div class="t m0 x2 h4 yf ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">&#58881;::=<span class="_ _2"> </span><span class="ff4 fc2">&#58885;&#58891;&#58882;&#58882;&#58887;&#58881;&#58893;&#58902;&#58886;</span>[<span class="ff4 fc2">&#58883;&#58885;&#58881;&#58889;&#58896;&#58881;&#58893;&#58883;&#58898;&#58891;&#58889;&#58886;</span>[</span>name<span class="ff3 fc0">]]</span></div><div class="t m0 x1 h3 y10 ff1 fs0 fc0 sc0 ls0 ws0">comment</div><div class="t m0 x5 h4 y11 ff2 fs1 fc1 sc0 ls0 ws0">comment<span class="ff3 fc0">&#58881;::=</span></div><div class="t m0 x6 h7 y12 ff2 fs1 fc1 sc0 ls0 ws0">SQL-comment<span class="ff4 fc2">&#58886;<span class="ff3 fs2 fc0">|</span>&#58886;</span>C-comment</div><div class="t m0 x2 h4 y13 ff2 fs1 fc1 sc0 ls0 ws0">SQL-comment<span class="ff3 fc0">&#58881;::=<span class="_ _2"> </span><span class="ff4 fc2">&#58903;&#58903;&#58886;</span></span>single-line</div><div class="t m0 x7 h4 y14 ff2 fs1 fc1 sc0 ls0 ws0">C-comment<span class="ff3 fc0">&#58881;::=</span></div><div class="t m0 x6 h5 y15 ff4 fs1 fc2 sc0 ls0 ws0">&#58904;<span class="fs2">&#58905;</span>&#58886;<span class="ff2 fc1">multiple-lines</span>&#58886;<span class="ff3 fc0">[</span><span class="fs2">&#58905;</span>&#58904;<span class="ff3 fc0">]</span></div><div class="t m0 x1 h6 y16 ff1 fs3 fc0 sc0 ls0 ws0">BEGIN TRANSACTION</div><div class="t m0 x2 h4 y17 ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">&#58881;::=</span></div><div class="t m0 x3 h7 y18 ff4 fs1 fc2 sc0 ls0 ws0">&#58887;&#58884;&#58897;&#58898;&#58889;<span class="_ _5"> </span>&#58886;<span class="ff3 fc0">[</span>&#58886;<span class="_ _5"> </span>&#58892;&#58884;&#58899;&#58884;&#58885;&#58885;&#58884;&#58892;<span class="_ _5"> </span>&#58886;<span class="ff3 fs2 fc0">|</span>&#58886;<span class="_ _5"> </span>&#58898;&#58890;&#58890;&#58884;&#58892;&#58898;&#58881;<span class="_ _0"></span>&#58883;&#58884;<span class="_ _6"> </span>&#58886;<span class="ff3 fs2 fc0">|</span>&#58886;<span class="_ _5"> </span>&#58884;&#58900;&#58893;&#58882;&#58894;&#58896;&#58898;&#58901;&#58884;<span class="_ _5"> </span>&#58886;<span class="ff3 fc0">]</span></div><div class="t m0 x3 h4 y19 ff3 fs1 fc0 sc0 ls0 ws0">[<span class="ff4 fc2">&#58883;&#58885;&#58881;&#58889;&#58896;&#58881;&#58893;&#58883;&#58898;&#58891;&#58889;&#58886;</span>[<span class="ff2 fc1">name</span>]]</div><div class="t m0 x2 h4 y1a ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">&#58881;::=<span class="_ _2"> </span><span class="ff4 fc2">&#58884;&#58889;&#58892;&#58886;</span>[<span class="ff4 fc2">&#58883;&#58885;&#58881;&#58889;&#58896;&#58881;&#58893;&#58883;&#58898;&#58891;&#58889;&#58886;</span>[</span>name<span class="ff3 fc0">]]</span></div><div class="t m0 x2 h4 y1b ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">&#58881;::=<span class="_ _2"> </span><span class="ff4 fc2">&#58893;&#58891;&#58890;&#58890;&#58898;&#58883;&#58886;</span>[<span class="ff4 fc2">&#58883;&#58885;&#58881;&#58889;&#58896;&#58881;&#58893;&#58883;&#58898;&#58891;&#58889;&#58886;</span>[</span>name<span class="ff3 fc0">]]</span></div><div class="t m0 x2 h4 y1c ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">&#58881;::=<span class="_ _2"> </span><span class="ff4 fc2">&#58885;&#58891;&#58882;&#58882;&#58887;&#58881;&#58893;&#58902;&#58886;</span>[<span class="ff4 fc2">&#58883;&#58885;&#58881;&#58889;&#58896;&#58881;&#58893;&#58883;&#58898;&#58891;&#58889;&#58886;</span>[</span>name<span class="ff3 fc0">]]</span></div><div class="t m0 x1 h6 y1d ff1 fs3 fc0 sc0 ls0 ws0">COPY</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div> </body> </html>
评论
    相关推荐