注意了,不同数据库厂商(MySQL、Oracle、PostgreSQL、SQL Server)的保留字体系不完全相同,但有一个基于 ANSI/ISO 标准的核心保留字集是通用的。
下面我会先给出 ANSI SQL 标准核心保留字:
数据操作(DML)
SELECT, INSERT, UPDATE, DELETE, INTO, VALUES, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET, FETCH, JOIN, ON, LEFT, RIGHT, INNER, OUTER, FULL, CROSS, UNION, ALL, DISTINCT
数据定义(DDL)
CREATE, ALTER, DROP, TRUNCATE, RENAME, TABLE, VIEW, INDEX, CONSTRAINT, PRIMARY, FOREIGN, KEY, UNIQUE, NOT NULL, DEFAULT, CHECK
数据控制(DCL)
GRANT, REVOKE, COMMIT, ROLLBACK, SAVEPOINT, TRANSACTION
条件 / 逻辑
AND, OR, NOT, IN, BETWEEN, LIKE, IS, NULL, EXISTS, CASE, WHEN, THEN, ELSE, END
函数 / 聚合
COUNT, SUM, AVG, MAX, MIN, CAST, CONVERT, AS, COALESCE, NULLIF
其他核心
AS, ASC, DESC, BY, FOR, HAVING, IN, JOIN, ON, USING, WITH, AS, UNION, INTERSECT, EXCEPT, FROM, TO, SET, INTO, WHERE