MongoDB Cheat Sheet

SQL Terms/Concepts	MongoDB Terms/Concepts
database	database
table	collection
row	document
column	field
index	index
table joins	embedded documents and linking

Show All Databases

show dbs

Show Current Database

db

Create Or Switch Database

use user

Display help on DB methods

db.help()

Drop Database

db.dropDatabase()

Create Collection

db.createCollection('user')

Show Collections

show collections

Display help on Collection

db.collection.help();

Drop Collection

db.user.drop()

Insert Row

db.user.insertOne({
  name: 'koray',
  surname: 'peker',
  yearOfBirth: 1987
})

Insert Multiple Rows

db.user.insertMany([
  {
    name: 'koray', surname: 'peker', yearOfBirth: 1987
  },
  {
    name: 'koray2', surname: 'peker', yearOfBirth: 1992
  },
  {
    name: 'koray3', surname: 'peker', yearOfBirth: 2021
  }
])

Get All Rows

db.user.find()

Get All Rows Formatted

db.user.find().pretty()

Find Rows

db.user.find({name : "koray"})

Sort Rows

# asc
db.user.find().sort({yearOfBirth:1})

# desc
db.user.find().sort({yearOfBirth:-1})

Count Rows

db.user.find().count()
db.user.find({name:"koray"}).count()

Limit Rows

db.user.find().limit(2)

Chaining

db.user.find().limit(2).sort({ yearOfBirth: 1 })

Foreach

db.user.find().forEach(function(doc) {
  print("User Name: " + doc.name)
})

Find One Row

db.user.findOne({name:"koray"})

Find Specific Fields

db.user.find({}, { yearOfBirth: 1, surname: 1 })
db.user.find({"name":"koray"}, {name:true, surname:true, _id:false})

Find With Comparison Operators

db.user.find({yearOfBirth: {$eq: 1987}})
db.user.find({yearOfBirth: {$lt: 1987}})
db.user.find({yearOfBirth: {$lte: 1987}})
db.user.find({yearOfBirth: {$gt: 1987}})
db.user.find({yearOfBirth: {$gte: 1987}})
db.user.find({yearOfBirth: {$ne: 1987}})
db.user.find({yearOfBirth: {$in: [1987, 1988]}})
db.user.find({yearOfBirth: {$nin: [1987, 1988]}})

Find With Logical Operators

db.user.find( { $or: [{yearOfBirth: {$lte: 1987}}, {yearOfBirth: {$eq: 1988}}]})
db.user.find( { $and: [{yearOfBirth: {$eq: 1987}}, {name: {$eq: "koray"}}]})
db.user.find( {$not: {yearOfBirth: {$eq: 1992} }})
db.user.find( { $nor: [{yearOfBirth: {$lte: 1987}}, {yearOfBirth: {$eq: 1988}}]})

Find With Element Operators

db.user.find( {name: {$exists: true }})

Update Row

db.user.update({ name: "koray" },
{
  name "koray",
  surname: "peker",
  yearOfBirth:1988
},
{
  upsert: true
})

db.user.updateOne({ name: "koray" }, { $set: { yearOfBirth: 1987 } })

Update Multiple Rows

db.user.updateMany({}, { $set: { yearOfBirth: 1987 } })

Update Specific Field

db.user.update({ name: "koray" },
{
  $set: {
    yearOfBirth:1988
  }
})

Increment Field ($inc)

db.posts.update({ name: "koray" },
{
  $inc: {
    yearOfBirth: 5
  }
})

Rename Field

db.posts.update({ name: "koray" },
{
  $rename: {
    yearOfBirth: "age"
  }
})

Delete Row

db.user.remove({ name: "koray" })
db.user.deleteOne({ name: "koray" })
db.user.deleteMany({ yearOfBirth: { $gt: 2000 } })

Create An Index

db.user.createIndex({ name: 1 })

Create a Unique Index

db.user.createIndex( {name:1},{unique:true} )

Create a Index On Multiple Fields (Compound Index)

db.user.createIndex({name:1, surname:-1})

Show All Indexes In a Collection

db.user.getIndexes()

Drop an Index

db.user.dropIndex({name:-1})

Show Index Statistics

db.user.stats()

Kaynaklar

• https://docs.mongodb.com/manual/reference/operator/query/
• https://info-mongodb-com.s3.amazonaws.com/ReferenceCards15-PDF.pdf
• https://docs.mongodb.com/manual/
• https://docs.mongodb.com/manual/reference/method/js-collection/
• https://gist.github.com/aponxi/4380516