SQL查询保留字和关键字_表格存储(Tablestore)-阿里云帮助中心

备案控制台登录注册

输入文档关键字查找

通过本文您可以了解表格存储中SQL查询的所有保留字与关键字。

A

ACCESSIBLE	ACCOUNT	ACTION	ADD	AFTER	AGAINST
AGGREGATE	ALGORITHM	ALL	ALTER	ALWAYS	ANALYSE
ANALYZE	ANDANY	AS	ASC	ASCII	ASENSITIVE
AT	AUTOEXTEND_SIZE	AUTO_INCREMENT	AVG	AVG_ROW_LENGTH

B

BACKUP	BEFORE	BEGIN	BETWEEN	BIGINT	BINARY
BINLOG	BIT	BLOB	BLOCK	BOOL	BOOLEAN
BOTH	BTREE	BY	BYTE

C

CACHE	CALL	CASCADE	CASCADED	CASE	CATALOG_NAME
CHAIN	CHANGE	CHANGED	CHANNEL	CHAR	CHARACTER
CHARSET	CHECK	CHECKSUM	CIPHER	CLASS_ORIGIN	CLIENT
CLOSE	COALESCE	CODE	COLLATE	COLLATION	COLUMN
COLUMNS	COLUMN_FORMAT	COLUMN_NAME	COMMENT	COMMIT	COMMITTED
COMPACT	COMPLETION	COMPRESSED	COMPRESSION	CONCURRENT	CONDITION
CONNECTION	CONSISTENT	CONSTRAINT	CONSTRAINT_CATALOG	CONSTRAINT_NAME	CONSTRAINT_SCHEMA
CONTAINS	CONTEXT	CONTINUE	CONVERT	CPU	CREATE
CROSS	CUBE	CURRENT	CURRENT_DATE	CURRENT_TIME	CURRENT_TIMESTAMP
CURRENT_USER	CURSOR	CURSOR_NAME

D

DATA	DATABASE	DATABASES	DATAFILE	DATE	DATETIME
DAY	DAY_HOUR	DAY_MICROSECOND	DAY_MINUTE	DAY_SECOND	DEALLOCATE
DEC	DECIMAL	DECLARE	DEFAULT	DEFAULT_AUTH	DEFINER
DELAYED	DELAY_KEY_WRITE	DELETE	DESC	DESCRIBE	DES_KEY_FILE
DETERMINISTIC	DIAGNOSTICS	DIRECTORY	DISABLE	DISCARD	DISK
DISTINCT	DISTINCTROW	DIV	DO	DOUBLE	DROP
DUAL	DUMPFILE	DUPLICATE	DYNAMIC

E

EACH	ELSE	ELSEIF	ENABLE	ENCLOSED	ENCRYPTION
END	ENDS	ENGINE	ENGINES	ENUM	ERROR
ERRORS	ESCAPE	ESCAPED	EVENT	EVENTS	EVERY
EXCHANGE	EXECUTE	EXISTS	EXIT	EXPANSION	EXPIRE
EXPLAIN	EXPORT	EXTENDED	EXTENT_SIZE

F

FALSE	FAST	FAULTS	FETCH	FIELDS	FILE
FILE_BLOCK_SIZE	FILTER	FIRST	FIXED	FLOAT	FLOAT4
FLOAT8	FLUSH	FOLLOWS	FOR	FORCE	FOREIGN
FORMAT	FOUND	FROM	FULL	FULLTEXT	FUNCTION

G

GENERAL	GENERATED	GEOMETRY	GEOMETRYCOLLECTION	GET	GET_FORMAT
GLOBAL	GRANT	GRANTS	GROUP	GROUP_REPLICATION

H

HANDLER	HASH	HAVING	HELP	HIGH_PRIORITY	HOST
HOSTS	HOUR	HOUR_MICROSECOND	HOUR_MINUTE	HOUR_SECOND

I

