Reserved Words
You are viewing an old version of this article. View
the current version here.
Contents
The following is a list of all reserved words in MariaDB.
Reserved words cannot be used as Identifiers, unless they are quoted.
The definitive list of reserved words for each version is all words that are listed in the sql/lex.h
file that are not listed in the keyword
rule of sql/sql_yacc.yy
, or the keyword_sp
rule
that keyword
rule includes.
Reserved words
Keyword | Notes |
---|---|
ACCESSIBLE | |
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 | |
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 | |
GENERAL | Added in MariaDB 5.5 |
GRANT | |
GROUP | |
HAVING | |
HIGH_PRIORITY | |
HOUR_MICROSECOND | |
HOUR_MINUTE | |
HOUR_SECOND | |
IF | |
IGNORE | |
IGNORE_SERVER_IDS | Added in MariaDB 5.5 |
IN | |
INDEX | |
INFILE | |
INNER | |
INOUT | |
INSENSITIVE | |
INSERT | |
INT | |
INT1 | |
INT2 | |
INT3 | |
INT4 | |
INT8 | |
INTEGER | |
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_HEARTBEAT_PERIOD | Added in MariaDB 5.5 |
MASTER_SSL_VERIFY_SERVER_CERT | |
MATCH | |
MAXVALUE | Added in MariaDB 5.5 |
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 | Added in MariaDB 10.0 |
PRECISION | |
PRIMARY | |
PROCEDURE | |
PURGE | |
RANGE | |
READ | |
READS | |
READ_WRITE | |
REAL | |
RECURSIVE | Added in MariaDB 10.2.0 |
REFERENCES | |
REGEXP | |
RELEASE | |
RENAME | |
REPEAT | |
REPLACE | |
REQUIRE | |
RESIGNAL | Added in MariaDB 5.5 |
RESTRICT | |
RETURN | |
REVOKE | |
RIGHT | |
RLIKE | |
ROWS | Added in MariaDB 10.2.4 |
SCHEMA | |
SCHEMAS | |
SECOND_MICROSECOND | |
SELECT | |
SENSITIVE | |
SEPARATOR | |
SET | |
SHOW | |
SIGNAL | Added in MariaDB 5.5 |
SLOW | Added in MariaDB 5.5 |
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 | |
WINDOW | Added in MariaDB 10.2.0 |
WITH | |
WRITE | |
XOR | |
YEAR_MONTH | |
ZEROFILL |
Exceptions
Some keywords are exceptions for historical reasons, and are permitted as unquoted identifiers. These include:
Function names
If the IGNORE_SPACE
SQL_MODE flag is set, function names become reserved words.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.