假如mongodb 有上面一个集合,我要将年纪为18岁的员工批量将其逻辑删除,请问mongo sql如何写
我发现这个写法只会更新一条
db.company.updateMany({"staff.age":18},{$set:{"staff.$.deleted": true}})
{
"_id" : ObjectId("63da119f07781d41000431b8"),
"name" : "公司1",
"staff" : [
{
"name" : "张三",
"age" : 18,
"deleted" : false
},
{
"name" : "李四",
"age" : 18,
"deleted" : false
}
]
}