mysql关键字

• Mysql 关键字-保留字

• 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	CONNECTION	CONSTRAINT
  CONTINUE	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
  DEFAULT	DELAYED	DELETE
  DESC	DESCRIBE	DETERMINISTIC
  DISTINCT	DISTINCTROW	DIV
  DOUBLE	DROP	DUAL
  EACH	ELSE	ELSEIF
  ENCLOSED	ESCAPED	EXISTS
  EXIT	EXPLAIN	FALSE
  FETCH	FLOAT	FLOAT4
  FLOAT8	FOR	FORCE
  FOREIGN	FROM	FULLTEXT
  GOTO	GRANT	GROUP
  HAVING	HIGH_PRIORITY	HOUR_MICROSECOND
  HOUR_MINUTE	HOUR_SECOND	IF
  IGNORE	IN	INDEX
  INFILE	INNER	INOUT
  INSENSITIVE	INSERT	INT
  INT1	INT2	INT3
  INT4	INT8	INTEGER
  INTERVAL	INTO	IS
  ITERATE	JOIN	KEY
  KEYS	KILL	LABEL
  LEADING	LEAVE	LEFT
  LIKE	LIMIT	LINEAR
  LINES	LOAD	LOCALTIME
  LOCALTIMESTAMP	LOCK	LONG
  LONGBLOB	LONGTEXT	LOOP
  LOW_PRIORITY	MATCH	MEDIUMBLOB
  MEDIUMINT	MEDIUMTEXT	MIDDLEINT
  MINUTE_MICROSECOND	MINUTE_SECOND	MOD
  MODIFIES	NATURAL	NOT
  NO_WRITE_TO_BINLOG	NULL	NUMERIC
  ON	OPTIMIZE	OPTION
  OPTIONALLY	OR	ORDER
  OUT	OUTER	OUTFILE
  PRECISION	PRIMARY	PROCEDURE
  PURGE	RAID0	RANGE
  READ	READS	REAL
  REFERENCES	REGEXP	RELEASE
  RENAME	REPEAT	REPLACE
  REQUIRE	RESTRICT	RETURN
  REVOKE	RIGHT	RLIKE
  SCHEMA	SCHEMAS	SECOND_MICROSECOND
  SELECT	SENSITIVE	SEPARATOR
  SET	SHOW	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	X509
  XOR	YEAR_MONTH	ZEROFILL

  MySQL允许部分关键字用做未引起来的识别符，因为许多人以前曾使用过它们。下面列出了一些例子：

  • ACTION

  • BIT

  • DATE

  • ENUM

  • NO

  • TEXT

  • TIME

  • TIMESTAMP

  如果非要使用的话应该在sql语句中将字段名用反单引号引起来，

• 改成 `describe` ，注意是数字键1旁边的反引号`  而 不是'  单引号

• 今天用describe作为字段名产生错误，找了半天。。哎。。。改为description多好。。。。