本章列出了GBase UP 支持的SQL 保留字。
表 5-112 保留字
ACCESSIBLE
ADD
ALL
ALTER
ANALYZE
AND
AS
ASC
ASENSITIVE
BEFORE
BETWEEN
BIGINT
BINARY
BIT_AND
BIT_OR
BIT_XOR
BLOB
BOTH
BY
CALL
CASCADE
CASE
CAST
CHANGE
CHAR
CHARACTER
CHECK
CLUSTER
COLLATE
COLUMN
COMPRESS
CONDITION
CONNECT
CONSTRAINT
CONTINUE
CONVERT
COUNT
CREATE
CROSS
CURDATE
CURDATETIME
CURRENT_DATE
CURRENT_DATETIME
GBase UP 产品手册 5 数据库管理指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 339
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
CURTIME
DATABASE
DATABASES
DATE_ADD
DATE_SUB
DAY_HOUR
DAY_MICROSECOND
DAY_MINUTE
DAY_SECOND
DEC
DECIMAL
DECLARE
DEFAULT
DELAYED
DELETE
DENSE_RANK
DESC
DESCRIBE
DETERMINISTIC
DISTINCT
DISTINCTROW
DISTRIBUTE
DISTRIBUTED
DIV
DOUBLE
DROP
DUAL
EACH
ELSE
ELSEIF
ENCLOSED
ESCAPED
EXISTS
EXIT
EXPLAIN
EXTRACT
EXCEPT
FALSE
FETCH
FLOAT
FLOAT4
FLOAT8
FOR
FORCE
FOREIGN
FROM
FULL
FULLTEXT
GCEXPORT
GCIMPORT
GCLOCAL
GCLUSTER
GCLUSTER_LOCAL
GET
GRANT
GROUP
GROUPED
GROUP_CONCAT
HAVING
HIGH_PRIORITY
HOUR_MICROSECOND
HOUR_MINUTE
HOUR_SECOND
IF
IGNORE
IN
INDEX
INFILE
INITNODEDATAMAP
INNER
INOUT
INPATH
INSENSITIVE
INSERT
INT
INT1
INT2
INT3
INT4
INT8
INTEGER
INTERSECT
INTERVAL
INTO
IS
ITERATE
JOIN
KEY
KEYS
KILL
LAG
LEAD
LEADING
LEAVE
LEFT
LEVEL
LIKE
LIMIT
LIMIT_STORAGE_SIZE
LINEAR
LINES
LINK
LOAD
LOCALTIME
LOCALTIMESTAMP
LOCK
LONG
LONGBLOB
LONGTEXT
LOOP
LOW_PRIORITY
MASTER_SSL_VERIFY_SERVER_C
ERT
MATCH
MAX
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
GBase UP 产品手册 5 数据库管理指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 340
MERGE
MID
MIDDLEINT
MIN
MINUS
MINUTE_MICROSECON
D
MINUTE_SECOND
MOD
MODIFIES
NATURAL
NOCOPIES
NOCYCLE
NOT
NOW
NO_WRITE_TO_BINLOG
NULL
NUMERIC
ON
OPTIMIZE
OPTION
OPTIONALLY
OR
ORDER
ORDERED
OUT
OUTER
OUTFILE
OVER
POSITION
PRECEDING
PRIMARY
PRIOR
PROCEDURE
PURGE
RANGE
RANK
READ
READS
READ_WRITE
REAL
REFERENCES
REFRESH
REFRESHNODEDATAMA
P
REGEXP
RELEASE
RENAME
REPEAT
REPLACE
REQUIRE
RESTRICT
RETURN
REVERT
REVOKE
RIGHT
RLIKE
SCHEMA
SCHEMAS
SCN_NUMBER
SECOND_MICROSECOND
SELECT
SELF
SENSITIVE
SEPARATOR
SET
SHOW
SMALLINT
SORT
SPATIAL
SPECIFIC
SQL
SQLEXCEPTION
SQLSTATE
SQLWARNING
SQL_BIG_RESULT
SQL_CALC_FOUND_RO
WS
SQL_SMALL_RESULT
SSL
START
STARTING
STD
STDDEV
STDDEV_POP
STDDEV_SAMP
STRAIGHT_JOIN
TABLE
TARGET
TERMINATED
THEN
TINYBLOB
TINYINT
TINYTEXT
TO
TRAILING
TRIGGER
TRIM
TRUE
UNDO
UNION
UNIQUE
UNLOCK
UNSIGNED
UPDATE
USAGE
USE
USING
UTC_DATE
UTC_DATETIME
UTC_TIME
UTC_TIMESTAMP
VALUES
VARBINARY
VARCHAR
VARCHARACTER
VARYING
VAR_SAMP
GBase UP 产品手册 5 数据库管理指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 341
WHEN
WHERE
WHILE
WITH
WRITE
XOR
YEAR_MONTH
ZEROFILL