mongdb查询显示全部数据

来源:互联网 发布:网络教育全国统考不过 编辑:程序博客网 时间:2024/06/10 15:18
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


原创粉丝点击