IDENTIFIED	IF	IGNORE	IGNORE_SERVER_IDS	IMPORT	IN
INDEX	INDEXES	INFILE	INITIAL_SIZE	INNER	INOUT
INSENSITIVE	INSERT	INSERT_METHOD	INSTALL	INSTANCE	INT
INT1	INT2	INT3	INT4	INT8	INTEGER
INTERVAL	INTO	INVOKER	IO	IO_AFTER_GTIDS	IO_BEFORE_GTIDS
IO_THREAD	IPC	IS	ISOLATION	ISSUER	ITERATE

J

JOIN

JSON

K

KEY

KEYS

KEY_BLOCK_SIZE

KILL

L

LANGUAGE	LAST	LEADING	LEAVE	LEAVES	LEFT
LESS	LEVEL	LIKE	LIMIT	LINEAR	LINES
LINESTRING	LIST	LOAD	LOCAL	LOCALTIME	LOCALTIMESTAMP
LOCK	LOCKS	LOGFILE	LOGS	LONG	LONGBLOB
LONGTEXT	LOOP	LOW_PRIORITY

M

MASTER	MASTER_AUTO_POSITION	MASTER_BIND	MASTER_CONNECT_RETRY	MASTER_DELAY	MASTER_HEARTBEAT_PERIOD
MASTER_HOST	MASTER_LOG_FILE	MASTER_LOG_POS	MASTER_PASSWORD	MASTER_PORT	MASTER_RETRY_COUNT
MASTER_SERVER_ID	MASTER_SSL	MASTER_SSL_CA	MASTER_SSL_CAPATH	MASTER_SSL_CERT	MASTER_SSL_CIPHER
MASTER_SSL_CRL	MASTER_SSL_CRLPATH	MASTER_SSL_KEY	MASTER_SSL_VERIFY_SERVER_CERT	MASTER_TLS_VERSION	MASTER_USER
MATCH	MAXVALUE	MAX_CONNECTIONS_PER_HOUR	MAX_QUERIES_PER_HOUR	MAX_ROWS	MAX_SIZE
MAX_UPDATES_PER_HOUR	MAX_USER_CONNECTIONS	MEDIUM	MEDIUMBLOB	MEDIUMINT	MEDIUMTEXT
MEMORY	MERGE	MESSAGE_TEXT	MICROSECOND	MIDDLEINT	MIGRATE
MINUTE	MINUTE_MICROSECOND	MINUTE_SECOND	MIN_ROWS	MOD	MODE
MODIFIES	MODIFY	MONTH	MULTILINESTRING	MULTIPOINT	MULTIPOLYGON
MUTEX	MYSQL_ERRNO

N

NAME	NAMES	NATIONAL	NATURAL	NCHAR	NDB
NDBCLUSTER	NEVER	NEW	NEXT	NO	NODEGROUP
NONBLOCKING	NONE	NOT	NO_WAIT	NO_WRITE_TO_BINLOG	NULL
NUMBER	NUMERIC	NVARCHAR

O

OFFSET	OLD_PASSWORD	ON	ONE	ONLY	OPEN
OPTIMIZE	OPTIMIZER_COSTS	OPTION	OPTIONALLY	OPTIONS	OR
ORDER	OUTER	OUTFILE	OWNER

P

PACK_KEYS	PAGE	PARSER	PARSE_GCOL_EXPR	PARTIAL	PARTITION
PARTITIONING	PARTITIONS	PASSWORD	PHASE	PLUGIN	PLUGINS
PLUGIN_DIR	POINT	POLYGON	PORT	PRECEDES	PRECISION
PREPARE	PRESERVE	PREV	PRIMARY	PRIVILEGES	PROCEDURE
PROCESSLIST	PROFILE	PROFILES	PROXY	PURGE

Q

QUARTER

QUERY

QUICK

R

