mysql 8.0版本出现报错 [SQL]insert into student(number,name,groups) value(6,‘ken’,‘男’);
[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 ‘groups) value(6,‘ken’,‘男’)’ at line 1,如下图显示报错:
是由于mysql表中字段使用了关键字groups,把表中字段groups修改后保存即可
注:表名和数据库名使用了关键字也会报错
https://blog.csdn.net/xc_zhou/article/details/80952199
https://blog.csdn.net/westworld2017163com/article/details/83150628
https://juejin.im/post/5bfe5cc36fb9a04a082161c2
https://www.cnblogs.com/osfipin/p/4248022.html