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 |