MySQL 偏移无限行

2021-11-20 00:00:00 sql mysql sql-limit

我想构建一个查询，在一个表中显示所有结果，但从表的开头偏移 5.据我所知，MySQL 的 LIMIT 需要限制和偏移量.有没有办法做到这一点?

I would like to construct a query that displays all the results in a table, but is offset by 5 from the start of the table. As far as I can tell, MySQL's LIMIT requires a limit as well as an offset. Is there any way to do this?

推荐答案

来自 MySQL 限制手册:

从某一行中检索所有行偏移到结果的末尾设置，您可以使用一些大数字第二个参数.这个说法从第 96 行检索所有行到最后:

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;

相关文章