mongodb数组更新--可以根据指定下标更新

籍籍无名333

于 2024-07-18 15:24:52 发布

阅读量84

点赞数 1

文章标签： mongodb 数据库 java

本文链接：https://blog.csdn.net/daydayup0658/article/details/140524243

版权

数据准备：

db.getCollection("hello100").insertOne({
"name":"zhangsan",
"edu":[
  {
	  "time":"2000",
		"school":"yizhong"
	},
	{
	 "time":"2003",
	 "school":"qinghua"
	}
]
});

更新第一个元素：添加属性:attr = abc

db.getCollection("hello100").updateOne(
{
  "name":"zhangsan"
}, {
"$set":{
  "edu.0.attr":"abc"
}
});

更新第二个元素：添加属性:attr = def

db.getCollection("hello100").updateOne(
{
  "name":"zhangsan"
}, {
"$set":{
  "edu.1.attr":"def"
}
});

查询结果：

db.getCollection("hello100").find();

{
    "_id": ObjectId("6698c1c519290000490014d4"),
    "name": "zhangsan",
    "edu": [
        {
            "time": "2000",
            "school": "yizhong",
            "attr": "abc"
        },
        {
            "time": "2003",
            "school": "qinghua",
            "attr": "def"
        }
    ]
}