SQLite语法备忘录VIP免费

结构定义 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 [database-name.]view-name trigger-action database-event ::= DELETE | INSERT | UPDATE | UPDATE OF column-list trigger-action ::= [ FOR EACH ROW | FOR EACH STATEMENT ][ WHEN expression] BEGIN trigger-step ; [trigger-step ; ]* END trigger-step ::= update-statement|insert-statement| delete-statement|select-statement 例子： CREATE TRIGGER update_customer_address UPDATE OF address ON customers BEGIN...