Skip to content

MongoDB

Launch MongoDB with a database path

shell
mongod --dbpath "C:/Program Files/MongoDB/Data/DataBase"

Launch the Mongo Client

shell
mongo

See the actions available on the database

shell
db.helps()

See available databases

shell
show dbs

Use a database

shell
use dmnchzl

See the database used

shell
db

See the collections available in the database

shell
show collections

Create documents

shell
db.apps.insert({_id:1, label:"Torch", color:"Red", available:false})
db.apps.insert({_id:2, label:"Decode", color:"Red", available:false})
db.apps.insert({_id:3, label:"PadLock", color:"Orange", available:false})

See the content of the collection

shell
db.apps.find()
{_id:1, label:"Torch", color:"Red", available:false}
{_id:2, label:"Decode", color:"Red", available:false}
{_id:3, label:"PadLock", color:"Orange", available:false}

Add a property to a document

shell
db.apps.update({label:"Torch"}, {$set: {tab:["A","B","C"]}})

Edit a property in multiple documents

shell
db.apps.update({available:false}, {$set: {available:true}}, {multi:true})

View table contents in descending order

shell
db.apps.find({label: {$in: ["Torch","Decode","PadLock"]}}).sort({_id:-1})
{_id:3, label:"PadLock", color:"Orange", available:true}
{_id:2, label:"Decode", color:"Red", available:true}
{_id:1, label:"Torch", color:"Red", available:true, tab:["A","B","C"]}

Add a value to an array

shell
db.apps.update({label:"Torch"}, {$push: {tab:"D"}})

Add the same value in an array without duplicate

shell
db.apps.update({label:"Torch"}, {$addToSet: {tab:"D"}})

View the element owning the array properly

shell
db.apps.find({label:"Torch"}).pretty()
{
     _id:1,
     label:"Torch",
     color:"Red",
     available:true,
     tab:[
         "A",
         "B",
         "C",
         "D"
     ]
}

Remove the last value from an array

shell
db.apps.update({label:"Torch"}, {$pop: {tab:1}})

Delete a property in a document

shell
db.apps.update({label:"Torch"}, {$unset: {tab:1}})

Delete a document from a collection

shell
db.apps.remove({label:"Torch"})

Delete a collection

shell
db.apps.drop()

Delete a database

shell
db.runCommand({dropDatabase:1})

Released under the MIT License.