保留字为程序设计语言定义过的字,不能再将其作为数据库变量名称,否则会做语法报错处理。
以下列出了GBase 8a MPP Cluster支持的SQL保留字。

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

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_CERT

MATCH

MAX

MEDIUMBLOB

MEDIUMINT

MEDIUMTEXT

MERGE

MID

MIDDLEINT

MIN

MINUS

MINUTE_MICROSECOND

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

REFRESHNODEDATAMAP

REGEXP

RELEASE

RENAME

REPEAT

REPLACE

REQUIRE

RESTRICT

RETURN

REVERT

REVOKE

RIGHT

RLIKE

SCHEMA

SCHEMAS

SCN_NUMBER

SECOND_MICROSECOND

SEGMENT_ID

SELECT

SELF

SENSITIVE

SEPARATOR

SET

SHOW

SMALLINT

SORT

SPATIAL

SPECIFIC

SQL

SQLEXCEPTION

SQLSTATE

SQLWARNING

SQL_BIG_RESULT

SQL_CALC_FOUND_ROWS

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

WHEN

WHERE

WHILE

WITH

WRITE

XOR

YEAR_MONTH

ZEROFILL


GBase数据库
1 声望2 粉丝

GBase数据库知识分享