Skip to content

Instantly share code, notes, and snippets.

@DikshaSach
Last active March 12, 2018 05:23
Show Gist options
  • Save DikshaSach/00c5b4d25784a21895a0253b04ccf683 to your computer and use it in GitHub Desktop.
Save DikshaSach/00c5b4d25784a21895a0253b04ccf683 to your computer and use it in GitHub Desktop.
1. Get all
> db.restaurants.find()
2. Limit and sort
> db.restaurants.find().limit(10).sort({name: 1})
3. Get by _id
> var foundOne = db.restaurants.findOne();
> db.restaurants.findOne(foundOne)
4. Get by value
> db.restaurants.find({borough: "Queens"})
5. Count
> db.restaurants.count()
3950
6. Count by nested value
> db.restaurants.find({"address.zipcode": "11206"}).count()
15
7. Delete by id
> var resId = db.restaurants.findOne({})._id;
> db.restaurants.remove({_id: resId})
WriteResult({ "nRemoved" : 1 })
8. Update a single document
> var newresId = db.restaurants.findOne({})._id;
> db.restaurants.updateOne({_id: newresId}, {$set: {"name":"Bizz Bar Bang"}});
{ "acknowledged" : true, "matchedCount" : 1, "modifiedCount" : 1 }
9. Update many documents
> db.restaurants.updateMany({"address.zipcode": "10035"}, {$set:{"address.zipcode": "10036"}});
{ "acknowledged" : true, "matchedCount" : 12, "modifiedCount" : 12 }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment