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 |