MySQL Server Version Reference  /  Keywords and Reserved Words

Chapter 2 Keywords and Reserved Words

This section contains information on the keywords and reserved words within the server when creating and submitting queries to the system. For more information on reserved words and their impact on your queries, see Chapter 2, Keywords and Reserved Words.

The following table shows all keywords and reserved words available across MySQL Server 5.5 through 8.0. The table contains these columns:

  • Name: The keyword or reserved word.

  • Introduced: The version in which the keyword or reserved word was introduced.

  • Removed: The version in which the keyword or reserved word was removed.

  • 5.5, 5.6, and so forth: Whether the keyword or reserved word is available in each MySQL Server series. Reserved keywords are marked with (R).

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

Table 2.1 Keyword and Reserved Word Reference

Name Introduced Removed 5.5 5.6 5.7 8.0
ACCESSIBLE Yes (R) Yes (R) Yes (R) Yes (R)
ACCOUNT 5.7.6 Yes Yes
ACTION Yes Yes Yes Yes
ACTIVE 8.0.14 Yes
ADD Yes (R) Yes (R) Yes (R) Yes (R)
ADMIN Yes
AFTER Yes Yes Yes Yes
AGAINST Yes Yes Yes Yes
AGGREGATE Yes Yes Yes Yes
ALGORITHM Yes Yes Yes Yes
ALL Yes (R) Yes (R) Yes (R) Yes (R)
ALTER Yes (R) Yes (R) Yes (R) Yes (R)
ALWAYS 5.7.6 Yes Yes
ANALYSE 5.6.6 8.0.1 Yes Yes Yes
ANALYZE Yes (R) Yes (R) Yes (R) Yes (R)
AND Yes (R) Yes (R) Yes (R) Yes (R)
ANY Yes Yes Yes Yes
ARRAY 8.0.17 Yes (R)
AS Yes (R) Yes (R) Yes (R) Yes (R)
ASC Yes (R) Yes (R) Yes (R) Yes (R)
ASCII Yes Yes Yes Yes
ASENSITIVE Yes (R) Yes (R) Yes (R) Yes (R)
AT Yes Yes Yes Yes
AUTHORS 5.6.8 Yes Yes
AUTOEXTEND_SIZE Yes Yes Yes Yes
AUTO_INCREMENT Yes Yes Yes Yes
AVG Yes Yes Yes Yes
AVG_ROW_LENGTH Yes Yes Yes Yes
BACKUP Yes Yes Yes Yes
BEFORE Yes (R) Yes (R) Yes (R) Yes (R)
BEGIN Yes Yes Yes Yes
BETWEEN Yes (R) Yes (R) Yes (R) Yes (R)
BIGINT Yes (R) Yes (R) Yes (R) Yes (R)
BINARY Yes (R) Yes (R) Yes (R) Yes (R)
BINLOG Yes Yes Yes Yes
BIT Yes Yes Yes Yes
BLOB Yes (R) Yes (R) Yes (R) Yes (R)
BLOCK Yes Yes Yes Yes
BOOL Yes Yes Yes Yes
BOOLEAN Yes Yes Yes Yes
BOTH Yes (R) Yes (R) Yes (R) Yes (R)
BTREE Yes Yes Yes Yes
BUCKETS 8.0.2 Yes
BY Yes (R) Yes (R) Yes (R) Yes (R)
BYTE Yes Yes Yes Yes
CACHE Yes Yes Yes Yes
CALL Yes (R) Yes (R) Yes (R) Yes (R)
CASCADE Yes (R) Yes (R) Yes (R) Yes (R)
CASCADED Yes Yes Yes Yes
CASE Yes (R) Yes (R) Yes (R) Yes (R)
CATALOG_NAME Yes Yes Yes Yes
CHAIN Yes Yes Yes Yes
CHANGE Yes (R) Yes (R) Yes (R) Yes (R)
CHANGED Yes Yes Yes Yes
CHANNEL 5.7.6 Yes Yes
CHAR Yes (R) Yes (R) Yes (R) Yes (R)
CHARACTER Yes (R) Yes (R) Yes (R) Yes (R)
CHARSET Yes Yes Yes Yes
CHECK Yes (R) Yes (R) Yes (R) Yes (R)
CHECKSUM Yes Yes Yes Yes
CIPHER Yes Yes Yes Yes
CLASS_ORIGIN Yes Yes Yes Yes
CLIENT Yes Yes Yes Yes
CLONE 8.0.3 Yes
CLOSE Yes Yes Yes Yes
COALESCE Yes Yes Yes Yes
CODE Yes Yes Yes Yes
COLLATE Yes (R) Yes (R) Yes (R) Yes (R)
COLLATION Yes Yes Yes Yes
COLUMN Yes (R) Yes (R) Yes (R) Yes (R)
COLUMNS Yes Yes Yes Yes
COLUMN_FORMAT 5.6.6 Yes Yes Yes
COLUMN_NAME Yes Yes Yes Yes
COMMENT Yes Yes Yes Yes
COMMIT Yes Yes Yes Yes
COMMITTED Yes Yes Yes Yes
COMPACT Yes Yes Yes Yes
COMPLETION Yes Yes Yes Yes
COMPONENT Yes
COMPRESSED Yes Yes Yes Yes
COMPRESSION 5.7.8 Yes Yes
CONCURRENT Yes Yes Yes Yes
CONDITION Yes (R) Yes (R) Yes (R) Yes (R)
CONNECTION Yes Yes Yes Yes
CONSISTENT Yes Yes Yes Yes
CONSTRAINT Yes (R) Yes (R) Yes (R) Yes (R)
CONSTRAINT_CATALOG Yes Yes Yes Yes
CONSTRAINT_NAME Yes Yes Yes Yes
CONSTRAINT_SCHEMA Yes Yes Yes Yes
CONTAINS Yes Yes Yes Yes
CONTEXT Yes Yes Yes Yes
CONTINUE Yes (R) Yes (R) Yes (R) Yes (R)
CONTRIBUTORS 5.6.8 Yes Yes
CONVERT Yes (R) Yes (R) Yes (R) Yes (R)
CPU Yes Yes Yes Yes
CREATE Yes (R) Yes (R) Yes (R) Yes (R)
CROSS Yes (R) Yes (R) Yes (R) Yes (R)
CUBE Yes Yes Yes Yes (R)
CUME_DIST 8.0.2 Yes (R)
CURRENT 5.6.4 Yes Yes Yes
CURRENT_DATE Yes (R) Yes (R) Yes (R) Yes (R)
CURRENT_TIME Yes (R) Yes (R) Yes (R) Yes (R)
CURRENT_TIMESTAMP Yes (R) Yes (R) Yes (R) Yes (R)
CURRENT_USER Yes (R) Yes (R) Yes (R) Yes (R)
CURSOR Yes (R) Yes (R) Yes (R) Yes (R)
CURSOR_NAME Yes Yes Yes Yes
DATA Yes Yes Yes Yes
DATABASE Yes (R) Yes (R) Yes (R) Yes (R)
DATABASES Yes (R) Yes (R) Yes (R) Yes (R)
DATAFILE Yes Yes Yes Yes
DATE Yes Yes Yes Yes
DATETIME Yes Yes Yes Yes
DAY Yes Yes Yes Yes
DAY_HOUR Yes (R) Yes (R) Yes (R) Yes (R)
DAY_MICROSECOND Yes (R) Yes (R) Yes (R) Yes (R)
DAY_MINUTE Yes (R) Yes (R) Yes (R) Yes (R)
DAY_SECOND Yes (R) Yes (R) Yes (R) Yes (R)
DEALLOCATE Yes Yes Yes Yes
DEC Yes (R) Yes (R) Yes (R) Yes (R)
DECIMAL Yes (R) Yes (R) Yes (R) Yes (R)
DECLARE Yes (R) Yes (R) Yes (R) Yes (R)
DEFAULT Yes (R) Yes (R) Yes (R) Yes (R)
DEFAULT_AUTH 5.6.4 Yes Yes Yes
DEFINER Yes Yes Yes Yes
DEFINITION 8.0.4 Yes
DELAYED Yes (R) Yes (R) Yes (R) Yes (R)
DELAY_KEY_WRITE Yes Yes Yes Yes
DELETE Yes (R) Yes (R) Yes (R) Yes (R)
DENSE_RANK 8.0.2 Yes (R)
DESC Yes (R) Yes (R) Yes (R) Yes (R)
DESCRIBE Yes (R) Yes (R) Yes (R) Yes (R)
DESCRIPTION 8.0.4 Yes
DES_KEY_FILE 8.0.3 Yes Yes Yes Yes
DETERMINISTIC Yes (R) Yes (R) Yes (R) Yes (R)
DIAGNOSTICS 5.6.4 Yes Yes Yes
DIRECTORY Yes Yes Yes Yes
DISABLE Yes Yes Yes Yes
DISCARD Yes Yes Yes Yes
DISK Yes Yes Yes Yes
DISTINCT Yes (R) Yes (R) Yes (R) Yes (R)
DISTINCTROW Yes (R) Yes (R) Yes (R) Yes (R)
DIV Yes (R) Yes (R) Yes (R) Yes (R)
DO Yes Yes Yes Yes
DOUBLE Yes (R) Yes (R) Yes (R) Yes (R)
DROP Yes (R) Yes (R) Yes (R) Yes (R)
DUAL Yes (R) Yes (R) Yes (R) Yes (R)
DUMPFILE Yes Yes Yes Yes
DUPLICATE Yes Yes Yes Yes
DYNAMIC Yes Yes Yes Yes
EACH Yes (R) Yes (R) Yes (R) Yes (R)
ELSE Yes (R) Yes (R) Yes (R) Yes (R)
ELSEIF Yes (R) Yes (R) Yes (R) Yes (R)
EMPTY 8.0.4 Yes (R)
ENABLE Yes Yes Yes Yes
ENCLOSED Yes (R) Yes (R) Yes (R) Yes (R)
ENCRYPTION 5.7.11 Yes Yes
END Yes Yes Yes Yes
ENDS Yes Yes Yes Yes
ENFORCED 8.0.16 Yes
ENGINE Yes Yes Yes Yes
ENGINES Yes Yes Yes Yes
ENUM Yes Yes Yes Yes
ERROR 5.5.3 Yes Yes Yes Yes
ERRORS Yes Yes Yes Yes
ESCAPE Yes Yes Yes Yes
ESCAPED Yes (R) Yes (R) Yes (R) Yes (R)
EVENT Yes Yes Yes Yes
EVENTS Yes Yes Yes Yes
EVERY Yes Yes Yes Yes
EXCEPT Yes (R)
EXCHANGE Yes Yes Yes
EXCLUDE 8.0.2 Yes
EXECUTE Yes Yes Yes Yes
EXISTS Yes (R) Yes (R) Yes (R) Yes (R)
EXIT Yes (R) Yes (R) Yes (R) Yes (R)
EXPANSION Yes Yes Yes Yes
EXPIRE 5.6.6 Yes Yes Yes
EXPLAIN Yes (R) Yes (R) Yes (R) Yes (R)
EXPORT 5.6.6 Yes Yes Yes
EXTENDED Yes Yes Yes Yes
EXTENT_SIZE Yes Yes Yes Yes
FALSE Yes (R) Yes (R) Yes (R) Yes (R)
FAST Yes Yes Yes Yes
FAULTS Yes Yes Yes Yes
FETCH Yes (R) Yes (R) Yes (R) Yes (R)
FIELDS Yes Yes Yes Yes
FILE Yes Yes Yes Yes
FILE_BLOCK_SIZE 5.7.6 Yes Yes
FILTER 5.7.3 Yes Yes
FIRST Yes Yes Yes Yes
FIRST_VALUE 8.0.2 Yes (R)
FIXED Yes Yes Yes Yes
FLOAT Yes (R) Yes (R) Yes (R) Yes (R)
FLOAT4 Yes (R) Yes (R) Yes (R) Yes (R)
FLOAT8 Yes (R) Yes (R) Yes (R) Yes (R)
FLUSH Yes Yes Yes Yes
FOLLOWING 8.0.2 Yes
FOLLOWS 5.7.2 Yes Yes
FOR Yes (R) Yes (R) Yes (R) Yes (R)
FORCE Yes (R) Yes (R) Yes (R) Yes (R)
FOREIGN Yes (R) Yes (R) Yes (R) Yes (R)
FORMAT 5.6.5 Yes Yes Yes
FOUND Yes Yes Yes Yes
FRAC_SECOND 5.5.3 Yes
FROM Yes (R) Yes (R) Yes (R) Yes (R)
FULL Yes Yes Yes Yes
FULLTEXT Yes (R) Yes (R) Yes (R) Yes (R)
FUNCTION Yes Yes Yes Yes (R)
GENERAL 5.5.3 Yes Yes Yes Yes
GENERATED 5.7.6 Yes (R) Yes (R)
GEOMCOLLECTION 8.0.11 Yes
GEOMETRY Yes Yes Yes Yes
GEOMETRYCOLLECTION Yes Yes Yes Yes
GET 5.6.4 Yes (R) Yes (R) Yes (R)
GET_FORMAT Yes Yes Yes Yes
GET_MASTER_PUBLIC_KEY 8.0.4 Yes
GLOBAL Yes Yes Yes Yes
GRANT Yes (R) Yes (R) Yes (R) Yes (R)
GRANTS Yes Yes Yes Yes
GROUP Yes (R) Yes (R) Yes (R) Yes (R)
GROUPING 8.0.1 Yes (R)
GROUPS 8.0.2 Yes (R)
GROUP_REPLICATION 5.7.6 Yes Yes
HANDLER Yes Yes Yes Yes
HASH Yes Yes Yes Yes
HAVING Yes (R) Yes (R) Yes (R) Yes (R)
HELP Yes Yes Yes Yes
HIGH_PRIORITY Yes (R) Yes (R) Yes (R) Yes (R)
HISTOGRAM 8.0.2 Yes
HISTORY 8.0.3 Yes
HOST Yes Yes Yes Yes
HOSTS Yes Yes Yes Yes
HOUR Yes Yes Yes Yes
HOUR_MICROSECOND Yes (R) Yes (R) Yes (R) Yes (R)
HOUR_MINUTE Yes (R) Yes (R) Yes (R) Yes (R)
HOUR_SECOND Yes (R) Yes (R) Yes (R) Yes (R)
IDENTIFIED Yes Yes Yes Yes
IF Yes (R) Yes (R) Yes (R) Yes (R)
IGNORE Yes (R) Yes (R) Yes (R) Yes (R)
IGNORE_SERVER_IDS Yes Yes Yes Yes
IMPORT Yes Yes Yes Yes
IN Yes (R) Yes (R) Yes (R) Yes (R)
INACTIVE 8.0.14 Yes
INDEX Yes (R) Yes (R) Yes (R) Yes (R)
INDEXES Yes Yes Yes Yes
INFILE Yes (R) Yes (R) Yes (R) Yes (R)
INITIAL_SIZE Yes Yes Yes Yes
INNER Yes (R) Yes (R) Yes (R) Yes (R)
INNOBASE 5.5.3 Yes
INNODB 5.5.3 Yes
INOUT Yes (R) Yes (R) Yes (R) Yes (R)
INSENSITIVE Yes (R) Yes (R) Yes (R) Yes (R)
INSERT Yes (R) Yes (R) Yes (R) Yes (R)
INSERT_METHOD Yes Yes Yes Yes
INSTALL Yes Yes Yes Yes
INSTANCE 5.7.11 Yes Yes
INT Yes (R) Yes (R) Yes (R) Yes (R)
INT1 Yes (R) Yes (R) Yes (R) Yes (R)
INT2 Yes (R) Yes (R) Yes (R) Yes (R)
INT3 Yes (R) Yes (R) Yes (R) Yes (R)
INT4 Yes (R) Yes (R) Yes (R) Yes (R)
INT8 Yes (R) Yes (R) Yes (R) Yes (R)
INTEGER Yes (R) Yes (R) Yes (R) Yes (R)
INTERVAL Yes (R) Yes (R) Yes (R) Yes (R)
INTO Yes (R) Yes (R) Yes (R) Yes (R)
INVISIBLE Yes
INVOKER Yes Yes Yes Yes
IO Yes Yes Yes Yes
IO_AFTER_GTIDS 5.6.5 Yes (R) Yes (R) Yes (R)
IO_BEFORE_GTIDS 5.6.5 Yes (R) Yes (R) Yes (R)
IO_THREAD Yes Yes Yes Yes
IPC Yes Yes Yes Yes
IS Yes (R) Yes (R) Yes (R) Yes (R)
ISOLATION Yes Yes Yes Yes
ISSUER Yes Yes Yes Yes
ITERATE Yes (R) Yes (R) Yes (R) Yes (R)
JOIN Yes (R) Yes (R) Yes (R) Yes (R)
JSON 5.7.8 Yes Yes
JSON_TABLE 8.0.4 Yes (R)
KEY Yes (R) Yes (R) Yes (R) Yes (R)
KEYS Yes (R) Yes (R) Yes (R) Yes (R)
KEY_BLOCK_SIZE Yes Yes Yes Yes
KILL Yes (R) Yes (R) Yes (R) Yes (R)
LAG 8.0.2 Yes (R)
LANGUAGE Yes Yes Yes Yes
LAST Yes Yes Yes Yes
LAST_VALUE 8.0.2 Yes (R)
LATERAL 8.0.14 Yes (R)
LEAD 8.0.2 Yes (R)
LEADING Yes (R) Yes (R) Yes (R) Yes (R)
LEAVE Yes (R) Yes (R) Yes (R) Yes (R)
LEAVES Yes Yes Yes Yes
LEFT Yes (R) Yes (R) Yes (R) Yes (R)
LESS Yes Yes Yes Yes
LEVEL Yes Yes Yes Yes
LIKE Yes (R) Yes (R) Yes (R) Yes (R)
LIMIT Yes (R) Yes (R) Yes (R) Yes (R)
LINEAR Yes (R) Yes (R) Yes (R) Yes (R)
LINES Yes (R) Yes (R) Yes (R) Yes (R)
LINESTRING Yes Yes Yes Yes
LIST Yes Yes Yes Yes
LOAD Yes (R) Yes (R) Yes (R) Yes (R)
LOCAL Yes Yes Yes Yes
LOCALTIME Yes (R) Yes (R) Yes (R) Yes (R)
LOCALTIMESTAMP Yes (R) Yes (R) Yes (R) Yes (R)
LOCK Yes (R) Yes (R) Yes (R) Yes (R)
LOCKED 8.0.1 Yes
LOCKS Yes Yes Yes Yes
LOGFILE Yes Yes Yes Yes
LOGS Yes Yes Yes Yes
LONG Yes (R) Yes (R) Yes (R) Yes (R)
LONGBLOB Yes (R) Yes (R) Yes (R) Yes (R)
LONGTEXT Yes (R) Yes (R) Yes (R) Yes (R)
LOOP Yes (R) Yes (R) Yes (R) Yes (R)
LOW_PRIORITY Yes (R) Yes (R) Yes (R) Yes (R)
MASTER Yes Yes Yes Yes
MASTER_AUTO_POSITION 5.6.5 Yes Yes Yes
MASTER_BIND 5.6.1 Yes (R) Yes (R) Yes (R)
MASTER_CONNECT_RETRY Yes Yes Yes Yes
MASTER_DELAY Yes Yes Yes
MASTER_HEARTBEAT_PERIOD Yes Yes Yes Yes
MASTER_HOST Yes Yes Yes Yes
MASTER_LOG_FILE Yes Yes Yes Yes
MASTER_LOG_POS Yes Yes Yes Yes
MASTER_PASSWORD Yes Yes Yes Yes
MASTER_PORT Yes Yes Yes Yes
MASTER_PUBLIC_KEY_PATH 8.0.4 Yes
MASTER_RETRY_COUNT 5.6.1 Yes Yes Yes
MASTER_SERVER_ID Yes Yes Yes Yes
MASTER_SSL Yes Yes Yes Yes
MASTER_SSL_CA Yes Yes Yes Yes
MASTER_SSL_CAPATH Yes Yes Yes Yes
MASTER_SSL_CERT Yes Yes Yes Yes
MASTER_SSL_CIPHER Yes Yes Yes Yes
MASTER_SSL_CRL 5.6.3 Yes Yes Yes
MASTER_SSL_CRLPATH 5.6.3 Yes Yes Yes
MASTER_SSL_KEY Yes Yes Yes Yes
MASTER_SSL_VERIFY_SERVER_CERT Yes (R) Yes (R) Yes (R) Yes (R)
MASTER_TLS_VERSION 5.7.10 Yes Yes
MASTER_USER Yes Yes Yes Yes
MATCH Yes (R) Yes (R) Yes (R) Yes (R)
MAXVALUE Yes (R) Yes (R) Yes (R) Yes (R)
MAX_CONNECTIONS_PER_HOUR Yes Yes Yes Yes
MAX_QUERIES_PER_HOUR Yes Yes Yes Yes
MAX_ROWS Yes Yes Yes Yes
MAX_SIZE Yes Yes Yes Yes
MAX_STATEMENT_TIME 5.7.4 5.7.8 Yes
MAX_UPDATES_PER_HOUR Yes Yes Yes Yes
MAX_USER_CONNECTIONS Yes Yes Yes Yes
MEDIUM Yes Yes Yes Yes
MEDIUMBLOB Yes (R) Yes (R) Yes (R) Yes (R)
MEDIUMINT Yes (R) Yes (R) Yes (R) Yes (R)
MEDIUMTEXT Yes (R) Yes (R) Yes (R) Yes (R)
MEMBER 8.0.17 Yes (R)
MEMORY Yes Yes Yes Yes
MERGE Yes Yes Yes Yes
MESSAGE_TEXT Yes Yes Yes Yes
MICROSECOND Yes Yes Yes Yes
MIDDLEINT Yes (R) Yes (R) Yes (R) Yes (R)
MIGRATE Yes Yes Yes Yes
MINUTE Yes Yes Yes Yes
MINUTE_MICROSECOND Yes (R) Yes (R) Yes (R) Yes (R)
MINUTE_SECOND Yes (R) Yes (R) Yes (R) Yes (R)
MIN_ROWS Yes Yes Yes Yes
MOD Yes (R) Yes (R) Yes (R) Yes (R)
MODE Yes Yes Yes Yes
MODIFIES Yes (R) Yes (R) Yes (R) Yes (R)
MODIFY Yes Yes Yes Yes
MONTH Yes Yes Yes Yes
MULTILINESTRING Yes Yes Yes Yes
MULTIPOINT Yes Yes Yes Yes
MULTIPOLYGON Yes Yes Yes Yes
MUTEX Yes Yes Yes Yes
MYSQL_ERRNO Yes Yes Yes Yes
NAME Yes Yes Yes Yes
NAMES Yes Yes Yes Yes
NATIONAL Yes Yes Yes Yes
NATURAL Yes (R) Yes (R) Yes (R) Yes (R)
NCHAR Yes Yes Yes Yes
NDB Yes Yes Yes Yes
NDBCLUSTER Yes Yes Yes Yes
NESTED 8.0.4 Yes
NETWORK_NAMESPACE 8.0.16 Yes
NEVER 5.7.4 Yes Yes
NEW Yes Yes Yes Yes
NEXT Yes Yes Yes Yes
NO Yes Yes Yes Yes
NODEGROUP Yes Yes Yes Yes
NONBLOCKING 5.7.6 Yes (R)
NONE Yes Yes Yes Yes
NOT Yes (R) Yes (R) Yes (R) Yes (R)
NOWAIT 8.0.1 Yes
NO_WAIT Yes Yes Yes Yes
NO_WRITE_TO_BINLOG Yes (R) Yes (R) Yes (R) Yes (R)
NTH_VALUE 8.0.2 Yes (R)
NTILE 8.0.2 Yes (R)
NULL Yes (R) Yes (R) Yes (R) Yes (R)
NULLS 8.0.2 Yes
NUMBER 5.6.4 Yes Yes Yes
NUMERIC Yes (R) Yes (R) Yes (R) Yes (R)
NVARCHAR Yes Yes Yes Yes
OF 8.0.1 Yes (R)
OFFSET Yes Yes Yes Yes
OJ 8.0.16 Yes
OLD 8.0.14 Yes
OLD_PASSWORD 5.7.5 Yes Yes Yes
ON Yes (R) Yes (R) Yes (R) Yes (R)
ONE Yes Yes Yes Yes
ONE_SHOT 5.6.5 Yes Yes (R)
ONLY 5.6.5 Yes Yes Yes
OPEN Yes Yes Yes Yes
OPTIMIZE Yes (R) Yes (R) Yes (R) Yes (R)
OPTIMIZER_COSTS 5.7.5 Yes (R) Yes (R)
OPTION Yes (R) Yes (R) Yes (R) Yes (R)
OPTIONAL 8.0.13 Yes
OPTIONALLY Yes (R) Yes (R) Yes (R) Yes (R)
OPTIONS Yes Yes Yes Yes
OR Yes (R) Yes (R) Yes (R) Yes (R)
ORDER Yes (R) Yes (R) Yes (R) Yes (R)
ORDINALITY 8.0.4 Yes
ORGANIZATION 8.0.4 Yes
OTHERS 8.0.2 Yes
OUT Yes (R) Yes (R) Yes (R) Yes (R)
OUTER Yes (R) Yes (R) Yes (R) Yes (R)
OUTFILE Yes (R) Yes (R) Yes (R) Yes (R)
OVER 8.0.2 Yes (R)
OWNER Yes Yes Yes Yes
PACK_KEYS Yes Yes Yes Yes
PAGE Yes Yes Yes Yes
PARSER Yes Yes Yes Yes
PARSE_GCOL_EXPR 5.7.6 Yes
PARTIAL Yes Yes Yes Yes
PARTITION Yes Yes (R) Yes (R) Yes (R)
PARTITIONING Yes Yes Yes Yes
PARTITIONS Yes Yes Yes Yes
PASSWORD Yes Yes Yes Yes
PATH 8.0.4 Yes
PERCENT_RANK 8.0.2 Yes (R)
PERSIST Yes
PERSIST_ONLY 8.0.2 Yes
PHASE Yes Yes Yes Yes
PLUGIN Yes Yes Yes Yes
PLUGINS Yes Yes Yes Yes
PLUGIN_DIR 5.6.4 Yes Yes Yes
POINT Yes Yes Yes Yes
POLYGON Yes Yes Yes Yes
PORT Yes Yes Yes Yes
PRECEDES 5.7.2 Yes Yes
PRECEDING 8.0.2 Yes
PRECISION Yes (R) Yes (R) Yes (R) Yes (R)
PREPARE Yes Yes Yes Yes
PRESERVE Yes Yes Yes Yes
PREV Yes Yes Yes Yes
PRIMARY Yes (R) Yes (R) Yes (R) Yes (R)
PRIVILEGES Yes Yes Yes Yes
PROCEDURE Yes (R) Yes (R) Yes (R) Yes (R)
PROCESS 8.0.11 Yes
PROCESSLIST Yes Yes Yes Yes
PROFILE Yes Yes Yes Yes
PROFILES Yes Yes Yes Yes
PROXY 5.5.7, 5.6.1 Yes Yes Yes Yes
PURGE Yes (R) Yes (R) Yes (R) Yes (R)
QUARTER Yes Yes Yes Yes
QUERY Yes Yes Yes Yes
QUICK Yes Yes Yes Yes
RANGE Yes (R) Yes (R) Yes (R) Yes (R)
RANK 8.0.2 Yes (R)
READ Yes (R) Yes (R) Yes (R) Yes (R)
READS Yes (R) Yes (R) Yes (R) Yes (R)
READ_ONLY Yes Yes Yes Yes
READ_WRITE Yes (R) Yes (R) Yes (R) Yes (R)
REAL Yes (R) Yes (R) Yes (R) Yes (R)
REBUILD Yes Yes Yes Yes
RECOVER Yes Yes Yes Yes
RECURSIVE 8.0.1 Yes (R)
REDOFILE 8.0.3 Yes Yes Yes Yes
REDO_BUFFER_SIZE Yes Yes Yes Yes
REDUNDANT Yes Yes Yes Yes
REFERENCE 8.0.4 Yes
REFERENCES Yes (R) Yes (R) Yes (R) Yes (R)
REGEXP Yes (R) Yes (R) Yes (R) Yes (R)
RELAY 5.5.3 Yes Yes Yes Yes
RELAYLOG Yes Yes Yes Yes
RELAY_LOG_FILE Yes Yes Yes Yes
RELAY_LOG_POS Yes Yes Yes Yes
RELAY_THREAD Yes Yes Yes Yes
RELEASE Yes (R) Yes (R) Yes (R) Yes (R)
RELOAD Yes Yes Yes Yes
REMOTE 8.0.3 8.0.14 Yes
REMOVE Yes Yes Yes Yes
RENAME Yes (R) Yes (R) Yes (R) Yes (R)
REORGANIZE Yes Yes Yes Yes
REPAIR Yes Yes Yes Yes
REPEAT Yes (R) Yes (R) Yes (R) Yes (R)
REPEATABLE Yes Yes Yes Yes
REPLACE Yes (R) Yes (R) Yes (R) Yes (R)
REPLICATE_DO_DB 5.7.3 Yes Yes
REPLICATE_DO_TABLE 5.7.3 Yes Yes
REPLICATE_IGNORE_DB 5.7.3 Yes Yes
REPLICATE_IGNORE_TABLE 5.7.3 Yes Yes
REPLICATE_REWRITE_DB 5.7.3 Yes Yes
REPLICATE_WILD_DO_TABLE 5.7.3 Yes Yes
REPLICATE_WILD_IGNORE_TABLE 5.7.3 Yes Yes
REPLICATION Yes Yes Yes Yes
REQUIRE Yes (R) Yes (R) Yes (R) Yes (R)
RESET Yes Yes Yes Yes
RESIGNAL Yes (R) Yes (R) Yes (R) Yes (R)
RESOURCE 8.0.3 Yes
RESPECT 8.0.2 Yes
RESTART 8.0.4 Yes
RESTORE Yes Yes Yes Yes
RESTRICT Yes (R) Yes (R) Yes (R) Yes (R)
RESUME Yes Yes Yes Yes
RETAIN 8.0.14 Yes
RETURN Yes (R) Yes (R) Yes (R) Yes (R)
RETURNED_SQLSTATE 5.6.4 Yes Yes Yes
RETURNS Yes Yes Yes Yes
REUSE 8.0.3 Yes
REVERSE Yes Yes Yes
REVOKE Yes (R) Yes (R) Yes (R) Yes (R)
RIGHT Yes (R) Yes (R) Yes (R) Yes (R)
RLIKE Yes (R) Yes (R) Yes (R) Yes (R)
ROLE Yes
ROLLBACK Yes Yes Yes Yes
ROLLUP Yes Yes Yes Yes
ROTATE 5.7.11 Yes Yes
ROUTINE Yes Yes Yes Yes
ROW Yes Yes Yes Yes (R)
ROWS Yes Yes Yes Yes (R)
ROW_COUNT 5.6.4 Yes Yes Yes
ROW_FORMAT Yes Yes Yes Yes
ROW_NUMBER 8.0.2 Yes (R)
RTREE Yes Yes Yes Yes
SAVEPOINT Yes Yes Yes Yes
SCHEDULE Yes Yes Yes Yes
SCHEMA Yes (R) Yes (R) Yes (R) Yes (R)
SCHEMAS Yes (R) Yes (R) Yes (R) Yes (R)
SCHEMA_NAME Yes Yes Yes Yes
SECOND Yes Yes Yes Yes
SECONDARY 8.0.16 Yes
SECONDARY_ENGINE 8.0.13 Yes
SECONDARY_LOAD 8.0.13 Yes
SECONDARY_UNLOAD 8.0.13 Yes
SECOND_MICROSECOND Yes (R) Yes (R) Yes (R) Yes (R)
SECURITY Yes Yes Yes Yes
SELECT Yes (R) Yes (R) Yes (R) Yes (R)
SENSITIVE Yes (R) Yes (R) Yes (R) Yes (R)
SEPARATOR Yes (R) Yes (R) Yes (R) Yes (R)
SERIAL Yes Yes Yes Yes
SERIALIZABLE Yes Yes Yes Yes
SERVER Yes Yes Yes Yes
SESSION Yes Yes Yes Yes
SET Yes (R) Yes (R) Yes (R) Yes (R)
SHARE Yes Yes Yes Yes
SHOW Yes (R) Yes (R) Yes (R) Yes (R)
SHUTDOWN Yes Yes Yes Yes
SIGNAL Yes (R) Yes (R) Yes (R) Yes (R)
SIGNED Yes Yes Yes Yes
SIMPLE Yes Yes Yes Yes
SKIP 8.0.1 Yes
SLAVE Yes Yes Yes Yes
SLOW 5.5.3 Yes Yes Yes Yes
SMALLINT Yes (R) Yes (R) Yes (R) Yes (R)
SNAPSHOT Yes Yes Yes Yes
SOCKET Yes Yes Yes Yes
SOME Yes Yes Yes Yes
SONAME Yes Yes Yes Yes
SOUNDS Yes Yes Yes Yes
SOURCE Yes Yes Yes Yes
SPATIAL Yes (R) Yes (R) Yes (R) Yes (R)
SPECIFIC Yes (R) Yes (R) Yes (R) Yes (R)
SQL Yes (R) Yes (R) Yes (R) Yes (R)
SQLEXCEPTION Yes (R) Yes (R) Yes (R) Yes (R)
SQLSTATE Yes (R) Yes (R) Yes (R) Yes (R)
SQLWARNING Yes (R) Yes (R) Yes (R) Yes (R)
SQL_AFTER_GTIDS 5.6.5 Yes Yes Yes
SQL_AFTER_MTS_GAPS 5.6.6 Yes Yes Yes
SQL_BEFORE_GTIDS 5.6.5 Yes Yes Yes
SQL_BIG_RESULT Yes (R) Yes (R) Yes (R) Yes (R)
SQL_BUFFER_RESULT Yes Yes Yes Yes
SQL_CACHE 8.0.3 Yes Yes Yes Yes
SQL_CALC_FOUND_ROWS Yes (R) Yes (R) Yes (R) Yes (R)
SQL_NO_CACHE Yes Yes Yes Yes
SQL_SMALL_RESULT Yes (R) Yes (R) Yes (R) Yes (R)
SQL_THREAD Yes Yes Yes Yes
SQL_TSI_DAY Yes Yes Yes Yes
SQL_TSI_FRAC_SECOND 5.5.3 Yes
SQL_TSI_HOUR Yes Yes Yes Yes
SQL_TSI_MINUTE Yes Yes Yes Yes
SQL_TSI_MONTH Yes Yes Yes Yes
SQL_TSI_QUARTER Yes Yes Yes Yes
SQL_TSI_SECOND Yes Yes Yes Yes
SQL_TSI_WEEK Yes Yes Yes Yes
SQL_TSI_YEAR Yes Yes Yes Yes
SRID 8.0.3 Yes
SSL Yes (R) Yes (R) Yes (R) Yes (R)
STACKED Yes Yes
START Yes Yes Yes Yes
STARTING Yes (R) Yes (R) Yes (R) Yes (R)
STARTS Yes Yes Yes Yes
STATS_AUTO_RECALC 5.6.6 Yes Yes Yes
STATS_PERSISTENT 5.6.6 Yes Yes Yes
STATS_SAMPLE_PAGES 5.6.6 Yes Yes Yes
STATUS Yes Yes Yes Yes
STOP Yes Yes Yes Yes
STORAGE Yes Yes Yes Yes
STORED 5.7.6 Yes (R) Yes (R)
STRAIGHT_JOIN Yes (R) Yes (R) Yes (R) Yes (R)
STRING Yes Yes Yes Yes
SUBCLASS_ORIGIN Yes Yes Yes Yes
SUBJECT Yes Yes Yes Yes
SUBPARTITION Yes Yes Yes Yes
SUBPARTITIONS Yes Yes Yes Yes
SUPER Yes Yes Yes Yes
SUSPEND Yes Yes Yes Yes
SWAPS Yes Yes Yes Yes
SWITCHES Yes Yes Yes Yes
SYSTEM 8.0.3 Yes (R)
TABLE Yes (R) Yes (R) Yes (R) Yes (R)
TABLES Yes Yes Yes Yes
TABLESPACE Yes Yes Yes Yes
TABLE_CHECKSUM Yes Yes Yes Yes
TABLE_NAME Yes Yes Yes Yes
TEMPORARY Yes Yes Yes Yes
TEMPTABLE Yes Yes Yes Yes
TERMINATED Yes (R) Yes (R) Yes (R) Yes (R)
TEXT Yes Yes Yes Yes
THAN Yes Yes Yes Yes
THEN Yes (R) Yes (R) Yes (R) Yes (R)
THREAD_PRIORITY 8.0.3 Yes
TIES 8.0.2 Yes
TIME Yes Yes Yes Yes
TIMESTAMP Yes Yes Yes Yes
TIMESTAMPADD Yes Yes Yes Yes
TIMESTAMPDIFF Yes Yes Yes Yes
TINYBLOB Yes (R) Yes (R) Yes (R) Yes (R)
TINYINT Yes (R) Yes (R) Yes (R) Yes (R)
TINYTEXT Yes (R) Yes (R) Yes (R) Yes (R)
TO Yes (R) Yes (R) Yes (R) Yes (R)
TRAILING Yes (R) Yes (R) Yes (R) Yes (R)
TRANSACTION Yes Yes Yes Yes
TRIGGER Yes (R) Yes (R) Yes (R) Yes (R)
TRIGGERS Yes Yes Yes Yes
TRUE Yes (R) Yes (R) Yes (R) Yes (R)
TRUNCATE Yes Yes Yes Yes
TYPE Yes Yes Yes Yes
TYPES Yes Yes Yes Yes
UNBOUNDED 8.0.2 Yes
UNCOMMITTED Yes Yes Yes Yes
UNDEFINED Yes Yes Yes Yes
UNDO Yes (R) Yes (R) Yes (R) Yes (R)
UNDOFILE Yes Yes Yes Yes
UNDO_BUFFER_SIZE Yes Yes Yes Yes
UNICODE Yes Yes Yes Yes
UNINSTALL Yes Yes Yes Yes
UNION Yes (R) Yes (R) Yes (R) Yes (R)
UNIQUE Yes (R) Yes (R) Yes (R) Yes (R)
UNKNOWN Yes Yes Yes Yes
UNLOCK Yes (R) Yes (R) Yes (R) Yes (R)
UNSIGNED Yes (R) Yes (R) Yes (R) Yes (R)
UNTIL Yes Yes Yes Yes
UPDATE Yes (R) Yes (R) Yes (R) Yes (R)
UPGRADE Yes Yes Yes Yes
USAGE Yes (R) Yes (R) Yes (R) Yes (R)
USE Yes (R) Yes (R) Yes (R) Yes (R)
USER Yes Yes Yes Yes
USER_RESOURCES Yes Yes Yes Yes
USE_FRM Yes Yes Yes Yes
USING Yes (R) Yes (R) Yes (R) Yes (R)
UTC_DATE Yes (R) Yes (R) Yes (R) Yes (R)
UTC_TIME Yes (R) Yes (R) Yes (R) Yes (R)
UTC_TIMESTAMP Yes (R) Yes (R) Yes (R) Yes (R)
VALIDATION 5.7.5 Yes Yes
VALUE Yes Yes Yes Yes
VALUES Yes (R) Yes (R) Yes (R) Yes (R)
VARBINARY Yes (R) Yes (R) Yes (R) Yes (R)
VARCHAR Yes (R) Yes (R) Yes (R) Yes (R)
VARCHARACTER Yes (R) Yes (R) Yes (R) Yes (R)
VARIABLES Yes Yes Yes Yes
VARYING Yes (R) Yes (R) Yes (R) Yes (R)
VCPU 8.0.3 Yes
VIEW Yes Yes Yes Yes
VIRTUAL 5.7.6 Yes (R) Yes (R)
VISIBLE Yes
WAIT Yes Yes Yes Yes
WARNINGS Yes Yes Yes Yes
WEEK Yes Yes Yes Yes
WEIGHT_STRING Yes Yes Yes
WHEN Yes (R) Yes (R) Yes (R) Yes (R)
WHERE Yes (R) Yes (R) Yes (R) Yes (R)
WHILE Yes (R) Yes (R) Yes (R) Yes (R)
WINDOW 8.0.2 Yes (R)
WITH Yes (R) Yes (R) Yes (R) Yes (R)
WITHOUT 5.7.5 Yes Yes
WORK Yes Yes Yes Yes
WRAPPER Yes Yes Yes Yes
WRITE Yes (R) Yes (R) Yes (R) Yes (R)
X509 Yes Yes Yes Yes
XA Yes Yes Yes Yes
XID 5.7.5 Yes Yes
XML Yes Yes Yes Yes
XOR Yes (R) Yes (R) Yes (R) Yes (R)
YEAR Yes Yes Yes Yes
YEAR_MONTH Yes (R) Yes (R) Yes (R) Yes (R)
ZEROFILL Yes (R) Yes (R) Yes (R) Yes (R)