检索数据类型
找出数据中 num 字段类型为 double 的数据,可以直接写 double ,也可以写在 MongoDB 中 double 类型指代的编码,如下两条语句是同义的:
db.test.find({'num': {'$type':1}})
db.test.find({'num': {'$type':'double'}})
关于数据的类型,以及对应的编码图,如下:(图片来源于 菜鸟教程 MongoDB 模块)
limit
通过 limit 限制返回的数据条数:
db.test.find().limit(2)
#返回数据:
{ "_id" : ObjectId("5d33d05a0536aa7970227ead"), "name" : "q1", "age" : 20, "sex" : "male", "num" : 34 }
{ "_id" : ObjectId("5d33d06b0536aa7970227eae"), "name" : "q2", "age" : 22, "sex" : "male", "num" : 62 }
skip
通过 skip 跳过前面几条数据:
db.test.find().skip(2)
#返回数据
{ "_id" : ObjectId("5d33d06b0536aa7970227eaf"), "name" : "q3", "age" : 23, "sex" : "female", "num" : 92 }
{ "_id" : ObjectId("5d33d06d0536aa7970227eb0"), "name" : "q4", "age" : 24, "sex" : "female", "num" : 52 }
sort
指定字段升序、降序, 1 为升序,-1 为降序
db.test.find().sort({'num': 1})
{ "_id" : ObjectId("5d33d05a0536aa7970227ead"), "name" : "q1", "age" : 20, "sex" : "male", "num" : 34 }
{ "_id" : ObjectId("5d33d06d0536aa7970227eb0"), "name" : "q4", "age" : 24, "sex" : "female", "num" : 52 }
{ "_id" : ObjectId("5d33d06b0536aa7970227eae"), "name" : "q2", "age" : 22, "sex" : "male", "num" : 62 }
{ "_id" : ObjectId("5d33d06b0536aa7970227eaf"), "name" : "q3", "age" : 23, "sex" : "female", "num" : 92 }
db.test.find().sort({'num': -1})
{ "_id" : ObjectId("5d33d06b0536aa7970227eaf"), "name" : "q3", "age" : 23, "sex" : "female", "num" : 92 }
{ "_id" : ObjectId("5d33d06b0536aa7970227eae"), "name" : "q2", "age" : 22, "sex" : "male", "num" : 62 }
{ "_id" : ObjectId("5d33d06d0536aa7970227eb0"), "name" : "q4", "age" : 24, "sex" : "female", "num" : 52 }
{ "_id" : ObjectId("5d33d05a0536aa7970227ead"), "name" : "q1", "age" : 20, "sex" : "male", "num" : 34 }