Update query on MongoDB
Execute the update normal query as show in SQL in MongoDB database
Following query is update the status column with age greater than 25 to “C” value.
-- 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 })