MySQL保留字参考表

发布时间:2018-03-20

MySQL是由关键字组成的语言,关键字是一些用于执行MySQL操作的特殊词汇,在命名数据库、表、列、和其他数据库对象时,一定不要使用这些关键字,因此,这些关键字是一定要保留的, (自MySQL5以后的版本)中所有的保留字。

以下保留字是MySQL必知必会一书里的, 把他挪到这里方便查找

1 2 3
ACTION CASE DATABASE
ADD CHANGE DATABASES
ALL CHAR DATE
ALTER CHARACTER DAY_HOUR
ANALYZE CHECK DAY_MICROSECOND
AND COLLATE DAY_MINUTE
AS COLUMN DAY_SECOND
ASC CONDITION DEC
ASENSITIVE CONNECTION DECIMAL
BEFORE CONSTRAINT DECLARE
BETWEEN CONTINUE DEFAULT
BIGINT CONVERT DELAYED
BINARY CREATE DELETE
BIT CROSS DESC
BLOB CURRENT_DATE DESCRIBE
BOTH CURRENT_TIME DETERMINISTTIC
BY CURRENT_TIMESTAMP DISTINCT
CALL CURRENT_USER DISTINCTROW
CASCADE CURSOR DIV
DOUBLE HOUR_MINUTE LINES
DROP HOUR_SECOND LOAD
DUAL IF LOCALTIME
EACH IGNORE LOCALTIMESTAMP
ELSE IN LOCK
ELSEIF INDEX LONG
ENCLOSED INFILE LONGBLOB
ENUM INNER LONGTEXT
ESCAPED INOUT LOOP
EXISTS INSENSITIVE LOW_PRIORITY
EXIT INSERT MATCH
EXPLAIN INT MEDIUMBLOB
FALSE INTEGER MEDIUMINT
FETCH INTERVAL MEDIUMTEXT
FLOAT INTO MIDDLEINT
FOR IS MINUTE_MICROSECOND
FORCE ITERATE MINUTE_SECOND
FOREIGN JOIN MOD
FROM KEY MODIFIES
FULLTEXT KEYS NATURAL
GOTO KILL NO
GRANT LEADING NO_WRITE_TO_BINLOG
GROUP LEAVE NOT
HAVING LEFT NULL
HIGH_PRIORITY LIKE NUMERIC
HOUR_MICROSECOND LIMIT ON
OPTIMIZE RLIKE THEN
OPTION SCHEMA TIME
OPTIONALLY SCHEMAS TIMESTAMP
OR SECOND_MICROSECOND TINYBLOB
ORDER SELECT TINYINT
OUT SENSITIVE TINYTEXT
OUTER SEPARATOR TO
OUTFILE SET TRAILING
PRECISION SHOW TRIGGER
PRIMARY SMALLINT TRUE
PROCEDURE SONAME UNDO
PURGE SPATIAL UNION
READ SPECIFIC UNIQUE
READS SQL UNLOCK
REAL SQL_BIG_RESULT UNSIGNED
REFERENCES SQL_CALC_FOUND_ROWS UPDATE
REGEXP SQL_SMALL_RESULT USAGE
RELEASE SQLEXCEPTION USE
RENAME SQLSTATE USING
REPEAT SQLWARNING UTC_DATE
REPLACE SSL UTC_TIME
REQUIRE STARTING UTC_TIMESTAMP
RESTRICT STRAIGHT_JOIN VALUES
RETURN TABLE VARBINARY
REVOKE TERMINATED VARCHAR
RIGHT TEXT VARCHARACTER
VARYING WHILE XOR
WHEN WITH YEAR_MONTH
WHERE WRITE ZEROFILL
数据库
广告