查看一个文档的一个键值comments为一个数组[“test1”,”test2”]:
> db.post.findOne({"id":1})
{
"_id" : ObjectId("54a530c3ff0df3732bac1680"),
"id" : 1,
"name" : "joe",
"age" : 21,
"comments" : [
"test1",
"test2"
]
}
>
一、$push向数组末尾添加元素
> db.post.update({"id":1},{$push:{"comments": "test3"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.post.findOne({"id":1})
{
"_id" : ObjectId("54a530c3ff0df3732bac1680"),
"id" : 1,
"name" : "joe",
"age" : 21,
"comments" : [
"test1",
"test2",
"test3"
]
}
>
使用$each一次性添加多个值:
> db.post.update({"id":1},{$push:{"comments":{$each:["test4","test5","test6"]}}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.post.findOne({"id":1})
{
"_id" : ObjectId("54a530c3ff0df3732bac1680"),
"id" : 1,
"name" : "joe",
"age" : 21,
"comments" : [
"test1",
"test2",
"test3",
"test4",
"test5",
"test6"
]
}
>
二、用$pop删除数组中的元素
从数组末尾删除一个值:
> db.post.update({"id":1},{$pop:{"comments":1}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.post.findOne({"id":1})
{
"_id" : ObjectId("54a530c3ff0df3732bac1680"),
"id" : 1,
"name" : "joe",
"age" : 21,
"comments" : [
"test1",
"test2",
"test3",
"test4",
"test5"
]
}
从数组开头删除一个值:
> db.post.update({"id":1},{$pop:{"comments":-1}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.post.findOne({"id":1})
{
"_id" : ObjectId("54a530c3ff0df3732bac1680"),
"id" : 1,
"name" : "joe",
"age" : 21,
"comments" : [
"test2",
"test3",
"test4",
"test5"
]
}
>
三、删除数组中一个指定的值:
> db.post.update({"id":1},{$pull:{"comments":"test3"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.post.findOne({"id":1})
{
"_id" : ObjectId("54a530c3ff0df3732bac1680"),
"id" : 1,
"name" : "joe",
"age" : 21,
"comments" : [
"test2",
"test4",
"test5"
]
}
>
四、基于数组下标位置修改:
> db.post.update({"id":1},{$set:{"comments.1":"test9"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.post.findOne({"id":1})
{
"_id" : ObjectId("54a530c3ff0df3732bac1680"),
"id" : 1,
"name" : "joe",
"age" : 21,
"comments" : [
"test2",
"test9",
"test5"
]
}
>
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。