Mongo DB CheatSheet

> db.CollectionName.count() //显示当前集合里item数量
> db.CollectionName.find() //显示当前集合里所有元素
> db.CollectionName.find(<query>,<projection>).sort(<sort order>).limit(<n>) //查找前<n>个并排序
//例子
> db.UserItem.find({},{follower_count:1,name:1}).sort({follower_count:-1}).limit(5);
{ "_id" : ObjectId("5931452190bd4b4e16868c3f"), "name" : "张佳玮", "follower_count" : 1350605 }
{ "_id" : ObjectId("5931452390bd4b4e16868c59"), "name" : "李开复", "follower_count" : 1006584 }
{ "_id" : ObjectId("5931453690bd4b4e16868cb2"), "name" : "黄继新", "follower_count" : 805432 }
{ "_id" : ObjectId("5931452390bd4b4e16868c57"), "name" : "周源", "follower_count" : 773221 }
{ "_id" : ObjectId("5931462690bd4b4e16868ebf"), "name" : "yolfilm", "follower_count" : 757138 }
//find里的支持函数 https://docs.mongodb.com/manual/reference/operator/query/

//获得某人对话的聊天记录，群组id @@95c5204edcc0e27d04bb103512f6ff211bac729f71bf89f39f104541b62ad475
db.getCollection('chat').find({$or : [
{"FromUserName":"@d999ef69564d2421edee9666587b2e54", "ToUserName":"@14b3e87ce332be741278d21839aa1374"}, 
{"ToUserName":"@d999ef69564d2421edee9666587b2e54", "FromUserName":"@14b3e87ce332be741278d21839aa1374"}
] })

db.getCollection('chat').find({$or : [
{"FromUserName":"@@95c5204edcc0e27d04bb103512f6ff211bac729f71bf89f39f104541b62ad475", "ToUserName":"@114dc2fa91784feb1b7a94ad7d5fae2a"}, 
{"ToUserName":"@@95c5204edcc0e27d04bb103512f6ff211bac729f71bf89f39f104541b62ad475", "FromUserName":"@114dc2fa91784feb1b7a94ad7d5fae2a"}
] })

mongod --config /usr/local/etc/mongod.conf #启动mogon服务
mogon #进入mogon客户端

Mongo数据库可视化管理工具

www.robomongo.org