SQLite 理解的 SQL
[*]聚集函数
[*]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`
[*]ON CONFLICT 子句
[*]PRAGMA
[*]REINDEX
[*]RELEASE SAVEPOINT
[*]REPLACE
[*]ROLLBACK TRANSACTION
[*]SAVEPOINT
[*]SELECT
[*]UPDATE
[*]VACUUM
页:
[1]