Keywords

This document introduces the keywords of MatrixOne. In MatrixOne, reserved keywords and non-reserved keywords are classified. When you use SQL statements, you can check reserved keywords and non-reserved keywords.

Keyword is a word with a special meaning in SQL statements, such as SELECT, UPDATE, DELETE, and so on.

Reserved keyword: A word in a keyword that requires special processing before it can be used as an identifier is called a reserved keyword.

When using reserved keywords as identifiers, they must be wrapped with backticks. Otherwise, an error will be reported:

\\The reserved keyword select is not wrapped in backticks, resulting in an error.
mysql> CREATE TABLE select (a INT);
ERROR 1064 (HY000): SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 19 near " select (a INT)";

\\Correctly wrap the reserved keyword select with backticks.
mysql> CREATE TABLE `select` (a INT);
Query OK, 0 rows affected (0.02 sec)

Non-reserved keywords: keywords can be directly used as identifiers, called non-reserved keywords.

When using non-reserved keywords as identifiers, they can be used directly without wrapping them in backticks.

\\BEGIN is not a reserved keyword and can be wrapped without backticks.
mysql> CREATE TABLE `select` (BEGIN int);
Query OK, 0 rows affected (0.01 sec)

Note

Unlike MySQL, in MatrixOne, if the qualifier . is used, an error will be reported if the reserved keywords are not wrapped in backticks. It is recommended to avoid using reserved keywords when creating tables and databases:

mysql> CREATE TABLE test.select (BEGIN int);
ERROR 1064 (HY000): SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 24 near "select (BEGIN int)";

Reserved keyword

A

ADD
ADMIN_NAME
ALL
AND
AS
ASC
ASCII
AUTO_INCREMENT

B

BETWEEN
BINARY
BY

C

CASE
CHAR
CHARACTER
CHECK
COLLATE
COLLATION
CONVERT
COALESCE
COLUMN_NUMBER
CONSTRAINT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_ROLE
CURRENT_USER
CURRENT_TIME
CURRENT_TIMESTAMP
CIPHER

D

DATABASE
DATABASES
DECLARE
DEFAULT
DELAYED
DELETE
DESC
DESCRIBE
DISTINCT
DISTINCTROW
DIV
DROP

E

ELSE
ENCLOSED
END
ESCAPE
ESCAPED
EXCEPT
EXISTS
EXPLAIN

F

FALSE
FAILED_LOGIN_ATTEMPTS
FIRST
FOLLOWING
FOR
FORCE
FOREIGN
FROM
FULLTEXT

G

GROUP
GROUPS

H

HAVING
HOUR
HIGH_PRIORITY

I

IDENTIFIED
IF
IGNORE
IMPORT
IN
INFILE
INDEX
INNER
INSERT
INTERVAL
INTO
INT1
INT2
INT3
INT4
INT8
IS
ISSUER

J

JOIN

K

KEY

L

LAST
LEADING
LEFT
LIKE
LIMIT
LINES
LOAD
LOCALTIME
LOCALTIMESTAMP
LOCK
LOCKS
LOW_PRIORITY

M

MATCH
MAXVALUE
MICROSECOND
MINUTE
MOD
MODUMP

N

NATURAL
NODE
NOT
NONE
NULL
NULLS

O

ON
OPTIONAL
OPTIONALLY
OR
ORDER
OUTER
OUTFILE
OVER

P

PASSWORD_LOCK_TIME
PARTITION
PRECEDING
PRIMARY

Q

QUICK

R

RANDOM
REGEXP
RENAME
REPLACE
RETURNS
REUSE
RIGHT
REQUIRE
REPEAT
ROW
ROWS
ROW_COUNT
REFERENCES
RECURSIVE
REVERSE

S

SAN
SECONDARY
SSL
SUBJECT
SCHEMA
SCHEMAS
SELECT
SECOND
SEPARATOR
SET
SHOW
SQL_SMALL_RESULT
SQL_BIG_RESULT
STRAIGHT_JOIN
STARTING
SUSPEND

