MongoDB: How to update multiple documents with a s

Question

I was surprised to find that the following example code only updates a single document:

> db.test.save({"_id":1, "foo":"bar"});
> db.test.save({"_id":2, "foo":"bar"});

> db.test.update({"foo":"bar"}, {"$set":{"test":"success!"}});

> db.test.find({"test":"success!"}).count();
1

I know I can loop through and keep updating until they're all changed, but that seems terribly inefficient. Is there a better way?

Answer 1

All latest versions of mongodb updateMany() is working fine

db.getCollection('workers').updateMany({},{$set: {"assignedVehicleId" : "45680"}});

Answer 2

For versions of mongodb 3.2+ you can use method updateMany() to update multiple documents,

http://answerexpress.blogspot.com/2018/09/mongodb-how-to-update-multiple.html

Answer 3

In the MongoDB Client, type:

db.Collection.updateMany({}, $set: {field1: 'field1', field2: 'field2'})

New in version 3.2

Params::

{}:  select all records updated

Keyword argument multi not taken

Answer 4

I've created a way to do this with a better interface.

• db.collection.find({ ... }).update({ ... }) -- multi update
• db.collection.find({ ... }).replace({ ... }) -- single replacement
• db.collection.find({ ... }).upsert({ ... }) -- single upsert
• db.collection.find({ ... }).remove() -- multi remove

You can also apply limit, skip, sort to the updates and removes by chaining them in beforehand.

If you are interested, check out Mongo-Hacker

Answer 5

For Mongo version > 2.2, add a field multi and set it to true

db.Collection.update({query}, 
                 {$set: {field1: "f1", field2: "f2"}},
                 {multi: true })

Answer 6

UPDATE as of V2.2, the update function takes the following form:

 db.collection.update(
   <query>,
   <update>,
   { upsert: <boolean>, multi: <boolean> }
)

The selected answer no longer applies.

https://docs.mongodb.com/manual/reference/method/db.collection.update/