SQLite速查手册.pdf

All Cheat Sheets Syntax Diagrams For SQLite Basic SQLite Statements: CREATE INDEX CREATE TABLE CREATE TRIGGER CREATE VIEW DELETE INSERT SELECT UPDATE All SQLite Statements: sql-stmt-list : References: sql-stmt See also: lang.html sql-stmt : Used by: sql-stmt-list References: alter-table-stmt analyze-stmt attach-stmt begin-stmt commit-stmt create-index- stmt create-table-stmt create-trigger-stmt create-view-stmt create-virtual-table-stmt delete- stmt delete-stmt-limited detach-stmt drop-index-stmt drop-table-stmt drop-trigger-stmt drop- view-stmt insert-stmt pragma-stmt reindex-stmt release-stmt rollback-stmt savepoint-stmt select-stmt update-stmt update-stmt-limited vacuum-stmt See also: lang.html lang_explain.html alter-table-stmt : Used by: sql-stmt References: column-def See also: lang_altertable.html analyze-stmt : Used by: sql-stmt See also: lang_analyze.html attach-stmt : Used by: sql-stmt See also: lang_attach.html begin-stmt : Used by: sql-stmt See also: lang_transaction.html commit-stmt : Used by: sql-stmt See also: lang_transaction.html rollback-stmt : Used by: sql-stmt See also: lang_savepoint.html lang_transaction.html savepoint-stmt : Used by: sql-stmt See also: lang_savepoint.html release-stmt : Used by: sql-stmt See also: lang_savepoint.html create-index-stmt : Used by: sql-stmt References: indexed-column See also: lang_createindex.html indexed-column : Used by: create-index-stmt table-constraint See also: lang_createindex.html create-table-stmt : Used by: sql-stmt Reference