Keywords
The SQL contains reserved keywords and non-reserved keywords. Standards require that reserved keywords not be used as other identifiers. Non-reserved keywords have special meanings only in a specific environment and can be used as identifiers in other environments. Based on reserved and non-reserved keywords, M-compatible further defines the application scope of keywords as identifiers and provides the four more types of keywords.
- Reserved: Common reserved keywords cannot be used as identifiers of any database objects, such as tables, columns, functions, types, views, indexes, and variables.
- Non-reserved: Common non-reserved keywords can be used as identifiers of any database object.
- Reserved (which can be a function or type): Special reserved keywords can be used as identifiers of functions and variables.
- Non-reserved (which cannot be a function or type): Special non-reserved keywords cannot be used as identifiers of functions and variables.
Constraint differences:
- For detailed constraint differences in keyword implementation, see "MySQL Compatibility Description > M-compatible Mode > SQL > Keywords" in Compatibility Description.
- Currently, the non-reserved keywords have the following restrictions when being used as the identifier of a database object:
Keywords such as BEGIN, BY, CLOSE, CURSOR, DECLARE, DELETE, EXECUTE, FUNCTION, IF, IMMEDIATE, INSERT, LOOP, MOVE, OF, REF, RELEASE, RETURN, SAVEPOINT, STRICT, TYPE, and UPDATE without backquotes cannot be used as variable names.
- Reserved keywords and the following keywords cannot be directly used as column aliases (that is, usage similar to SELECT 1 BIGINT may cause errors):
BETWEEN, BIGINT, BLOB, CHAR, CHARACTER, CROSS, DEC, DECIMAL, DIV, DOUBLE, EXISTS, FLOAT, FLOAT4, FLOAT8, GROUPING, INNER, INOUT, INT, INT1, INT2, INT3, INT4, INT8, INTEGER, JOIN, LEFT, LIKE, LONGBLOB, LONGTEXT, MEDIUMBLOB, MEDIUMINT, MEDIUMTEXT, MOD, NATURAL, NUMERIC, OUT, OUTER, PRECISION, REAL, RIGHT, ROW, ROW_NUMBER, SIGNED, SMALLINT, SOUNDS, TINYBLOB, TINYINT, TINYTEXT, VALUES, VARCHAR, VARYING, and WITHOUT.
SQL Keywords
|
Keyword |
Type |
|---|---|
|
ABSOLUTE |
Non-reserved |
|
ACCESSIBLE |
Reserved |
|
ACCOUNT |
Non-reserved |
|
ACTION |
Non-reserved |
|
ACTIVE |
Non-reserved |
|
ADD |
Non-reserved |
|
ADDDATE |
Non-reserved |
|
ADMIN |
Non-reserved |
|
AFTER |
Non-reserved |
|
AGAINST |
Non-reserved |
|
AGGREGATE |
Non-reserved |
|
ALGORITHM |
Non-reserved |
|
ALL |
Reserved |
|
ALTER |
Non-reserved |
|
ALWAYS |
Non-reserved |
|
ANALYZE |
Reserved |
|
AND |
Reserved |
|
ANY |
Reserved |
|
APPEND |
Non-reserved |
|
ARRAY |
Reserved |
|
AS |
Reserved |
|
ASC |
Reserved |
|
ASCII |
Non-reserved |
|
ASENSITIVE |
Reserved |
|
ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS |
Non-reserved |
|
AT |
Non-reserved |
|
ATTRIBUTE |
Non-reserved |
|
AUTHID |
Non-reserved |
|
AUTHENTICATION |
Non-reserved |
|
AUTHORIZATION |
Non-reserved |
|
AUTO_INCREMENT |
Non-reserved |
|
AUTOEXTEND_SIZE |
Non-reserved |
|
AVG |
Non-reserved |
|
AVG_ROW_LENGTH |
Non-reserved |
|
BACKUP |
Non-reserved |
|
BEFORE |
Non-reserved |
|
BEGIN |
Non-reserved |
|
BEGIN_NON_ANOYBLOCK |
Non-reserved |
|
BETWEEN |
Non-reserved (cannot be functions or types) |
|
BIGINT |
Non-reserved (cannot be functions or types) |
|
BINARY |
Reserved |
|
BINLOG |
Non-reserved |
|
BIT |
Non-reserved (cannot be functions or types) |
|
BLOB |
Non-reserved (cannot be functions or types) |
|
BLOCK |
Non-reserved |
|
BOOL |
Non-reserved (cannot be functions or types) |
|
BOOLEAN |
Non-reserved (cannot be functions or types) |
|
BOTH |
Reserved |
|
BTREE |
Non-reserved |
|
BUCKETS |
Non-reserved |
|
BULK |
Non-reserved |
|
BY |
Non-reserved |
|
BYTE |
Non-reserved |
|
CACHE |
Non-reserved |
|
CALL |
Non-reserved |
|
CALLED |
Non-reserved |
|
CASCADE |
Non-reserved |
|
CASCADED |
Non-reserved |
|
CASE |
Reserved |
|
CAST |
Non-reserved |
|
CATALOG_NAME |
Non-reserved |
|
CHAIN |
Non-reserved |
|
CHALLENGE_RESPONSE |
Non-reserved |
|
CHANGE |
Non-reserved |
|
CHANGED |
Non-reserved |
|
CHANNEL |
Non-reserved |
|
CHAR |
Non-reserved (cannot be functions or types) |
|
CHARACTER |
Non-reserved (cannot be functions or types) |
|
CHARSET |
Non-reserved |
|
CHECK |
Reserved |
|
CHECKPOINT |
Non-reserved |
|
CHECKSUM |
Non-reserved |
|
CIPHER |
Non-reserved |
|
CLASS_ORIGIN |
Non-reserved |
|
CLEAN |
Non-reserved |
|
CLIENT |
Non-reserved |
|
CLONE |
Non-reserved |
|
CLOSE |
Non-reserved |
|
CLUSTER |
Non-reserved |
|
COALESCE |
Non-reserved |
|
CODE |
Non-reserved |
|
COLLATE |
Reserved |
|
COLLATION |
Non-reserved |
|
COLUMN |
Reserved |
|
COLUMN_FORMAT |
Non-reserved |
|
COLUMN_NAME |
Non-reserved |
|
COLUMNS |
Non-reserved |
|
COMMENT |
Non-reserved |
|
COMMIT |
Non-reserved |
|
COMMITTED |
Non-reserved |
|
COMPACT |
Reserved (functions and types allowed) |
|
COMPLETION |
Non-reserved |
|
COMPONENT |
Non-reserved |
|
COMPRESSED |
Non-reserved |
|
COMPRESSION |
Non-reserved |
|
CONCURRENT |
Non-reserved |
|
CONCURRENTLY |
Reserved (functions and types allowed) |
|
CONDITION |
Non-reserved |
|
CONNECTION |
Non-reserved |
|
CONSISTENT |
Non-reserved |
|
CONSTRAINT |
Reserved |
|
CONSTRAINT_CATALOG |
Non-reserved |
|
CONSTRAINT_NAME |
Non-reserved |
|
CONSTRAINT_SCHEMA |
Non-reserved |
|
CONSTRAINTS |
Non-reserved |
|
CONTAINS |
Non-reserved |
|
CONTEXT |
Non-reserved |
|
CONTINUE |
Non-reserved |
|
CONVERT |
Non-reserved |
|
COORDINATOR |
Non-reserved |
|
COORDINATORS |
Non-reserved |
|
COPY |
Non-reserved |
|
COST |
Non-reserved |
|
COUNT |
Non-reserved |
|
CPU |
Non-reserved |
|
CREATE |
Reserved |
|
CROSS |
Reserved (functions and types allowed) |
|
CSV |
Non-reserved |
|
CUBE |
Non-reserved |
|
CUME_DIST |
Reserved |
|
CURRENT |
Non-reserved |
|
CURRENT_DATE |
Reserved |
|
CURRENT_SCHEMA |
Reserved (functions and types allowed) |
|
CURRENT_TIME |
Reserved |
|
CURRENT_TIMESTAMP |
Reserved |
|
CURRENT_USER |
Reserved |
|
CURSOR |
Non-reserved |
|
CURSOR_NAME |
Non-reserved |
|
CURTIME |
Non-reserved |
|
CYCLE |
Non-reserved |
|
DATA |
Non-reserved |
|
DATABASE |
Non-reserved |
|
DATABASES |
Reserved |
|
DATAFILE |
Non-reserved |
|
DATANODE |
Non-reserved |
|
DATANODES |
Non-reserved |
|
DATE |
Non-reserved (cannot be functions or types) |
|
DATE_ADD |
Non-reserved |
|
DATE_FORMAT |
Non-reserved |
|
DATE_SUB |
Non-reserved |
|
DATETIME |
Non-reserved |
|
DAY |
Non-reserved |
|
DAY_HOUR |
Reserved |
|
DAY_MICROSECOND |
Reserved |
|
DAY_MINUTE |
Reserved |
|
DAY_SECOND |
Reserved |
|
DEALLOCATE |
Non-reserved |
|
DEC |
Non-reserved (cannot be functions or types) |
|
DECIMAL |
Non-reserved (cannot be functions or types) |
|
DECLARE |
Non-reserved |
|
DECODE |
Non-reserved |
|
DEFAULT |
Reserved |
|
DEFAULT_AUTH |
Non-reserved |
|
DEFINER |
Non-reserved |
|
DEFINITION |
Non-reserved |
|
DELAY_KEY_WRITE |
Non-reserved |
|
DELAYED |
Reserved |
|
DELETE |
Non-reserved |
|
DELIMITER |
Non-reserved |
|
DENSE_RANK |
Reserved |
|
DESC |
Reserved |
|
DESCRIBE |
Reserved |
|
DESCRIPTION |
Non-reserved |
|
DETERMINISTIC |
Non-reserved |
|
DIAGNOSTICS |
Non-reserved |
|
DICTIONARY |
Non-reserved |
|
DIRECT |
Non-reserved |
|
DIRECTORY |
Non-reserved |
|
DISABLE |
Non-reserved |
|
DISCARD |
Non-reserved |
|
DISK |
Non-reserved |
|
DISTINCT |
Reserved |
|
DISTINCTROW |
Reserved |
|
DISTRIBUTE |
Non-reserved |
|
DISTRIBUTED |
Non-reserved |
|
DIV |
Reserved (functions and types allowed) |
|
DO |
Non-reserved |
|
DOCUMENT |
Non-reserved |
|
DOUBLE |
Non-reserved (cannot be functions or types) |
|
DROP |
Non-reserved |
|
DUAL |
Reserved |
|
DUMPFILE |
Non-reserved |
|
DUPLICATE |
Non-reserved |
|
DYNAMIC |
Non-reserved |
|
EACH |
Non-reserved |
|
ELSE |
Reserved |
|
ELSEIF |
Reserved |
|
EMPTY |
Reserved |
|
ENABLE |
Non-reserved |
|
ENCLOSED |
Non-reserved |
|
ENCRYPTION |
Non-reserved |
|
END |
Non-reserved |
|
ENDS |
Non-reserved |
|
ENFORCED |
Non-reserved |
|
ENGINE |
Non-reserved |
|
ENGINE_ATTRIBUTE |
Non-reserved |
|
ENGINES |
Non-reserved |
|
ENUM |
Non-reserved |
|
ERROR |
Non-reserved |
|
ERRORS |
Non-reserved |
|
ESCAPE |
Non-reserved |
|
ESCAPED |
Non-reserved |
|
EVENT |
Non-reserved |
|
EVENTS |
Non-reserved |
|
EVERY |
Non-reserved |
|
EXCEPT |
Reserved |
|
EXCHANGE |
Non-reserved |
|
EXCLUDE |
Non-reserved |
|
EXECUTE |
Non-reserved |
|
EXISTS |
Non-reserved (cannot be functions or types) |
|
EXIT |
Reserved |
|
EXPANSION |
Non-reserved |
|
EXPIRE |
Non-reserved |
|
EXPIRED |
Non-reserved |
|
EXPLAIN |
Non-reserved |
|
EXPORT |
Non-reserved |
|
EXTENDED |
Non-reserved |
|
EXTENSION |
Non-reserved |
|
EXTENT_SIZE |
Non-reserved |
|
EXTERNAL |
Non-reserved |
|
EXTRACT |
Non-reserved |
|
FACTOR |
Non-reserved |
|
FAILED_LOGIN_ATTEMPTS |
Non-reserved |
|
FALSE |
Reserved |
|
FAST |
Non-reserved |
|
FAULTS |
Non-reserved |
|
FENCED |
Non-reserved |
|
FETCH |
Reserved |
|
FIELDS |
Non-reserved |
|
FILE |
Non-reserved |
|
FILE_BLOCK_SIZE |
Non-reserved |
|
FILTER |
Non-reserved |
|
FINISH |
Non-reserved |
|
FIRST |
Non-reserved |
|
FIRST_VALUE |
Reserved |
|
FIXED |
Non-reserved (cannot be functions or types) |
|
FLOAT |
Non-reserved (cannot be functions or types) |
|
FLOAT4 |
Non-reserved (cannot be functions or types) |
|
FLOAT8 |
Non-reserved (cannot be functions or types) |
|
FLUSH |
Non-reserved |
|
FOLLOWING |
Non-reserved |
|
FOLLOWS |
Non-reserved |
|
FOR |
Reserved |
|
FORCE |
Reserved |
|
FOREIGN |
Reserved |
|
FORMAT |
Non-reserved |
|
FORWARD |
Non-reserved |
|
FOUND |
Non-reserved |
|
FREEZE |
Reserved (functions and types allowed) |
|
FROM |
Reserved |
|
FULL |
Non-reserved |
|
FULLTEXT |
Reserved |
|
FUNCTION |
Non-reserved |
|
GENERAL |
Non-reserved |
|
GENERATE |
Non-reserved |
|
GENERATED |
Non-reserved |
|
GEOMCOLLECTION |
Non-reserved |
|
GEOMETRY |
Non-reserved |
|
GEOMETRYCOLLECTION |
Non-reserved |
|
GET |
Reserved |
|
GET_FORMAT |
Non-reserved |
|
GET_MASTER_PUBLIC_KEY |
Non-reserved |
|
GET_SOURCE_PUBLIC_KEY |
Non-reserved |
|
GLOBAL |
Non-reserved |
|
GRANT |
Reserved |
|
GRANTED |
Non-reserved |
|
GRANTS |
Non-reserved |
|
GROUP |
Reserved |
|
GROUP_REPLICATION |
Non-reserved |
|
GROUPING |
Non-reserved (cannot be functions or types) |
|
GROUPS |
Reserved |
|
GTID_ONLY |
Non-reserved |
|
HANDLER |
Non-reserved |
|
HASH |
Non-reserved |
|
HAVING |
Reserved |
|
HELP |
Non-reserved |
|
HIGH_PRIORITY |
Reserved |
|
HISTOGRAM |
Non-reserved |
|
HISTORY |
Non-reserved |
|
HOLD |
Non-reserved |
|
HOST |
Non-reserved |
|
HOSTS |
Non-reserved |
|
HOUR |
Non-reserved |
|
HOUR_MICROSECOND |
Reserved |
|
HOUR_MINUTE |
Reserved |
|
HOUR_SECOND |
Reserved |
|
IDENTIFIED |
Non-reserved |
|
IDENTITY |
Non-reserved |
|
IF |
Reserved |
|
IGNORE |
Reserved |
|
IGNORE_SERVER_IDS |
Non-reserved |
|
IMMUTABLE |
Non-reserved |
|
IMPORT |
Non-reserved |
|
IN |
Reserved |
|
INACTIVE |
Non-reserved |
|
INCLUDING |
Non-reserved |
|
INCREMENT |
Non-reserved |
|
INDEX |
Reserved |
|
INDEXES |
Non-reserved |
|
INFILE |
Non-reserved |
|
INITIAL |
Non-reserved |
|
INITIAL_SIZE |
Non-reserved |
|
INITIATE |
Non-reserved |
|
INNER |
Reserved (functions and types allowed) |
|
INOUT |
Non-reserved (cannot be functions or types) |
|
INPUT |
Non-reserved |
|
INSENSITIVE |
Non-reserved |
|
INSERT |
Non-reserved |
|
INSERT_METHOD |
Non-reserved |
|
INSTALL |
Non-reserved |
|
INSTANCE |
Non-reserved |
|
INT |
Non-reserved (cannot be functions or types) |
|
INT1 |
Non-reserved (cannot be functions or types) |
|
INT2 |
Non-reserved (cannot be functions or types) |
|
INT3 |
Non-reserved (cannot be functions or types) |
|
INT4 |
Non-reserved (cannot be functions or types) |
|
INT8 |
Non-reserved (cannot be functions or types) |
|
INTEGER |
Non-reserved (cannot be functions or types) |
|
INTERSECT |
Reserved |
|
INTERVAL |
Reserved |
|
INTO |
Reserved |
|
INVISIBLE |
Non-reserved |
|
INVOKER |
Non-reserved |
|
IO |
Non-reserved |
|
IO_AFTER_GTIDS |
Reserved |
|
IO_BEFORE_GTIDS |
Reserved |
|
IO_THREAD |
Non-reserved |
|
IPC |
Non-reserved |
|
IS |
Reserved |
|
ISNULL |
Non-reserved |
|
ISOLATION |
Non-reserved |
|
ISSUER |
Non-reserved |
|
ITERATE |
Reserved |
|
JOIN |
Reserved (functions and types allowed) |
|
JSON |
Non-reserved |
|
JSON_TABLE |
Reserved |
|
JSON_VALUE |
Non-reserved |
|
KEY |
Reserved |
|
KEY_BLOCK_SIZE |
Non-reserved |
|
KEYRING |
Non-reserved |
|
KEYS |
Reserved |
|
KILL |
Non-reserved |
|
LAG |
Reserved |
|
LANGUAGE |
Non-reserved |
|
LAST |
Non-reserved |
|
LAST_VALUE |
Reserved |
|
LATERAL |
Reserved |
|
LC_COLLATE |
Non-reserved |
|
LEAD |
Reserved |
|
LEADING |
Reserved |
|
LEAKPROOF |
Non-reserved |
|
LEAVE |
Reserved |
|
LEAVES |
Non-reserved |
|
LEFT |
Reserved (functions and types allowed) |
|
LESS |
Non-reserved |
|
LEVEL |
Non-reserved |
|
LIKE |
Reserved (functions and types allowed) |
|
LIMIT |
Reserved |
|
LINEAR |
Reserved |
|
LINES |
Non-reserved |
|
LINESTRING |
Non-reserved |
|
LIST |
Non-reserved |
|
LOAD |
Non-reserved |
|
LOAD_BAD |
Non-reserved |
|
LOAD_DISCARD |
Non-reserved |
|
LOCAL |
Non-reserved |
|
LOCALTIME |
Reserved |
|
LOCALTIMESTAMP |
Reserved |
|
LOCATION |
Non-reserved |
|
LOCK |
Reserved |
|
LOCKED |
Non-reserved |
|
LOCKS |
Non-reserved |
|
LOGFILE |
Non-reserved |
|
LOGS |
Non-reserved |
|
LONG |
Reserved |
|
LONGBLOB |
Non-reserved (cannot be functions or types) |
|
LONGTEXT |
Non-reserved (cannot be functions or types) |
|
LOOP |
Non-reserved |
|
LOW_PRIORITY |
Reserved |
|
MASTER |
Non-reserved |
|
MASTER_AUTO_POSITION |
Non-reserved |
|
MASTER_BIND |
Reserved |
|
MASTER_COMPRESSION_ALGORITHMS |
Non-reserved |
|
MASTER_CONNECT_RETRY |
Non-reserved |
|
MASTER_DELAY |
Non-reserved |
|
MASTER_HEARTBEAT_PERIOD |
Non-reserved |
|
MASTER_HOST |
Non-reserved |
|
MASTER_LOG_FILE |
Non-reserved |
|
MASTER_LOG_POS |
Non-reserved |
|
MASTER_PASSWORD |
Non-reserved |
|
MASTER_PORT |
Non-reserved |
|
MASTER_PUBLIC_KEY_PATH |
Non-reserved |
|
MASTER_RETRY_COUNT |
Non-reserved |
|
MASTER_SSL |
Non-reserved |
|
MASTER_SSL_CA |
Non-reserved |
|
MASTER_SSL_CAPATH |
Non-reserved |
|
MASTER_SSL_CERT |
Non-reserved |
|
MASTER_SSL_CIPHER |
Non-reserved |
|
MASTER_SSL_CRL |
Non-reserved |
|
MASTER_SSL_CRLPATH |
Non-reserved |
|
MASTER_SSL_KEY |
Non-reserved |
|
MASTER_SSL_VERIFY_SERVER_CERT |
Reserved |
|
MASTER_TLS_CIPHERSUITES |
Non-reserved |
|
MASTER_TLS_VERSION |
Non-reserved |
|
MASTER_USER |
Non-reserved |
|
MASTER_ZSTD_COMPRESSION_LEVEL |
Non-reserved |
|
MATCH |
Reserved |
|
MAX_CONNECTIONS_PER_HOUR |
Non-reserved |
|
MAX_QUERIES_PER_HOUR |
Non-reserved |
|
MAX_ROWS |
Non-reserved |
|
MAX_SIZE |
Non-reserved |
|
MAX_UPDATES_PER_HOUR |
Non-reserved |
|
MAX_USER_CONNECTIONS |
Non-reserved |
|
MAXVALUE |
Reserved |
|
MEDIUM |
Non-reserved |
|
MEDIUMBLOB |
Non-reserved (cannot be functions or types) |
|
MEDIUMINT |
Non-reserved (cannot be functions or types) |
|
MEDIUMTEXT |
Non-reserved (cannot be functions or types) |
|
MEMBER |
Non-reserved |
|
MEMORY |
Non-reserved |
|
MERGE |
Non-reserved |
|
MESSAGE_TEXT |
Non-reserved |
|
MICROSECOND |
Non-reserved |
|
MIDDLEINT |
Reserved |
|
MIGRATE |
Non-reserved |
|
MIN_ROWS |
Non-reserved |
|
MINUTE |
Non-reserved |
|
MINUTE_MICROSECOND |
Reserved |
|
MINUTE_SECOND |
Reserved |
|
MINVALUE |
Non-reserved |
|
MOD |
Reserved (functions and types allowed) |
|
MODE |
Non-reserved |
|
MODIFIES |
Reserved |
|
MODIFY |
Non-reserved |
|
MONTH |
Non-reserved |
|
MOVE |
Non-reserved |
|
MULTILINESTRING |
Non-reserved |
|
MULTIPOINT |
Non-reserved |
|
MULTIPOLYGON |
Non-reserved |
|
MUTEX |
Non-reserved |
|
MYSQL_ERRNO |
Non-reserved |
|
NAME |
Non-reserved |
|
NAMES |
Non-reserved |
|
NATIONAL |
Non-reserved (cannot be functions or types) |
|
NATURAL |
Reserved (functions and types allowed) |
|
NCHAR |
Non-reserved (cannot be functions or types) |
|
NDB |
Non-reserved |
|
NDBCLUSTER |
Non-reserved |
|
NESTED |
Non-reserved |
|
NETWORK_NAMESPACE |
Non-reserved |
|
NEVER |
Non-reserved |
|
NEW |
Non-reserved |
|
NEXT |
Non-reserved |
|
NO |
Non-reserved |
|
NO_WAIT |
Non-reserved |
|
NO_WRITE_TO_BINLOG |
Reserved |
|
NOCYCLE |
Non-reserved |
|
NODE |
Non-reserved |
|
NODEGROUP |
Non-reserved |
|
NOMAXVALUE |
Non-reserved |
|
NOMINVALUE |
Non-reserved |
|
NONE |
Non-reserved |
|
NOT |
Reserved |
|
NOTHING |
Non-reserved |
|
NOW |
Non-reserved |
|
NOWAIT |
Non-reserved |
|
NTH_VALUE |
Reserved |
|
NTILE |
Reserved |
|
NULL |
Reserved |
|
NULLS |
Non-reserved |
|
NUMBER |
Non-reserved (cannot be functions or types) |
|
NUMERIC |
Non-reserved (cannot be functions or types) |
|
NVARCHAR |
Non-reserved (cannot be functions or types) |
|
OF |
Non-reserved |
|
OFF |
Non-reserved |
|
OFFSET |
Reserved |
|
OIDS |
Non-reserved |
|
OJ |
Non-reserved |
|
OLD |
Non-reserved |
|
ON |
Reserved |
|
ONE |
Non-reserved |
|
ONLY |
Reserved |
|
OPEN |
Non-reserved |
|
OPERATOR |
Non-reserved |
|
OPTIMIZE |
Reserved |
|
OPTIMIZE_COSTS |
Reserved |
|
OPTION |
Non-reserved |
|
OPTIONAL |
Non-reserved |
|
OPTIONALLY |
Non-reserved |
|
OPTIONS |
Non-reserved |
|
OR |
Reserved |
|
ORDER |
Reserved |
|
ORDINALITY |
Non-reserved |
|
ORGANIZATION |
Non-reserved |
|
OTHERS |
Non-reserved |
|
OUT |
Non-reserved (cannot be functions or types) |
|
OUTER |
Reserved (functions and types allowed) |
|
OUTFILE |
Non-reserved |
|
OVER |
Non-reserved |
|
OWNED |
Non-reserved |
|
OWNER |
Non-reserved |
|
PACK_KEYS |
Non-reserved |
|
PAGE |
Non-reserved |
|
PARSER |
Non-reserved |
|
PARTIAL |
Non-reserved |
|
PARTITION |
Non-reserved |
|
PARTITIONING |
Non-reserved |
|
PARTITIONS |
Non-reserved |
|
PASSWORD |
Non-reserved |
|
PASSWORD_LOCK_TIME |
Non-reserved |
|
PATH |
Non-reserved |
|
PERCENT_RANK |
Reserved |
|
PERSIST |
Non-reserved |
|
PERSIST_ONLY |
Non-reserved |
|
PHASE |
Non-reserved |
|
PLUGIN |
Non-reserved |
|
PLUGINS |
Non-reserved |
|
PLUGIN_DIR |
Non-reserved |
|
POINT |
Non-reserved |
|
POLYGON |
Non-reserved |
|
PORT |
Non-reserved |
|
PRECEDES |
Non-reserved |
|
PRECEDING |
Non-reserved |
|
PRECISION |
Non-reserved (cannot be functions or types) |
|
PREPARE |
Non-reserved |
|
PREPARED |
Non-reserved |
|
PRESERVE |
Non-reserved |
|
PREV |
Non-reserved |
|
PRIMARY |
Reserved |
|
PRIVILEGES |
Non-reserved |
|
PRIVILEGE_CHECKS_USER |
Non-reserved |
|
PROCEDURE |
Reserved |
|
PROCESS |
Non-reserved |
|
PROCESSLIST |
Non-reserved |
|
PROFILE |
Non-reserved |
|
PROFILES |
Non-reserved |
|
PROXY |
Non-reserved |
|
PURGE |
Non-reserved |
|
QUARTER |
Non-reserved |
|
QUERY |
Non-reserved |
|
QUICK |
Non-reserved |
|
RANDOM |
Non-reserved |
|
RANGE |
Non-reserved |
|
RANK |
Reserved |
|
READ |
Reserved |
|
READS |
Reserved |
|
READ_ONLY |
Non-reserved |
|
READ_WRITE |
Reserved |
|
REAL |
Non-reserved (cannot be functions or types) |
|
REBUILD |
Non-reserved |
|
RECOVER |
Non-reserved |
|
RECURSIVE |
Non-reserved |
|
RECYCLEBIN |
Non-reserved |
|
REDO_BUFFER_SIZE |
Non-reserved |
|
REDUNDANT |
Non-reserved |
|
REFERENCE |
Non-reserved |
|
REFERENCES |
Reserved |
|
REGEXP |
Reserved |
|
REGISTRATION |
Non-reserved |
|
REINDEX |
Non-reserved |
|
RELATIVE |
Non-reserved |
|
RELAY |
Non-reserved |
|
RELAYLOG |
Non-reserved |
|
RELAY_LOG_FILE |
Non-reserved |
|
RELAY_LOG_POS |
Non-reserved |
|
RELAY_THREAD |
Non-reserved |
|
RELEASE |
Non-reserved |
|
RELOAD |
Non-reserved |
|
REMOVE |
Non-reserved |
|
RENAME |
Non-reserved |
|
REORGANIZE |
Non-reserved |
|
REPAIR |
Non-reserved |
|
REPEAT |
Reserved |
|
REPEATABLE |
Non-reserved |
|
REPLACE |
Non-reserved |
|
REPLICA |
Non-reserved |
|
REPLICAS |
Non-reserved |
|
REPLICATE_DO_DB |
Non-reserved |
|
REPLICATE_DO_TABLE |
Non-reserved |
|
REPLICATE_IGNORE_DB |
Non-reserved |
|
REPLICATE_IGNORE_TABLE |
Non-reserved |
|
REPLICATE_REWRITE_DB |
Non-reserved |
|
REPLICATE_WILD_DO_TABLE |
Non-reserved |
|
REPLICATE_WILD_IGNORE_TABLE |
Non-reserved |
|
REPLICATION |
Non-reserved |
|
REQUIRE |
Reserved |
|
REQUIRE_ROW_FORMAT |
Non-reserved |
|
REQUIRE_TABLE_PRIMARY_KEY_CHECK |
Non-reserved |
|
RESET |
Non-reserved |
|
RESIGNAL |
Reserved |
|
RESOURCE |
Non-reserved |
|
RESPECT |
Non-reserved |
|
RESTART |
Non-reserved |
|
RESTORE |
Non-reserved |
|
RESTRICT |
Non-reserved |
|
RESUME |
Non-reserved |
|
RETAIN |
Non-reserved |
|
RETURN |
Non-reserved |
|
RETURNED_SQLSTATE |
Non-reserved |
|
RETURNING |
Reserved |
|
RETURNS |
Non-reserved |
|
REUSE |
Non-reserved |
|
REVERSE |
Non-reserved |
|
REVOKE |
Non-reserved |
|
RIGHT |
Reserved (functions and types allowed) |
|
RLIKE |
Reserved |
|
ROLE |
Non-reserved |
|
ROLLBACK |
Non-reserved |
|
ROLLUP |
Non-reserved |
|
ROTATE |
Non-reserved |
|
ROUTINE |
Non-reserved |
|
ROW |
Non-reserved (cannot be functions or types) |
|
ROWS |
Non-reserved |
|
ROW_COUNT |
Non-reserved |
|
ROW_FORMAT |
Non-reserved |
|
ROW_NUMBER |
Reserved (functions and types allowed) |
|
RTREE |
Non-reserved |
|
SAVEPOINT |
Non-reserved |
|
SCHEDULE |
Non-reserved |
|
SCHEMA |
Non-reserved |
|
SCHEMAS |
Reserved |
|
SCHEMA_NAME |
Non-reserved |
|
SCROLL |
Non-reserved |
|
SECOND |
Non-reserved |
|
SECOND_MICROSECOND |
Reserved |
|
SECONDARY |
Non-reserved |
|
SECONDARY_ENGINE |
Non-reserved |
|
SECONDARY_ENGINE_ATTRIBUTE |
Non-reserved |
|
SECONDARY_LOAD |
Non-reserved |
|
SECONDARY_UNLOAD |
Non-reserved |
|
SECURITY |
Non-reserved |
|
SELECT |
Reserved |
|
SENSITIVE |
Reserved |
|
SEPARATOR |
Non-reserved |
|
SEQUENCE |
Non-reserved |
|
SERIAL |
Non-reserved |
|
SERIALIZABLE |
Non-reserved |
|
SERVER |
Non-reserved |
|
SESSION |
Non-reserved |
|
SET |
Non-reserved |
|
SETOF |
Non-reserved (cannot be functions or types) |
|
SHARE |
Non-reserved |
|
SHIPPABLE |
Non-reserved |
|
SHOW |
Non-reserved |
|
SHUTDOWN |
Non-reserved |
|
SIGNAL |
Reserved |
|
SIGNED |
Non-reserved |
|
SIMPLE |
Non-reserved |
|
SIZE |
Non-reserved |
|
SKIP |
Non-reserved |
|
SLAVE |
Non-reserved |
|
SLICE |
Non-reserved |
|
SLICEGROUP |
Non-reserved |
|
SLOW |
Non-reserved |
|
SMALLDATETIME |
Non-reserved (cannot be functions or types) |
|
SMALLDATETIME_FORMAT |
Non-reserved |
|
SMALLINT |
Non-reserved (cannot be functions or types) |
|
SNAPSHOT |
Non-reserved |
|
SOCKET |
Non-reserved |
|
SOME |
Reserved |
|
SONAME |
Non-reserved |
|
SOUNDS |
Non-reserved |
|
SOURCE |
Non-reserved |
|
SOURCE_AUTO_POSITION |
Non-reserved |
|
SOURCE_BIND |
Non-reserved |
|
SOURCE_COMPRESSION_ALGORITHMS |
Non-reserved |
|
SOURCE_CONNECTION_AUTO_FAILOVER |
Non-reserved |
|
SOURCE_CONNECT_RETRY |
Non-reserved |
|
SOURCE_DELAY |
Non-reserved |
|
SOURCE_HEARTBEAT_PERIOD |
Non-reserved |
|
SOURCE_HOST |
Non-reserved |
|
SOURCE_LOG_FILE |
Non-reserved |
|
SOURCE_LOG_POS |
Non-reserved |
|
SOURCE_PASSWORD |
Non-reserved |
|
SOURCE_PORT |
Non-reserved |
|
SOURCE_PUBLIC_KEY_PATH |
Non-reserved |
|
SOURCE_RETRY_COUNT |
Non-reserved |
|
SOURCE_SSL |
Non-reserved |
|
SOURCE_SSL_CA |
Non-reserved |
|
SOURCE_SSL_CAPATH |
Non-reserved |
|
SOURCE_SSL_CERT |
Non-reserved |
|
SOURCE_SSL_CIPHER |
Non-reserved |
|
SOURCE_SSL_CRL |
Non-reserved |
|
SOURCE_SSL_CRLPATH |
Non-reserved |
|
SOURCE_SSL_KEY |
Non-reserved |
|
SOURCE_SSL_VERIFY_SERVER_CERT |
Non-reserved |
|
SOURCE_TLS_CIPHERSUITES |
Non-reserved |
|
SOURCE_TLS_VERSION |
Non-reserved |
|
SOURCE_USER |
Non-reserved |
|
SOURCE_ZSTD_COMPRESSION_LEVEL |
Non-reserved |
|
SPATIAL |
Reserved |
|
SPECIFIC |
Reserved |
|
SPLIT |
Non-reserved |
|
SQL |
Non-reserved |
|
SQLEXCEPTION |
Reserved |
|
SQLSTATE |
Reserved |
|
SQLWARNNING |
Reserved |
|
SQL_AFTER_GTIDS |
Non-reserved |
|
SQL_AFTER_MTS_GAPS |
Non-reserved |
|
SQL_BEFORE_GTIDS |
Non-reserved |
|
SQL_BIG_RESULT |
Reserved |
|
SQL_BUFFER_RESULT |
Non-reserved |
|
SQL_CALC_FOUND_ROWS |
Reserved |
|
SQL_NO_CACHE |
Reserved |
|
SQL_SMALL_RESULT |
Non-reserved |
|
SQL_THREAD |
Non-reserved |
|
SQL_TSI_DAY |
Non-reserved |
|
SQL_TSI_HOUR |
Non-reserved |
|
SQL_TSI_MINUTE |
Non-reserved |
|
SQL_TSI_MONTH |
Non-reserved |
|
SQL_TSI_QUARTER |
Non-reserved |
|
SQL_TSI_SECOND |
Non-reserved |
|
SQL_TSI_WEEK |
Non-reserved |
|
SQL_TSI_YEAR |
Non-reserved |
|
SRID |
Non-reserved |
|
SSL |
Reserved |
|
STABLE |
Non-reserved |
|
STACKED |
Non-reserved |
|
START |
Non-reserved |
|
STARTING |
Non-reserved |
|
STARTS |
Non-reserved |
|
STATS_AUTO_RECALC |
Non-reserved |
|
STATS_PERSISTENT |
Non-reserved |
|
STATS_SAMPLE_PAGES |
Non-reserved |
|
STATUS |
Non-reserved |
|
STDIN |
Non-reserved |
|
STDOUT |
Non-reserved |
|
STOP |
Non-reserved |
|
STORAGE |
Non-reserved |
|
STORED |
Non-reserved |
|
STRAIGHT_JOIN |
Reserved |
|
STREAM |
Non-reserved |
|
STRICT |
Non-reserved |
|
STRING |
Non-reserved |
|
SUBCLASS_ORIGIN |
Non-reserved |
|
SUBDATE |
Non-reserved |
|
SUBJECT |
Non-reserved |
|
SUBPARTITION |
Non-reserved |
|
SUBPARTITIONS |
Non-reserved |
|
SUBSTR |
Non-reserved |
|
SUBSTRING |
Non-reserved |
|
SUPER |
Non-reserved |
|
SUSPEND |
Non-reserved |
|
SWAPS |
Non-reserved |
|
SWITCHES |
Non-reserved |
|
SYSDATE |
Non-reserved |
|
SYSTEM |
Non-reserved |
|
TABLE |
Reserved |
|
TABLES |
Non-reserved |
|
TABLESPACE |
Non-reserved |
|
TABLE_CHECKSUM |
Non-reserved |
|
TABLE_NAME |
Non-reserved |
|
TEMPORARY |
Non-reserved |
|
TEMPTABLE |
Non-reserved |
|
TERMINATED |
Non-reserved |
|
TEXT |
Non-reserved (cannot be functions or types) |
|
THAN |
Non-reserved |
|
THEN |
Reserved |
|
THREAD_PRIORITY |
Non-reserved |
|
TIES |
Non-reserved |
|
TIME |
Non-reserved (cannot be functions or types) |
|
TIMESTAMP |
Non-reserved (cannot be functions or types) |
|
TIMESTAMPADD |
Non-reserved |
|
TIMESTAMPDIFF |
Non-reserved |
|
TINYBLOB |
Non-reserved (cannot be functions or types) |
|
TINYINT |
Non-reserved (cannot be functions or types) |
|
TINYTEXT |
Non-reserved (cannot be functions or types) |
|
TLS |
Non-reserved |
|
TO |
Reserved |
|
TRAILING |
Reserved |
|
TRANSACTION |
Non-reserved |
|
TRIGGER |
Reserved |
|
TRIGGERS |
Non-reserved |
|
TRIM |
Non-reserved |
|
TRUE |
Reserved |
|
TRUNCATE |
Non-reserved |
|
TYPE |
Non-reserved |
|
TYPES |
Non-reserved |
|
UNBOUNDED |
Non-reserved |
|
UNCOMMITTED |
Non-reserved |
|
UNDEFINED |
Non-reserved |
|
UNDO |
Reserved |
|
UNDOFILE |
Non-reserved |
|
UNDO_BUFFER_SIZE |
Non-reserved |
|
UNICODE |
Non-reserved |
|
UNINSTALL |
Non-reserved |
|
UNION |
Reserved |
|
UNIQUE |
Reserved |
|
UNKNOWN |
Non-reserved |
|
UNLOCK |
Non-reserved |
|
UNLOGGED |
Non-reserved |
|
UNREGISTER |
Non-reserved |
|
UNSIGNED |
Reserved |
|
UNTIL |
Non-reserved |
|
UNUSABLE |
Non-reserved |
|
UPDATE |
Non-reserved |
|
UPGRADE |
Non-reserved |
|
URL |
Non-reserved |
|
USAGE |
Non-reserved |
|
USE |
Reserved |
|
USER |
Reserved |
|
USER_RESOURCES |
Non-reserved |
|
USE_FRM |
Non-reserved |
|
USING |
Reserved |
|
UTC_DATE |
Reserved |
|
UTC_TIME |
Reserved |
|
UTC_TIMESTAMP |
Reserved |
|
VACUUM |
Non-reserved |
|
VALID |
Non-reserved |
|
VALIDATION |
Non-reserved |
|
VALUE |
Non-reserved |
|
VALUES |
Non-reserved (cannot be functions or types) |
|
VARBINARY |
Reserved |
|
VARCHAR |
Non-reserved (cannot be functions or types) |
|
VARCHAR2 |
Non-reserved (cannot be functions or types) |
|
VARCHARACTER |
Non-reserved (cannot be functions or types) |
|
VARIABLES |
Non-reserved |
|
VARYING |
Non-reserved |
|
VCPU |
Non-reserved |
|
VERBOSE |
Reserved (functions and types allowed) |
|
VERSION |
Non-reserved |
|
VIEW |
Non-reserved |
|
VIRTUAL |
Reserved |
|
VISIBLE |
Non-reserved |
|
VOLATILE |
Non-reserved |
|
WAIT |
Non-reserved |
|
WARNINGS |
Non-reserved |
|
WEEK |
Non-reserved |
|
WEIGHT_STRING |
Non-reserved |
|
WHEN |
Reserved |
|
WHERE |
Reserved |
|
WHILE |
Reserved |
|
WINDOW |
Reserved |
|
WITH |
Reserved |
|
WITHIN |
Non-reserved |
|
WITHOUT |
Non-reserved |
|
WORKComments |
Non-reserved |
|
WRAPPER |
Non-reserved |
|
WRITE |
Reserved |
|
X509 |
Non-reserved |
|
XA |
Non-reserved |
|
XID |
Non-reserved |
|
XML |
Non-reserved |
|
XOR |
Reserved |
|
YEAR |
Non-reserved (cannot be functions or types) |
|
YEAR_MONTH |
Reserved |
|
ZEROFILL |
Reserved |
|
ZONE |
Non-reserved |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
