开发者

Should the result be consistent if using Limit without Order By in MySQL

开发者 https://www.devze.com 2023-02-25 04:05 出处:网络
Should the result be consistent if using Limit without Order By in MySQL, e.g. SELECT * FROM LARGE_TABLE LIMIT 1000, 10;

Should the result be consistent if using Limit without Order By in MySQL, e.g.

SELECT * FROM LARGE_TABLE LIMIT 1000, 10;

I am using PHP, so开发者_JS百科 option such as discussed in this post cannot be used.


No, it is not guaranteed to be consistent. the results may defer from time to time (but this is not guaranteed either)

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号