Guest User

Untitled

a guest
Mar 20th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. 1. Get all
  2. > db.restaurants.find()
  3.  
  4. 2. Limit and sort
  5. > db.restaurants.find().limit(10).sort({name: 1})
  6.  
  7. 3. Get by _id
  8. > var foundOne = db.restaurants.findOne();
  9. > db.restaurants.findOne(foundOne)
  10.  
  11. 4. Get by value
  12. > db.restaurants.find({borough: "Queens"})
  13.  
  14. 5. Count
  15. > db.restaurants.count()
  16. 3950
  17.  
  18. 6. Count by nested value
  19. > db.restaurants.find({"address.zipcode": "11206"}).count()
  20. 15
  21.  
  22. 7. Delete by id
  23. > var resId = db.restaurants.findOne({})._id;
  24. > db.restaurants.remove({_id: resId})
  25. WriteResult({ "nRemoved" : 1 })
  26.  
  27. 8. Update a single document
  28. > var newresId = db.restaurants.findOne({})._id;
  29. > db.restaurants.updateOne({_id: newresId}, {$set: {"name":"Bizz Bar Bang"}});
  30. { "acknowledged" : true, "matchedCount" : 1, "modifiedCount" : 1 }
  31.  
  32. 9. Update many documents
  33. > db.restaurants.updateMany({"address.zipcode": "10035"}, {$set:{"address.zipcode": "10036"}});
  34. { "acknowledged" : true, "matchedCount" : 12, "modifiedCount" : 12 }
Add Comment
Please, Sign In to add comment