title

summary

aliases

关键字

本文介绍 TiDB 的关键字。

/docs-cn/dev/keywords/

/docs-cn/dev/keywords-and-reserved-words/

/docs-cn/dev/reference/sql/language-structure/keywords-and-reserved-words/

关键字

本文介绍 TiDB 的关键字，对保留字和非保留字作出区分，并汇总所有的关键字以供查询使用。

关键字是 SQL 语句中具有特殊含义的单词，例如 SELECT，UPDATE，DELETE 等等。它们之中有的能够直接作为标识符，被称为非保留关键字（简称非保留字），但有需要经过特殊处理才能作为标识符的字，被称为保留关键字（简称保留字）。

对于保留字，必须使用反引号包裹，才能作为标识符被使用。例如：

CREATE TABLE select (a INT);

ERROR 1105 (HY000): line 0 column 19 near " (a INT)" (total length 27)

CREATE TABLE `select` (a INT);

Query OK, 0 rows affected (0.09 sec)

而非保留字则不需要反引号也能直接作为标识符。例如 BEGIN 和 END 是非保留字，以下语句能够正常执行：

CREATE TABLE `select` (BEGIN int, END int);

Query OK, 0 rows affected (0.09 sec)

有一种特殊情况，如果使用了限定符 .，那么也不需要用反引号：

CREATE TABLE test.select (BEGIN int, END int);

Query OK, 0 rows affected (0.08 sec)

下表列出了 TiDB 中所有的关键字。其中保留字用 (R) 来标识。窗口函数的保留字用 (R-Window) 来标识：

{{< tabs-panel "A" "B" "C" "D" "E" "F" "G" "H" "I" "J" "K" "L" "M" "N" "O" "P" "Q" "R" "S" "T" "U" "V" "W" "X" "Y" "Z" >}}

A

ACCOUNT
ACTION
ADD (R)
ADMIN (R)
ADVISE
AFTER
AGAINST
AGO
ALGORITHM
ALL (R)
ALTER (R)
ALWAYS
ANALYZE (R)
AND (R)
ANY
AS (R)
ASC (R)
ASCII
AUTO_ID_CACHE
AUTO_INCREMENT
AUTO_RANDOM
AUTO_RANDOM_BASE
AVG
AVG_ROW_LENGTH

B

BACKEND
BACKUP
BACKUPS
BEGIN
BETWEEN (R)
BIGINT (R)
BINARY (R)
BINDING
BINDINGS
BINLOG
BIT
BLOB (R)
BLOCK
BOOL
BOOLEAN
BOTH (R)
BTREE
BUCKETS (R)
BUILTINS (R)
BY (R)
BYTE

C

CACHE
CANCEL (R)
CAPTURE
CASCADE (R)
CASCADED
CASE (R)
CHAIN
CHANGE (R)
CHAR (R)
CHARACTER (R)
CHARSET
CHECK (R)
CHECKPOINT
CHECKSUM
CIPHER
CLEANUP
CLIENT
CMSKETCH (R)
COALESCE
COLLATE (R)
COLLATION
COLUMN (R)
COLUMNS
COLUMN_FORMAT
COMMENT
COMMIT
COMMITTED
COMPACT
COMPRESSED
COMPRESSION
CONCURRENCY
CONFIG
CONNECTION
CONSISTENT
CONSTRAINT (R)
CONTEXT
CONVERT (R)
CPU
CREATE (R)
CROSS (R)
CSV_BACKSLASH_ESCAPE
CSV_DELIMITER
CSV_HEADER
CSV_NOT_NULL
CSV_NULL
CSV_SEPARATOR
CSV_TRIM_LAST_SEPARATORS
CUME_DIST (R-Window)
CURRENT
CURRENT_DATE (R)
CURRENT_ROLE (R)
CURRENT_TIME (R)
CURRENT_TIMESTAMP (R)
CURRENT_USER (R)
CYCLE

D

DATA
DATABASE (R)
DATABASES (R)
DATE
DATETIME
DAY
DAY_HOUR (R)
DAY_MICROSECOND (R)
DAY_MINUTE (R)
DAY_SECOND (R)
DDL (R)
DEALLOCATE
DECIMAL (R)
DEFAULT (R)
DEFINER
DELAYED (R)
DELAY_KEY_WRITE
DELETE (R)
DENSE_RANK (R-Window)
DEPTH (R)
DESC (R)
DESCRIBE (R)
DIRECTORY
DISABLE
DISCARD
DISK
DISTINCT (R)
DISTINCTROW (R)
DIV (R)
DO
DOUBLE (R)
DRAINER (R)
DROP (R)
DUAL (R)
DUPLICATE
DYNAMIC

