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