Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1. Get all
- > db.restaurants.find()
- 2. Limit and sort
- > db.restaurants.find().limit(10).sort({name: 1})
- 3. Get by _id
- > var foundOne = db.restaurants.findOne();
- > db.restaurants.findOne(foundOne)
- 4. Get by value
- > db.restaurants.find({borough: "Queens"})
- 5. Count
- > db.restaurants.count()
- 3950
- 6. Count by nested value
- > db.restaurants.find({"address.zipcode": "11206"}).count()
- 15
- 7. Delete by id
- > var resId = db.restaurants.findOne({})._id;
- > db.restaurants.remove({_id: resId})
- WriteResult({ "nRemoved" : 1 })
- 8. Update a single document
- > var newresId = db.restaurants.findOne({})._id;
- > db.restaurants.updateOne({_id: newresId}, {$set: {"name":"Bizz Bar Bang"}});
- { "acknowledged" : true, "matchedCount" : 1, "modifiedCount" : 1 }
- 9. Update many documents
- > db.restaurants.updateMany({"address.zipcode": "10035"}, {$set:{"address.zipcode": "10036"}});
- { "acknowledged" : true, "matchedCount" : 12, "modifiedCount" : 12 }
Add Comment
Please, Sign In to add comment