mongdb查询显示全部数据

最新推荐文章于 2023-09-19 14:37:37 发布

原创最新推荐文章于 2023-09-19 14:37:37 发布 · 3.4k 阅读

2 ·

CC 4.0 BY-SA版权

技术（mysql）专栏收录该内容

16 篇文章

订阅专栏

本文介绍MongoDB中如何使用find命令进行数据查询，并演示了如何通过调整DBQuery.shellBatchSize来改变每页显示的数据数量。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

db.库名.find();

相当于：select * from 表名;

默认每页显示20条记录，当显示不下的情况下，可以用it迭代命令查询下一页数据。注意：键入it命令不能带“；”

但是你可以设置每页显示数据的大小，用DBQuery.shellBatchSize= 50;这样每页就显示50条记录了。

> db.dome.find()
{ "_id" : ObjectId("5930245f78ac7423ed2177e0"), "name" : "a", "password" : "111" }
{ "_id" : ObjectId("5930256c78ac7423ed2177ea"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177eb"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177ec"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177ed"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177ee"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177ef"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177f0"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177f1"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177f2"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930257978ac7423ed2177f3"), "name" : "i", "password" : "i", "passsword" : "789" }
{ "_id" : ObjectId("5930257978ac7423ed2177f4"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177f5"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177f6"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177f7"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177f8"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177f9"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177fa"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177fb"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed2177fc"), "name" : "i", "password" : "i" }
Type "it" for more
> it
{ "_id" : ObjectId("593025a578ac7423ed2177fd"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed2177fe"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed2177ff"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed217800"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed217801"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed217802"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed217803"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed217804"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed217805"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed217806"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed217807"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed217808"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed217809"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed21780a"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed21780b"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed21780c"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed21780d"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930272878ac7423ed21780e"), "name" : "i" }
{ "_id" : ObjectId("5930272878ac7423ed21780f"), "name" : "i" }
{ "_id" : ObjectId("5930272878ac7423ed217810"), "name" : "i" }
Type "it" for more

设置DBQuery.shellBatchSize= 50（50页一行）
> DBQuery.shellBatchSize= 50
50
> db.dome.find()
{ "_id" : ObjectId("5930245f78ac7423ed2177e0"), "name" : "a", "password" : "111" }
{ "_id" : ObjectId("5930256c78ac7423ed2177ea"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177eb"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177ec"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177ed"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177ee"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177ef"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177f0"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177f1"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930256c78ac7423ed2177f2"), "name" : "as", "password" : "11+i" }
{ "_id" : ObjectId("5930257978ac7423ed2177f3"), "name" : "i", "password" : "i", "passsword" : "789" }
{ "_id" : ObjectId("5930257978ac7423ed2177f4"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177f5"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177f6"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177f7"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177f8"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177f9"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177fa"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930257978ac7423ed2177fb"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed2177fc"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed2177fd"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed2177fe"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed2177ff"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed217800"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed217801"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed217802"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed217803"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("593025a578ac7423ed217804"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed217805"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed217806"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed217807"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed217808"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed217809"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed21780a"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed21780b"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed21780c"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930271078ac7423ed21780d"), "name" : "i", "password" : "i" }
{ "_id" : ObjectId("5930272878ac7423ed21780e"), "name" : "i" }
{ "_id" : ObjectId("5930272878ac7423ed21780f"), "name" : "i" }
{ "_id" : ObjectId("5930272878ac7423ed217810"), "name" : "i" }
{ "_id" : ObjectId("5930272878ac7423ed217811"), "name" : "i" }
{ "_id" : ObjectId("5930272878ac7423ed217812"), "name" : "i" }
{ "_id" : ObjectId("5930272878ac7423ed217813"), "name" : "i" }
{ "_id" : ObjectId("5930272878ac7423ed217814"), "name" : "i" }
{ "_id" : ObjectId("5930272878ac7423ed217815"), "name" : "i" }
{ "_id" : ObjectId("5930272878ac7423ed217816"), "name" : "i" }
{ "_id" : ObjectId("59302db978ac7423ed21781a"), "name" : ISODate("2017-06-01T15:07:37.146Z"), "password" : "test" }
{ "_id" : ObjectId("59302e9978ac7423ed21781c"), "name" : "test", "password" : "test" }
{ "_id" : ObjectId("59302eb678ac7423ed21781d"), "test" : 1 }
{ "_id" : ObjectId("59302f0778ac7423ed21781e"), "name" : "test", "password" : [ "123", "456", "789" ] }
Type "it" for more