MongDB usage - hqzhang/cloudtestbed GitHub Wiki

How to use Mongodb

===install Mongodb===

brew update
brew install mongodb
mkdir -p /data/db

===use Mongodb

sudo mongod &
mongo
>show dbs
>use test  //create database
>db.createUser({  //create user
     user:"name",
     passwd:"passwd",
     roles:["readWrite"]
    });
>db.createCollection("cisco"); //create collection
>db.cisco.insert(    //insert document into collection:restaurants
		{
			"id" : 1,
			"Name" : "Martin",
                        "age":25
		}
	);
>db.cisco.update({Name:"Martin"},{$set:{sex:"male"}});  //add more field
>db.cisco.update({name:"Martin"},{$inc:{id:5}})         //increase id
>db.cisco.update({name:"Martin"},{$unset:{age:1}})      //remove a field
>db.cisco.update({name:"Martin"},{$rename:{"id":"Emid"}}) //change field name
>db.cisco.find({age:{$gt:40}})                           //age > 40
>db.restaurants.find().pretty()                          //good format
>db.cisco.find({$and:[{age:{$gt:40}},{name:"sandeep"}]}) // two condition  
>db.cisco.find().sort({name})                            //sort by name
> db.cisco.find().count()                                //count record
> db.cisco.find().limit(2)                               //list top 2
>db.cisco.remove({name:"Martin"})                        //remove a record
>db.restaurants.find()    //query data