如何删除 MongoDB 字段中的元素

Question

{
    _id: "d473ad718f214f158b31d591a97a5ce7",
    name: 'sam',
    keys: {
      q8f3ff57b03940959e1ae4dfe2cb57ad: {
        serviceaccountkey: {
          keyID: 'q8f3ff57b03940959e1ae4dfe2cb57ad',
          status: 'ACTIVE',
          keytype: 2,
        }
      },
      m887f7854adb4907b57903b896bcf6d6: {
        serviceaccountkey: {
          keyID: 'm887f7854adb4907b57903b896bcf6d6',
          status: 'ACTIVE',
          keytype: 2,
        }
      }
    }
  }
}

假设这是一个文档。如何从此文档中删除 ID 为“q8f3ff57b03940959e1ae4dfe2cb57ad”的第一个密钥？我希望最终结果看起来像：

{
    _id: "d473ad718f214f158b31d591a97a5ce7",
    name: 'sam',
    keys: {
      m887f7854adb4907b57903b896bcf6d6: {
        serviceaccountkey: {
          keyID: 'm887f7854adb4907b57903b896bcf6d6',
          status: 'ACTIVE',
          keytype: 2,
        }
      }
    }
  }
}

Answer 1

使用$unset：

db.collection.update({},
{
  "$unset": {
    "keys.q8f3ff57b03940959e1ae4dfe2cb57ad": ""
  }
})

Answer 2

如果您有许多与该 ID 或密钥匹配的文档，则应该这样做

db.collection.updateMany({},{"$unset":{"keys.q8f3ff57b03940959e1ae4dfe2cb57ad":1}})