Is there a way to say from the 20th row to the last row? Instead of saying 9999999999, I would like to replace it with something like the last row. Is that possible?
SELECT name from names limit 20, 9999999999
Asked
Active
Viewed 25 times
0
-
Unfortunately not, mysql still requires a `limit` when using an `offset`. – Jeemusu Jan 13 '16 at 01:40
-
manual suggests just what you are doing "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. " – Jan 13 '16 at 01:41
-
1Technically, your query is starting at the 21st row. – Gordon Linoff Jan 13 '16 at 01:43
-
You can replace 999999 with a count query :P – seahorsepip Jan 13 '16 at 01:46
-
@seahorsepip no you cant. – Jan 13 '16 at 01:47
-
I meant: run the count query and then run the actual query with limit afterwards. Though It will probbaly only make it slower – seahorsepip Jan 13 '16 at 01:50
-
@seahorsepip Then why suggest it? – frosty Jan 13 '16 at 01:55
-
Since I'm not totally sure, maybe someone has done benchmarks on it or some logical explanation why the method is slower of faster. – seahorsepip Jan 13 '16 at 01:58