SQL As Understood By SQLite

  • R7_990440
    了解作者
  • 1.4MB
    文件大小
  • zip
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-06-04 03:57
    上传日期
SQL As Understood By SQLite SQL As Understood By SQLite SQL As Understood By SQLite SQL As Understood By SQLite SQL As Understood By SQLite
SQL As Understood By SQLite@www.java1234.com.zip
  • SQL As Understood By SQLite@www.java1234.com.pdf
    1.9MB
内容介绍
<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://csdnimg.cn/release/download_crawler_static/css/base.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/11975106/raw.css"><script src="https://csdnimg.cn/release/download_crawler_static/js/compatibility.min.js"></script><script src="https://csdnimg.cn/release/download_crawler_static/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://csdnimg.cn/release/download_crawler_static/11975106/bg1.jpg"><div class="c x0 y1 w2 h0"><div class="t m0 x1 h2 y2 ff1 fs0 fc0 sc0 ls0 ws0">SQL As Understood By SQLite<span class="ff2"> </span></div><div class="t m0 x2 h3 y3 ff3 fs1 fc0 sc0 ls0 ws0">SQLite understands most of the standard SQL lan<span class="_ _0"></span>guage. But it does <span class="_ _1"></span><span class="fc1">omit some features</span> while at the same </div><div class="t m0 x2 h3 y4 ff3 fs1 fc0 sc0 ls0 ws0">time adding a few features of its own. This document attempts to describe precisely what parts of the SQL </div><div class="t m0 x2 h3 y5 ff3 fs1 fc0 sc0 ls0 ws0">language SQLite does and does not support. A <span class="_ _0"></span>list of <span class="_ _1"></span><span class="fc1">SQL keywords</span> is also provided. The SQL language </div><div class="t m0 x2 h3 y6 ff3 fs1 fc0 sc0 ls0 ws0">syntax is described by <span class="fc1">syntax diagrams</span><span class="ls1">. </span> </div><div class="t m0 x2 h3 y7 ff3 fs1 fc0 sc0 ls0 ws0">The following syntax documentation topics are available: </div></div><div class="c x3 y8 w3 h4"><div class="t m0 x4 h5 y9 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">aggregate functions<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 ya ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">ALTER TABLE<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 yb ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">ANALYZE<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 yc ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">ATTACH DATABASE<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 yd ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">BEGIN TRANSACTION<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 ye ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">comment<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 yf ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">COMMIT TRANSACTION<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y10 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">core functions<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y11 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">CREATE INDEX<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y12 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">CREATE TABLE<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y13 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">CREATE TRIGGER<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y14 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">CREATE VIEW<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y15 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">CREATE VIRTUAL TABLE<span class="fc0"> </span></span></span></div></div><div class="c x5 y8 w4 h4"><div class="t m0 x4 h5 y9 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">date and time functions<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 ya ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">DELETE<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 yb ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">DETACH DATABASE<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 yc ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">DROP INDEX<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 yd ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">DROP TABLE<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 ye ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">DROP TRIGGER<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 yf ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">DROP VIEW<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y10 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">END TRANSACTION<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y11 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">EXPLAIN<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y12 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">expression<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y13 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">INDEXED BY<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y14 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">INSERT<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y15 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">keywords<span class="fc0"> </span></span></span></div></div><div class="c x6 y8 w5 h4"><div class="t m0 x4 h5 y9 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">ON CONFLICT clause<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 ya ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">PRAGMA<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 yb ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">REINDEX<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 yc ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">RELEASE SAVEPOINT<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 yd ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">REPLACE<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 ye ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">ROLLBACK TRANSACTION<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 yf ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">SAVEPOINT<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y10 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">SELECT<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y11 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">UPDATE<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y12 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">UPSERT<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y13 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">VACUUM<span class="fc0"> </span></span></span></div><div class="t m0 x4 h5 y14 ff4 fs2 fc0 sc0 ls0 ws0"><span class="fc2 sc0">o</span><span class="ff5"><span class="fc2 sc0"> </span><span class="_ _2"> </span><span class="ff3 fs1 fc1">WITH clause<span class="fc0"> </span></span></span></div></div><div class="c x0 y1 w2 h0"><div class="t m0 x2 h3 y16 ff3 fs1 fc0 sc0 ls0 ws0">The routines <span class="fc1">sqlite3_prepare_v2()</span><span class="ls1">, </span><span class="fc1">sqlite3_<span class="_ _1"></span>prepare()</span><span class="ls2">, </span><span class="fc1">sqli<span class="_ _1"></span>te3_prepare16()</span><span class="ls1">, </span><span class="fc1">sqlite3_prepare16_v2()</span><span class="ls1">, </span></div><div class="t m0 x2 h3 y17 ff3 fs1 fc1 sc0 ls0 ws0">sqlite3_exec()<span class="fc0">, and </span>sqlite3_get_table()<span class="_ _1"></span><span class="fc0"> accept an SQL statement list (sql-stmt-list) which is a semicolon-</span></div><div class="t m0 x2 h3 y18 ff3 fs1 fc0 sc0 ls0 ws0">separated list of statements. </div><div class="t m0 x2 h6 y19 ff2 fs1 fc1 sc0 ls0 ws0">sql-stmt-list:<span class="ff3 fc0"> </span></div><div class="t m0 x7 h3 y1a ff3 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y1b ff3 fs1 fc0 sc0 ls0 ws0">Each SQL statement in the statement list is an instance of the following: </div><div class="t m0 x2 h6 y1c ff2 fs1 fc1 sc0 ls0 ws0">sql-stmt:<span class="ff3 fc0"> </span></div></div><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div></body></html>
评论
    相关推荐
    • SQLite SQL语法中文手册
      SQLite SQL语法中文手册 SQLite是个轻便的数据库,不太适合网络环境,但是使用还是很方便的。
    • SQLiteSQL语法
      SQLiteSQL语法 SQLite库可以解析大部分标准SQL语言。但它也省去了一些特性 并且加入了一些自己的新特性。这篇文档就是试图描述那些SQLite支持/不支持的SQL语法的。
    • Sqlite sql 语法
      Sqlite sql 语法 Sqlite sql 语法
    • sqlite sql 语法
      sqlite sql 语法的一个简单的介绍。入门学习使用。
    • SQLite Sql语法参考手册
      提供一个详细的SQLite Sql语法手册,供各位使用.对于有兴趣使用嵌入式数据库的同仁来说谅是一个不错的参考书.
    • sqlite sql 语法(chm版)
      sqlite sql 语法(chm版) SQLite库可以解析大部分标准SQL语言。但它也省去了一些特性 并且加入了一些自己的新特性。
    • Sqlite SQL基本语法汇总
      Sqlite SQL基本语法汇总,在其官方网站及网络整理的。
    • sql server 转换成 sqlite
      sql server 转换成 sqlite
    • SQLite支持的SQL语言
      本资源是SQLite支持的SQL的语法的总结。 已经算是很全。
    • SIM800C_MQTT.rar
      使用SIM800C模块,使用MQTT协议,连接中国移动onenet平台,能实现数据的订阅、发布、存储等