Update query in MongoDB shell

Question

In the shell, my query is:

db.checkin_4e95ae0926abe9ad28000001.update({location_city:"New York"}, {location_country: "FUDGE!"});

However, it doesn't actually update my records. It doesn't error either. When I do a db.checkin_4e95ae0926abe9ad28000001.find({location_city:"New York"}); after running this, I get all my results but the location_country has not changed:

{
    "_id": ObjectId("4e970209a0290b70660009e9"),
    "addedOn": ISODate("2011-10-13T15:21:45.772Z"),
    "location_address1": "",
    "location_city": "New York",
    "location_country": "United States",
    "location_latLong": {
        "xLon": -74.007124,
        "yLat": 40.71455
    },
    "location_source": "socialprofile",
    "location_state": "New York",
    "location_zip": ""
}

Andrew Orsich · Accepted Answer · 2011-10-13 16:08:57Z

33

This is because in second parameter of update function you need to use $set operator to update location_country as in example below:

db.checkin_4e95ae0926abe9ad28000001.update(
   {location_city:"New York"}, //find criteria
   // this row contains fix with $set oper
   { $set : { location_country: "FUDGE!"}});

Here you can find a list of available update operators.

answered Oct 13, 2011 at 16:08

Andrew Orsich

53.8k17 gold badges142 silver badges134 bronze badges

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

Comments

Amitesh Bharti · Accepted Answer · 2018-08-09 18:14:27Z

Changed in version 3.6. Following is the syntax for update :

db.collection.update(
   <query>,
   <update>,
   {
     upsert: <boolean>,
     multi: <boolean>,
     writeConcern: <document>,
     collation: <document>,
     arrayFilters: [ <filterdocument1>, ... ]
   }
)

Example :

db.getCollection('products').update({},{$unset: {translate:1, qordoba_translation_version:1}}, {multi: true})

In your example :

db.checkin_4e95ae0926abe9ad28000001.update(
   {location_city:"New York"}, //query
   // $update query
   { $set : { location_country: "FUDGE!"}});

By default, the update() method updates a single document. Set the Multi Parameter to update all documents that match the query criteria.

Example 2 :

   db.checkin_4e95ae0926abe9ad28000001.update(
       {location_city:"New York"}, //query
       // $update query
       { $set : { location_country: "FUDGE!"}}, {multi: true});

Delimitry · Accepted Answer · 2018-11-19 13:13:08Z

9

db.m_country.update(
    {"countryId": "962a0935-bf3d-4f63-a53c-254760273ede"}, 
    {$set: {'countryPopulation': '12540000'}})

edited Nov 19, 2018 at 13:13

Delimitry

3,0374 gold badges33 silver badges39 bronze badges

answered Jul 6, 2018 at 5:13

Sagar Jadhav

1,11911 silver badges10 bronze badges

Comments

Doddanna D · Accepted Answer · 2021-01-29 11:18:34Z

0

Before Update

> db.student.find({name:"Venky"}).pretty();

{
    "_id" : ObjectId("6012e64dc2979ddffe1e5df9"),
    "name" : "Venky",
    "dept" : "MCA",
    "age" : "26",
    "phone" : "89786465"

}

Update Command

> db.student.update({name:"Venky"},{$set: {name:"DODDANNA CHAWAN",dept:"MCA(CS)", age:"25", phone:"1234567890"}});

Find Command See Result

> db.student.find({name:"DODDANNA CHAWAN"}).pretty();

After Updated Result

{
    "_id" : ObjectId("6012e64dc2979ddffe1e5df9"),
    "name" : "DODDANNA CHAWAN",
    "dept" : "MCA(CS)",
    "age" : "25",
    "phone" : "1234567890"

}

in real life use unique "_id" to match the document becuase names will found as duplicates

answered Jan 29, 2021 at 11:18

Doddanna D

514 bronze badges

Collectives™ on Stack Overflow

Update query in MongoDB shell

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related