CODEWITHSUNDEEP
phpmysql
Howard
Howard

Reputation: 19805

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

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 option such as discussed in this post cannot be used.

Upvotes: 0

Views: 327

Answers (1)

Headshota
Headshota

Reputation: 21449

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

Upvotes: 3

Related Questions