Reserved Words for MariaDB Community Server 10.6
This page is part of MariaDB's Documentation.
The parent of this page is: Reference for MariaDB Community Server 10.6
Topics on this page:
Overview
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_ |
BOTH | |
BY | |
CALL | |
CASCADE | |
CASE | |
CHANGE | |
CHAR | |
CHARACTER | |
CHECK | |
COLLATE | |
COLUMN | |
CONDITION | |
CONSTRAINT | |
CONTINUE | |
CONVERT | |
CREATE | |
CROSS | |
CURRENT_ | |
CURRENT_ | |
CURRENT_ | |
CURRENT_ | |
CURRENT_ | |
CURSOR | |
DATABASE | |
DATABASES | |
DAY_ | |
DAY_ | |
DAY_ | |
DAY_ | |
DEC | |
DECIMAL | |
DECLARE | |
DEFAULT | |
DELAYED | |
DELETE | |
DELETE_ | |
DESC | |
DESCRIBE | |
DETERMINISTIC | |
DISTINCT | |
DISTINCTROW | |
DIV | |
DO_ | |
DOUBLE | |
DROP | |
DUAL | |
EACH | |
ELSE | |
ELSEIF | |
ELSIF | Only reserved when sql_ |
ENCLOSED | |
ESCAPED | |
EXCEPT | |
EXISTS | |
EXIT | |
EXPLAIN | |
FALSE | |
FETCH | |
FLOAT | |
FLOAT4 | |
FLOAT8 | |
FOR | |
FORCE | |
FOREIGN | |
FROM | |
FULLTEXT | |
GOTO | Only reserved when sql_ |
GRANT | |
GROUP | |
HAVING | |
HIGH_ | |
HOUR_ | |
HOUR_ | |
HOUR_ | |
IF | |
IGNORE | |
IGNORE_ | |
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_ | |
MASTER_ | |
MATCH | |
MAXVALUE | |
MEDIUMBLOB | |
MEDIUMINT | |
MEDIUMTEXT | |
MIDDLEINT | |
MINUS | Only reserved when sql_ |
MINUTE_ | |
MINUTE_ | |
MOD | |
MODIFIES | |
NATURAL | |
NO_ | |
NOT | |
NULL | |
NUMERIC | |
OFFSET | Reserved word added in MariaDB Community Server 10.6.0. |
ON | |
OPTIMIZE | |
OPTIONALLY | |
OR | |
ORDER | |
OTHERS | Only reserved when sql_ |
OUT | |
OUTER | |
OUTFILE | |
OVER | |
PACKAGE | Only reserved when sql_ |
PAGE_ | |
PARSE_ | |
PARTITION | |
PORTION | |
PRECISION | |
PRIMARY | |
PROCEDURE | |
PURGE | |
RAISE | Only reserved when sql_ |
RANGE | |
READ | |
READ_ | |
READS | |
REAL | |
RECURSIVE | |
REF_ | |
REFERENCES | |
REGEXP | |
RELEASE | |
RENAME | |
REPEAT | |
REPLACE | |
REQUIRE | |
RESIGNAL | |
RESTRICT | |
RETURN | |
RETURNING | |
REVOKE | |
RIGHT | |
RLIKE | |
ROWNUM | Only reserved when sql_ |
ROWS | |
ROWTYPE | Only reserved when sql_ |
SCHEMA | |
SCHEMAS | |
SECOND_ | |
SELECT | |
SENSITIVE | |
SEPARATOR | |
SET | |
SHOW | |
SIGNAL | |
SMALLINT | |
SPATIAL | |
SPECIFIC | |
SQL | |
SQL_ | |
SQL_ | |
SQL_ | |
SQLEXCEPTION | |
SQLSTATE | |
SQLWARNING | |
SSL | |
STARTING | |
STATS_ | |
STATS_ | |
STATS_ | |
STRAIGHT_ | |
SYSDATE | Only reserved when sql_ |
TABLE | |
TERMINATED | |
THEN | |
TINYBLOB | |
TINYINT | |
TINYTEXT | |
TO | |
TRAILING | |
TRIGGER | |
TRUE | |
UNDO | |
UNION | |
UNIQUE | |
UNLOCK | |
UNSIGNED | |
UPDATE | |
USAGE | |
USE | |
USING | |
UTC_ | |
UTC_ | |
UTC_ | |
VALUES | |
VARBINARY | |
VARCHAR | |
VARCHARACTER | |
VARYING | |
WHEN | |
WHERE | |
WHILE | |
WITH | |
WRITE | |
XOR | |
YEAR_ | |
ZEROFILL |