MySQL 5.7關鍵字、保留詞
- 1.官網位址:https://dev.mysql.com/doc/refman/5.7/en/keywords.html
- ---- 共:622個關鍵字
- A【24個】
- B【16個】
- C【57個】
- D【40個】
- E【28個】
- F【24個】
- G【11個】
- H【11個】
- I【36個】
- J【2個】
- K【4個】
- L【27個】
- M【57個】
- N【21個】
- O【17個】
- P【29個】
- Q【3個】
- R【57個】
- S【77個】
- T【27個】
- U【24個】
- V【10個】
- W【12個】
- X【5個】
- Y【2個】
- Z【1個】
1.官網位址:https://dev.mysql.com/doc/refman/5.7/en/keywords.html
---- 共:622個關鍵字
A【24個】
- ACCESSIBLE ®
- ACCOUNT; added in 5.7.6 (nonreserved)
- ACTION
- ADD ®
- AFTER
- AGAINST
- AGGREGATE
- ALGORITHM
- ALL ®
- ALTER ®
- ALWAYS; added in 5.7.6 (nonreserved)
- ANALYSE
- ANALYZE ®
- AND ®
- ANY
- AS ®
- ASC ®
- ASCII
- ASENSITIVE ®
- AT
- AUTOEXTEND_SIZE
- AUTO_INCREMENT
- AVG
- AVG_ROW_LENGTH
B【16個】
- BACKUP
- BEFORE ®
- BEGIN
- BETWEEN ®
- BIGINT ®
- BINARY ®
- BINLOG
- BIT
- BLOB ®
- BLOCK
- BOOL
- BOOLEAN
- BOTH ®
- BTREE
- BY ®
- BYTE
C【57個】
- CACHE
- CALL ®
- CASCADE ®
- CASCADED
- CASE ®
- CATALOG_NAME
- CHAIN
- CHANGE ®
- CHANGED
- CHANNEL; added in 5.7.6 (nonreserved)
- CHAR ®
- CHARACTER ®
- CHARSET
- CHECK ®
- CHECKSUM
- CIPHER
- CLASS_ORIGIN
- CLIENT
- CLOSE
- COALESCE
- CODE
- COLLATE ®
- COLLATION
- COLUMN ®
- COLUMNS
- COLUMN_FORMAT
- COLUMN_NAME
- COMMENT
- COMMIT
- COMMITTED
- COMPACT
- COMPLETION
- COMPRESSED
- COMPRESSION; added in 5.7.8 (nonreserved)
- CONCURRENT
- CONDITION ®
- CONNECTION
- CONSISTENT
- CONSTRAINT ®
- CONSTRAINT_CATALOG
- CONSTRAINT_NAME
- CONSTRAINT_SCHEMA
- CONTAINS
- CONTEXT
- CONTINUE ®
- CONVERT ®
- CPU
- CREATE ®
- CROSS ®
- CUBE
- CURRENT
- CURRENT_DATE ®
- CURRENT_TIME ®
- CURRENT_TIMESTAMP ®
- CURRENT_USER ®
- CURSOR ®
- CURSOR_NAME
D【40個】
- DATA
- DATABASE ®
- DATABASES ®
- DATAFILE
- DATE
- DATETIME
- DAY
- DAY_HOUR ®
- DAY_MICROSECOND ®
- DAY_MINUTE ®
- DAY_SECOND ®
- DEALLOCATE
- DEC ®
- DECIMAL ®
- DECLARE ®
- DEFAULT ®
- DEFAULT_AUTH
- DEFINER
- DELAYED ®
- DELAY_KEY_WRITE
- DELETE ®
- DESC ®
- DESCRIBE ®
- DES_KEY_FILE
- DETERMINISTIC ®
- DIAGNOSTICS
- DIRECTORY
- DISABLE
- DISCARD
- DISK
- DISTINCT ®
- DISTINCTROW ®
- DIV ®
- DO
- DOUBLE ®
- DROP ®
- DUAL ®
- DUMPFILE
- DUPLICATE
- DYNAMIC
E【28個】
- EACH ®
- ELSE ®
- ELSEIF ®
- ENABLE
- ENCLOSED ®
- ENCRYPTION; added in 5.7.11 (nonreserved)
- END
- ENDS
- ENGINE
- ENGINES
- ENUM
- ERROR
- ERRORS
- ESCAPE
- ESCAPED ®
- EVENT
- EVENTS
- EVERY
- EXCHANGE
- EXECUTE
- EXISTS ®
- EXIT ®
- EXPANSION
- EXPIRE
- EXPLAIN ®
- EXPORT
- EXTENDED
- EXTENT_SIZE
F【24個】
- FALSE ®
- FAST
- FAULTS
- FETCH ®
- FIELDS
- FILE
- FILE_BLOCK_SIZE; added in 5.7.6 (nonreserved)
- FILTER; added in 5.7.3 (nonreserved)
- FIRST
- FIXED
- FLOAT ®
- FLOAT4 ®
- FLOAT8 ®
- FLUSH
- FOLLOWS; added in 5.7.2 (nonreserved)
- FOR ®
- FORCE ®
- FOREIGN ®
- FORMAT
- FOUND
- FROM ®
- FULL
- FULLTEXT ®
- FUNCTION
G【11個】
- GENERAL
- GENERATED ®; added in 5.7.6 (reserved)
- GEOMETRY
- GEOMETRYCOLLECTION
- GET ®
- GET_FORMAT
- GLOBAL
- GRANT ®
- GRANTS
- GROUP ®
- GROUP_REPLICATION; added in 5.7.6 (nonreserved)
H【11個】
- HANDLER
- HASH
- HAVING ®
- HELP
- HIGH_PRIORITY ®
- HOST
- HOSTS
- HOUR_MICROSECOND ®
- HOUR_MINUTE ®
- HOUR_SECOND ®
I【36個】
- IDENTIFIED
- IF ®
- IGNORE ®
- IGNORE_SERVER_IDS
- IMPORT
- IN ®
- INDEX ®
- INDEXES
- INFILE ®
- INITIAL_SIZE
- INNER ®
- INOUT ®
- INSENSITIVE ®
- INSERT ®
- INSERT_METHOD
- INSTALL
- INSTANCE; added in 5.7.11 (nonreserved)
- INT ®
- INT1 ®
- INT2 ®
- INT3 ®
- INT4 ®
- INT8 ®
- INTEGER ®
- INTERVAL ®
- INTO ®
- INVOKER
- IO
- IO_AFTER_GTIDS ®
- IO_BEFORE_GTIDS ®
- IO_THREAD
- IPC
- IS ®
- ISOLATION
- ISSUER
- ITERATE ®
J【2個】
- JOIN ®
- JSON; added in 5.7.8 (nonreserved)
K【4個】
- KEY ®
- KEYS ®
- KEY_BLOCK_SIZE
- KILL ®
L【27個】
- LANGUAGE
- LAST
- LEADING ®
- LEAVE ®
- LEAVES
- LEFT ®
- LESS
- LEVEL
- LIKE ®
- LIMIT ®
- LINEAR ®
- LINES ®
- LINESTRING
- LIST
- LOAD ®
- LOCAL
- LOCALTIME ®
- LOCALTIMESTAMP ®
- LOCK ®
- LOCKS
- LOGFILE
- LOGS
- LONG ®
- LONGBLOB ®
- LONGTEXT ®
- LOOP ®
- LOW_PRIORITY ®
M【57個】
- MASTER
- MASTER_AUTO_POSITION
- MASTER_BIND ®
- MASTER_CONNECT_RETRY
- MASTER_DELAY
- MASTER_HEARTBEAT_PERIOD
- MASTER_HOST
- MASTER_LOG_FILE
- MASTER_LOG_POS
- MASTER_PASSWORD
- MASTER_PORT
- MASTER_RETRY_COUNT
- MASTER_SERVER_ID
- MASTER_SSL
- MASTER_SSL_CA
- MASTER_SSL_CAPATH
- MASTER_SSL_CERT
- MASTER_SSL_CIPHER
- MASTER_SSL_CRL
- MASTER_SSL_CRLPATH
- MASTER_SSL_KEY
- MASTER_SSL_VERIFY_SERVER_CERT ®
- MASTER_TLS_VERSION; added in 5.7.10 (nonreserved)
- MASTER_USER
- MATCH ®
- MAXVALUE ®
- MAX_CONNECTIONS_PER_HOUR
- MAX_QUERIES_PER_HOUR
- MAX_ROWS
- MAX_SIZE
- MAX_STATEMENT_TIME; added in 5.7.4 (nonreserved); removed in 5.7.8
- MAX_UPDATES_PER_HOUR
- MAX_USER_CONNECTIONS
- MEDIUM
- MEDIUMBLOB ®
- MEDIUMINT ®
- MEDIUMTEXT ®
- MEMORY
- MERGE
- MESSAGE_TEXT
- MICROSECOND
- MIDDLEINT ®
- MIGRATE
- MINUTE
- MINUTE_MICROSECOND ®
- MINUTE_SECOND ®
- MIN_ROWS
- MOD ®
- MODE
- MODIFIES ®
- MODIFY
- MONTH
- MULTILINESTRING
- MULTIPOINT
- MULTIPOLYGON
- MUTEX
- MYSQL_ERRNO
N【21個】
- NAME
- NAMES
- NATIONAL
- NATURAL ®
- NCHAR
- NDB
- NDBCLUSTER
- NEVER; added in 5.7.4 (nonreserved)
- NEW
- NEXT
- NO
- NODEGROUP
- NONBLOCKING; removed in 5.7.6
- NONE
- NOT ®
- NO_WAIT
- NO_WRITE_TO_BINLOG ®
- NULL ®
- NUMBER
- NUMERIC ®
- NVARCHAR
O【17個】
- OFFSET
- OLD_PASSWORD; removed in 5.7.5
- ON ®
- ONE
- ONLY
- OPEN
- OPTIMIZE ®
- OPTIMIZER_COSTS ®; added in 5.7.5 (reserved)
- OPTION ®
- OPTIONALLY ®
- OPTIONS
- OR ®
- ORDER ®
- OUT ®
- OUTER ®
- OUTFILE ®
- OWNER
P【29個】
- PACK_KEYS
- PAGE
- PARSER
- PARSE_GCOL_EXPR; added in 5.7.6 (reserved); became nonreserved in 5.7.8
- PARTIAL
- PARTITION ®
- PARTITIONING
- PARTITIONS
- PASSWORD
- PHASE
- PLUGIN
- PLUGINS
- PLUGIN_DIR
- POINT
- POLYGON
- PORT
- PRECEDES; added in 5.7.2 (nonreserved)
- PRECISION ®
- PREPARE
- PRESERVE
- PREV
- PRIMARY ®
- PRIVILEGES
- PROCEDURE ®
- PROCESSLIST
- PROFILE
- PROFILES
- PROXY
- PURGE ®
Q【3個】
- QUARTER
- QUERY
- QUICK
R【57個】
- RANGE ®
- READ ®
- READS ®
- READ_ONLY
- READ_WRITE ®
- REAL ®
- REBUILD
- RECOVER
- REDOFILE
- REDO_BUFFER_SIZE
- REDUNDANT
- REFERENCES ®
- REGEXP ®
- RELAY
- RELAYLOG
- RELAY_LOG_FILE
- RELAY_LOG_POS
- RELAY_THREAD
- RELEASE ®
- RELOAD
- REMOVE
- RENAME ®
- REORGANIZE
- REPAIR
- REPEAT ®
- REPEATABLE
- REPLACE ®
- REPLICATE_DO_DB; added in 5.7.3 (nonreserved)
- REPLICATE_DO_TABLE; added in 5.7.3 (nonreserved)
- REPLICATE_IGNORE_DB; added in 5.7.3 (nonreserved)
- REPLICATE_IGNORE_TABLE; added in 5.7.3 (nonreserved)
- REPLICATE_REWRITE_DB; added in 5.7.3 (nonreserved)
- REPLICATE_WILD_DO_TABLE; added in 5.7.3 (nonreserved)
- REPLICATE_WILD_IGNORE_TABLE; added in 5.7.3 (nonreserved)
- REPLICATION
- REQUIRE ®
- RESET
- RESIGNAL ®
- RESTORE
- RESTRICT ®
- RESUME
- RETURN ®
- RETURNED_SQLSTATE
- RETURNS
- REVERSE
- REVOKE ®
- RIGHT ®
- RLIKE ®
- ROLLBACK
- ROLLUP
- ROTATE; added in 5.7.11 (nonreserved)
- ROUTINE
- ROW
- ROWS
- ROW_COUNT
- ROW_FORMAT
- RTREE
S【77個】
- SAVEPOINT
- SCHEDULE
- SCHEMA ®
- SCHEMAS ®
- SCHEMA_NAME
- SECOND
- SECOND_MICROSECOND ®
- SECURITY
- SELECT ®
- SENSITIVE ®
- SEPARATOR ®
- SERIAL
- SERIALIZABLE
- SERVER
- SESSION
- SET ®
- SHARE
- SHOW ®
- SHUTDOWN
- SIGNAL ®
- SIGNED
- SIMPLE
- SLAVE
- SLOW
- SMALLINT ®
- SNAPSHOT
- SOCKET
- SOME
- SONAME
- SOUNDS
- SOURCE
- SPATIAL ®
- SPECIFIC ®
- SQL ®
- SQLEXCEPTION ®
- SQLSTATE ®
- SQLWARNING ®
- SQL_AFTER_GTIDS
- SQL_AFTER_MTS_GAPS
- SQL_BEFORE_GTIDS
- SQL_BIG_RESULT ®
- SQL_BUFFER_RESULT
- SQL_CACHE
- SQL_CALC_FOUND_ROWS ®
- SQL_NO_CACHE
- SQL_SMALL_RESULT ®
- SQL_THREAD
- 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 ®
- STACKED
- START
- STARTING ®
- STARTS
- STATS_AUTO_RECALC
- STATS_PERSISTENT
- STATS_SAMPLE_PAGES
- STATUS
- STOP
- STORAGE
- STORED ®; added in 5.7.6 (reserved)
- STRAIGHT_JOIN ®
- STRING
- SUBCLASS_ORIGIN
- SUBJECT
- SUBPARTITION
- SUBPARTITIONS
- SUPER
- SUSPEND
- SWAPS
- SWITCHES
T【27個】
- TABLE ®
- TABLES
- TABLESPACE
- TABLE_CHECKSUM
- TABLE_NAME
- TEMPORARY
- TEMPTABLE
- TERMINATED ®
- TEXT
- THAN
- THEN ®
- TIME
- TIMESTAMP
- TIMESTAMPADD
- TIMESTAMPDIFF
- TINYBLOB ®
- TINYINT ®
- TINYTEXT ®
- TO ®
- TRAILING ®
- TRANSACTION
- TRIGGER ®
- TRIGGERS
- TRUE ®
- TRUNCATE
- TYPE
- TYPES
U【24個】
- UNCOMMITTED
- UNDEFINED
- UNDO ®
- UNDOFILE
- UNDO_BUFFER_SIZE
- UNICODE
- UNINSTALL
- UNION ®
- UNIQUE ®
- UNKNOWN
- UNLOCK ®
- UNSIGNED ®
- UNTIL
- UPDATE ®
- UPGRADE
- USAGE ®
- USE ®
- USER
- USER_RESOURCES
- USE_FRM
- USING ®
- UTC_DATE ®
- UTC_TIME ®
- UTC_TIMESTAMP ®
V【10個】
- VALIDATION; added in 5.7.5 (nonreserved)
- VALUE
- VALUES ®
- VARBINARY ®
- VARCHAR ®
- VARCHARACTER ®
- VARIABLES
- VARYING ®
- VIEW
- VIRTUAL ®; added in 5.7.6 (reserved)
W【12個】
- WAIT
- WARNINGS
- WEEK
- WEIGHT_STRING
- WHEN ®
- WHERE ®
- WHILE ®
- WITH ®
- WITHOUT; added in 5.7.5 (nonreserved)
- WORK
- WRAPPER
- WRITE ®
X【5個】
- X509
- XA
- XID; added in 5.7.5 (nonreserved)
- XML
- XOR ®
Y【2個】
- YEAR
- YEAR_MONTH ®
Z【1個】
- ZEROFILL ®