Mysql中的保留字desc_mysql desc保留字-优快云博客

表中有个字段名为desc,结果死活插不进数据,今天早上才猛然醒悟,ft~~~~~

下面的词在 MySQL 中是被明确保留的。它们大多数被 ANSI SQL92 禁止作为列或表名(例如， GROUP)。一些被保留是因为 MySQL 需要它们并且它使用的是一个 yacc 语法分析器：

单词	单词	单词
`ADD`	`ALL`	`ALTER`
`ANALYZE`	`AND`	`AS`
`ASC`	`AUTO_INCREMENT`	`BDB`
`BEFORE`	`BERKELEYDB`	`BETWEEN`
`BIGINT`	`BINARY`	`BLOB`
`BOTH`	`BTREE`	`BY`
`CASCADE`	`CASE`	`CHANGE`
`CHAR`	`CHARACTER`	`CHECK`
`COLLATE`	`COLUMN`	`COLUMNS`
`CONSTRAINT`	`CREATE`	`CROSS`
`CURRENT_DATE`	`CURRENT_TIME`	`CURRENT_TIMESTAMP`
`DATABASE`	`DATABASES`	`DAY_HOUR`
`DAY_MINUTE`	`DAY_SECOND`	`DEC`
`DECIMAL`	`DEFAULT`	`DELAYED`
`DELETE`	`DESC`	`DESCRIBE`
`DISTINCT`	`DISTINCTROW`	`DIV`
`DOUBLE`	`DROP`	`ELSE`
`ENCLOSED`	`ERRORS`	`ESCAPED`
`EXISTS`	`EXPLAIN`	`FALSE`
`FIELDS`	`FLOAT`	`FOR`
`FORCE`	`FOREIGN`	`FROM`
`FULLTEXT`	`FUNCTION`	`GRANT`
`GROUP`	`HASH`	`HAVING`
`HIGH_PRIORITY`	`HOUR_MINUTE`	`HOUR_SECOND`
`IF`	`IGNORE`	`IN`
`INDEX`	`INFILE`	`INNER`
`INNODB`	`INSERT`	`INT`
`INTEGER`	`INTERVAL`	`INTO`
`IS`	`JOIN`	`KEY`
`KEYS`	`KILL`	`LEADING`
`LEFT`	`LIKE`	`LIMIT`
`LINES`	`LOAD`	`LOCALTIME`
`LOCALTIMESTAMP`	`LOCK`	`LONG`
`LONGBLOB`	`LONGTEXT`	`LOW_PRIORITY`
`MASTER_SERVER_ID`	`MATCH`	`MEDIUMBLOB`
`MEDIUMINT`	`MEDIUMTEXT`	`MIDDLEINT`
`MINUTE_SECOND`	`MOD`	`MRG_MYISAM`
`NATURAL`	`NOT`	`NULL`
`NUMERIC`	`ON`	`OPTIMIZE`
`OPTION`	`OPTIONALLY`	`OR`
`ORDER`	`OUTER`	`OUTFILE`
`PRECISION`	`PRIMARY`	`PRIVILEGES`
`PROCEDURE`	`PURGE`	`READ`
`REAL`	`REFERENCES`	`REGEXP`
`RENAME`	`REPLACE`	`REQUIRE`
`RESTRICT`	`RETURNS`	`REVOKE`
`RIGHT`	`RLIKE`	`RTREE`
`SELECT`	`SET`	`SHOW`
`SMALLINT`	`SOME`	`SONAME`
`SPATIAL`	`SQL_BIG_RESULT`	`SQL_CALC_FOUND_ROWS`
`SQL_SMALL_RESULT`	`SSL`	`STARTING`
`STRAIGHT_JOIN`	`STRIPED`	`TABLE`
`TABLES`	`TERMINATED`	`THEN`
`TINYBLOB`	`TINYINT`	`TINYTEXT`
`TO`	`TRAILING`	`TRUE`
`TYPES`	`UNION`	`UNIQUE`
`UNLOCK`	`UNSIGNED`	`UPDATE`
`USAGE`	`USE`	`USER_RESOURCES`
`USING`	`VALUES`	`VARBINARY`
`VARCHAR`	`VARCHARACTER`	`VARYING`
`WARNINGS`	`WHEN`	`WHERE`
`WITH`	`WRITE`	`XOR`
`YEAR_MONTH`	`ZEROFILL`