跳过并全部拿走? [英] Skip and take all?

问题描述

雄辩地说，我如何跳过10行然后得到表的其余部分?

In eloquent, how can I skip 10 rows and then get the rest of the table?

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

上面的方法不起作用，但是可以使您了解我要寻找的东西.

The above does not work, but it gives you an idea what I am looking for.

推荐答案

尝试一下:

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

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

一个查询:

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

很丑陋，但这是一个示例，摘自MySQL官方手册:

It's ugly, but it's an example from official MySQL manual:

检索从特定偏移量到结果结尾的所有行 设置，您可以为第二个参数使用较大的数字.这 语句检索从第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;

这篇关于跳过并全部拿走?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！