📄
MongoDB
CheatSheet
MongoDB Cheat Sheet
Show All Databases
show dbs
Show Current Database
db
Create Or Switch Database
use acme
MongoDB CheatSheet 1
Drop
[Link]()
Create Collection
[Link]('posts')
Show Collections
show collections
Insert Row
[Link]({
title: 'Post One',
body: 'Body of post one',
category: 'News',
tags: ['news', 'events'],
user: {
name: 'John Doe',
status: 'author'
},
MongoDB CheatSheet 2
date: Date()
})
Insert Multiple Rows
[Link]([
{
title: 'Post Two',
body: 'Body of post two',
category: 'Technology',
date: Date()
},
{
title: 'Post Three',
body: 'Body of post three',
category: 'News',
date: Date()
},
{
title: 'Post Four',
body: 'Body of post three',
category: 'Entertainment',
date: Date()
}
])
Get All Rows
[Link]()
MongoDB CheatSheet 3
Get All Rows Formatted
[Link]().pretty()
Find Rows
[Link]({ category: 'News' })
Sort Rows
# asc
[Link]().sort({ title: 1 }).pretty()
# desc
[Link]().sort({ title: -1 }).pretty()
Count Rows
[Link]().count()
[Link]({ category: 'news' }).count()
Limit Rows
MongoDB CheatSheet 4
[Link]().limit(2).pretty()
Chaining
[Link]().limit(2).sort({ title: 1 }).pretty()
Foreach
[Link]().forEach(function(doc) {
print("Blog Post: " + [Link])
})
Find One Row
[Link]({ category: 'News' })
Find Specific Fields
[Link]({ title: 'Post One' }, {
title: 1,
author: 1
})
MongoDB CheatSheet 5
Update Row
[Link]({ title: 'Post Two' },
{
title: 'Post Two',
body: 'New body for post 2',
date: Date()
},
{
upsert: true
})
Update Specific Field
[Link]({ title: 'Post Two' },
{
$set: {
body: 'Body for post 2',
category: 'Technology'
}
})
Increment Field ($inc)
[Link]({ title: 'Post Two' },
{
$inc: {
MongoDB CheatSheet 6
likes: 5
}
})
Rename Field
[Link]({ title: 'Post Two' },
{
$rename: {
likes: 'views'
}
})
Delete Row
[Link]({ title: 'Post Four' })
Sub-Documents
[Link]({ title: 'Post One' },
{
$set: {
comments: [
{
body: 'Comment One',
user: 'Mary Williams',
date: Date()
MongoDB CheatSheet 7
},
{
body: 'Comment Two',
user: 'Harry White',
date: Date()
}
]
}
})
Find By Element in Array
($elemMatch)
[Link]({
comments: {
$elemMatch: {
user: 'Mary Williams'
}
}
}
)
Add Index
[Link]({ title: 'text' })
Text Search
MongoDB CheatSheet 8
[Link]({
$text: {
$search: "\"Post O\""
}
})
Greater & Less Than
[Link]({ views: { $gt: 2 } })
[Link]({ views: { $gte: 7 } })
[Link]({ views: { $lt: 7 } })
[Link]({ views: { $lte: 7 } })
Made with ❤ by Sarthak Chauhan.
MongoDB CheatSheet 9
