By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 916 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Paging in mysql store procedure? need help

P: 1
How to do paging in mysql store procedure??

input paramter will be (in pageno INT, IN no_records)

result will be for example i pass value 1 and 10 : first 10 records it will show.
or 2 and 10 then it will show 11 to 20 records.. please help..
Jul 21 '15 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,031
search for 'MySQL' and 'LIMIT'

Expand|Select|Wrap|Line Numbers
  1. SELECT something
  2. FROM tablename
  3. LIMIT 3,5
will return from the 3rd row the next 5 rows....
Jul 25 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.