MySQL偏移无限行 [英] MySQL offset infinite rows

问题描述

我想构造一个查询，该查询在一个表中显示所有结果，但是从表的开头偏移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?

推荐答案

来自有关LIMIT的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;

这篇关于MySQL偏移无限行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！