Advertisement
Guest User

Untitled

a guest
Apr 24th, 2017
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. LET var mydb = db.restaurants
  2.  
  3. FIND ALL
  4. mydb.find()
  5. FIND FIRST TEN SORTED BY ALPHABETICAL ORDER
  6. mydb.find().sort({name: 1}).limit(10)
  7. FIND ANY ITEM
  8. var id = mydb.findOne({}, {_id: 1})
  9. mydb.find(id)
  10. FIND ALL WITH BOROUGH=QUEENS
  11. mydb.find({borough:"Queens"})
  12. FIND NUMBER OF ITEMS IN COLLECTION
  13. mydb.count()
  14. FIND NUMBER OF ITEMS WITH "address.zipcode" FIELD EQUAL TO "11206"
  15. mydb.find({"address.zipcode": "11206"}).count()
  16. DELETE AN ITEM
  17. var id = mydb.findOne({}, {_id: 1})
  18. mydb.delete(id)
  19. UPDATE AN ITEM
  20. var id = mydb.findOne({}, {_id: 1})
  21. mydb.update(id, {name: "Fizz Bar Bang"})
  22. UPDATE MANY ITEMS
  23. mydb.updateMany({"address.zipcode": "11206"}, {$set:{"address.zipcode": "11205"}})
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement