MySQL Forums
Forum List  »  Newbie

Re: MySQL pagination
Posted by: Peter Brawley
Date: September 02, 2017 12:16PM

Limit applies itself to the query it finds, not to the query writer's thinking. The first productid returned by your query without a limit clause would be 501. Addimg Limit ... Offset 500 makes it 1001.

Options: ReplyQuote


Subject
Written By
Posted
September 01, 2017 12:29AM
September 01, 2017 09:57AM
September 02, 2017 11:14AM
Re: MySQL pagination
September 02, 2017 12:16PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.