|
记录一下自己开发ezSqliteAdmin时所掌握的SQLite资料。
SQLite内建语法表
结构定义
CREATE TABLE
创建新表。
语法：
sql-command ::=
CREATE [TEMP | TEMPORARY] TABLE table-name (
column-def [, column-def]*
[, constraint]*
)
sql-command ::=
CREATE [TEMP | TEMPORARY] TABLE [database-name.] table-name AS select-statement
column-def ::=
name [type] [[CONSTRAINT name] column-constraint]*
type ::=
typename |
typename ( number ) |
typename ( number , number )
column-constraint ::=
NOT NULL [ conflict-clause ] |
PRIMARY KEY [sort-order] [ conflict-clause ] |
UNIQUE [ conflict-clause ] |
CHECK ( expr ) [ conflict-clause ] |
DEFAULT value |
COLLATE collation-name
constraint ::=
PRIMARY KEY ( column-list ) [ conflict-clause ] |
UNIQUE ( column-list ) [ conflict-clause ] |
CHECK ( expr ) [ conflict-clause ]
conflict-clause ::=
ON CONFLICT conflict-algorithm
CREATE VIEW
创建一个视图（虚拟表），该表以另一种方式表示一个或多个表中的数据。
语法：
sql-command ::=
CREATE [TEMP | TEMPORARY] VIEW [database-name.] view-name AS select-statement
例子：
CREATE VIEW master_view AS
SELECT * FROM sqlite_master WHERE type=''''view'''';
说明：
创建一个名为master_view的视图，其中包括sqlite_master这个表中的所有视图表。
CREATE TRIGGER
创建触发器，触发器是一种特殊的存储过程，在用户试图对指定的表执行指定的数据修改语句时自动执行。
语法：
sql-statement ::=
CREATE [TEMP | TEMPORARY] TRIGGER trigger-name [ BEFORE | AFTER ]
database-event ON [database-name .] table-name
trigger-action
sql-statement ::=
CREATE [TEMP | TEMPORARY] TRIGGER trigger-name INSTEAD OF
database-event ON [1] [2] [3] [4] 下一页 | 
