记录一下自己开发ezSqliteAdmin时所掌握的SQLite资料。
SQLite内建语法表
创建新表。
语法: 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
创建一个视图(虚拟表),该表以另一种方式表示一个或多个表中的数据。
语法: 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这个表中的所有视图表。
创建触发器,触发器是一种特殊的存储过程,在用户试图对指定的表执行指定的数据修改语句时自动执行。
语法: sql-statement ::= CREATE [TEMP | TEMPORARY] TRIGGER trigger-name [ BEFORE | AFTER ]database-event ON [database-name .] table-nametrigger-action sql-statement ::= CREATE [TEMP | TEMPORARY] TRIGGER trigger-name INSTEAD OFdatabase-event ON
[1] [2] [3] [4] 下一页
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18