MySQL reserved word list. Bark finishing.
Attempting to use a qualifier, such as using an embedded MySQL data type or function name as a table or column name, such as timestamp or group, can cause a common problem. Allows you to do this (for example, ABS can be used as a column name). However, by default, spaces are not allowed between the function name and the following ' (' character) in a number call. This requirement makes the function call different from the column name reference.
Reserved Words in MySQL 5.6.23 |
|
|
ACCESSIBLE |
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 |
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 |
GET |
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 |
Io_after_gtids |
Io_before_gtids |
Is |
Iterate |
JOIN |
KEY |
KEYS |
KILL |
Leading |
LEAVE |
Left |
Like |
LIMIT |
LINEAR |
LINES |
LOAD |
LocalTime |
Localtimestamp |
LOCK |
LONG |
Longblob |
Longtext |
LOOP |
Low_priority |
Master_bind |
Master_ssl_verify_server_cert |
MATCH |
MAXVALUE |
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 |
PARTITION |
PRECISION |
PRIMARY |
PROCEDURE |
PURGE |
RANGE |
READ |
READS |
Read_write |
REAL |
REFERENCES |
Regexp |
RELEASE |
RENAME |
REPEAT |
REPLACE |
REQUIRE |
RESIGNAL |
RESTRICT |
RETURN |
REVOKE |
Right |
Rlike |
SCHEMA |
SCHEMAS |
Second_microsecond |
SELECT |
Sensitive |
SEPARATOR |
SET |
SHOW |
SIGNAL |
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 |
Xor |
Year_month |
Zerofill |
|
  |
|
Io_after_gtids |
partition |
sql_after_gtids |
|
MySQL permits some keywords to be used as unquoted identifiers because many people previously used them. Examples is those in the following list:
ACTION
BIT
DATE
Enum
NO
TEXT
Time
TIMESTAMP
mysql keyword mysql reserved word list mysql field name