- 聚集函数
- 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,z)
- load_extension(x)
- load_extension(x,y)
- lower(x)
- ltrim(x)
- max(x,…)
- min(x,…)
- nullif(x,y)
- quote(x)
- random()
- randomblob(n)
- replace(x,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,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,…)
- datetime(timestring,…)
- julianday(timestring,…)
- strftime(format,timestring,…)
- 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