E

ELSE (R)
ENABLE
ENCLOSED (R)
ENCRYPTION
END
ENFORCED
ENGINE
ENGINES
ENUM
ERROR
ERRORS
ESCAPE
ESCAPED (R)
EVENT
EVENTS
EVOLVE
EXCEPT (R)
EXCHANGE
EXCLUSIVE
EXECUTE
EXISTS (R)
EXPANSION
EXPIRE
EXPLAIN (R)
EXTENDED

F

FALSE (R)
FAULTS
FIELDS
FILE
FIRST
FIRST_VALUE (R-Window)
FIXED
FLOAT (R)
FLUSH
FOLLOWING
FOR (R)
FORCE (R)
FOREIGN (R)
FORMAT
FROM (R)
FULL
FULLTEXT (R)
FUNCTION

G

GENERAL
GENERATED (R)
GLOBAL
GRANT (R)
GRANTS
GROUP (R)
GROUPS (R-Window)

H

HASH
HAVING (R)
HIGH_PRIORITY (R)
HISTORY
HOSTS
HOUR
HOUR_MICROSECOND (R)
HOUR_MINUTE (R)
HOUR_SECOND (R)

I

IDENTIFIED
IF (R)
IGNORE (R)
IMPORT
IMPORTS
IN (R)
INCREMENT
INCREMENTAL
INDEX (R)
INDEXES
INFILE (R)
INNER (R)
INSERT (R)
INSERT_METHOD
INSTANCE
INT (R)
INT1 (R)
INT2 (R)
INT3 (R)
INT4 (R)
INT8 (R)
INTEGER (R)
INTERVAL (R)
INTO (R)
INVISIBLE
INVOKER
IO
IPC
IS (R)
ISOLATION
ISSUER

J

JOB (R)
JOBS (R)
JOIN (R)
JSON

K

KEY (R)
KEYS (R)
KEY_BLOCK_SIZE
KILL (R)

L

LABELS
LAG (R-Window)
LANGUAGE
LAST
LASTVAL
LAST_BACKUP
LAST_VALUE (R-Window)
LEAD (R-Window)
LEADING (R)
LEFT (R)
LESS
LEVEL
LIKE (R)
LIMIT (R)
LINEAR (R)
LINES (R)
LIST
LOAD (R)
LOCAL
LOCALTIME (R)
LOCALTIMESTAMP (R)
LOCATION
LOCK (R)
LOGS
LONG (R)
LONGBLOB (R)
LONGTEXT (R)
LOW_PRIORITY (R)

M

MASTER
MATCH (R)
MAXVALUE (R)
MAX_CONNECTIONS_PER_HOUR
MAX_IDXNUM
MAX_MINUTES
MAX_QUERIES_PER_HOUR
MAX_ROWS
MAX_UPDATES_PER_HOUR
MAX_USER_CONNECTIONS
MB
MEDIUMBLOB (R)
MEDIUMINT (R)
MEDIUMTEXT (R)
MEMORY
MERGE
MICROSECOND
MINUTE
MINUTE_MICROSECOND (R)
MINUTE_SECOND (R)
MINVALUE
MIN_ROWS
MOD (R)
MODE
MODIFY
MONTH

N

NAMES
NATIONAL
NATURAL (R)
NCHAR
NEVER
NEXT
NEXTVAL
NO
NOCACHE
NOCYCLE
NODEGROUP
NODE_ID (R)
NODE_STATE (R)
NOMAXVALUE
NOMINVALUE
NONE
NOT (R)
NOWAIT
NO_WRITE_TO_BINLOG (R)
NTH_VALUE (R-Window)
NTILE (R-Window)
NULL (R)
NULLS
NUMERIC (R)
NVARCHAR

O

OFFSET
ON (R)
ONLINE
ONLY
ON_DUPLICATE
OPEN
OPTIMISTIC (R)
OPTIMIZE (R)
OPTION (R)
OPTIONALLY (R)
OR (R)
ORDER (R)
OUTER (R)
OUTFILE (R)
OVER (R-Window)

P

PACK_KEYS
PAGE
PARSER
PARTIAL
PARTITION (R)
PARTITIONING
PARTITIONS
PASSWORD
PERCENT_RANK (R-Window)
PER_DB
PER_TABLE
PESSIMISTIC (R)
PLUGINS
PRECEDING
PRECISION (R)
PREPARE
PRE_SPLIT_REGIONS
PRIMARY (R)
PRIVILEGES
PROCEDURE (R)
PROCESS
PROCESSLIST
PROFILE
PROFILES
PUMP (R)