T

TABLE
TABLE_NUMBER
TABLE_SIZE
TABLE_VALUES
TERMINATED
THEN
TO
TRAILING
TRUE
TRUNCATE

U

UNBOUNDED
UNION
UNIQUE
UPDATE
USE
USING
UTC_DATE
UTC_TIME
UTC_TIMESTAMP

V

VALUES

W

WHEN
WHERE
WEEK
WITH

Non reserved keyword

A

ACCOUNT
ACCOUNTS
AGAINST
AVG_ROW_LENGTH
AUTO_RANDOM
ATTRIBUTE
ACTION
ALGORITHM
ANY

B

BEGIN
BIGINT
BIT
BLOB
BOOL

C

CHAIN
CHECKSUM
CLUSTER
COMPRESSION
COMMENT_KEYWORD
COMMIT
COMMITTED
CHARSET
COLUMNS
CONNECTION
CONSISTENT
COMPRESSED
COMPACT
COLUMN_FORMAT
CASCADE

D

DATA
DATE
DATETIME
DECIMAL
DYNAMIC
DISK
DO
DOUBLE
DIRECTORY
DUPLICATE
DELAY_KEY_WRITE

E

ENUM
ENCRYPTION
ENFORCED
ENGINE
ENGINES
ERRORS
EXPANSION
EXPIRE
EXTENDED
EXTENSION
EXTERNAL

F

FORMAT
FLOAT_TYPE
FULL
FIXED
FIELDS
FORCE_QUOTE

G

GEOMETRY
GEOMETRYCOLLECTION
GLOBAL
GRANT

H

HASH
HEADER
HISTORY

I

INT
INTEGER
INDEXES
ISOLATION

J

JSON

K

KEY_BLOCK_SIZE
KEYS

L

LANGUAGE
LESS
LEVEL
LINESTRING
LINEAR
LIST
LONGBLOB
LONGTEXT
LOCAL
LOW_CARDINALITY

M

MAX_CONNECTIONS_PER_HOUR
MAX_FILE_SIZE
MAX_QUERIES_PER_HOUR
MAX_ROWS
MAX_UPDATES_PER_HOUR
MAX_USER_CONNECTIONS
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MEMORY
MIN_ROWS
MODE
MONTH
MULTILINESTRING
MULTIPOINT
MULTIPOLYGON

N

NAMES
NCHAR
NUMERIC
NEVER
NO

O

OFFSET
ONLY
OPTIMIZE
OPEN
OPTION

P

PACK_KEYS
PASSWORD
PARTIAL
PARTITIONS
POINT
POLYGON
PROCEDURE
PROFILES
PROXY

Q

QUARTER
QUERY

R

ROLE
RANGE
READ
REAL
REORGANIZE
REDUNDANT
REPAIR
REPEATABLE
RELEASE
REVOKE
REPLICATION
ROW_FORMAT
ROLLBACK
RESTRICT

S

SESSION
SERIALIZABLE
SHARE
SIGNED
SMALLINT
SNAPSHOT
SOME
SPATIAL
START
STATUS
STORAGE
STREAM
STATS_AUTO_RECALC
STATS_PERSISTENT
STATS_SAMPLE_PAGES
SUBPARTITIONS
SUBPARTITION
SIMPLE
S3OPTION

T

TABLES
TEXT
THAN
TINYBLOB
TIME
TIMESTAMP
TINYINT
TINYTEXT
TRANSACTION
TRIGGER
TRIGGERS
TYPE

U

UNCOMMITTED
UNKNOWN
UNSIGNED
UNUSED
UNLOCK
URL
USER

V

VARBINARY
VARCHAR
VARIABLES
VIEW

W

WRITE
WARNINGS
WORK

X

X509

Y

YEAR

Z

ZEROFILL