Update query on MongoDB
UPDATE employees SET status = “C” WHERE age > 25
MongoDB:
———–
db.employees.update( { age: { $gt: 25 } }, { $set: { status: “C” } }, { multi: true } )
> db.employees.update( { age: { $gt: 25 } }, { $set: { status: “C” } }, { multi: true } )
WriteResult({ “nMatched” : 2, “nUpserted” : 0, “nModified” : 2 })
UPDATE employees SET age = age + 3 WHERE status = “A”;
db.employees.update( { status: “A” } , { $inc: { age: 3 } } ,{ multi: true })
Advertisements
