Mongodb update number field with arithmetic operator

Question

I have a collection with a number field named "reference". I want to update every document in the collection and add 1000 to the reference field.

so if reference = 1 it will become 1001

pseudo below:

db.item.updateMany({}, {$set:{reference: reference+1000}}

Any idea how best to achieve this?

Eric · Accepted Answer · 2019-08-20 11:38:22Z

2

Use the $inc operator

db.item.updateMany({}, { $inc: { reference: 10000 }});

answered Aug 20, 2019 at 11:38

Eric

10.7k14 gold badges75 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1