Android SQLite总结[转载]

傷城~ 2022-05-11 09:54 186阅读 0赞

引用：http://www.cnblogs.com/rockdean/articles/2425843.html

最近在做的项目涉及到了SQLite，大学时没有好好学习数据库，趁这次项目学习总结下。

SQLite是一款轻量级数据库，它的设计目的是嵌入式，而且它占用的资源非常少，在嵌入式设备中，可能只需要几百KB，这也是 Android 系统采用 SQLite 数据库的原因之一。

下面给出SQLite的数据类型。

一般数据采用的固定的静态数据类型，而SQLite采用的是动态数据类型，会根据存入值自动判断。SQLite具有以下五种数据类型：

1.NULL：空值。  
　　2.INTEGER：带符号的整型，具体取决有存入数字的范围大小。  
　　3.REAL：浮点数字，存储为8-byte IEEE浮点数。  
　　4.TEXT：字符串文本。  
　　5.BLOB：二进制对象。

但实际上，sqlite3也接受如下的数据类型：  
 smallint 16 位元的整数。  
 interger 32 位元的整数。  
 decimal(p,s) p 精确值和 s 大小的十进位整数，精确值p是指全部有几个数(digits)大小值，s是指小数点後有几位数。如果没有特别指定，则系统会设为 p=5; s=0 。  
 float  32位元的实数。  
 double  64位元的实数。  
 char(n)  n 长度的字串，n不能超过 254。  
 varchar(n) 长度不固定且其最大长度为 n 的字串，n不能超过 4000。  
 graphic(n) 和 char(n) 一样，不过其单位是两个字元 double-bytes， n不能超过127。这个形态是为了支援两个字元长度的字体，例如中文字。  
 vargraphic(n) 可变长度且其最大长度为 n 的双字元字串，n不能超过 2000  
 date  包含了 年份、月份、日期。  
 time  包含了 小时、分钟、秒。  
 timestamp 包含了 年、月、日、时、分、秒、千分之一秒。

datetime 包含日期时间格式，必须写成'2010-08-05'不能写为'2010-8-5'，否则在读取时会产生错误！

使用SQLite关键是创建一个类，这个类继承自SQLiteOpenHelper，我们自己创建的类必须重写三个方法：构造方法，onCreate()方法和onUpdate()方法。SQLiteDatabase是直接操作数据库的对象。可以通过SQLiteOpenHelper的getWritableDatabase()和getReadableDatabase()这两个方法来或得SQLiteDatabase的对象。根据方法名字可以知道一个是获得可读的，一个是获得可写的。

下面给出一个例子创建一个数据库。

public static class DatabaseHelper extends SQLiteOpenHelper\{  
        public DatabaseHelper(Context context) \{  
            super(context, DATABASE\_NAME, null, DATABASE\_VERSION);  
        \}  
        @Override  
        public void onCreate(SQLiteDatabase db) \{  
            // TODO Auto-generated method stub  
            Log.i("TAG", "create table start...");  
            db.execSQL(TABLECONTACTS);

Log.i("TAG", "create table over...");

@Override  
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) \{  
            // TODO Auto-generated method stub  
            Log.i("TAG", "contactsmanager.db Upgrade...");  
            db.execSQL("DROP TABLE IF EXISTS "+TABLE\_CONTACTS);  
            onCreate(db);  
              
        \}  
          
    \}

为了创建表和索引，需要调用 SQLiteDatabase 的 execSQL() 方法来执行 DDL 语句。如果没有异常，这个方法没有返回值。

例如，你可以执行如下代码：

这条语句会创建一个名为 mytable 的表，表有一个列名为 \_id，并且是主键，这列的值是会自动增长的整数（例如，当你插入一行时，SQLite 会给这列自动赋值），另外还有两列：title( 字符 ) 和 value( 浮点数 )。 SQLite 会自动为主键列创建索引。

通常情况下，第一次创建数据库时创建了表和索引。如果你不需要改变表的 schema，不需要删除表和索引 . 删除表和索引，需要使用 execSQL() 方法调用 DROP INDEX 和 DROP TABLE 语句。

给表添加数据

上面的代码，已经创建了数据库和表，现在需要给表添加数据。有两种方法可以给表添加数据。

