laravel - 跳过并全部拿走？

Question

在 eloquent 中，如何跳过 10 行然后获取表格的其余部分？

User::skip(10)->all();

以上不起作用，但它让你知道我在寻找什么。

Answer 1

尝试这个:

$count = User::count();
$skip = 10;

User::skip($skip)->take($count - $skip)->get();

通过一个查询:

User::skip($skip)->take(18446744073709551615)->get();

它很丑，但它是一个例子 from official MySQL manual :

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;