Example of update query on MongoDB

Execute the update query as shown in SQL for the MongoDB database. This query updates the status column to “C” for employees older than 25.

-- SQL in Oracle 
UPDATE employees SET status = "C" WHERE age > 25
-- In MongoDB for update same:
db.employees.update(  { age: { $gt: 25 } }, { $set: { status: "C" } }, { multi: true } )

Output:

db.employees.update(  { age: { $gt: 25 } }, { $set: { status: "C" } }, { multi: true } )
WriteResult({ "nMatched" : 2, "nUpserted" : 0, "nModified" : 2 })

Example of expression in update query
Following query update the age with plus 3 value who is having status equal to “A”.

-- In RDBMS SQL
UPDATE employees SET age = age + 3 WHERE status = "A";

-- In MongoDB
db.employees.update( { status: "A" } , { $inc: { age: 3 } } ,{ multi: true })