如何在 MongoDB 中向嵌套数组中添加新项?
为此,请结合使用 find() 和 update()。让我们创建一个包含文档的集合−
> db.demo124.insertOne(
... {
... "Name" : "John",
... "Id" : 101,
... "ProjectDetails" : [{
... "ProjectName1" : "Online Book",
... "ProjectName2" : "Online Banking"
... }, {
... "ProjectName1" : "Online Library Management System",
... "ProjectName2" : "School Management System"
... }]
... }
... );
{
"acknowledged" : true,
"insertedId" : ObjectId("5e2f2c8b140daf4c2a3544bb")
}使用 find() 方法显示集合中的所有文档−
> db.demo124.find();
这将产生以下输出−
{
"_id" : ObjectId("5e2f2c8b140daf4c2a3544bb"), "Name" : "John", "Id" : 101, "ProjectDetails" : [
{ "ProjectName1" : "Online Book", "ProjectName2" : "Online Banking" },
{ "ProjectName1" : "Online Library Management System", "ProjectName2" : "School Management System" }
]
}以下是向嵌套数组添加新项的查询−
> db.demo124.find().toArray().forEach(
... function(d){
... for(var i = 0; i< d.ProjectDetails.length; ++i) {
... d.ProjectDetails[i]['ProjectName3'] = 'Online Snake Game';
... }
... db.demo124.update({_id: d._id}, d);
... }
... );使用 find() 方法显示集合中的所有文档−
> db.demo124.find().pretty();
这将产生以下输出−
{
"_id" : ObjectId("5e2f2c8b140daf4c2a3544bb"),
"Name" : "John",
"Id" : 101,
"ProjectDetails" : [
{
"ProjectName1" : "Online Book",
"ProjectName2" : "Online Banking",
"ProjectName3" : "Online Snake Game"
},
{
"ProjectName1" : "Online Library Management System",
"ProjectName2" : "School Management System",
"ProjectName3" : "Online Snake Game"
}
]
}
广告
数据结构
网络
RDBMS
操作系统
Java
iOS
HTML
CSS
Linux
Python
C 编程
C++
C#
MongoDB
MySQL
Javascript
PHP