Guest User

Untitled

a guest
May 26th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. get all restaurants :
  2. db.restaurants.find({})
  3.  
  4. limit and sort :
  5. db.restaurants.find({},{name:1}).sort({name:1}).limit(10)
  6.  
  7. get by id :
  8. var aRestaurant = db.restaurants.findOne({},{id:1})._id
  9. db.restaurants.find({_id: aRestaurant})
  10.  
  11. get by value :
  12. db.restaurants.find({borough: "Queens"})
  13.  
  14. count :
  15. db.restaurants.count()
  16.  
  17. count by nested value :11206 document.address.zipcode
  18. db.restaurants.count({"address.zipcode":"11206"})
  19.  
  20. delete one :
  21. var deletedObjectedId = db.restaurants.findOne({},{id:1})._id
  22. db.restaurants.deleteOne({"_id": deletedObjectId})
  23.  
  24. update one:
  25. var ObjectId = db.restaurants.findOne({},{_id:1})._id
  26. db.restaurants.updateOne({_id:ObjectId},{$set:{name:"Bizz Bar Bang"}})
  27.  
  28. update many:
  29. db.restaurants.updateMany({"address.zipcode":"10035"},{$set:{"address.zipcode":"10036"}})
Add Comment
Please, Sign In to add comment