Each language will have some keywords or reserved words, MySQL is no exception, here are listed, easy to query:
MYQL keyword list, mark.
ADD all ALTER ANALYZE and as ASC asensitive before BETWEEN BIGINT BINARY
| ADD |
All |
Alter |
| ANALYZE |
and |
As |
| Asc |
Asensitive |
Before |
| BETWEEN |
BIGINT |
BINARY |
| Blob |
BOTH |
By |
| Call |
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 |
In |
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 keywords to be used as an unrecognized identifier because many people have used them before. Some examples are listed below:
ACTION BIT DATE ENUM NO TEXT time TIMESTAMP