Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. // Get all
  2.  
  3. db.restaurants.find();
  4.  
  5. // Limit and sort
  6.  
  7. db.restaurants.
  8. find().
  9. sort({name: 1}).
  10. limit(10);
  11.  
  12. // Get by _id
  13.  
  14. var myId = db.restaurants.findOne({}, {_id: true})._id;
  15. db.restaurants.findOne({_id: myId});
  16.  
  17. // Get by value
  18.  
  19. db.restaurants.find({borough: "Queens"});
  20.  
  21. // Count
  22.  
  23. db.restaurants.count();
  24.  
  25. // Count by nested value
  26.  
  27. db.restaurants.find({'address.zipcode': '11206'}).count()
  28.  
  29. // delete by id
  30.  
  31. var myId = db.restaurants.findOne({}, {_id: true})._id;
  32. db.restaurants.removeOne({_id: myId});
  33.  
  34. // update a single document
  35.  
  36. var myId = db.restaurants.findOne({}, {_id: true})._id;
  37. db.restaurants.updateOne(
  38. {_id: myId},
  39. {$set: {name: 'Bizz Bar Bang'}});
  40.  
  41. // update many documents
  42.  
  43. db.restaurants.updateMany(
  44. {'address.zipcode': '10035'},
  45. {$set: {'address.zipcode': '10036'}});
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement