MySQL插入信息时报语句错误

Question

到底哪错了

mysql> inster into `enrollment` (`OfferNo`,`StdNo`,`EnrGrade`) values
    -> (1,"171002","A");
ERROR 1064 (42000): 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 'inster into enrollment (`OfferNo`,`StdNo`,`EnrGrade`) values
(1,"171002","A")' at line 1

Answer 1

你提供的SQL语句有一个拼写错误，正确的关键字是"insert"，而不是"inster"。此外，如果你要插入字符串值，需要将字符串值用单引号括起来。

INSERT INTO `enrollment` (`OfferNo`, `StdNo`, `EnrGrade`) VALUES (1, '171002', 'A');