mysql 报错Err] 1064，使用了mysql保留字

执行插入语句：insert into primary values(‘教师’,3,1)

报错：Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘primary values(‘教师’,3,1)’ at line 1

检查半天没有发现丝毫错误。错误很奇怪，奇怪就是表名primary，表名是mysql保留字。

解决办法：

1、表名primary使用了mysql的关键字,需要把priamry 用反引号号`括起来,就是键盘上数据1左边的那个键.

 INSERT INTO `primary` VALUES ('教师', '4', '1'); 

2、避免使用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