Q

QUARTER
QUERIES
QUERY
QUICK

R

RANGE (R)
RANK (R-Window)
RATE_LIMIT
READ (R)
REAL (R)
REBUILD
RECOVER
REDUNDANT
REFERENCES (R)
REGEXP (R)
REGION (R)
REGIONS (R)
RELEASE (R)
RELOAD
REMOVE
RENAME (R)
REORGANIZE
REPAIR
REPEAT (R)
REPEATABLE
REPLACE (R)
REPLICA
REPLICATION
REQUIRE (R)
RESPECT
RESTORE
RESTORES
RESTRICT (R)
REVERSE
REVOKE (R)
RIGHT (R)
RLIKE (R)
ROLE
ROLLBACK
ROUTINE
ROW (R)
ROWS (R-Window)
ROW_COUNT
ROW_FORMAT
ROW_NUMBER (R-Window)
RTREE

S

SAMPLES (R)
SECOND
SECONDARY_ENGINE
SECONDARY_LOAD
SECONDARY_UNLOAD
SECOND_MICROSECOND (R)
SECURITY
SELECT (R)
SEND_CREDENTIALS_TO_TIKV
SEPARATOR
SEQUENCE
SERIAL
SERIALIZABLE
SESSION
SET (R)
SETVAL
SHARD_ROW_ID_BITS
SHARE
SHARED
SHOW (R)
SHUTDOWN
SIGNED
SIMPLE
SKIP_SCHEMA_FILES
SLAVE
SLOW
SMALLINT (R)
SNAPSHOT
SOME
SOURCE
SPATIAL (R)
SPLIT (R)
SQL (R)
SQL_BIG_RESULT (R)
SQL_BUFFER_RESULT
SQL_CACHE
SQL_CALC_FOUND_ROWS (R)
SQL_NO_CACHE
SQL_SMALL_RESULT (R)
SQL_TSI_DAY
SQL_TSI_HOUR
SQL_TSI_MINUTE
SQL_TSI_MONTH
SQL_TSI_QUARTER
SQL_TSI_SECOND
SQL_TSI_WEEK
SQL_TSI_YEAR
SSL (R)
START
STARTING (R)
STATS (R)
STATS_AUTO_RECALC
STATS_BUCKETS (R)
STATS_HEALTHY (R)
STATS_HISTOGRAMS (R)
STATS_META (R)
STATS_PERSISTENT
STATS_SAMPLE_PAGES
STATUS
STORAGE
STORED (R)
STRAIGHT_JOIN (R)
STRICT_FORMAT
SUBJECT
SUBPARTITION
SUBPARTITIONS
SUPER
SWAPS
SWITCHES
SYSTEM_TIME

T

TABLE (R)
TABLES
TABLESPACE
TABLE_CHECKSUM
TEMPORARY
TEMPTABLE
TERMINATED (R)
TEXT
THAN
THEN (R)
TIDB (R)
TIFLASH (R)
TIKV_IMPORTER
TIME
TIMESTAMP
TINYBLOB (R)
TINYINT (R)
TINYTEXT (R)
TO (R)
TOPN (R)
TRACE
TRADITIONAL
TRAILING (R)
TRANSACTION
TRIGGER (R)
TRIGGERS
TRUE (R)
TRUNCATE
TYPE

U

UNBOUNDED
UNCOMMITTED
UNDEFINED
UNICODE
UNION (R)
UNIQUE (R)
UNKNOWN
UNLOCK (R)
UNSIGNED (R)
UPDATE (R)
USAGE (R)
USE (R)
USER
USING (R)
UTC_DATE (R)
UTC_TIME (R)
UTC_TIMESTAMP (R)

V

VALIDATION
VALUE
VALUES (R)
VARBINARY (R)
VARCHAR (R)
VARCHARACTER (R)
VARIABLES
VARYING (R)
VIEW
VIRTUAL (R)
VISIBLE

W

WARNINGS
WEEK
WEIGHT_STRING
WHEN (R)
WHERE (R)
WIDTH (R)
WINDOW (R-Window)
WITH (R)
WITHOUT
WRITE (R)

X

X509
XOR (R)

Y

YEAR
YEAR_MONTH (R)

Z

ZEROFILL (R)

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

keywords.md

keywords.md

关键字

Files

keywords.md

Latest commit

History

keywords.md

File metadata and controls

关键字