开发必备词典:Mysql保留关键字

2017-01-10 10:04:00来源:作者:tiger人点击

本文列举了Mysql开发中需要注意的保留关键字。


你可以按ctrl+f使用浏览器搜索,或者点击右侧的首字母导航栏查看。


A

ACTION
ADD
ALL
ALTER
ANALYZE

AND
AS
ASC
ASENSITIVE
B

BEFORE
BETWEEN
BIGINT
BINARY
BIT

BLOB
BOTH
BY C

CALL
CASCADE
CASE
CHANGE
CHAR
CHARACTER
COLLATE
COLUMN
CONDITION
CONNECTIONCONSTRAINT
CONTINUE
CONVERT
CREATE
CROSSCURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSORCHECK D

DATABASE
DATABASES
DATE
DAY_HOUR
DAY_MICROSECOND
DAY_MINUTE
DAY_SECOND
DEC
DECIMAL
DECLAREDEFAULT
DELAYED
DELETE
DESC
DESCRIBEDETERMINISTIC
DISTINCT
DISTINCTROW
DIV
DOUBLEDROP
DUAL
E

EACH
ELSE
ELSEIF
ENCLOSED
ENUM

ESCAPED
EXISTS
EXIT
EXPLAIN
F

FALSE
FETCH
FLOAT
FOR
FORCE

FOREIGN
FORM
FULLTEXT G

GOTO
GRANT

GROUP
H

HAVING
HIGH_PRIORITY
HOUR_MICROSECOND
HOUR_MINUTE

HOUR_SECOND
I

IF
IGNORE
IN
INDEX
INFILE
INNER
INOUT
INSENSITIVE
INSERT
INTINTEGER
INTERVAL
INTO
IS
ITERATEJ

JOIN


K

KEY
KYES

KILL
L

LEADING
LEAVE
LEFT
LIKE
LIMIT
LINES
LOAD
LOCALTIME
LOCALTIMESTAMP
LOCKLONG
LONGBLOB
LONGTEXT
LOOP
LOW_PRIORITYM

MATCH
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MIDDLEINT

MINUTE_MICROSECOND
MINUTE_SECOND
MOD
MODIFIES
N

NATURAL
NO
NO_WRITE_TO_BINLOG
NOT
NULL

NUMERIC O

ON
OPTIMIZE
OPTION
OPTIONALLY
OR

ORDER
OUT
OUTER
OUTFILE
P

PRECISION
PRIMARY

PROCEDURE
PURGER

READ
READS
REFERENCES
REGEXP
RELEASE
RENAME
REPEAT
REPLACE
REQUIRE
RESTRICTRETURN
REVOKE
RIGHT
RLIKE
REALS

SCHEMA
SCHEMAS
SECOND_MICROSECOND
SELECT
SENSITIVE
SEPARATOR
SET
SHOW
SMALLINT
SONAMESPATIAL
SPECIFIC
SQL
SQL_BIG_RESULT
SQL_CALC_FOUND_ROWSSQL_SMALL_RESULT
SQLEXCEPTION
SQLSTATE
SQLWARNING
SSLSTARTING
STRAIGHT_JOIN
T

TABLE
TERMINATED
TEXT
THEN
TIME
TIMESTAMP
TINYBLOB
TINYINT
TINYTEXT
TOTRAILING
TRIGGER
TRUE U

UNDO
UNION
UNIQUE
UNLOCK
UNSIGNED
UPDATE
USAGE
USE
USING
UTC_DATEUTC_TIME
UTC_TIMESTAMP
V

VALUES
VARBINARY
VARCHAR

VARCHARACTER
VARYING
W

WHEN
WHERE
WHILE

WITH
WRITE
X

XOR


Y

YEAR_MONTH


Z

ZEROFILL


星空幻颖,严颖


个人主页:segmentfault

内容来源:https://segmentfault.com/a/1190000008028674

最新文章

123

最新摄影

微信扫一扫

第七城市微信公众平台