Add new field to every document in a MongoDB collection

by

Same as the updating existing collection field, $set will add a new fields if the specified field does not exist.

Check out this example:

> db.foo.find()
> db.foo.insert({"test":"a"})
> db.foo.find()
{ "_id" : ObjectId("4e93037bbf6f1dd3a0a9541a"), "test" : "a" }
> item = db.foo.findOne()
{ "_id" : ObjectId("4e93037bbf6f1dd3a0a9541a"), "test" : "a" }
> db.foo.update({"_id" :ObjectId("4e93037bbf6f1dd3a0a9541a") },{$set : {"new_field":1}})
> db.foo.find()
{ "_id" : ObjectId("4e93037bbf6f1dd3a0a9541a"), "new_field" : 1, "test" : "a" }

EDIT:

In case you want to add a new_field to all your collection, you have to use empty selector, and set multi flag to true (last param) to update all the documents

db.your_collection.update(
  {},
  { $set: {"new_field": 1} },
  false,
  true
)

EDIT:

In the above example last 2 fields false, true specifies the upsert and multi flags.

Upsert: If set to true, creates a new document when no document matches the query criteria.

Multi: If set to true, updates multiple documents that meet the query criteria. If set to false, updates one document.

This is for Mongo versions prior to 2.2. For latest versions the query is changed a bit

db.your_collection.update({},
                          {$set : {"new_field":1}},
                          {upsert:false,
                          multi:true})

More Related Contents:

  1. Update field in exact element array in MongoDB
  2. MongoDB: How to update multiple documents with a single command?
  3. Possibility of duplicate Mongo ObjectId’s being generated in two different collections?
  4. Querying internal array size in MongoDB
  5. How can I run MongoDB as a Windows service?
  6. String field value length in mongoDB
  7. Where does mongodb stand in the CAP theorem?
  8. How to enforce foreign keys in NoSql databases (MongoDB)?
  9. NoSQL (MongoDB) vs Lucene (or Solr) as your database [closed]
  10. How do you query for “is not null” in Mongo?
  11. MongoDB lookup when foreign field is an array of objects
  12. How to stop insertion of Duplicate documents in a mongodb collection
  13. MongoDB nested array query
  14. Filtering embedded documents in MongoDB
  15. MongoDB/NoSQL: Keeping Document Change History
  16. Is mongodb running?
  17. Does MongoDB support floating point types?
  18. MongoDB normalization, foreign key and joining
  19. Unique IDs with mongodb
  20. Get a document in MongoDB without specifying collection
  21. Mongodb sort inner array
  22. Querying an array of arrays in MongoDB
  23. Is there any option to limit mongodb memory usage?
  24. $unwind empty array
  25. Find all duplicate documents in a MongoDB collection by a key field
  26. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  27. Push to two separate arrays in one update call in mongodb
  28. How to toggle a boolean field in one document with atomic operation?
  29. Sort nested array of objects
  30. How to return only value of a field in mongodb

Leave a Comment