MySQLの予約語がかなり多かったので予約語だけ抜粋してまとめてみました。
MySQLは予約語多いですね～!!
一目でわかりやすいように、8.0以降で追加されたり予約語になったものはアンダーラインを入れておきます。
何度か見直したつもりですが、間違いがあった時はすみません ( ..)φ
DB名、テーブル名、カラム名の識別子を付ける祭は予約語は使わないようにしましょう!
もし、バージョンUP前に使用されていて回避策で使用するのであれば、バッククォート「` `」で囲めば大丈夫です。
予約語とは
予約語とは言語の仕様で使い方が決められている単語のことです。
A ～C
| A | B | C | C |
|---|---|---|---|
| ACCESSIBLE | BEFORE | CALL | CONTINUE |
| ADD | BETWEEN | CASCADE | CONVERT |
| ALL | BIGINT | CASE | CREATE |
| ALTER | BINARY | CHANGE | CROSS |
| ANALYZE | BLOB | CHAR | CUBE(8.0.1で予約) |
| AND | BOTH | CHARACTER | CUME_DIST(8.0.2で追加) |
| AS | BY | CHECK | CURRENT_DATE |
| ASC | COLLATE | CURRENT_TIME | |
| ASENSITIVE | COLUMN | CURRENT_TIMESTAMP | |
| CONDITION | CURRENT_USER | ||
| CONSTRAINT | CURSOR |
D ～E
| D | D | E |
|---|---|---|
| DATABASE | DELETE | EACH |
| DATABASES | DENSE_RANK | ELSE |
| DAY_HOUR | DESC | ELSEIF |
| DAY_MICROSECOND | DESCRIBE | EMPTY(8.0.4で追加) |
| DAY_MINUTE | DETERMINISTIC | ENCLOSED |
| DAY_SECOND | DISTINCT | ESCAPED |
| DEC | DISTINCTROW | EXCEPT |
| DECIMAL | DIV | EXISTS |
| DECLARE | DOUBLE | EXIT |
| DEFAULT | DROP | EXPLAIN |
| DELAYED | DUAL |
F ～I
| F | G | I |
|---|---|---|
| FALSE | GENERATED | IF |
| FETCH | GET | IGNORE |
| FIRST_VALUE(8.0.2で追加) | GRANT | IN |
| FLOAT | GROUP | INDEX |
| FLOAT4 | GROUPING(8.0.1で追加) | INFILE |
| FLOAT8 | GROUPS(8.0.2で追加) | INNER |
| FOR | H | INOUT |
| FORCE | HAVING | INSENSITIVE |
| FOREIGN | HIGH_PRIORITY | INSERT |
| FROM | HOUR_MICROSECOND | INT |
| FULLTEXT | HOUR_MINUTE | INT1 |
| FUNCTION(8.0.1で予約) | HOUR_SECOND | INT2 |
I ～L
| I | K | L |
|---|---|---|
| INT3 | KEY | LIMIT |
| INT4 | KEYS | LINEAR |
| INT8 | KILL | LINES |
| INTEGER | LOAD | |
| INTERVAL | L | LOCALTIME |
| INTO | LAG(8.0.2で追加) | LOCALTIMESTAMP |
| IO_AFTER_GTIDS | LAST_VALUE(8.0.2で追加) | LOCK |
| IO_BEFORE_GTIDS | LEAD(8.0.2で追加) | LONG |
| IS | LEADING | LONGBLOB |
| ITERATE | LEAVE | LONGTEXT |
| J | LEFT | LOOP |
| JOIN | LIKE | LOW_PRIORITY |
M～N
| M | N |
|---|---|
| MASTER_BIND | NATURAL |
| MASTER_SSL_VERIFY_SERVER_CERT | NOT |
| MATCH | NO_WRITE_TO_BINLOG |
| MAXVALUE | NTH_VALUE(8.0.2で追加) |
| MEDIUMBLOB | NTILE(8.0.2で追加) |
| MEDIUMINT | NULL |
| MEDIUMTEXT | NUMERIC |
| MIDDLEINT | |
| MINUTE_MICROSECOND | |
| MINUTE_SECOND | |
| MOD | |
| MODIFIES |
O～Q
| O | P | R |
|---|---|---|
| OF(8.0.1で追加) | PARTITION | RANGE |
| ON | PERCENT_RANK(8.0.2で追加) | RANK |
| OPTIMIZE | PERSIST | READ |
| OPTIMIZER_COSTS | PERSIST_ONLY(8.0.2で追加) | READS |
| OPTION | PRECISION | READ_WRITE |
| OPTIONALLY | PRIMARY | REAL |
| OR | PROCEDURE | RECURSIVE(8.0.1で追加) |
| ORDER | PURGE | REFERENCES |
| OUT | REGEXP | |
| OUTER | RELEASE | |
| OUTFILE | RENAME | |
| OVER | REPEAT |
R～S
| R | S | S |
|---|---|---|
| REPLACE | SCHEMA | SQL |
| REQUIRE | SCHEMAS | SQLEXCEPTION |
| RESIGNAL | SECOND_MICROSECOND | SQLSTATE |
| RESTRICT | SELECT | SQLWARNING |
| RETURN | SENSITIVE | SQL_BIG_RESULT |
| REVOKE | SEPARATOR | SQL_CALC_FOUND_ROWS |
| RIGHT | SET | SQL_SMALL_RESULT |
| RLIKE | SHOW | SSL |
| ROW(8.0.2で予約) | SIGNAL | STARTING |
| ROWS(8.0.2で予約) | SMALLINT | STORED |
| ROW_NUMBER(8.0.2で追加) | SPATIAL | STRAIGHT_JOIN |
| SPECIFIC | SYSTEM(8.0.3で追加) |
T～Z
| T | U | V | W |
|---|---|---|---|
| TABLE | UNDO | VALUES | WHEN |
| TERMINATED | UNION | VARBINARY | WHERE |
| THEN | UNIQUE | VARCHAR | WHILE |
| TINYBLOB | UNLOCK | VARCHARACTER | WINDOW(8.0.2で追加) |
| TINYINT | UNSIGNED | VARYING | WITH |
| TINYTEXT | UPDATE | VIRTUAL | WRITE |
| TO | USAGE | X | |
| TRAILING | USE | XOR | |
| TRIGGER | USING | Y | |
| TRUE | UTC_DATE | YEAR_MONTH | |
| UTC_TIME | Z | ||
| UTC_TIMESTAMP | ZEROFILL |
この記事が役に立ったと思ったらポチッ!っと応援お願いします。
↓ ↓
独学でなかなか学習が進まない方は!
↓ ↓
時間や場所に縛られず学習できるMySQL３選
コメント