Update query on MongoDB

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s