Mysql keyword-reserved word
Reprint: http://linux.it.net.cn/e/data/mysql/2014/1202/9460.html
Time:2014-12-02 13:09
Source:linux.it.net.cn
Author:IT
| ADD |
All |
Alter |
| ANALYZE |
and |
As |
| Asc |
Asensitive |
Before |
| Between |
BIGINT |
BINARY |
| Blob |
BOTH |
By |
| Pager |
CASCADE |
Case |
| Change |
CHAR |
CHARACTER |
| CHECK |
COLLATE |
COLUMN |
| CONDITION |
CONNECTION |
CONSTRAINT |
| CONTINUE |
CONVERT |
CREATE |
| Cross |
Current_date |
Current_time |
| Current_timestamp |
Current_User |
CURSOR |
| DATABASE |
DATABASES |
Day_hour |
| Day_microsecond |
Day_minute |
Day_second |
| DEC |
DECIMAL |
DECLARE |
| DEFAULT |
DELAYED |
DELETE |
| DESC |
DESCRIBE |
Deterministic |
| DISTINCT |
Distinctrow |
Div |
| DOUBLE |
DROP |
DUAL |
| each |
ELSE |
ELSEIF |
| Enclosed |
Escaped |
EXISTS |
| EXIT |
EXPLAIN |
FALSE |
| FETCH |
FLOAT |
FLOAT4 |
| FLOAT8 |
For |
Force |
| FOREIGN |
From |
Fulltext |
| Goto |
GRANT |
GROUP |
| Having |
High_priority |
Hour_microsecond |
| Hour_minute |
Hour_second |
IF |
| IGNORE |
Inch |
INDEX |
| INFILE |
INNER |
INOUT |
| Insensitive |
INSERT |
Int |
| INT1 |
INT2 |
INT3 |
| INT4 |
INT8 |
INTEGER |
| INTERVAL |
Into |
Is |
| Iterate |
JOIN |
KEY |
| KEYS |
KILL |
LABEL |
| Leading |
LEAVE |
Left |
| Like |
LIMIT |
LINEAR |
| LINES |
LOAD |
LocalTime |
| Localtimestamp |
LOCK |
LONG |
| Longblob |
Longtext |
LOOP |
| Low_priority |
MATCH |
Mediumblob |
| Mediumint |
Mediumtext |
Middleint |
| Minute_microsecond |
Minute_second |
MOD |
| Modifies |
NATURAL |
Not |
| No_write_to_binlog |
Null |
NUMERIC |
| On |
OPTIMIZE |
OPTION |
| Optionally |
OR |
ORDER |
| Out |
OUTER |
OUTFILE |
| PRECISION |
PRIMARY |
PROCEDURE |
| PURGE |
RAID0 |
RANGE |
| READ |
READS |
REAL |
| REFERENCES |
Regexp |
RELEASE |
| RENAME |
REPEAT |
REPLACE |
| REQUIRE |
RESTRICT |
RETURN |
| REVOKE |
Right |
Rlike |
| SCHEMA |
SCHEMAS |
Second_microsecond |
| SELECT |
Sensitive |
SEPARATOR |
| SET |
SHOW |
SMALLINT |
| SPATIAL |
Specific |
Sql |
| SQLEXCEPTION |
SQLSTATE |
SQLWarning |
| Sql_big_result |
Sql_calc_found_rows |
Sql_small_result |
| Ssl |
Starting |
Straight_join |
| TABLE |
TERMINATED |
Then |
| Tinyblob |
TINYINT |
Tinytext |
| To |
TRAILING |
TRIGGER |
| TRUE |
UNDO |
UNION |
| UNIQUE |
UNLOCK |
UNSIGNED |
| UPDATE |
USAGE |
Use |
| USING |
Utc_date |
Utc_time |
| Utc_timestamp |
VALUES |
VARBINARY |
| VARCHAR |
Varcharacter |
VARYING |
| When |
WHERE |
While |
| With |
WRITE |
X509 |
| Xor |
Year_month |
Zerofill |
MySQL allows some of the keywords to be used as unrecognized identifiers, because many people have been using them before. Some examples are listed below:
ACTION BIT DATE Enum NO TEXT Time TIMESTAMP
|
16/7/14-mysql-keywords
