開發必備詞典：Mysql保留關鍵字

星空幻穎發表於2019-02-16
MySql

本文列舉了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 CONNECTION
CONSTRAINT CONTINUE CONVERT CREATE CROSS
CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR
CHECK

D

DATABASE DATABASES DATE DAY_HOUR DAY_MICROSECOND
DAY_MINUTE DAY_SECOND DEC DECIMAL DECLARE
DEFAULT DELAYED DELETE DESC DESCRIBE
DETERMINISTIC DISTINCT DISTINCTROW DIV DOUBLE
DROP 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 INT
INTEGER INTERVAL INTO IS ITERATE

J

JOIN

K

KEY KYES
KILL

L

LEADING LEAVE LEFT LIKE LIMIT
LINES LOAD LOCALTIME LOCALTIMESTAMP LOCK
LONG LONGBLOB LONGTEXT LOOP LOW_PRIORITY

M

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 PURGE

R

READ READS REFERENCES REGEXP RELEASE
RENAME REPEAT REPLACE REQUIRE RESTRICT
RETURN REVOKE RIGHT RLIKE REAL

S

SCHEMA SCHEMAS SECOND_MICROSECOND SELECT SENSITIVE
SEPARATOR SET SHOW SMALLINT SONAME
SPATIAL SPECIFIC SQL SQL_BIG_RESULT SQL_CALC_FOUND_ROWS
SQL_SMALL_RESULT SQLEXCEPTION SQLSTATE SQLWARNING SSL
STARTING STRAIGHT_JOIN

T

TABLE TERMINATED TEXT THEN TIME
TIMESTAMP TINYBLOB TINYINT TINYTEXT TO
TRAILING TRIGGER TRUE

U

UNDO UNION UNIQUE UNLOCK UNSIGNED
UPDATE USAGE USE USING UTC_DATE
UTC_TIME UTC_TIMESTAMP

V

VALUES VARBINARY VARCHAR
VARCHARACTER VARYING

W

WHEN WHERE WHILE
WITH WRITE

X

XOR

Y

YEAR_MONTH

Z

ZEROFILL

星空幻穎，嚴穎

個人主頁：segmentfault

相關文章