Here’s a cheat-sheet for basic database management and manipulation in MongoDB
.
Check for mongo process
ps -ef | grep mongo
Show DBs
show dbs
Create & Use DB
use DATABASE_NAME
Drop DB (must switch to it)
db.dropDatabase()
Check Current DB
db
Create Collection
db.createCollection("COLLECTION_NAME")
Show Collections
show collections
Drop Collection
db.COLLECTION_NAME.drop()
Insert
db.COLLECTION_NAME.insert(document)
db.COLLECTION_NAME.insert({
_id: ObjectId(7df78ad8902c),
title: 'MongoDB Overview',
description: 'MongoDB is no sql database',
by: 'tutorials point',
url: 'http://www.tutorialspoint.com',
tags: ['mongodb', 'database', 'NoSQL'],
likes: 100
})
db.COLLECTION_NAME.insert([
{
title: 'MongoDB Overview',
description: 'MongoDB is no sql database',
by: 'tutorials point',
url: 'http://www.tutorialspoint.com',
tags: ['mongodb', 'database', 'NoSQL'],
likes: 100
},
{
title: 'NoSQL Database',
description: 'NoSQL database doesn't have tables',
by: 'tutorials point',
url: 'http://www.tutorialspoint.com',
tags: ['mongodb', 'database', 'NoSQL'],
likes: 20,
comments: [
{
user:'user1',
message: 'My first comment',
dateCreated: new Date(2013,11,10,2,35),
like: 0
}
]
}
])
Find
db.COLLECTION_NAME.find()
Pretty Response Find
db.COLLECTION_NAME.find().pretty()
db.COLLECTION_NAME.find({key1:value1, key2:value2}).pretty()
Update
db.COLLECTION_NAME.update(SELECTIOIN_CRITERIA, UPDATED_DATA)
db.COLLECTION_NAME.update({'title':'MongoDB Overview'},{$set:{'title':'New MongoDB Tutorial'}})
Save
db.COLLECTION_NAME.save({_id:ObjectId(),NEW_DATA})
db.COLLECTION_NAME.save(
{
"_id" : ObjectId(5983548781331adf45ec7), "title":"Tutorials Point New Topic",
"by":"Tutorials Point"
}
)