Search code examples
mysqllimitoffset

OFFSET without LIMIT in mysql

Is there any way to use OFFSET without LIMIT in mysql? I tried many ways and many times. I also searched a lot.

Solution

  • No there is no way. You need to provide the LIMIT.

    Then manual says:

    To retrieve all rows from a certain offset up to the end of the result set, you can use some large number for the second parameter.