首页 > 解决方案 > mongodb更新参数存在的地方

问题描述

db.filmes.insertMany(
[
  {
    "num": 1,
    "title": "movie1",
    "category": "Horror",
    "review": 5,
    "cast": {
      "director": "R1",
      "artist": "A1"
    },
    "exibition": [
      "Lisboa",
      "Porto",
      "Braga"
    ]
  },
  {
    "num": 2,
    "title": "movie2",
    "category": "Action",
    "review": 3,
    "cast": {
      "director": "R2",
      "artist": "A2"
    },
    "exibition": [
      "Lisboa",
      "Porto"
    ]
  },
  {
    "num": 3,
    "title": "movie3",
    "category": "Animation",
    "review": 3,
    "cast": {
      "director": "R2",
      "artist": "A2"
    },
    "exibition": [
      "Lisboa",
      "Porto",
      "Viseu"
    ]
  },
  {
    "num": 4,
    "title": "movie4",
    "category": "Animation",
    "review": 6,
    "cast": {
      "director": "R1",
      "artist": "A4"
    },
    "exibition": [
      "Lisboa",
      "Porto",
      "Braga"
    ]
  },
  {
    "num": 5,
    "title": "movie5",
    "category": "Horror",
    "review": 5,
    "cast": {
      "director": "R3",
      "artist": "A3"
    },
    "exibition": [
      "Lisboa",
      "Porto"
    ]
  }
]);

我需要将所有评论更新到出现艺术家“A3”的 10 条?

我已经尝试过:

db.movies.updateMany({cast:{artist:"A3"}},{$set:{review:10}})
db.movies.update({artist:"A3"},{$ste:{review:10}});

还有其他记不得了

有办法吗?

标签: mongodbmongodb-queryupdates

解决方案


推荐阅读