MySQL Crash Course

2017-07-07 02:10:07

MySQL is made up of keywordsspecial words used in performing SQL operations. Do not use these keywords when naming databases, tables, columns, and any other database objects. These keywords are considered reserved. This appendix lists all of the MySQL reserved words (as of MySQL 5).

`ACTION`	`CASE`	`DATABASE`
`ADD`	`CHANGE`	`DATABASES`
`ALL`	`CHAR`	`DATE`
`ALTER`	`CHARACTER`	`DAY_HOUR`
`ANALYZE`	`CHECK`	`DAY_MICROSECOND`
`AND`	`COLLATE`	`DAY_MINUTE`
`AS`	`COLUMN`	`DAY_SECOND`
`ASC`	`CONDITION`	`DEC`
`ASENSITIVE`	`CONNECTION`	`DECIMAL`
`BEFORE`	`CONSTRAINT`	`DECLARE`
`BETWEEN`	`CONTINUE`	`DEFAULT`
`BIGINT`	`CONVERT`	`DELAYED`
`BINARY`	`CREATE`	`DELETE`
`BIT`	`CROSS`	`DESC`
`BLOB`	`CURRENT_DATE`	`DESCRIBE`
`BOTH`	`CURRENT_TIME`	`DETERMINISTIC`
`BY`	`CURRENT_TIMESTAMP`	`DISTINCT`
`CALL`	`CURRENT_USER`	`DISTINCTROW`
`CASCADE`	`CURSOR`	`DIV`
`DOUBLE`	`HOUR_MINUTE`	`LINES`
`DROP`	`HOUR_SECOND`	`LOAD`
`DUAL`	`IF`	`LOCALTIME`
`EACH`	`IGNORE`	`LOCALTIMESTAMP`
`ELSE`	`IN`	`LOCK`
`ELSEIF`	`INDEX`	`LONG`
`ENCLOSED`	`INFILE`	`LONGBLOB`
`ENUM`	`INNER`	`LONGTEXT`
`ESCAPED`	`INOUT`	`LOOP`
`EXISTS`	`INSENSITIVE`	`LOW_PRIORITY`
`EXIT`	`INSERT`	`MATCH`
`EXPLAIN`	`INT`	`MEDIUMBLOB`
`FALSE`	`INTEGER`	`MEDIUMINT`
`FETCH`	`INTERVAL`	`MEDIUMTEXT`
`FLOAT`	`INTO`	`MIDDLEINT`
`FOR`	`IS`	`MINUTE_MICROSECOND`
`FORCE`	`ITERATE`	`MINUTE_SECOND`
`FOREIGN`	`JOIN`	`MOD`
`FROM`	`KEY`	`MODIFIES`
`FULLTEXT`	`KEYS`	`NATURAL`
`GOTO`	`KILL`	`NO`
`GRANT`	`LEADING`	`NO_WRITE_TO_BINLOG`
`GROUP`	`LEAVE`	`NOT`
`HAVING`	`LEFT`	`NULL`
`HIGH_PRIORITY`	`LIKE`	`NUMERIC`
`HOUR_MICROSECOND`	`LIMIT`	`ON`
`OPTIMIZE`	`RLIKE`	`THEN`
`OPTION`	`SCHEMA`	`TIME`
`OPTIONALLY`	`SCHEMAS`	`TIMESTAMP`
`OR`	`SECOND_MICROSECOND`	`TINYBLOB`
`ORDER`	`SELECT`	`TINYINT`
`OUT`	`SENSITIVE`	`TINYTEXT`
`OUTER`	`SEPARATOR`	`TO`
`OUTFILE`	`SET`	`TRAILING`
`PRECISION`	`SHOW`	`trIGGER`
`PRIMARY`	`SMALLINT`	`TRUE`
`PROCEDURE`	`SONAME`	`UNDO`
`PURGE`	`SPATIAL`	`UNION`
`READ`	`SPECIFIC`	`UNIQUE`
`READS`	`SQL`	`UNLOCK`
`REAL`	`SQL_BIG_RESULT`	`UNSIGNED`
`REFERENCES`	`SQL_CALC_FOUND_ROWS`	`UPDATE`
`REGEXP`	`SQL_SMALL_RESULT`	`USAGE`
`RELEASE`	`SQLEXCEPTION`	`USE`
`RENAME`	`SQLSTATE`	`USING`
`REPEAT`	`SQLWARNING`	`UTC_DATE`
`REPLACE`	`SSL`	`UTC_TIME`
`REQUIRE`	`STARTING`	`UTC_TIMESTAMP`
`RESTRICT`	`STRAIGHT_JOIN`	`VALUES`
`RETURN`	`TABLE`	`VARBINARY`
`REVOKE`	`TERMINATED`	`VARCHAR`
`RIGHT`	`TEXT`	`VARCHARACTER`
`VARYING`
`WHEN`
`WHERE`
`WHILE`
`WITH`
`WRITE`
`XOR`
`YEAR_MONTH`
`ZEROFILL`

Категории