OFFSET without LIMIT in mysql

Question

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

Check this [**ANSWER**](http://stackoverflow.com/questions/15950871/select-all-records-using-mysql-limit-and-offset-query) — 1000111, Mar 24 '16 at 09:53
You should ask what you really want to accomplish, rather than trying to bend mysql syntax to your needs. Offset must be used in conjunction with limit. — Shadow, Mar 24 '16 at 09:54

Rahul Tripathi · Accepted Answer · 2016-03-24T09:56:38.147

2

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.

edited Mar 24 '16 at 09:56

answered Mar 24 '16 at 09:53

Rahul Tripathi

Is there any work around query – padippist Mar 24 '16 at 09:54
@padippist:- You can provide some large number in case you are not sure. Thats what I can think of but I dont think there is any other workaround. – Rahul Tripathi Mar 24 '16 at 09:55

1 Answers1