使用.sql文件导入数据库后,我查看数据库group表时出现错误ERROR 1064(42000),其他表均未出现错误。
错误提示为: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 ‘group’ at line 1
搜索问题后发现,group在mysql中属于特殊名称,所以调用时应该加上符号" ` "声明为普通表格。
mysql> select * from `group`;
参考文章:
1、完美解决 ERROR 1064 (42000): You have an error in your SQL…
https://www.jianshu.com/p/a0e6f1e1ac73