db.collection.update( ) all documents

Question

I try rename one field in all documents of a collection, with

db.coll.update({},{ $rename: {'originField':'newField'} });

but only one document is changed, why ?

by default updates are singular, you need to add `,{multi:true}` as a third param — Sammaye, Mar 26 '13 at 23:58
Possible duplicate of [MongoDB: update every document on one field](http://stackoverflow.com/questions/9038547/mongodb-update-every-document-on-one-field) — Ciro Santilli OurBigBook.com, Jan 07 '16 at 01:18

score 50 · Accepted Answer · edited Sep 12 '18 at 01:40

50

All updates in MongoDB are, by default, singular. You must add a third option to your command to make:

db.coll.update({},{ $rename: {'originField':'newField'} }, {multi:true});

If you are using 3.2 and above you can use updateMany():

db.coll.updateMany({}, {$rename: {'originField': "newField"}})

edited Sep 12 '18 at 01:40

Mark Stosberg

answered Mar 27 '13 at 00:15

Sammaye

Here is the reference from MongoDB documentation http://docs.mongodb.org/manual/applications/update/#update-multiple-documents – Sridhar Nanjundeswaran Mar 27 '13 at 00:17
1

Since MongoDB 3.2 you can also [use `updateMany`](https://stackoverflow.com/a/9038593/1494454). – totymedli Sep 20 '17 at 01:29

score 4 · Answer 2 · answered Jan 18 '17 at 17:57

4

db.collectionname.update( { "field" : "oldvalue" }, { $set:{ "field" : "newvalue" } }, { multi : true } );

answered Jan 18 '17 at 17:57

abdulH

score 2 · Answer 3 · edited Sep 12 '18 at 01:40

2

Since MongoDB 3.2, you can use this shorter syntax:

db.coll.updateMany({}, {$rename: {'originField': "newField"}})

edited Sep 12 '18 at 01:40

Mark Stosberg

answered Jun 28 '18 at 02:54

Josh

3 Answers3