Reserved Words in 10.5 ES
The following words are reserved and must therefore be quoted when used as a column name.
Reserved Word |
Comment |
---|---|
ACCESSIBLE |
|
ADD |
|
ALL |
|
ALTER |
|
ANALYZE |
|
AND |
|
AS |
|
ASC |
|
ASENSITIVE |
|
BEFORE |
|
BETWEEN |
|
BIGINT |
|
BINARY |
|
BLOB |
|
BODY |
Only reserved when sql_mode=ORACLE is set. |
BOTH |
|
BY |
|
CALL |
|
CASCADE |
|
CASE |
|
CHANGE |
|
CHAR |
|
CHARACTER |
|
CHECK |
|
COLLATE |
|
COLUMN |
|
CONDITION |
|
CONSTRAINT |
|
CONTINUE |
|
CONVERT |
|
CREATE |
|
CROSS |
|
CURRENT_DATE |
|
CURRENT_ROLE |
|
CURRENT_TIME |
|
CURRENT_TIMESTAMP |
|
CURRENT_USER |
|
CURSOR |
|
DATABASE |
|
DATABASES |
|
DAY_HOUR |
|
DAY_MICROSECOND |
|
DAY_MINUTE |
|
DAY_SECOND |
|
DEC |
|
DECIMAL |
|
DECLARE |
|
DEFAULT |
|
DELAYED |
|
DELETE |
|
DELETE_DOMAIN_ID |
|
DESC |
|
DESCRIBE |
|
DETERMINISTIC |
|
DISTINCT |
|
DISTINCTROW |
|
DIV |
|
DO_DOMAIN_IDS |
|
DOUBLE |
|
DROP |
|
DUAL |
|
EACH |
|
ELSE |
|
ELSEIF |
|
ELSIF |
Only reserved when sql_mode=ORACLE is set. |
ENCLOSED |
|
ESCAPED |
|
EXCEPT |
|
EXISTS |
|
EXIT |
|
EXPLAIN |
|
FALSE |
|
FETCH |
|
FLOAT |
|
FLOAT4 |
|
FLOAT8 |
|
FOR |
|
FORCE |
|
FOREIGN |
|
FROM |
|
FULLTEXT |
|
GOTO |
Only reserved when sql_mode=ORACLE is set. |
GRANT |
|
GROUP |
|
HAVING |
|
HIGH_PRIORITY |
|
HOUR_MICROSECOND |
|
HOUR_MINUTE |
|
HOUR_SECOND |
|
IF |
|
IGNORE |
|
IGNORE_DOMAIN_IDS |
|
IN |
|
INDEX |
|
INFILE |
|
INNER |
|
INOUT |
|
INSENSITIVE |
|
INSERT |
|
INT |
|
INT1 |
|
INT2 |
|
INT3 |
|
INT4 |
|
INT8 |
|
INTEGER |
|
INTERSECT |
|
INTERVAL |
|
INTO |
|
IS |
|
ITERATE |
|
JOIN |
|
KEY |
|
KEYS |
|
KILL |
|
LEADING |
|
LEAVE |
|
LEFT |
|
LIKE |
|
LIMIT |
|
LINEAR |
|
LINES |
|
LOAD |
|
LOCALTIME |
|
LOCALTIMESTAMP |
|
LOCK |
|
LONG |
|
LONGBLOB |
|
LONGTEXT |
|
LOOP |
|
LOW_PRIORITY |
|
MASTER_SSL_VERIFY_SERVER_CERT |
|
MATCH |
|
MAXVALUE |
|
MEDIUMBLOB |
|
MEDIUMINT |
|
MEDIUMTEXT |
|
MIDDLEINT |
|
MINUTE_MICROSECOND |
|
MINUTE_SECOND |
|
MOD |
|
MODIFIES |
|
NATURAL |
|
NO_WRITE_TO_BINLOG |
|
NOT |
|
NULL |
|
NUMERIC |
|
ON |
|
OPTIMIZE |
|
OPTIONALLY |
|
OR |
|
ORDER |
|
OTHERS |
Only reserved when sql_mode=ORACLE is set. |
OUT |
|
OUTER |
|
OUTFILE |
|
OVER |
|
PACKAGE |
Only reserved when sql_mode=ORACLE is set. |
PAGE_CHECKSUM |
|
PARSE_VCOL_EXPR |
|
PARTITION |
|
PORTION |
|
PRECISION |
|
PRIMARY |
|
PROCEDURE |
|
PURGE |
|
RAISE |
Only reserved when sql_mode=ORACLE is set. |
RANGE |
|
READ |
|
READ_WRITE |
|
READS |
|
REAL |
|
RECURSIVE |
|
REF_SYSTEM_ID |
|
REFERENCES |
|
REGEXP |
|
RELEASE |
|
RENAME |
|
REPEAT |
|
REPLACE |
|
REQUIRE |
|
RESIGNAL |
|
RESTRICT |
|
RETURN |
|
RETURNING |
|
REVOKE |
|
RIGHT |
|
RLIKE |
|
ROWS |
|
ROWTYPE |
Only reserved when sql_mode=ORACLE is set. |
SCHEMA |
|
SCHEMAS |
|
SECOND_MICROSECOND |
|
SELECT |
|
SENSITIVE |
|
SEPARATOR |
|
SET |
|
SHOW |
|
SIGNAL |
|
SMALLINT |
|
SPATIAL |
|
SPECIFIC |
|
SQL |
|
SQL_BIG_RESULT |
|
SQL_CALC_FOUND_ROWS |
|
SQL_SMALL_RESULT |
|
SQLEXCEPTION |
|
SQLSTATE |
|
SQLWARNING |
|
SSL |
|
STARTING |
|
STATS_AUTO_RECALC |
|
STATS_PERSISTENT |
|
STATS_SAMPLE_PAGES |
|
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 |