将现有的外部文档移至内部文档

Question

给定与以下文档相似的文档集合，

{
"description": "janeetjack",
"name": "Pocog bistro janeetjack"
}

该文档名称是一个唯一字段

，我如何更新所有现有文档并添加其他字段，从而看起来像这样

{
"userDetails":{
"description": "janeetjack",
"name": "Pocog bistro janeetjack"
},
"userLikes":{
"likes": "food",
"plays": "ball"
},

}

Answer 1

您需要运行set和unset在所有文档上使用updatemany

游乐场

db.collection.update({},
{
  "$set": {
    "userDetails.description": "$description",
    "userDetails.name": "$name",
    "userLikes.like": "abs"
  },
  "$unset": {
    description: 1,
    name: 1
  }
})