Reserved Keywords

Description

Reserved keywords are words that have special meanings in SQL. Reserved keywords are a special category of keywords; if you want to use them as object identifiers, you must use backticks (`). For example, FROM. For more details on object identifiers, please refer to the Object Identifiers section.

List of Reserved Keywords

• ACCOUNT_LOCK
• ACCOUNT_UNLOCK
• ADD
• ADMIN
• ALL
• ALTER
• ANALYZE
• AND
• ANTI
• APPEND
• AS
• ASC
• AUTO
• BACKEND
• BETWEEN
• BIGINT
• BINARY
• BINLOG
• BY
• CANCEL
• CASE
• CAST
• CHAR
• CHARACTER
• CLEAN
• COLLATE
• COLUMN
• CONSTRAINT_LIGHT_CHANGE_PROCESS
• CREATE
• CROSS
• CUBE
• CURRENT
• DATABASE
• DATABASES
• DECOMMISSION
• DEFAULT
• DELETE
• DESC
• DESCRIBE
• DISK
• DISTINCT
• DISTRIBUTED
• DISTRIBUTION
• DIV
• DOUBLE
• DROP
• DROPP
• DUMP
• DUPLICATE
• ELSE
• ENTER
• EXCEPT
• EXECUTE
• EXISTS
• EXPLAIN
• EXPORT
• EXTENDED
• EXTRACT
• FALSE
• FLOAT
• FOLLOWER
• FOLLOWING
• FOR
• FORCE
• FOREIGN
• FROM
• FRONTEND
• FULL
• FUNCTIONS
• GRANT
• GRANTS
• GROUP
• HAVING
• HLL
• IF
• IN
• INDEX
• INFILE
• INNER
• INSERT
• INSTALL
• INT
• INTEGER
• INTERMEDIATE
• INTERSECT
• INTERVAL
• INTO
• IS
• JOIN
• KEY
• KEYS
• KILL
• LARGEINT
• LATERAL
• LEFT
• LIKE
• LIMIT
• LIST
• LOAD
• LOW_PRIORITY
• MATCH
• MAXVALUE
• MINUS
• NATURAL
• NOT
• NULL
• OBSERVER
• ON
• OR
• ORDER
• OUTER
• OUTFILE
• OVERWRITE
• PARTITION
• PLAY
• PRECEDING
• PREPARE
• PRIMARY
• PROCEDURE
• RANGE
• READ
• REAL
• REBALANCE
• REFERENCES
• REGEXP
• RELEASE
• RENAME
• REPAIR
• REPLICA
• REVOKE
• RIGHT
• ROLE
• ROLES
• ROW
• ROWS
• SCHEMAS
• SELECT
• SEMI
• SET
• SETS
• SHOW
• SIGNED
• SMALLINT
• SQL_BLOCK_RULE
• SUPERUSER
• SWITCH
• SYNC
• SYSTEM
• TABLE
• TABLESAMPLE
• TABLET
• TABLETS
• TERMINATED
• THEN
• TINYINT
• TO
• TRASH
• TRIM
• TRUE
• TYPE_CAST
• UNBOUNDED
• UNINSTALL
• UNION
• UNIQUE
• UNSIGNED
• UPDATE
• USE
• USING
• VALUES
• WHEN
• WHERE
• WHITELIST
• WITH
• WORKLOAD
• WRITE
• XOR