[MongoDB] Remove, update, create document

標籤：

Remove:

remove the wand with the name of "Doom Bringer" from our wandscollection.

db.wands.remove({name: "Doom Bringer"})>> WriteResult({‘ngRemoved‘: 1})

 

When we removed the "Doom Bringer" wand, we noticed that it had a power of "Death", and we don‘t want any wands like that in our database. To be safe, let‘s remove any wands containing that in their powers.

db.wands.remove({name: "Doom Bringer", powers: "Death"})

 

Update:

Write the command to update the wand with a name of "Devotion Shift" and set the price to 5.99.

db.wands.update({name: "Devotion Shift"},{"$set": {price: 5.99}});

 

Update all the document: "multi"

Increase level_required by 2, apply to all the documents match {powers: "Fire"}:

db.wands.update(  {powers: "Fire"},  {"$inc":{level_required: 2}},  {"multi": true})

 

Create new document if there is no existing one: "upsert"

db.logs.update(  {name: "Dream Bender"},  {"$inc": {count: 1}},  {"upsert": true})

[MongoDB] Remove, update, create document