聚集函数
avg(X) count(X) count(*) group_concat(x) 返回由所有X的非空值连接成的字符串。如果Y存在则作为分隔符。 group_concat(x,y) max(x) min(x) sum(x) total(x) ALTER TABLE
表重命名 添加新列 不支持列重命名、移除列、添加或移除约束 ANALYZE ATTACH DATABASE BEGIN TRANSACTION 注释
-- /* */ COMMIT TRANSACTION 核心函数
abs(x) chages() coalesce(x,y,…) glob(x,y) ifnull(x,y) hex(x) last_insert_rowid() length(x) like(x,y) like(x,y,z) load_extension(x) load_extension(x,y) lower(x) ltrim(x) max(x,y,…) min(x,y,…) nullif(x,y) quote(x) random() randomblob(n) replace(x,y,z) round(x) round(x,y) rtrim(x) rtrim(x,y) soundex(x) sqlite_compileoption_get(n) sqlite_compileoption_used(x) sqlite_source_id() sqlite_version() substr(x,y,z) substr(x,y) total_changes() trim(x) trim(x,y) typeof(x) upper(x) zeroblob(n) CREATE INDEX CREATE TABLE CREATE TRIGGER CREATE VIEW CREATE VIRTUAL_TABLE 日期和时间函数(http://www.sqlite.org/lang_datefunc.html)
date(timestring, modifier, modifer, …) time(timestring, modifier, modifer, …) datetime(timestring, modifier, modifier, …) julianday(timestring, modifier, modifier, …) strftime(format, timestring, modifier, modifier, …) DELETE DETACH DATABASE DROP INDEX DROP TABLE DROP TRIGGER DROP VIEW END TRANSACTION EXPLAIN 表达式(http://www.sqlite.org/lang_expr.html)
几个字面表达式:NULL,CURRENT_DATE,CURRENT_TIME,CURRENT_TIMESTAMP INDEXED BY INSERT 关键字(http://www.sqlite.org/lang_keywords.html)
想把关键字当作名字来用:'keyword', "keyword", [keyword], `keyword` ON CONFLICT 子句 PRAGMA REINDEX RELEASE SAVEPOINT REPLACE ROLLBACK TRANSACTION SAVEPOINT SELECT UPDATE VACUUM