Articles → MONGODB → Upsert In Mongodb

Upsert In Mongodb

In this article, we will discuss upsert in MongoDB.

Purpose

The upsert operation combines the functionality of insert and update. If the document exists then the document will be updated else inserted.

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

Consider the following collection: -

The requirement is to update the field age to 70 where name is John Doe. So, the query is: -

db.mycollection.updateOne({ name: 'John Doe' },  { $set: { age: 70 } }, { upsert: true })

As the document exists, the update will happen on the collection. The updated document is: -

Execute the following query: -

db.mycollection.updateOne({ name: 'John Doe1' },  { $set: { age: 70 } }, { upsert: true })

The above query will insert a document because the John Doe1 does not exist.

The updated document is: -

Query/Feedback