Reserved Words in MySQL 5.5.27
ACCESSIBLE | ADD | ALL |
ALTER | ANALYZE | AND |
AS | ASC | ASENSITIVE |
BEFORE | BETWEEN | BIGINT |
BINARY | BLOB | BOTH |
BY | CALL | CASCADE |
CASE | CHANGE | CHAR |
CHARACTER | CHECK | COLLATE |
COLUMN | CONDITION | CONSTRAINT |
CONTITUTE | CONVERT | CREATE |
CROSS | CURRENT_DATE | CURRENT_TIME |
CURRENT_TIMESTAMP | CURRENT_USER | CURSOR |
DATABASE | DATABASES | DAY_HOUR |
DAY_MICROSECOND | DAY_MINUTE | DAY_SECOND |
DEC | DECIMAL | DECLARE |
DISTINCT | DISTINCROW | DIV |
DOUBLE | DROP | DUAL |
EACH | ELSE | ELSEIF |
ENCLOSED | ESCAPED | EXISTS |
EXIT | EXPLAIN | FALSE |
FETCH | FLOAT | FLOAT4 |
FLOAT8 | FOR | FORCE |
FOREIGN | FROM | FULLTEXT |
GRANT | GROUP | HAVING |
HIGH_PRIORITY | HOUR_MICROSECOND | HOUR_MINUTE |
HOUR_SECOND | IF | IGNORE |
IN | INDEX | INFILE |
INNER | INOUT | INSENTIVE |
INSERT | INT | INT1 |
INT2 | INT3 | INT4 |
INT8 | INTERGER | INTERVAL |
INTO | IS | ITERATE |
JOIN | KEY | KEYS |
KILL | LEADING | LEAVE |
LEFT | LIKE | LIMIT |
LINEAR | LINES | LOAD |
LOCALTIME | LOCALTIMESTAMP | LOCK |
LONG | LONGBLOB | LONGTEXT |
LOOP | LOW_PRIORITY | MASTER_SSL_VARIFY_SERVER_CERT |
MATCH | MAXVALUE | MEDIUMBLOB |
MEDIUMINT | MEDIUMTEXT | MIDDLEINT |
MINUTE_MISROSECOND | MINUTE_SECOND | MOD |
MIDIFIES | NATUAL | NOT |
NO_WRI?tE_TO_BINLOG | NULL | NUMERIC |
ON | OPTIMIZE | OPTION |
OPTIONALLY | OR | ORDER |
OUT | OUTER | OUTFILE |
PRECISION | PRIMARY | PROCEDURE |
PURGE | RANGE | READ |
READS | READ_WRITE | REAL |
REDERENCES | REGEXP | RELEASE |
RENAME | REFEAT | REPLACE |
REQUIRE | RESIGNAL | RESTRICT |
RETURN | REVOKE | RIGHT |
RLIKE | SCHEMA | SCHEMAS |
SECIND_MISROSECOND | SELECT | SENSITIVE |
SEPARATIR | SET | SHOW |
SIGNAL | SMALLINT | SPATIAL |
SPECIFIC | SQL | SQLEXCEPTION |
SQLSTATE | SQLWARNING | SQL_BIG_RESULT |
SQL_CALC_FOUND_ROWS | SQL_SMALL_RESULT | SSL |
STARTING | STRAIGHT_JOIN | TABLE |
TERMINATED | THEN | TINYBLOB |
TINYINT | TINYTEXT | TO |
TRAILING | TRIGGER | TRUE |
UNDO | UNION | UNIQUE |
UNLOCK | UNSIGNED | UPDATE |
USAGE | USE | USING |
UTC_DATE | UTC_TIME | UTC_TIMESTAMP |
VALUES | VARBINARY | VARCHAR |
VARCHARACTER | VARYING | WHEN |
WHERE | WHILE | WITH |
WRITE | XOR | YEAR_MONTH |
ZEROFILL |
New Reserved Words in MySQL 5.5
GENERAL | IGNORE_SERVER_IDS | MASTER_HEARTBEAT_PERIOD |
MAXVALUE | RESIGNAL | SIGNAL |
SLOW |
'Database > MySQL' 카테고리의 다른 글
MariaDB Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MariaDB server (0) | 2016.08.08 |
---|---|
mysql jdbc test code (0) | 2016.07.28 |
error: 'Access denied for user 'root'@'localhost' (using password: NO)' (0) | 2016.07.27 |
Table character set 확인 방법 (0) | 2016.07.11 |
mysql에서 한글 깨짐 현상 (0) | 2011.04.22 |
댓글