有没有办法在 MongoDB 中跳过一些文档?
是的,你可以使用 MongoDB 中的 skip() 跳过一些文档。使用 limit() 显示跳过某些文档后你想要展示多少个文档。让我们创建一个带有文档的集合 -
> db.demo682.insertOne({FirstName:"John"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea462a804263e90dac94402")
}
> db.demo682.insertOne({FirstName:"Sam"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea462ac04263e90dac94403")
}
> db.demo682.insertOne({FirstName:"Bob"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea462af04263e90dac94404")
}
> db.demo682.insertOne({FirstName:"David"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea462b304263e90dac94405")
}
> db.demo682.insertOne({FirstName:"Adam"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea462ba04263e90dac94406")
}
> db.demo682.insertOne({FirstName:"Chris"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea462be04263e90dac94407")
}
> db.demo682.insertOne({FirstName:"Carol"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5ea462c404263e90dac94408")
}使用 find() 方法显示来自集合的所有文档 -
> db.demo682.find();
这将生成以下输出 -
{ "_id" : ObjectId("5ea462a804263e90dac94402"), "FirstName" : "John" }
{ "_id" : ObjectId("5ea462ac04263e90dac94403"), "FirstName" : "Sam" }
{ "_id" : ObjectId("5ea462af04263e90dac94404"), "FirstName" : "Bob" }
{ "_id" : ObjectId("5ea462b304263e90dac94405"), "FirstName" : "David" }
{ "_id" : ObjectId("5ea462ba04263e90dac94406"), "FirstName" : "Adam" }
{ "_id" : ObjectId("5ea462be04263e90dac94407"), "FirstName" : "Chris" }
{ "_id" : ObjectId("5ea462c404263e90dac94408"), "FirstName" : "Carol" }以下是对 3 个文档执行操作并显示 2 个文档的查询 -
> db.demo682.find().skip(3).limit(2);
这将生成以下输出 -
{ "_id" : ObjectId("5ea462b304263e90dac94405"), "FirstName" : "David" }
{ "_id" : ObjectId("5ea462ba04263e90dac94406"), "FirstName" : "Adam" }
广告
数据结构
网络
RDBMS
操作系统
Java
iOS
HTML
CSS
Android
Python
C 编程
C++
C#
MongoDB
MySQL
Javascript
PHP