mongodb insert field in single array document

Question

I have a document in mongodb that looks like this

{
   "_id": ObjectId("5378da275ad972a811c119fb"),
   "name": "test test",
   "fname": "test",
   "lname": "test",
   "phone": "13254355554",
   "user": "525518965ad972636d7aa0ae",
}

And i want to insert a new field for "employee_id" so the result should be exactly like this.

 {
   "_id": ObjectId("5378da275ad972a811c119fb"),
   "name": "test test",
   "fname": "test",
   "lname": "test",
   "employee_id": "09872",
   "phone": "13254355554",
   "user": "525518965ad972636d7aa0ae",
}

I have used $push and $addToSet but the results became an array like

"employee_id": {
     "0": "09872",
}

Joachim Isaksson · Accepted Answer · 2014-05-19 06:53:25Z

1

Just use $set;

db.test.update(
      { _id:ObjectId("5378da275ad972a811c119fb") },    // Update this id only 
      { $set:{"employee_id": "09872"} }                // by setting employee_id
)

answered May 19, 2014 at 6:53

Joachim Isaksson

182k28 gold badges298 silver badges308 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Neil Lunn · Accepted Answer · 2014-05-19 06:53:56Z

1

Use the $set operator, $push and $addToSet are for arrays:

db.collection.update({}, {'$set': { "employee_id": "09872" } })

answered May 19, 2014 at 6:53

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

Collectives™ on Stack Overflow

mongodb insert field in single array document

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related