56,677
社区成员
发帖
与我相关
我的任务
分享mysql limit 附近老是报错，求帮助！
select distinct from_user, realname, mobile from `testtable`
where id = '2' and storeid ='5' LIMIT (1-1)*10,10
报错信息为：
---------------------------
错误
---------------------------
SQL 执行错误 # 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 '(1-1)*10,10' at line 2
---------------------------
确定
---------------------------
求教，这个是什么原因？
where id = '2' and storeid ='5' LIMIT (1-1)*10,10
报错信息为：
---------------------------
错误
---------------------------
SQL 执行错误 # 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 '(1-1)*10,10' at line 2
---------------------------
确定
---------------------------
求教，这个是什么原因？
...全文
请发表友善的回复…
发表回复
lvchenotl 2016-04-28
- 打赏
- 举报
+1，报错信息明显是说你sql语句写的有问题
zhu19774279 2016-04-28
- 打赏
- 举报
在外部程序计算好，然后再传给MySQL吧
阳泉酒家小当家 2016-04-28
- 打赏
- 举报
limit 后面是不能做计算的，只能直接写 limit xx
gikod 2016-04-28
- 打赏
- 举报
用动态SQL应该可以办到，大概是这样
set @ms=concat ('select distinct from_user, realname, mobile from testtable where id = ? and storeid = ? LIMIT ', (1-1)*10, ',10';
set @p1 = '2';
set @p2 = '5';
PREPARE s1 from @ms;
EXECUTE s1 USING @p1, @p2;
deallocate prepare s1;
