查询
基本查询:
db.user.find({"_id": NumberLong(1000023)})
聚合查询:
db.userPointRecord.aggregate([
{
$match : { "userId": 10000264 }
},
{
$group : {
_id : "$userId",
membershipUserId: { $last: "$membershipUserId" },
experiencePoints: { $sum: "$point" }
}
},
{
$sort : { experiencePoints: -1 }
},
{
$skip : 0
},
{
$limit : 50
}
])
$match:查询条件
$group:分组
$last:每个分组的最后一个数据
$sum:求和
$sort:排序,1为顺序,-1为倒序
$skip:跳页,一般和limit组合使用,达到分页效果
$limit:返回多少条数据
返回结果:
{"_id":10000264, "membershipUserId": 15001, "experiencePoints":NumberLong(234000)}
修改字段
db.user.update({"phone": "15939080226"}, {$set:{"",}})
普通删除
db.user.remove({"_id": NumberLong(1000012)})
删除嵌套字段
数据:
{ "_id" : 1574951737, "userId" : 10000003, "experiencePoints" : NumberLong(0), "levelId" : 1574923859, "levelName" : "初来乍到", "levelLogoUrl" : "http://xx1.jpg", "taskRecordSet" : [ { "taskId" : 1574952198, "doingCount" : 1, "lastTime" : NumberLong(1574870400) } ], "taskRecordList" : [ { "taskId" : 1574958739, "doingCount" : 1, "lastTime" : NumberLong(1574956800) } ] }
命令:
第一种方式:
db.membershipUser.update({"_id":1574951737}, {$unset:
{"taskRecordSet":1,
"taskRecordList":1}})
第二种方式:
db.membershipUser.update({"_id":1574951737},
{$unset: {"taskRecordSet":1, "taskRecordList":1}}, false, true)
查询、删除Index
查询:
db.xx.getIndexes()
[
{
"v" : 2,
"key" : {
"_id" : 1
},
"name" : "_id_",
"ns" : "imapi.advert"
}
]
删除:db.xx.dropIndex({"name":"_id"})
删除所有:db.xx.dropIndexes()