RANGE	RANK	READ	READS	READ_ONLY	READ_WRITE
REAL	REBUILD	RECOVER	REDOFILE	REDO_BUFFER_SIZE	REDUNDANT
REFERENCES	REGEXP	RELAY	RELAYLOG	RELAY_LOG_FILE	RELAY_LOG_POS
RELAY_THREAD	RELEASE	RELOAD	REMOVE	RENAME	REORGANIZE
REPAIR	REPEAT	REPEATABLE	REPLACE	REPLICATE_DO_DB	REPLICATE_DO_TABLE
REPLICATE_IGNORE_DB	REPLICATE_IGNORE_TABLE	REPLICATE_REWRITE_DB	REPLICATE_WILD_DO_TABLE	REPLICATE_WILD_IGNORE_TABLE	REPLICATION
REQUIRE	RESET	RESIGNAL	RESTORE	RESTRICT	RESUME
RETURN	RETURNED_SQLSTATE	RETURNS	REVERSE	REVOKE	RIGHT
RLIKE	ROLLBACK	ROLLUP	ROTATE	ROUTINE	ROW
ROWS	ROW_COUNT	ROW_FORMAT	RTREE

S

SAVEPOINT	SCHEDULE	SCHEMA	SCHEMAS	SCHEMA_NAME	SECOND
SECOND_MICROSECOND	SECURITY	SELECT	SENSITIVE	SEPARATOR	SERIAL
SERIALIZABLE	SERVER	SESSION	SET	SHARE	SHOW
SHUTDOWN	SIGNAL	SIGNED	SIMPLE	SLAVE	SLOW
SMALLINT	SNAPSHOT	SOCKET	SOME	SONAME	SOUNDSSOURCE
SPATIAL	SPECIFIC	SQL	SQLEXCEPTION	SQLSTATE	SQLWARNING
SQL_AFTER_GTIDS	SQL_AFTER_MTS_GAPS	SQL_BEFORE_GTIDS	SQL_BIG_RESULT	SQL_BUFFER_RESULT	SQL_CACHE
SQL_CALC_FOUND_ROWS	SQL_NO_CACHE	SQL_SMALL_RESULT	SQL_THREAD	SQL_TSI_DAY	SQL_TSI_HOUR
SQL_TSI_MINUTE	SQL_TSI_MONTH	SQL_TSI_QUARTER	SQL_TSI_SECOND	SQL_TSI_WEEK	SQL_TSI_YEAR
SSL	STACKED	START	STARTING	STARTS	STATS_AUTO_RECALC
STATS_PERSISTENT	STATS_SAMPLE_PAGES	STATUS	STOP	STORAGE	STORED
STRAIGHT_JOIN	STRING	SUBCLASS_ORIGIN	SUBJECT	SUBPARTITION	SUBPARTITIONS
SUPER	SUSPEND	SWAPS	SWITCHES

T

TABLE	TABLES	TABLESPACE	TABLE_CHECKSUM	TABLE_NAME	TEMPORARY
TEMPTABLE	TERMINATED	TEXT	THAN	THEN	TIME
TIMESTAMP	TIMESTAMPADD	TIMESTAMPDIFF	TINYBLOB	TINYINT	TINYTEXT
TO	TRAILING	TRANSACTION	TRIGGER	TRIGGERS	TRUE
TRUNCATE	TYPE	TYPES

U

UNCOMMITTED	UNDEFINED	UNDO	UNDOFILE	UNDO_BUFFER_SIZE	UNICODE
UNINSTALL	UNION	UNIQUE	UNKNOWN	UNLOCK	UNSIGNED
UNTIL	UPDATE	UPGRADE	USAGE	USE	USER
USER_RESOURCES	USE_FRM	USING	UTC_DATE	UTC_TIME	UTC_TIMESTAMP

V

VALIDATION	VALUE	VALUES	VARBINARY	VARCHAR	VARCHARACTER
VARIABLES	VARYING	VIEW	VIRTUAL

W

WAIT	WARNINGS	WEEK	WEIGHT_STRING	WHEN	WHERE
WHILE	WITH	WITHOUT	WORK	WRAPPER	WRITE

X

X509

XA

XID

XML

XOR

Y

YEAR

YEAR_MONTH

Z

ZEROFILL

上一篇：SQL操作符下一篇：通道服务

该文章对您有帮助吗？

本页导读（1）

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

点击开启售前

在线咨询服务

你好，我是AI助理

可以解答问题、推荐解决方案等