像上面创建表一样，你可以使用 execSQL() 方法执行 INSERT, UPDATE, DELETE 等语句来更新表的数据。execSQL() 方法适用于所有不返回结果的 SQL 语句。例如：

另一种方法是使用 SQLiteDatabase 对象的 insert(), update(), delete() 方法。这些方法把 SQL 语句的一部分作为参数。示例如下：

update（）方法有四个参数，分别是表名，表示列名和值的 ContentValues 对象，可选的 WHERE 条件和可选的填充 WHERE 语句的字符串，这些字符串会替换 WHERE 条件中的“？”标记。update() 根据条件，更新指定列的值，所以用 execSQL() 方法可以达到同样的目的。

WHERE 条件和其参数和用过的其他 SQL APIs 类似。例如：

delete() 方法的使用和 update() 类似，使用表名，可选的 WHERE 条件和相应的填充 WHERE 条件的字符串。

对于查询来说，主要是有两种方法：rawQuery和query。

SQLite内建语法表

<table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); color:rgb(0,0,0); font-family:verdana,'ms song',宋体,Arial,微软雅黑,Helvetica,sans-serif; font-size:14.44444465637207px; text-align:left; line-height:25px; width:748.888916015625px"> 
 <tbody style="margin:0px; padding:0px"> 
  <tr style="margin:0px; padding:0px"> 
   <td colspan="2" style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> 结构定义</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> CREATE TABLE</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 创建新表。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px; width:631px; height:525px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-command&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> CREATE [TEMP | TEMPORARY] TABLE table-name (<br style="margin:0px; padding:0px"> &nbsp;&nbsp;&nbsp;&nbsp;column-def [, column-def]*<br style="margin:0px; padding:0px"> &nbsp;&nbsp;&nbsp;&nbsp;[, constraint]*<br style="margin:0px; padding:0px"> )</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-command&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> CREATE [TEMP | TEMPORARY] TABLE [database-name.] table-name AS select-statement</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> column-def&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> name [type] [[CONSTRAINT name] column-constraint]*</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> type&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> typename |<br style="margin:0px; padding:0px"> typename ( number ) |<br style="margin:0px; padding:0px"> typename ( number , number )</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> column-constraint&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> NOT NULL [ conflict-clause ] |<br style="margin:0px; padding:0px"> PRIMARY KEY [sort-order] [ conflict-clause ] |<br style="margin:0px; padding:0px"> UNIQUE [ conflict-clause ] |<br style="margin:0px; padding:0px"> CHECK ( expr ) [ conflict-clause ] |<br style="margin:0px; padding:0px"> DEFAULT value |<br style="margin:0px; padding:0px"> COLLATE collation-name</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> constraint&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> PRIMARY KEY ( column-list ) [ conflict-clause ] |<br style="margin:0px; padding:0px"> UNIQUE ( column-list ) [ conflict-clause ] |<br style="margin:0px; padding:0px"> CHECK ( expr ) [ conflict-clause ]</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> conflict-clause&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> ON CONFLICT conflict-algorithm</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> CREATE VIEW</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 创建一个视图（虚拟表），该表以另一种方式表示一个或多个表中的数据。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-command&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> CREATE [TEMP | TEMPORARY] VIEW [database-name.] view-name AS select-statement</td> 
      </tr> 
     </tbody> 
    </table> <br style="margin:0px; padding:0px"> 例子：<br style="margin:0px; padding:0px"> CREATE VIEW master_view AS<br style="margin:0px; padding:0px"> &nbsp;&nbsp;&nbsp; SELECT * FROM sqlite_master WHERE type='view';<br style="margin:0px; padding:0px"> 说明：<br style="margin:0px; padding:0px"> 创建一个名为master_view的视图，其中包括sqlite_master这个表中的所有视图表。</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> CREATE TRIGGER</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 创建触发器，触发器是一种特殊的存储过程，在用户试图对指定的表执行指定的数据修改语句时自动执行。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> CREATE [TEMP | TEMPORARY] TRIGGER trigger-name [ BEFORE | AFTER ]<br style="margin:0px; padding:0px"> database-event ON [database-name .] table-name<br style="margin:0px; padding:0px"> trigger-action</td> 
      </tr> 
     </tbody> 
    </table> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> CREATE [TEMP | TEMPORARY] TRIGGER trigger-name INSTEAD OF<br style="margin:0px; padding:0px"> database-event ON [database-name .] view-name<br style="margin:0px; padding:0px"> trigger-action</td> 
      </tr> 
     </tbody> 
    </table> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> database-event&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DELETE |&nbsp;<br style="margin:0px; padding:0px"> INSERT |&nbsp;<br style="margin:0px; padding:0px"> UPDATE |&nbsp;<br style="margin:0px; padding:0px"> UPDATE OF column-list</td> 
      </tr> 
     </tbody> 
    </table> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> trigger-action&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> [ FOR EACH ROW | FOR EACH STATEMENT ] [ WHEN expression ]&nbsp;<br style="margin:0px; padding:0px"> BEGIN&nbsp;<br style="margin:0px; padding:0px"> &nbsp;&nbsp;&nbsp;&nbsp;trigger-step ; [ trigger-step ; ]*<br style="margin:0px; padding:0px"> END</td> 
      </tr> 
     </tbody> 
    </table> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> trigger-step&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> update-statement | insert-statement |&nbsp;<br style="margin:0px; padding:0px"> delete-statement | select-statement</td> 
      </tr> 
     </tbody> 
    </table> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 例子：<br style="margin:0px; padding:0px"> CREATE TRIGGER update_customer_address UPDATE OF address ON customers&nbsp;<br style="margin:0px; padding:0px"> &nbsp; BEGIN<br style="margin:0px; padding:0px"> &nbsp;&nbsp;&nbsp; UPDATE orders SET address = new.address WHERE customer_name = old.name;<br style="margin:0px; padding:0px"> &nbsp; END;<br style="margin:0px; padding:0px"> 说明：<br style="margin:0px; padding:0px"> 创建了一个名为update_customer_address的触发器，当用户更新customers表中的address字段时，将触发并更新orders表中的address字段为新的值。<br style="margin:0px; padding:0px"> 比如执行如下一条语句：<br style="margin:0px; padding:0px"> UPDATE customers SET address = '1 Main St.' WHERE name = 'Jack Jones';<br style="margin:0px; padding:0px"> 数据库将自动执行如下语句：<br style="margin:0px; padding:0px"> UPDATE orders SET address = '1 Main St.' WHERE customer_name = 'Jack Jones';</p> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> CREATE INDEX</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 为给定表或视图创建索引。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> CREATE [UNIQUE] INDEX index-name&nbsp;<br style="margin:0px; padding:0px"> ON [database-name .] table-name ( column-name [, column-name]* )<br style="margin:0px; padding:0px"> [ ON CONFLICT conflict-algorithm ]</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> column-name&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> name [ COLLATE collation-name] [ ASC | DESC ]</td> 
      </tr> 
     </tbody> 
    </table> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 例子：<br style="margin:0px; padding:0px"> CREATE INDEX&nbsp;idx_email ON customers (email);<br style="margin:0px; padding:0px"> 说明：<br style="margin:0px; padding:0px"> 为customers表中的email创建一个名为idx_email的字段。</p> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td colspan="2" style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> 结构删除</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DROP TABLE</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 删除表定义及该表的所有索引。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-command&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DROP TABLE [database-name.] table-name</td> 
      </tr> 
     </tbody> 
    </table> 例子：<br style="margin:0px; padding:0px"> DROP TABLE customers;</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DROP VIEW</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 删除一个视图。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-command&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DROP VIEW view-name</td> 
      </tr> 
     </tbody> 
    </table> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 例子：<br style="margin:0px; padding:0px"> DROP VIEW master_view;</p> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DROP TRIGGER</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 删除一个触发器。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DROP TRIGGER [database-name .] trigger-name</td> 
      </tr> 
     </tbody> 
    </table> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 例子：<br style="margin:0px; padding:0px"> DROP TRIGGER update_customer_address;</p> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DROP INDEX</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 删除一个索引。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-command&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DROP INDEX [database-name .] index-name</td> 
      </tr> 
     </tbody> 
    </table> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 例子：<br style="margin:0px; padding:0px"> DROP INDEX idx_email;</p> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td colspan="2" style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> 数据操作</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> INSERT</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 将新行插入到表。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> INSERT [OR conflict-algorithm] INTO [database-name .] table-name [(column-list)] VALUES(value-list) |<br style="margin:0px; padding:0px"> INSERT [OR conflict-algorithm] INTO [database-name .] table-name [(column-list)] select-statement</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> UPDATE</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 更新表中的现有数据。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> UPDATE [ OR conflict-algorithm ] [database-name .] table-name<br style="margin:0px; padding:0px"> SET assignment [, assignment]*<br style="margin:0px; padding:0px"> [WHERE expr]</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> assignment&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> column-name = expr</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DELETE</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 从表中删除行。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DELETE FROM [database-name .] table-name [WHERE expr]</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> SELECT</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 从表中检索数据。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> SELECT [ALL | DISTINCT] result [FROM table-list]<br style="margin:0px; padding:0px"> [WHERE expr]<br style="margin:0px; padding:0px"> [GROUP BY expr-list]<br style="margin:0px; padding:0px"> [HAVING expr]<br style="margin:0px; padding:0px"> [compound-op select]*<br style="margin:0px; padding:0px"> [ORDER BY sort-expr-list]<br style="margin:0px; padding:0px"> [LIMIT integer [( OFFSET | , ) integer]]</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> result&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> result-column [, result-column]*</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> result-column&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> * | table-name . * | expr [ [AS] string ]</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> table-list&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> table [join-op table join-args]*</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> table&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> table-name [AS alias] |<br style="margin:0px; padding:0px"> ( select ) [AS alias]</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> join-op&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> , | [NATURAL] [LEFT | RIGHT | FULL] [OUTER | INNER | CROSS] JOIN</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> join-args&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> [ON expr] [USING ( id-list )]</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sort-expr-list&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> expr [sort-order] [, expr [sort-order]]*</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sort-order&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> [ COLLATE collation-name ] [ ASC | DESC ]</td> 
      </tr> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> compound_op&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> UNION | UNION ALL | INTERSECT | EXCEPT</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> REPLACE</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 类似INSERT</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> REPLACE INTO [database-name .] table-name [( column-list )] VALUES ( value-list ) |<br style="margin:0px; padding:0px"> REPLACE INTO [database-name .] table-name [( column-list )] select-statement</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td colspan="2" style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> 事务处理</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> BEGIN TRANSACTION</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 标记一个事务的起始点。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> BEGIN [TRANSACTION [name]]</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> END TRANSACTION</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 标记一个事务的终止。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> END [TRANSACTION [name]]</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> COMMIT TRANSACTION</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 标志一个事务的结束。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> COMMIT [TRANSACTION [name]]</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> ROLLBACK TRANSACTION</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 将事务回滚到事务的起点。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> ROLLBACK [TRANSACTION [name]]</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td colspan="2" style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> 其他操作</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> COPY</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 主要用于导入大量的数据。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> COPY [ OR conflict-algorithm ] [database-name .] table-name FROM filename<br style="margin:0px; padding:0px"> [ USING DELIMITERS delim ]</td> 
      </tr> 
     </tbody> 
    </table> 例子：<br style="margin:0px; padding:0px"> COPY&nbsp;customers FROM customers.csv;</td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> EXPLAIN</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> EXPLAIN sql-statement</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> PRAGMA</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> PRAGMA name [= value] |<br style="margin:0px; padding:0px"> PRAGMA function(arg)</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> VACUUM</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> VACUUM [index-or-table-name]</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> ATTACH DATABASE</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 附加一个数据库到当前的数据库连接。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-statement&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> ATTACH [DATABASE] database-filename AS database-name</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
  <tr style="margin:0px; padding:0px"> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DETTACH DATABASE</td> 
   <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 从当前的数据库分离一个使用ATTACH DATABASE附加的数据库。</p> <p style="margin-top:0px; margin-bottom:10px; padding-top:0px; padding-bottom:0px; text-indent:2em"> 语法：</p> 
    <table style="margin:0px; padding:0px; border-collapse:collapse; border-spacing:0px; border:1px solid rgb(192,192,192); line-height:25px"> 
     <tbody style="margin:0px; padding:0px"> 
      <tr style="margin:0px; padding:0px"> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> sql-command&nbsp;::=</td> 
       <td style="margin:0px; padding:3px; border:1px solid rgb(192,192,192); border-collapse:collapse; word-break:normal!important"> DETACH [DATABASE] database-name</td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
 </tbody> 
</table>

SQLite内建函数表