大写 | 小写 |
| A | a |
| ACCESSIBLE (R) | accessible (r) |
| ACCOUNT | account |
| ACTION | action |
| ACTIVE | active |
| ACTIVE; added in 8.0.14 (nonreserved) | active; added in 8.0.14 (nonreserved) |
| ADD (R) | add (r) |
| ADMIN | admin |
| ADMIN; became nonreserved in 8.0.12 | admin; became nonreserved in 8.0.12 |
| AFTER | after |
| AGAINST | against |
| AGGREGATE | aggregate |
| ALGORITHM | algorithm |
| ALL (R) | all (r) |
| ALTER (R) | alter (r) |
| ALWAYS | always |
| ANALYSE; removed in 8.0.1 | analyse; removed in 8.0.1 |
| ANALYZE (R) | analyze (r) |
| AND (R) | and (r) |
| ANY | any |
| ARRAY | array |
| ARRAY; added in 8.0.17 (reserved); became nonreserved in 8.0.19 | array; added in 8.0.17 (reserved); became nonreserved in 8.0.19 |
| AS (R) | as (r) |
| ASC (R) | asc (r) |
| ASCII | ascii |
| ASENSITIVE (R) | asensitive (r) |
| AT | at |
| ATTRIBUTE | attribute |
| ATTRIBUTE; added in 8.0.21 (nonreserved) | attribute; added in 8.0.21 (nonreserved) |
| AUTHENTICATION | authentication |
| AUTHENTICATION; added in 8.0.27 (nonreserved) | authentication; added in 8.0.27 (nonreserved) |
| AUTO_INCREMENT | auto_increment |
| AUTOEXTEND_SIZE | autoextend_size |
| AVG | avg |
| AVG_ROW_LENGTH | avg_row_length |
| B | b |
| BACKUP | backup |
| BEFORE (R) | before (r) |
| BEGIN | begin |
| BETWEEN (R) | between (r) |
| BIGINT (R) | bigint (r) |
| BINARY (R) | binary (r) |
| BINLOG | binlog |
| BIT | bit |
| BLOB (R) | blob (r) |
| BLOCK | block |
| BOOL | bool |
| BOOLEAN | boolean |
| BOTH (R) | both (r) |
| BTREE | btree |
| BUCKETS | buckets |
| BUCKETS; added in 8.0.2 (nonreserved) | buckets; added in 8.0.2 (nonreserved) |
| BY (R) | by (r) |
| BYTE | byte |
| C | c |
| CACHE | cache |
| CALL (R) | call (r) |
| CASCADE (R) | cascade (r) |
| CASCADED | cascaded |
| CASE (R) | case (r) |
| CATALOG_NAME | catalog_name |
| CHAIN | chain |
| CHALLENGE_RESPONSE | challenge_response |
| CHALLENGE_RESPONSE; added in 8.0.27 (nonreserved) | challenge_response; added in 8.0.27 (nonreserved) |
| CHANGE (R) | change (r) |
| CHANGED | changed |
| CHANNEL | channel |
| CHAR (R) | char (r) |
| CHARACTER (R) | character (r) |
| CHARSET | charset |
| CHECK (R) | check (r) |
| CHECKSUM | checksum |
| CIPHER | cipher |
| CLASS_ORIGIN | class_origin |
| CLIENT | client |
| CLONE | clone |
| CLONE; added in 8.0.3 (nonreserved) | clone; added in 8.0.3 (nonreserved) |
| CLOSE | close |
| COALESCE | coalesce |
| CODE | code |
| COLLATE (R) | collate (r) |
| COLLATION | collation |
| COLUMN (R) | column (r) |
| COLUMN_FORMAT | column_format |
| COLUMN_NAME | column_name |
| COLUMNS | columns |
| COMMENT | comment |
| COMMIT | commit |
| COMMITTED | committed |
| COMPACT | compact |
| COMPLETION | completion |
| COMPONENT | component |
| COMPONENT | component |
| COMPRESSED | compressed |
| COMPRESSION | compression |
| CONCURRENT | concurrent |
| CONDITION (R) | condition (r) |
| CONNECTION | connection |
| CONSISTENT | consistent |
| CONSTRAINT (R) | constraint (r) |
| CONSTRAINT_CATALOG | constraint_catalog |
| CONSTRAINT_NAME | constraint_name |
| CONSTRAINT_SCHEMA | constraint_schema |
| CONTAINS | contains |
| CONTEXT | context |
| CONTINUE (R) | continue (r) |
| CONVERT (R) | convert (r) |
| CPU | cpu |
| CREATE (R) | create (r) |
| CROSS (R) | cross (r) |
| CUBE (R); became reserved in 8.0.1 | cube (r); became reserved in 8.0.1 |
| CUME_DIST (R) | cume_dist (r) |
| CUME_DIST (R); added in 8.0.2 (reserved) | cume_dist (r); added in 8.0.2 (reserved) |
| CURRENT | current |
| CURRENT_DATE (R) | current_date (r) |
| CURRENT_TIME (R) | current_time (r) |
| CURRENT_TIMESTAMP (R) | current_timestamp (r) |
| CURRENT_USER (R) | current_user (r) |
| CURSOR (R) | cursor (r) |
| CURSOR_NAME | cursor_name |
| D | d |
| DATA | data |
| DATABASE (R) | database (r) |
| DATABASES (R) | databases (r) |
| DATAFILE | datafile |
| DATE | date |
| DATETIME | datetime |
| DAY | day |
| DAY_HOUR (R) | day_hour (r) |
| DAY_MICROSECOND (R) | day_microsecond (r) |
| DAY_MINUTE (R) | day_minute (r) |
| DAY_SECOND (R) | day_second (r) |
| DEALLOCATE | deallocate |
| DEC (R) | dec (r) |
| DECIMAL (R) | decimal (r) |
| DECLARE (R) | declare (r) |
| DEFAULT (R) | default (r) |
| DEFAULT_AUTH | default_auth |
| DEFINER | definer |
| DEFINITION | definition |
| DEFINITION; added in 8.0.4 (nonreserved) | definition; added in 8.0.4 (nonreserved) |
| DELAY_KEY_WRITE | delay_key_write |
| DELAYED (R) | delayed (r) |
| DELETE (R) | delete (r) |
| DENSE_RANK (R) | dense_rank (r) |
| DENSE_RANK (R); added in 8.0.2 (reserved) | dense_rank (r); added in 8.0.2 (reserved) |
| DES_KEY_FILE; removed in 8.0.3 | des_key_file; removed in 8.0.3 |
| DESC (R) | desc (r) |
| DESCRIBE (R) | describe (r) |
| DESCRIPTION | description |
| DESCRIPTION; added in 8.0.4 (nonreserved) | description; added in 8.0.4 (nonreserved) |
| DETERMINISTIC (R) | deterministic (r) |
| DIAGNOSTICS | diagnostics |
| DIRECTORY | directory |
| DISABLE | disable |
| DISCARD | discard |
| DISK | disk |
| DISTINCT (R) | distinct (r) |
| DISTINCTROW (R) | distinctrow (r) |
| DIV (R) | div (r) |
| DO | do |
| DOUBLE (R) | double (r) |
| DROP (R) | drop (r) |
| DUAL (R) | dual (r) |
| DUMPFILE | dumpfile |
| DUPLICATE | duplicate |
| DYNAMIC | dynamic |
| E | e |
| EACH (R) | each (r) |
| ELSE (R) | else (r) |
| ELSEIF (R) | elseif (r) |
| EMPTY (R) | empty (r) |
| EMPTY (R); added in 8.0.4 (reserved) | empty (r); added in 8.0.4 (reserved) |
| ENABLE | enable |
| ENCLOSED (R) | enclosed (r) |
| ENCRYPTION | encryption |
| END | end |
| ENDS | ends |
| ENFORCED | enforced |
| ENFORCED; added in 8.0.16 (nonreserved) | enforced; added in 8.0.16 (nonreserved) |
| ENGINE | engine |
| ENGINE_ATTRIBUTE | engine_attribute |
| ENGINE_ATTRIBUTE; added in 8.0.21 (nonreserved) | engine_attribute; added in 8.0.21 (nonreserved) |
| ENGINES | engines |
| ENUM | enum |
| ERROR | error |
| ERRORS | errors |
| ESCAPE | escape |
| ESCAPED (R) | escaped (r) |
| EVENT | event |
| EVENTS | events |
| EVERY | every |
| EXCEPT (R) | except (r) |
| EXCEPT (R) | except (r) |
| EXCHANGE | exchange |
| EXCLUDE | exclude |
| EXCLUDE; added in 8.0.2 (nonreserved) | exclude; added in 8.0.2 (nonreserved) |
| EXECUTE | execute |
| EXISTS (R) | exists (r) |
| EXIT (R) | exit (r) |
| EXPANSION | expansion |
| EXPIRE | expire |
| EXPLAIN (R) | explain (r) |
| EXPORT | export |
| EXTENDED | extended |
| EXTENT_SIZE | extent_size |
| F | f |
| FACTOR | factor |
| FACTOR; added in 8.0.27 (nonreserved) | factor; added in 8.0.27 (nonreserved) |
| FAILED_LOGIN_ATTEMPTS | failed_login_attempts |
| FAILED_LOGIN_ATTEMPTS; added in 8.0.19 (nonreserved) | failed_login_attempts; added in 8.0.19 (nonreserved) |
| FALSE (R) | false (r) |
| FAST | fast |
| FAULTS | faults |
| FETCH (R) | fetch (r) |
| FIELDS | fields |
| FILE | file |
| FILE_BLOCK_SIZE | file_block_size |
| FILTER | filter |
| FINISH | finish |
| FINISH; added in 8.0.27 (nonreserved) | finish; added in 8.0.27 (nonreserved) |
| FIRST | first |
| FIRST_VALUE (R) | first_value (r) |
| FIRST_VALUE (R); added in 8.0.2 (reserved) | first_value (r); added in 8.0.2 (reserved) |
| FIXED | fixed |
| FLOAT (R) | float (r) |
| FLOAT4 (R) | float4 (r) |
| FLOAT8 (R) | float8 (r) |
| FLUSH | flush |
| FOLLOWING | following |
| FOLLOWING; added in 8.0.2 (nonreserved) | following; added in 8.0.2 (nonreserved) |
| FOLLOWS | follows |
| FOR (R) | for (r) |
| FORCE (R) | force (r) |
| FOREIGN (R) | foreign (r) |
| FORMAT | format |
| FOUND | found |
| FROM (R) | from (r) |
| FULL | full |
| FULLTEXT (R) | fulltext (r) |
| FUNCTION (R); became reserved in 8.0.1 | function (r); became reserved in 8.0.1 |
| G | g |
| GENERAL | general |
| GENERATED (R) | generated (r) |
| GEOMCOLLECTION | geomcollection |
| GEOMCOLLECTION; added in 8.0.11 (nonreserved) | geomcollection; added in 8.0.11 (nonreserved) |
| GEOMETRY | geometry |
| GEOMETRYCOLLECTION | geometrycollection |
| GET (R) | get (r) |
| GET_FORMAT | get_format |
| GET_MASTER_PUBLIC_KEY | get_master_public_key |
| GET_MASTER_PUBLIC_KEY; added in 8.0.4 (reserved); became nonreserved in 8.0.11 | get_master_public_key; added in 8.0.4 (reserved); became nonreserved in 8.0.11 |
| GET_SOURCE_PUBLIC_KEY | get_source_public_key |
| GET_SOURCE_PUBLIC_KEY; added in 8.0.23 (nonreserved) | get_source_public_key; added in 8.0.23 (nonreserved) |
| GLOBAL | global |
| GRANT (R) | grant (r) |
| GRANTS | grants |
| GROUP (R) | group (r) |
| GROUP_REPLICATION | group_replication |
| GROUPING (R) | grouping (r) |
| GROUPING (R); added in 8.0.1 (reserved) | grouping (r); added in 8.0.1 (reserved) |
| GROUPS (R) | groups (r) |
| GROUPS (R); added in 8.0.2 (reserved) | groups (r); added in 8.0.2 (reserved) |
| GTID_ONLY | gtid_only |
| GTID_ONLY; added in 8.0.27 (nonreserved) | gtid_only; added in 8.0.27 (nonreserved) |
| H | h |
| HANDLER | handler |
| HASH | hash |
| HAVING (R) | having (r) |
| HELP | help |
| HIGH_PRIORITY (R) | high_priority (r) |
| HISTOGRAM | histogram |
| HISTOGRAM; added in 8.0.2 (nonreserved) | histogram; added in 8.0.2 (nonreserved) |
| HISTORY | history |
| HISTORY; added in 8.0.3 (nonreserved) | history; added in 8.0.3 (nonreserved) |
| HOST | host |
| HOSTS | hosts |
| HOUR | hour |
| HOUR_MICROSECOND (R) | hour_microsecond (r) |
| HOUR_MINUTE (R) | hour_minute (r) |
| HOUR_SECOND (R) | hour_second (r) |
| I | i |
| IDENTIFIED | identified |
| IF (R) | if (r) |
| IGNORE (R) | ignore (r) |
| IGNORE_SERVER_IDS | ignore_server_ids |
| IMPORT | import |
| IN (R) | in (r) |
| INACTIVE | inactive |
| INACTIVE; added in 8.0.14 (nonreserved) | inactive; added in 8.0.14 (nonreserved) |
| INDEX (R) | index (r) |
| INDEXES | indexes |
| INFILE (R) | infile (r) |
| INITIAL | initial |
| INITIAL; added in 8.0.27 (nonreserved) | initial; added in 8.0.27 (nonreserved) |
| INITIAL_SIZE | initial_size |
| INITIATE | initiate |
| INITIATE; added in 8.0.27 (nonreserved) | initiate; added in 8.0.27 (nonreserved) |
| INNER (R) | inner (r) |
| INOUT (R) | inout (r) |
| INSENSITIVE (R) | insensitive (r) |
| INSERT (R) | insert (r) |
| INSERT_METHOD | insert_method |
| INSTALL | install |
| INSTANCE | instance |
| INT (R) | int (r) |
| INT1 (R) | int1 (r) |
| INT2 (R) | int2 (r) |
| INT3 (R) | int3 (r) |
| INT4 (R) | int4 (r) |
| INT8 (R) | int8 (r) |
| INTEGER (R) | integer (r) |
| INTERSECT (R) | intersect (r) |
| INTERSECT (R); added in 8.0.31 (reserved) | intersect (r); added in 8.0.31 (reserved) |
| INTERVAL (R) | interval (r) |
| INTO (R) | into (r) |
| INVISIBLE | invisible |
| INVISIBLE | invisible |
| INVOKER | invoker |
| IO | io |
| IO_AFTER_GTIDS (R) | io_after_gtids (r) |
| IO_BEFORE_GTIDS (R) | io_before_gtids (r) |
| IO_THREAD | io_thread |
| IPC | ipc |
| IS (R) | is (r) |
| ISOLATION | isolation |
| ISSUER | issuer |
| ITERATE (R) | iterate (r) |
| J | j |
| JOIN (R) | join (r) |
| JSON | json |
| JSON_TABLE (R) | json_table (r) |
| JSON_TABLE (R); added in 8.0.4 (reserved) | json_table (r); added in 8.0.4 (reserved) |
| JSON_VALUE | json_value |
| JSON_VALUE; added in 8.0.21 (nonreserved) | json_value; added in 8.0.21 (nonreserved) |
| K | k |
| KEY (R) | key (r) |
| KEY_BLOCK_SIZE | key_block_size |
| KEYRING | keyring |
| KEYRING; added in 8.0.24 (nonreserved) | keyring; added in 8.0.24 (nonreserved) |
| KEYS (R) | keys (r) |
| KILL (R) | kill (r) |
| L | l |
| LAG (R) | lag (r) |
| LAG (R); added in 8.0.2 (reserved) | lag (r); added in 8.0.2 (reserved) |
| LANGUAGE | language |
| LAST | last |
| LAST_VALUE (R) | last_value (r) |
| LAST_VALUE (R); added in 8.0.2 (reserved) | last_value (r); added in 8.0.2 (reserved) |
| LATERAL (R) | lateral (r) |
| LATERAL (R); added in 8.0.14 (reserved) | lateral (r); added in 8.0.14 (reserved) |
| LEAD (R) | lead (r) |
| LEAD (R); added in 8.0.2 (reserved) | lead (r); added in 8.0.2 (reserved) |
| LEADING (R) | leading (r) |
| LEAVE (R) | leave (r) |
| LEAVES | leaves |
| LEFT (R) | left (r) |
| LESS | less |
| LEVEL | level |
| LIKE (R) | like (r) |
| LIMIT (R) | limit (r) |
| LINEAR (R) | linear (r) |
| LINES (R) | lines (r) |
| LINESTRING | linestring |
| LIST | list |
| LOAD (R) | load (r) |
| LOCAL | local |
| LOCALTIME (R) | localtime (r) |
| LOCALTIMESTAMP (R) | localtimestamp (r) |
| LOCK (R) | lock (r) |
| LOCKED | locked |
| LOCKED; added in 8.0.1 (nonreserved) | locked; added in 8.0.1 (nonreserved) |
| LOCKS | locks |
| LOGFILE | logfile |
| LOGS | logs |
| LONG (R) | long (r) |
| LONGBLOB (R) | longblob (r) |
| LONGTEXT (R) | longtext (r) |
| LOOP (R) | loop (r) |
| LOW_PRIORITY (R) | low_priority (r) |
| M | m |
| MASTER | master |
| MASTER_AUTO_POSITION | master_auto_position |
| MASTER_BIND (R) | master_bind (r) |
| MASTER_COMPRESSION_ALGORITHMS | master_compression_algorithms |
| MASTER_COMPRESSION_ALGORITHMS; added in 8.0.18 (nonreserved) | master_compression_algorithms; added in 8.0.18 (nonreserved) |
| MASTER_CONNECT_RETRY | master_connect_retry |
| MASTER_DELAY | master_delay |
| MASTER_HEARTBEAT_PERIOD | master_heartbeat_period |
| MASTER_HOST | master_host |
| MASTER_LOG_FILE | master_log_file |
| MASTER_LOG_POS | master_log_pos |
| MASTER_PASSWORD | master_password |
| MASTER_PORT | master_port |
| MASTER_PUBLIC_KEY_PATH | master_public_key_path |
| MASTER_PUBLIC_KEY_PATH; added in 8.0.4 (nonreserved) | master_public_key_path; added in 8.0.4 (nonreserved) |
| MASTER_RETRY_COUNT | master_retry_count |
| MASTER_SERVER_ID; removed in 8.0.23 | master_server_id; removed in 8.0.23 |
| MASTER_SSL | master_ssl |
| MASTER_SSL_CA | master_ssl_ca |
| MASTER_SSL_CAPATH | master_ssl_capath |
| MASTER_SSL_CERT | master_ssl_cert |
| MASTER_SSL_CIPHER | master_ssl_cipher |
| MASTER_SSL_CRL | master_ssl_crl |
| MASTER_SSL_CRLPATH | master_ssl_crlpath |
| MASTER_SSL_KEY | master_ssl_key |
| MASTER_SSL_VERIFY_SERVER_CERT (R) | master_ssl_verify_server_cert (r) |
| MASTER_TLS_CIPHERSUITES | master_tls_ciphersuites |
| MASTER_TLS_CIPHERSUITES; added in 8.0.19 (nonreserved) | master_tls_ciphersuites; added in 8.0.19 (nonreserved) |
| MASTER_TLS_VERSION | master_tls_version |
| MASTER_USER | master_user |
| MASTER_ZSTD_COMPRESSION_LEVEL | master_zstd_compression_level |
| MASTER_ZSTD_COMPRESSION_LEVEL; added in 8.0.18 (nonreserved) | master_zstd_compression_level; added in 8.0.18 (nonreserved) |
| MATCH (R) | match (r) |
| MAX_CONNECTIONS_PER_HOUR | max_connections_per_hour |
| MAX_QUERIES_PER_HOUR | max_queries_per_hour |
| MAX_ROWS | max_rows |
| MAX_SIZE | max_size |
| MAX_UPDATES_PER_HOUR | max_updates_per_hour |
| MAX_USER_CONNECTIONS | max_user_connections |
| MAXVALUE (R) | maxvalue (r) |
| MEDIUM | medium |
| MEDIUMBLOB (R) | mediumblob (r) |
| MEDIUMINT (R) | mediumint (r) |
| MEDIUMTEXT (R) | mediumtext (r) |
| MEMBER | member |
| MEMBER; added in 8.0.17 (reserved); became nonreserved in 8.0.19 | member; added in 8.0.17 (reserved); became nonreserved in 8.0.19 |
| MEMORY | memory |
| MERGE | merge |
| MESSAGE_TEXT | message_text |
| MICROSECOND | microsecond |
| MIDDLEINT (R) | middleint (r) |
| MIGRATE | migrate |
| MIN_ROWS | min_rows |
| MINUTE | minute |
| MINUTE_MICROSECOND (R) | minute_microsecond (r) |
| MINUTE_SECOND (R) | minute_second (r) |
| MOD (R) | mod (r) |
| MODE | mode |
| MODIFIES (R) | modifies (r) |
| MODIFY | modify |
| MONTH | month |
| MULTILINESTRING | multilinestring |
| MULTIPOINT | multipoint |
| MULTIPOLYGON | multipolygon |
| MUTEX | mutex |
| MySQL 8.0 New Keywords and Reserved Words | mysql 8.0 new keywords and reserved words |
| MYSQL_ERRNO | mysql_errno |
| N | n |
| NAME | name |
| NAMES | names |
| NATIONAL | national |
| NATURAL (R) | natural (r) |
| NCHAR | nchar |
| NDB | ndb |
| NDBCLUSTER | ndbcluster |
| NESTED | nested |
| NESTED; added in 8.0.4 (nonreserved) | nested; added in 8.0.4 (nonreserved) |
| NETWORK_NAMESPACE | network_namespace |
| NETWORK_NAMESPACE; added in 8.0.16 (nonreserved) | network_namespace; added in 8.0.16 (nonreserved) |
| NEVER | never |
| NEW | new |
| NEXT | next |
| NO | no |
| NO_WAIT | no_wait |
| NO_WRITE_TO_BINLOG (R) | no_write_to_binlog (r) |
| NODEGROUP | nodegroup |
| NONE | none |
| NOT (R) | not (r) |
| NOWAIT | nowait |
| NOWAIT; added in 8.0.1 (nonreserved) | nowait; added in 8.0.1 (nonreserved) |
| NTH_VALUE (R) | nth_value (r) |
| NTH_VALUE (R); added in 8.0.2 (reserved) | nth_value (r); added in 8.0.2 (reserved) |
| NTILE (R) | ntile (r) |
| NTILE (R); added in 8.0.2 (reserved) | ntile (r); added in 8.0.2 (reserved) |
| NULL (R) | null (r) |
| NULLS | nulls |
| NULLS; added in 8.0.2 (nonreserved) | nulls; added in 8.0.2 (nonreserved) |
| NUMBER | number |
| NUMERIC (R) | numeric (r) |
| NVARCHAR | nvarchar |
| O | o |
| OF (R) | of (r) |
| OF (R); added in 8.0.1 (reserved) | of (r); added in 8.0.1 (reserved) |
| OFF | off |
| OFF; added in 8.0.20 (nonreserved) | off; added in 8.0.20 (nonreserved) |
| OFFSET | offset |
| OJ | oj |
| OJ; added in 8.0.16 (nonreserved) | oj; added in 8.0.16 (nonreserved) |
| OLD | old |
| OLD; added in 8.0.14 (nonreserved) | old; added in 8.0.14 (nonreserved) |
| ON (R) | on (r) |
| ONE | one |
| ONLY | only |
| OPEN | open |
| OPTIMIZE (R) | optimize (r) |
| OPTIMIZER_COSTS (R) | optimizer_costs (r) |
| OPTION (R) | option (r) |
| OPTIONAL | optional |
| OPTIONAL; added in 8.0.13 (nonreserved) | optional; added in 8.0.13 (nonreserved) |
| OPTIONALLY (R) | optionally (r) |
| OPTIONS | options |
| OR (R) | or (r) |
| ORDER (R) | order (r) |
| ORDINALITY | ordinality |
| ORDINALITY; added in 8.0.4 (nonreserved) | ordinality; added in 8.0.4 (nonreserved) |
| ORGANIZATION | organization |
| ORGANIZATION; added in 8.0.4 (nonreserved) | organization; added in 8.0.4 (nonreserved) |
| OTHERS | others |
| OTHERS; added in 8.0.2 (nonreserved) | others; added in 8.0.2 (nonreserved) |
| OUT (R) | out (r) |
| OUTER (R) | outer (r) |
| OUTFILE (R) | outfile (r) |
| OVER (R) | over (r) |
| OVER (R); added in 8.0.2 (reserved) | over (r); added in 8.0.2 (reserved) |
| OWNER | owner |
| P | p |
| PACK_KEYS | pack_keys |
| PAGE | page |
| PARSER | parser |
| PARTIAL | partial |
| PARTITION (R) | partition (r) |
| PARTITIONING | partitioning |
| PARTITIONS | partitions |
| PASSWORD | password |
| PASSWORD_LOCK_TIME | password_lock_time |
| PASSWORD_LOCK_TIME; added in 8.0.19 (nonreserved) | password_lock_time; added in 8.0.19 (nonreserved) |
| PATH | path |
| PATH; added in 8.0.4 (nonreserved) | path; added in 8.0.4 (nonreserved) |
| PERCENT_RANK (R) | percent_rank (r) |
| PERCENT_RANK (R); added in 8.0.2 (reserved) | percent_rank (r); added in 8.0.2 (reserved) |
| PERSIST | persist |
| PERSIST; became nonreserved in 8.0.16 | persist; became nonreserved in 8.0.16 |
| PERSIST_ONLY | persist_only |
| PERSIST_ONLY; added in 8.0.2 (reserved); became nonreserved in 8.0.16 | persist_only; added in 8.0.2 (reserved); became nonreserved in 8.0.16 |
| PHASE | phase |
| PLUGIN | plugin |
| PLUGIN_DIR | plugin_dir |
| PLUGINS | plugins |
| POINT | point |
| POLYGON | polygon |
| PORT | port |
| PRECEDES | precedes |
| PRECEDING | preceding |
| PRECEDING; added in 8.0.2 (nonreserved) | preceding; added in 8.0.2 (nonreserved) |
| PRECISION (R) | precision (r) |
| PREPARE | prepare |
| PRESERVE | preserve |
| PREV | prev |
| PRIMARY (R) | primary (r) |
| PRIVILEGE_CHECKS_USER | privilege_checks_user |
| PRIVILEGE_CHECKS_USER; added in 8.0.18 (nonreserved) | privilege_checks_user; added in 8.0.18 (nonreserved) |
| PRIVILEGES | privileges |
| PROCEDURE (R) | procedure (r) |
| PROCESS | process |
| PROCESS; added in 8.0.11 (nonreserved) | process; added in 8.0.11 (nonreserved) |
| PROCESSLIST | processlist |
| PROFILE | profile |
| PROFILES | profiles |
| PROXY | proxy |
| PURGE (R) | purge (r) |
| Q | q |
| QUARTER | quarter |
| QUERY | query |
| QUICK | quick |
| R | r |
| RANDOM | random |
| RANDOM; added in 8.0.18 (nonreserved) | random; added in 8.0.18 (nonreserved) |
| RANGE (R) | range (r) |
| RANK (R) | rank (r) |
| RANK (R); added in 8.0.2 (reserved) | rank (r); added in 8.0.2 (reserved) |
| READ (R) | read (r) |
| READ_ONLY | read_only |
| READ_WRITE (R) | read_write (r) |
| READS (R) | reads (r) |
| REAL (R) | real (r) |
| REBUILD | rebuild |
| RECOVER | recover |
| RECURSIVE (R) | recursive (r) |
| RECURSIVE (R); added in 8.0.1 (reserved) | recursive (r); added in 8.0.1 (reserved) |
| REDO_BUFFER_SIZE | redo_buffer_size |
| REDOFILE; removed in 8.0.3 | redofile; removed in 8.0.3 |
| REDUNDANT | redundant |
| REFERENCE | reference |
| REFERENCE; added in 8.0.4 (nonreserved) | reference; added in 8.0.4 (nonreserved) |
| REFERENCES (R) | references (r) |
| REGEXP (R) | regexp (r) |
| REGISTRATION | registration |
| REGISTRATION; added in 8.0.27 (nonreserved) | registration; added in 8.0.27 (nonreserved) |
| RELAY | relay |
| RELAY_LOG_FILE | relay_log_file |
| RELAY_LOG_POS | relay_log_pos |
| RELAY_THREAD | relay_thread |
| RELAYLOG | relaylog |
| RELEASE (R) | release (r) |
| RELOAD | reload |
| REMOTE; added in 8.0.3 (nonreserved); removed in 8.0.14 | remote; added in 8.0.3 (nonreserved); removed in 8.0.14 |
| REMOVE | remove |
| RENAME (R) | rename (r) |
| REORGANIZE | reorganize |
| REPAIR | repair |
| REPEAT (R) | repeat (r) |
| REPEATABLE | repeatable |
| REPLACE (R) | replace (r) |
| REPLICA | replica |
| REPLICA; added in 8.0.22 (nonreserved) | replica; added in 8.0.22 (nonreserved) |
| REPLICAS | replicas |
| REPLICAS; added in 8.0.22 (nonreserved) | replicas; added in 8.0.22 (nonreserved) |
| REPLICATE_DO_DB | replicate_do_db |
| REPLICATE_DO_TABLE | replicate_do_table |
| REPLICATE_IGNORE_DB | replicate_ignore_db |
| REPLICATE_IGNORE_TABLE | replicate_ignore_table |
| REPLICATE_REWRITE_DB | replicate_rewrite_db |
| REPLICATE_WILD_DO_TABLE | replicate_wild_do_table |
| REPLICATE_WILD_IGNORE_TABLE | replicate_wild_ignore_table |
| REPLICATION | replication |
| REQUIRE (R) | require (r) |
| REQUIRE_ROW_FORMAT | require_row_format |
| REQUIRE_ROW_FORMAT; added in 8.0.19 (nonreserved) | require_row_format; added in 8.0.19 (nonreserved) |
| RESET | reset |
| RESIGNAL (R) | resignal (r) |
| RESOURCE | resource |
| RESOURCE; added in 8.0.3 (nonreserved) | resource; added in 8.0.3 (nonreserved) |
| RESPECT | respect |
| RESPECT; added in 8.0.2 (nonreserved) | respect; added in 8.0.2 (nonreserved) |
| RESTART | restart |
| RESTART; added in 8.0.4 (nonreserved) | restart; added in 8.0.4 (nonreserved) |
| RESTORE | restore |
| RESTRICT (R) | restrict (r) |
| RESUME | resume |
| RETAIN | retain |
| RETAIN; added in 8.0.14 (nonreserved) | retain; added in 8.0.14 (nonreserved) |
| RETURN (R) | return (r) |
| RETURNED_SQLSTATE | returned_sqlstate |
| RETURNING | returning |
| RETURNING; added in 8.0.21 (nonreserved) | returning; added in 8.0.21 (nonreserved) |
| RETURNS | returns |
| REUSE | reuse |
| REUSE; added in 8.0.3 (nonreserved) | reuse; added in 8.0.3 (nonreserved) |
| REVERSE | reverse |
| REVOKE (R) | revoke (r) |
| RIGHT (R) | right (r) |
| RLIKE (R) | rlike (r) |
| ROLE | role |
| ROLE; became nonreserved in 8.0.1 | role; became nonreserved in 8.0.1 |
| ROLLBACK | rollback |
| ROLLUP | rollup |
| ROTATE | rotate |
| ROUTINE | routine |
| ROW (R); became reserved in 8.0.2 | row (r); became reserved in 8.0.2 |
| ROW_COUNT | row_count |
| ROW_FORMAT | row_format |
| ROW_NUMBER (R) | row_number (r) |
| ROW_NUMBER (R); added in 8.0.2 (reserved) | row_number (r); added in 8.0.2 (reserved) |
| ROWS (R); became reserved in 8.0.2 | rows (r); became reserved in 8.0.2 |
| RTREE | rtree |
| S | s |
| SAVEPOINT | savepoint |
| SCHEDULE | schedule |
| SCHEMA (R) | schema (r) |
| SCHEMA_NAME | schema_name |
| SCHEMAS (R) | schemas (r) |
| SECOND | second |
| SECOND_MICROSECOND (R) | second_microsecond (r) |
| SECONDARY | secondary |
| SECONDARY; added in 8.0.16 (nonreserved) | secondary; added in 8.0.16 (nonreserved) |
| SECONDARY_ENGINE | secondary_engine |
| SECONDARY_ENGINE; added in 8.0.13 (nonreserved) | secondary_engine; added in 8.0.13 (nonreserved) |
| SECONDARY_ENGINE_ATTRIBUTE | secondary_engine_attribute |
| SECONDARY_ENGINE_ATTRIBUTE; added in 8.0.21 (nonreserved) | secondary_engine_attribute; added in 8.0.21 (nonreserved) |
| SECONDARY_LOAD | secondary_load |
| SECONDARY_LOAD; added in 8.0.13 (nonreserved) | secondary_load; added in 8.0.13 (nonreserved) |
| SECONDARY_UNLOAD | secondary_unload |
| SECONDARY_UNLOAD; added in 8.0.13 (nonreserved) | secondary_unload; added in 8.0.13 (nonreserved) |
| SECURITY | security |
| SELECT (R) | select (r) |
| SENSITIVE (R) | sensitive (r) |
| SEPARATOR (R) | separator (r) |
| SERIAL | serial |
| SERIALIZABLE | serializable |
| SERVER | server |
| SESSION | session |
| SET (R) | set (r) |
| SHARE | share |
| SHOW (R) | show (r) |
| SHUTDOWN | shutdown |
| SIGNAL (R) | signal (r) |
| SIGNED | signed |
| SIMPLE | simple |
| SKIP | skip |
| SKIP; added in 8.0.1 (nonreserved) | skip; added in 8.0.1 (nonreserved) |
| SLAVE | slave |
| SLOW | slow |
| SMALLINT (R) | smallint (r) |
| SNAPSHOT | snapshot |
| SOCKET | socket |
| SOME | some |
| SONAME | soname |
| SOUNDS | sounds |
| SOURCE | source |
| SOURCE_AUTO_POSITION | source_auto_position |
| SOURCE_AUTO_POSITION; added in 8.0.23 (nonreserved) | source_auto_position; added in 8.0.23 (nonreserved) |
| SOURCE_BIND | source_bind |
| SOURCE_BIND; added in 8.0.23 (nonreserved) | source_bind; added in 8.0.23 (nonreserved) |
| SOURCE_COMPRESSION_ALGORITHMS | source_compression_algorithms |
| SOURCE_COMPRESSION_ALGORITHMS; added in 8.0.23 (nonreserved) | source_compression_algorithms; added in 8.0.23 (nonreserved) |
| SOURCE_CONNECT_RETRY | source_connect_retry |
| SOURCE_CONNECT_RETRY; added in 8.0.23 (nonreserved) | source_connect_retry; added in 8.0.23 (nonreserved) |
| SOURCE_DELAY | source_delay |
| SOURCE_DELAY; added in 8.0.23 (nonreserved) | source_delay; added in 8.0.23 (nonreserved) |
| SOURCE_HEARTBEAT_PERIOD | source_heartbeat_period |
| SOURCE_HEARTBEAT_PERIOD; added in 8.0.23 (nonreserved) | source_heartbeat_period; added in 8.0.23 (nonreserved) |
| SOURCE_HOST | source_host |
| SOURCE_HOST; added in 8.0.23 (nonreserved) | source_host; added in 8.0.23 (nonreserved) |
| SOURCE_LOG_FILE | source_log_file |
| SOURCE_LOG_FILE; added in 8.0.23 (nonreserved) | source_log_file; added in 8.0.23 (nonreserved) |
| SOURCE_LOG_POS | source_log_pos |
| SOURCE_LOG_POS; added in 8.0.23 (nonreserved) | source_log_pos; added in 8.0.23 (nonreserved) |
| SOURCE_PASSWORD | source_password |
| SOURCE_PASSWORD; added in 8.0.23 (nonreserved) | source_password; added in 8.0.23 (nonreserved) |
| SOURCE_PORT | source_port |
| SOURCE_PORT; added in 8.0.23 (nonreserved) | source_port; added in 8.0.23 (nonreserved) |
| SOURCE_PUBLIC_KEY_PATH | source_public_key_path |
| SOURCE_PUBLIC_KEY_PATH; added in 8.0.23 (nonreserved) | source_public_key_path; added in 8.0.23 (nonreserved) |
| SOURCE_RETRY_COUNT | source_retry_count |
| SOURCE_RETRY_COUNT; added in 8.0.23 (nonreserved) | source_retry_count; added in 8.0.23 (nonreserved) |
| SOURCE_SSL | source_ssl |
| SOURCE_SSL; added in 8.0.23 (nonreserved) | source_ssl; added in 8.0.23 (nonreserved) |
| SOURCE_SSL_CA | source_ssl_ca |
| SOURCE_SSL_CA; added in 8.0.23 (nonreserved) | source_ssl_ca; added in 8.0.23 (nonreserved) |
| SOURCE_SSL_CAPATH | source_ssl_capath |
| SOURCE_SSL_CAPATH; added in 8.0.23 (nonreserved) | source_ssl_capath; added in 8.0.23 (nonreserved) |
| SOURCE_SSL_CERT | source_ssl_cert |
| SOURCE_SSL_CERT; added in 8.0.23 (nonreserved) | source_ssl_cert; added in 8.0.23 (nonreserved) |
| SOURCE_SSL_CIPHER | source_ssl_cipher |
| SOURCE_SSL_CIPHER; added in 8.0.23 (nonreserved) | source_ssl_cipher; added in 8.0.23 (nonreserved) |
| SOURCE_SSL_CRL | source_ssl_crl |
| SOURCE_SSL_CRL; added in 8.0.23 (nonreserved) | source_ssl_crl; added in 8.0.23 (nonreserved) |
| SOURCE_SSL_CRLPATH | source_ssl_crlpath |
| SOURCE_SSL_CRLPATH; added in 8.0.23 (nonreserved) | source_ssl_crlpath; added in 8.0.23 (nonreserved) |
| SOURCE_SSL_KEY | source_ssl_key |
| SOURCE_SSL_KEY; added in 8.0.23 (nonreserved) | source_ssl_key; added in 8.0.23 (nonreserved) |
| SOURCE_SSL_VERIFY_SERVER_CERT | source_ssl_verify_server_cert |
| SOURCE_SSL_VERIFY_SERVER_CERT; added in 8.0.23 (nonreserved) | source_ssl_verify_server_cert; added in 8.0.23 (nonreserved) |
| SOURCE_TLS_CIPHERSUITES | source_tls_ciphersuites |
| SOURCE_TLS_CIPHERSUITES; added in 8.0.23 (nonreserved) | source_tls_ciphersuites; added in 8.0.23 (nonreserved) |
| SOURCE_TLS_VERSION | source_tls_version |
| SOURCE_TLS_VERSION; added in 8.0.23 (nonreserved) | source_tls_version; added in 8.0.23 (nonreserved) |
| SOURCE_USER | source_user |
| SOURCE_USER; added in 8.0.23 (nonreserved) | source_user; added in 8.0.23 (nonreserved) |
| SOURCE_ZSTD_COMPRESSION_LEVEL | source_zstd_compression_level |
| SOURCE_ZSTD_COMPRESSION_LEVEL; added in 8.0.23 (nonreserved) | source_zstd_compression_level; added in 8.0.23 (nonreserved) |
| SPATIAL (R) | spatial (r) |
| SPECIFIC (R) | specific (r) |
| SQL (R) | sql (r) |
| SQL_AFTER_GTIDS | sql_after_gtids |
| SQL_AFTER_MTS_GAPS | sql_after_mts_gaps |
| SQL_BEFORE_GTIDS | sql_before_gtids |
| SQL_BIG_RESULT (R) | sql_big_result (r) |
| SQL_BUFFER_RESULT | sql_buffer_result |
| SQL_CACHE; removed in 8.0.3 | sql_cache; removed in 8.0.3 |
| SQL_CALC_FOUND_ROWS (R) | sql_calc_found_rows (r) |
| SQL_NO_CACHE | sql_no_cache |
| SQL_SMALL_RESULT (R) | sql_small_result (r) |
| SQL_THREAD | sql_thread |
| SQL_TSI_DAY | sql_tsi_day |
| SQL_TSI_HOUR | sql_tsi_hour |
| SQL_TSI_MINUTE | sql_tsi_minute |
| SQL_TSI_MONTH | sql_tsi_month |
| SQL_TSI_QUARTER | sql_tsi_quarter |
| SQL_TSI_SECOND | sql_tsi_second |
| SQL_TSI_WEEK | sql_tsi_week |
| SQL_TSI_YEAR | sql_tsi_year |
| SQLEXCEPTION (R) | sqlexception (r) |
| SQLSTATE (R) | sqlstate (r) |
| SQLWARNING (R) | sqlwarning (r) |
| SRID | srid |
| SRID; added in 8.0.3 (nonreserved) | srid; added in 8.0.3 (nonreserved) |
| SSL (R) | ssl (r) |
| STACKED | stacked |
| START | start |
| STARTING (R) | starting (r) |
| STARTS | starts |
| STATS_AUTO_RECALC | stats_auto_recalc |
| STATS_PERSISTENT | stats_persistent |
| STATS_SAMPLE_PAGES | stats_sample_pages |
| STATUS | status |
| STOP | stop |
| STORAGE | storage |
| STORED (R) | stored (r) |
| STRAIGHT_JOIN (R) | straight_join (r) |
| STREAM | stream |
| STREAM; added in 8.0.20 (nonreserved) | stream; added in 8.0.20 (nonreserved) |
| STRING | string |
| SUBCLASS_ORIGIN | subclass_origin |
| SUBJECT | subject |
| SUBPARTITION | subpartition |
| SUBPARTITIONS | subpartitions |
| SUPER | super |
| SUSPEND | suspend |
| SWAPS | swaps |
| SWITCHES | switches |
| SYSTEM (R) | system (r) |
| SYSTEM (R); added in 8.0.3 (reserved) | system (r); added in 8.0.3 (reserved) |
| T | t |
| TABLE (R) | table (r) |
| TABLE_CHECKSUM | table_checksum |
| TABLE_NAME | table_name |
| TABLES | tables |
| TABLESPACE | tablespace |
| TEMPORARY | temporary |
| TEMPTABLE | temptable |
| TERMINATED (R) | terminated (r) |
| TEXT | text |
| THAN | than |
| The following list shows the keywords and reserved words that are added in MySQL 8.0, compared to MySQL 5.7. Reserved keywords are marked with (R). | the following list shows the keywords and reserved words that are added in mysql 8.0, compared to mysql 5.7. reserved keywords are marked with (r). |
| THEN (R) | then (r) |
| THREAD_PRIORITY | thread_priority |
| THREAD_PRIORITY; added in 8.0.3 (nonreserved) | thread_priority; added in 8.0.3 (nonreserved) |
| TIES | ties |
| TIES; added in 8.0.2 (nonreserved) | ties; added in 8.0.2 (nonreserved) |
| TIME | time |
| TIMESTAMP | timestamp |
| TIMESTAMPADD | timestampadd |
| TIMESTAMPDIFF | timestampdiff |
| TINYBLOB (R) | tinyblob (r) |
| TINYINT (R) | tinyint (r) |
| TINYTEXT (R) | tinytext (r) |
| TLS | tls |
| TLS; added in 8.0.21 (nonreserved) | tls; added in 8.0.21 (nonreserved) |
| TO (R) | to (r) |
| TRAILING (R) | trailing (r) |
| TRANSACTION | transaction |
| TRIGGER (R) | trigger (r) |
| TRIGGERS | triggers |
| TRUE (R) | true (r) |
| TRUNCATE | truncate |
| TYPE | type |
| TYPES | types |
| U | u |
| UNBOUNDED | unbounded |
| UNBOUNDED; added in 8.0.2 (nonreserved) | unbounded; added in 8.0.2 (nonreserved) |
| UNCOMMITTED | uncommitted |
| UNDEFINED | undefined |
| UNDO (R) | undo (r) |
| UNDO_BUFFER_SIZE | undo_buffer_size |
| UNDOFILE | undofile |
| UNICODE | unicode |
| UNINSTALL | uninstall |
| UNION (R) | union (r) |
| UNIQUE (R) | unique (r) |
| UNKNOWN | unknown |
| UNLOCK (R) | unlock (r) |
| UNREGISTER | unregister |
| UNREGISTER; added in 8.0.27 (nonreserved) | unregister; added in 8.0.27 (nonreserved) |
| UNSIGNED (R) | unsigned (r) |
| UNTIL | until |
| UPDATE (R) | update (r) |
| UPGRADE | upgrade |
| USAGE (R) | usage (r) |
| USE (R) | use (r) |
| USE_FRM | use_frm |
| USER | user |
| USER_RESOURCES | user_resources |
| USING (R) | using (r) |
| UTC_DATE (R) | utc_date (r) |
| UTC_TIME (R) | utc_time (r) |
| UTC_TIMESTAMP (R) | utc_timestamp (r) |
| V | v |
| VALIDATION | validation |
| VALUE | value |
| VALUES (R) | values (r) |
| VARBINARY (R) | varbinary (r) |
| VARCHAR (R) | varchar (r) |
| VARCHARACTER (R) | varcharacter (r) |
| VARIABLES | variables |
| VARYING (R) | varying (r) |
| VCPU | vcpu |
| VCPU; added in 8.0.3 (nonreserved) | vcpu; added in 8.0.3 (nonreserved) |
| VIEW | view |
| VIRTUAL (R) | virtual (r) |
| VISIBLE | visible |
| VISIBLE | visible |
| W | w |
| WAIT | wait |
| WARNINGS | warnings |
| WEEK | week |
| WEIGHT_STRING | weight_string |
| WHEN (R) | when (r) |
| WHERE (R) | where (r) |
| WHILE (R) | while (r) |
| WINDOW (R) | window (r) |
| WINDOW (R); added in 8.0.2 (reserved) | window (r); added in 8.0.2 (reserved) |
| WITH (R) | with (r) |
| WITHOUT | without |
| WORK | work |
| WRAPPER | wrapper |
| WRITE (R) | write (r) |
| X | x |
| X509 | x509 |
| XA | xa |
| XID | xid |
| XML | xml |
| XOR (R) | xor (r) |
| Y | y |
| YEAR | year |
| YEAR_MONTH (R) | year_month (r) |
| Z | z |
| ZEROFILL (R) | zerofill (r) |
| ZONE | zone |
| ZONE; added in 8.0.22 (nonreserved) | zone; added in 8.0.22 (nonreserved) |
8245
09-01
“相关推荐”对你有帮助么？
-
非常没帮助 -
没帮助 -
一般 -
有帮助 -
非常有帮助
提交
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
