limit第二个参数为-1

最新推荐文章于 2023-07-05 17:13:17 发布

kjshuan

最新推荐文章于 2023-07-05 17:13:17 发布

阅读量1.1k

点赞数

文章标签： limit Mysql

本文链接：https://blog.csdn.net/just_learing/article/details/123789672

版权

听人说过可以用-1作为最大值，尝试了上网查一下，结果失败了。

具体原因在下面

[7 Dec 2003 11:02] nico champix
Description:
mysql> select * from users_permissions limit 0, -1;
ERROR 1064 (42000): 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' at line 1

How to repeat:
mysql> select * from users_permissions limit 0, -1;
ERROR 1064 (42000): 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' at line 1
[8 Dec 2003 7:30] Sergei Golubchik
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

this is not a bug.
Instead, the fact that LIMIT X, -1 worked some time ago was a bug (low priority, though) and it was listed in the "known bugs" section. Finally it was fixed, so LIMIT no longer accepts negative arguments. Use a large positive number for that.