Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. Get all
  2. db.restaurants.find();
  3.  
  4. Limit and Sort
  5. db.restaurants.find().
  6. sort({name: 1 }).
  7. limit(10)
  8.  
  9. Get by _id
  10. restaurant_id = db.restaurants.findOne({}, {_id: true})._id
  11. db.restaurants.find({_id:restaurant_id})
  12.  
  13. Get by Value
  14. db.restaurants.find({borough: "Queens"});
  15.  
  16. count
  17. db.restaurants.count()
  18.  
  19. Count by Nested Value
  20. db.restaurants.find({document.address.zipcode: 11206}).count()
  21.  
  22. Delete by Id
  23. restaurant_id = db.restaurants.findOne({}, {_id: true})._id; //find query - find first item and then return the iD component
  24. db.restaurants.removeOne({_id:restaurant_id})
  25.  
  26. Update a Single Document
  27. var myId = db.restaurants.findOne({}, {_id: true})._id;
  28. db.restaurants.updateOne(
  29. {_id: myId},
  30. {$set: {name: 'Bizz Bar Bang'}});
  31.  
  32. Update Many documents
  33. db.restaurants.updateMany(
  34. {'address.zipcode': '10035'},
  35. {$set: {'address.zipcode': '10036'}});
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement