MySQL LIMIT/OFFSET: get all records except the fir

2019-01-15 15:38发布

I want to query all records from number 50 and up. So instead of doing something like LIMIT 49, 99999 I want to know if there is an official way.

标签: mysql limit
1条回答
够拽才男人
2楼-- · 2019-01-15 15:54

No, sorry. From the MySQL Documentation:

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. This statement retrieves all rows from the 96th row to the last:

SELECT * FROM tbl LIMIT 95,18446744073709551615;
查看更多
登录 后发表回答