建了个表，有个字段起名为key，结果insert语句报错了，说是sql不对。
原因：字段key和MySQL的保留字冲突了，当mysql的字段名和保留字冲突的时候，sql语句中的字段名需要加上反引号``来加以区别，反引号可以用Esc键下面那个按键在英文模式不按shift键打出来，注意，是反引号不是单引号，回车键左边那个是单引号。
另外附上mysql保留字列表：
|
Reserved Words in MySQL 5.6.23 |
|
|
|
ACCESSIBLE |
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 |
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 |
|
GET |
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 |
IO_AFTER_GTIDS |
|
IO_BEFORE_GTIDS |
IS |
ITERATE |
|
JOIN |
KEY |
KEYS |
|
KILL |
LEADING |
LEAVE |
|
LEFT |
LIKE |
LIMIT |
|
LINEAR |
LINES |
LOAD |
|
LOCALTIME |
LOCALTIMESTAMP |
LOCK |
|
LONG |
LONGBLOB |
LONGTEXT |
|
LOOP |
LOW_PRIORITY |
MASTER_BIND |
|
MASTER_SSL_VERIFY_SERVER_CERT |
MATCH |
MAXVALUE |
|
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 |
PARTITION |
PRECISION |
|
PRIMARY |
PROCEDURE |
PURGE |
|
RANGE |
READ |
READS |
|
READ_WRITE |
REAL |
REFERENCES |
|
REGEXP |
RELEASE |
RENAME |
|
REPEAT |
REPLACE |
REQUIRE |
|
RESIGNAL |
RESTRICT |
RETURN |
|
REVOKE |
RIGHT |
RLIKE |
|
SCHEMA |
SCHEMAS |
SECOND_MICROSECOND |
|
SELECT |
SENSITIVE |
SEPARATOR |
|
SET |
SHOW |
SIGNAL |
|
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 |
|
XOR |
YEAR_MONTH |
ZEROFILL |
|
NewReserved Words in MySQL 5.6 |
|
|
|
GET |
IO_AFTER_GTIDS |
IO_BEFORE_GTIDS |
|
MASTER_BIND |
ONE_SHOT |
PARTITION |
|
SQL_AFTER_GTIDS |
SQL_BEFORE_GTIDS |
|