‘updateMany()’ method is used to update all the documents that satisfy given filter criteria.
Syntax
db.collection.updateMany( <filter>, <update>, { upsert: <boolean>, writeConcern: <document>, collation: <document>, arrayFilters: [ <filterdocument1>, ... ], hint: <document|string> // Available starting in MongoDB 4.2.1 } )
Example
db.employee.updateMany({"lastName" : "Gurram"}, {$set : {"active": false, "modifiedTime" : Date.now()}})
Let’s experiment with employee collection.
> db.employee.find() { "_id" : ObjectId("60baff65baf44d88348459bf"), "firstName" : "Krishna", "lastName" : "Gurram", "active" : false, "modifiedTime" : 1622868001073 } { "_id" : ObjectId("60baff6dbaf44d88348459c0"), "firstName" : "Ram", "lastName" : "Gurram", "active" : true } { "_id" : ObjectId("60baff75baf44d88348459c1"), "firstName" : "Thulasi", "lastName" : "Gurram", "active" : true } { "_id" : ObjectId("60baff83baf44d88348459c2"), "firstName" : "Gopi", "lastName" : "Battu", "active" : true } { "_id" : ObjectId("60baff8fbaf44d88348459c3"), "firstName" : "Sailaja", "lastName" : "PTR", "active" : true }
For example, set the active property of all the employees whose lastName is Gurram to false and add modifiedTime property with current time stamp.
> db.employee.updateMany({"lastName" : "Gurram"}, {$set : {"active": false, "modifiedTime" : Date.now()}})
{ "acknowledged" : true, "matchedCount" : 3, "modifiedCount" : 3 }
>
>
>
> db.employee.find()
{ "_id" : ObjectId("60baff65baf44d88348459bf"), "firstName" : "Krishna", "lastName" : "Gurram", "active" : false, "modifiedTime" : 1622868537108 }
{ "_id" : ObjectId("60baff6dbaf44d88348459c0"), "firstName" : "Ram", "lastName" : "Gurram", "active" : false, "modifiedTime" : 1622868537108 }
{ "_id" : ObjectId("60baff75baf44d88348459c1"), "firstName" : "Thulasi", "lastName" : "Gurram", "active" : false, "modifiedTime" : 1622868537108 }
{ "_id" : ObjectId("60baff83baf44d88348459c2"), "firstName" : "Gopi", "lastName" : "Battu", "active" : true }
{ "_id" : ObjectId("60baff8fbaf44d88348459c3"), "firstName" : "Sailaja", "lastName" : "PTR", "active" : true }
No comments:
Post a Comment