MongoDB CheatSheet

All MongoDB commands MongoDb Cheatsheet

As a beginner in MongoDB, you might find it helpful to have a comprehensive list of all the necessary commands. This list includes almost all of the most commonly used commands in MongoDB. For the purpose of this guide, let us assume that you are working within a collection named comments on a MongoDB database of your choice.

1. Database Commands

View all databases

show dbs

Create a new or switch databases

use dbName

View current Database

db

Delete Database

db.dropDatabase()

2. Collection Commands

Show Collections

show collections

Create a collection named comments

db.createCollection('comments')

Drop a collection named comments

db.comments.drop()

3. Row(Document) Commands

Show all Rows in a Collection

db.comments.find()

Show all Rows in a Collection (Prettified)

db.comments.find().pretty()

Find the first row matching the object

db.comments.findOne({name: 'Ahmad'})

Insert One Row

db.comments.insert({
    'name': 'Ahmad',
    'tech_lang': 'JavaScript',
    'member_since': 5
 })

Insert many Rows

db.comments.insertMany([{
    'name': 'Ahmad',
    'tech_lang': 'JavaScript',
    'member_since': 5
    }, 
    {'name': 'test',
    'tech_lang': 'Python',
    'member_since': 3
    },
    {'name': 'ali',
    'tech_lang': 'Java',
    'member_since': 4
}])

Search in a MongoDb Database

db.comments.find({tech_lang:'Python'})

Limit the number of rows in output

db.comments.find().limit(2)

Count the number of rows in the output

db.comments.find().count()

Update a row

db.comments.updateOne({name: 'Ali'},
{$set: {'name': 'Ahmad',
    'tech_lang': 'JavaScript',
    'member_since': 51
}}, {upsert: true})

Mongodb Increment Operator

db.comments.update({name: 'Admin User'},
{$inc:{
    member_since: 2
}})

Mongodb Rename Operator

db.comments.update({name: 'Admin'},
{$rename:{
    member_since: 'member'
}})

Delete Row

db.comments.remove({name: 'Ahmad'})

Less than/Greater than/ Less than or Eq/Greater than or Eq

db.comments.find({member_since: {$lt: 90}})

db.comments.find({member_since: {$lte: 90}})

db.comments.find({member_since: {$gt: 90}})

db.comments.find({member_since: {$gte: 90}})