Skip to content

Instantly share code, notes, and snippets.

@ms-vague
Created June 27, 2017 01:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ms-vague/f34d5b9a6bd3bf618148253e2f718d04 to your computer and use it in GitHub Desktop.
Save ms-vague/f34d5b9a6bd3bf618148253e2f718d04 to your computer and use it in GitHub Desktop.
// get all
db.restaurants.find();
// limit and sort
db.restaurants.
find().
sort({name: 1}).
limit(10);
// get by _id
var myId = db.restaurants.findOne({}, {_id: true})._id;
db.restaurants.findOne({_id: myId});
// get by value
db.restaurants.find({borough: "Queens"});
// count
db.restaurants.count();
// count by nest value
db.restaurants.find({'address.zipcode': '11206'}).count()
//delete by id
var myId = db.restaurants.findOne({}, {_id: true})._id;
db.restaurants.removeOne({_id: myId});
//update a single document
var myId = db.restaurants.findOne({}, {_id: true})._id;
db.restaurants.updateOne(
{_id: myId},
{$set: {name: 'Bizz Bar Bang'}});
// update many documents
db.restaurants.updateMany(
{'address.zipcode': '10035'},
{$set: {'address.zipcode': '10036'}});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment