原来sql语句如下:
SELECT id ,column from sys_shelf;
报错详情:
SELECT id ,column from sys_shelf
> 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 'column from sys_shelf' at line 1
> 时间: 0.027s
还是sql基础不牢,可以通过添加反引号``或者直接重命名来避免这种错误。修改后sql语句:
SELECT id ,`column` from sys_shelf;