使用mybatis-plus的分页插件sql语句注意
错误信息
Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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’ at line 1
SQL: select * from department order by did asc; LIMIT 10
错误原因
分页查询会使用limit拼串,SQL语句后不能跟 ;