MongoDB
Launch MongoDB with a database path
shell
mongod --dbpath "C:/Program Files/MongoDB/Data/DataBase"Launch the Mongo Client
shell
mongoSee the actions available on the database
shell
db.helps()See available databases
shell
show dbsUse a database
shell
use dmnchzlSee the database used
shell
dbSee the collections available in the database
shell
show collectionsCreate 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})