【网学网提醒】:网学会员,鉴于大家对SQLiteSQL语法图十分关注,会员在此为大家搜集整理了“SQLiteSQL语法图”一文,供大家参考学习!
SQLiteSQL语
sql-stmt-list::=sql-stmt[;sql-stmt]*sql-stmt::=EXPLAIN[QUERYPLAN]stmt-belowalter-table-stmt:
图
analyze-stmt:
attach-stmt:
begin-stmt:
commit-stmt:
rollback-stmt:
savepoint-stmt:
release-stmt:
create-index-stmt:
indexed-column:{create-index-stmt;table-constraint}
create-table-stmt:
column-def:{alter-table-stmt;create-table-stmt}
type-name:{column-def;expr}
signed-number:{column-constraint;pragma-value;type-name}
table-constraint:{create-table-stmt}
foreign-key-clause:{column-constraint;table-constraint}
conflict-clause:{column-constraint;table-constraint}
column-constraint:{column-def}
create-trigger-stmt:
create-view-stmt:
create-virtual-table-stmt:
delete-stmt:{create-trigger-stmt;sql-stmt}
delete-stmt-limited:
detach-stmt:
drop-index-stmt:
drop-table-stmt:
drop-trigger-stmt:
drop-view-stmt:
expr:{column-constraint;create-trigger-stmt;delete-stmt;delete-stmt-limited
insert-stmt;
join-constraint;ordering-term;result-column;select-core;table-constraint;update-stmt;update-stmt-limited}
raise-function:{expr}
literal-value:{column-constraint;expr}
numeric-literal:
insert-stmt:{create-trigger-stmt;sql-stmt}
pragma-stmt:
pragma-value:{pragma-stmt}
reindex-stmt:
select-stmt:{create-table-stmt;single-source;sql-stmt}
create-trigger-stmt;
create-view-stmt;
expr;
insert-stmt;
select-core:{select-stmt}
result-column:{select-core}
join-source:{select-core;single-source}
single-source:{join-source}
join-op:{join-source}
join-constraint:{join-source}
ordering-term:{delete-stmt-limited;select-core;select-stmt;update-stmt-limited}
compound-operator:{select-stmt}
update-stmt:{create-trigger-stmt;sql-stmt}
update-stmt-limited:
qualified-table-name:{delete-stmt;delete-stmt-limited;update-stmt;update-stmt-limited}
vacuum-stmt:
comment-syntax: