Update salary field value with 10 percent of each employee in MongoDB

Let us first create a collection with documents −

> db.demo417.insertOne({"EmployeeName":"Chris","EmployeeSalary":500});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e723ebbb912067e57771ae4")
}
> db.demo417.insertOne({"EmployeeName":"Mike","EmployeeSalary":1000});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e723ed7b912067e57771ae5")
}

Display all documents from a collection with the help of find() method −

> db.demo417.find();

This will produce the following output −

{ "_id" : ObjectId("5e723ebbb912067e57771ae4"), "EmployeeName" : "Chris", "EmployeeSalary" : 500 }
{ "_id" : ObjectId("5e723ed7b912067e57771ae5"), "EmployeeName" : "Mike", "EmployeeSalary" : 1000 }

Following is the query to update salary field value with 10 percent of each employee in employee collection −

> db.demo417.update({ "EmployeeName": { $in: ["Chris", "Mike"] } }, { $mul: { EmployeeSalary: 1.1 }},{multi:true});
WriteResult({ "nMatched" : 2, "nUpserted" : 0, "nModified" : 2 })

Display all documents from a collection with the help of find() method −

> db.demo417.find();

This will produce the following output −

{ "_id" : ObjectId("5e723ebbb912067e57771ae4"), "EmployeeName" : "Chris", "EmployeeSalary" : 550 }
{ "_id" : ObjectId("5e723ed7b912067e57771ae5"), "EmployeeName" : "Mike", "EmployeeSalary" : 1100 }

AmitDiwan

Updated on 03-Apr-2020 13:38:00

• Related Questions & Answers
• MySQL edit and update records including employee salary
• Update MongoDB field using value of another field?
• MongoDB query to update each field of documents in collection with a formula?
• Update _id field in MongoDB
• MongoDB query to update array with another field?
• Update MongoDB variable value with variable itself?
• Replace an array field value with MongoDB?
• Display only the employee names with specific salaries in MongoDB documents with employee records?
• How to update _id field in MongoDB?
• Update all the values of a field with a specific string in MongoDB?
• How to run MongoDB query to update only a specific field value?
• Update field in exact element array in MongoDB?
• Want to update inner field in a MongoDB
• Conditional update depending on field matched in MongoDB
• Find max and second max salary for a MySQL Employee table?