Results 1 to 6 of 6

Thread: Paging in mysql

  1. #1
    Join Date
    May 2015
    Posts
    9

    Unanswered: Paging in mysql

    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..

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Check out the LIMIT clause in the manual: https://dev.mysql.com/doc/refman/5.1...40599410103360
    George
    Home | Blog

  3. #3
    Join Date
    May 2015
    Posts
    9

    Unhappy No able to solve

    please help

  4. #4
    Join Date
    May 2015
    Posts
    9

    Unhappy No able to solve

    please help

  5. #5
    Join Date
    Jul 2015
    Posts
    6
    Anu,

    You have been helped already, gvee gave you the answer

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Show us what you have tried so far and we might be able to give you some pointers.
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •