执行插入语句: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 |