liuonestar
2017-03-23 09:15
采纳率: 16.7%
浏览 1.0k

mysql分页的sql语句报错,求解??

String sql = "select s.* from user s where s.id limit ((?-1)*?),?";

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 '((1-1)*1),1' at line 1

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

5条回答 默认 最新

相关推荐 更多相似问题