"LIMIT 5,10" returns 9 rows in MySQL?

Viewed 20879
3 Answers

I suggest go to this link LIMIT in mysql, after I browsed through the above comments, I have to point out, that limit 5, 10 returns 10 rows and it starts from row 6.

LIMIT:
limit 10 offset 5 and limit 5, 10, both of them return 10 rows, starting from row 6.
I strongly recommend go to the above link.

Hope it helps!!

Related