本文列举了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
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
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
**粗体** _斜体_ [链接](http://example.com) `代码` - 列表 > 引用
。你还可以使用@
来通知其他用户。