Error querying database. Cause: java.sql.SQLSyntaxErrorException: 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 ‘LIMIT 10, 10’ at line 3
要了老命了,这个问题查了好久
原因:
查询语句:
select *
from tb_instructor;
pagehelper分页会在SQL语句后自动加一个limit,就会变成
select *
from tb_instructor; limit xxx
分号啊分号!!!报SQL语法错误