Scribd
Upload
32 views10 pages

Mongo Commands

The document shows examples of CRUD operations in MongoDB like insert, find, update, delete. It also shows aggregation operations like lookup, match, sort. Collections like studinfo and courseinfo are created, records inserted, updated and deleted. Joins are performed using lookup.

Uploaded by

niveditam0104
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
32 views10 pages

Mongo Commands

The document shows examples of CRUD operations in MongoDB like insert, find, update, delete. It also shows aggregation operations like lookup, match, sort. Collections like studinfo and courseinfo are created, records inserted, updated and deleted. Joins are performed using lookup.

Uploaded by

niveditam0104
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

[Link]

v=FwMwO8pXfq0
Show the databases available
>show dbs
Create a new database
>use student
Insert a record into Collection
> [Link]({"name":"roahit","regno":"18IT001"})
WriteResult({ "nInserted" : 1 })
Display the Collections Available
> show collections
Studinfo

Find()
>[Link]()
{ "_id" : ObjectId("60dca1bc6355fb9d774016cd"), "name" : "roahit", "regno" : "18IT001" }

>[Link]({"name":"Anitha","regno":"18IT002","Total_Marks":456})
WriteResult({ "nInserted" : 1 })

> [Link]()
{ "_id" : ObjectId("60dca1bc6355fb9d774016cd"), "name" : "roahit", "regno" : "18IT001" }
{ "_id" : ObjectId("60dca2a66355fb9d774016ce"), "name" : "Anitha", "regno" : "18IT002",
"Total_Marks" : 456 }

Insert many documents


> [Link]( [ {"name":"Akila","regno":"18IT008"},
{"name":"Manoj","regno":"18IT067","Total_Marks":432,"Grade":"S"}])
{
"acknowledged" : true,
"insertedIds" : [
ObjectId("60dca5f26355fb9d774016cf"),
ObjectId("60dca5f26355fb9d774016d0")
]
}
> [Link]()
{ "_id" : ObjectId("60dca1bc6355fb9d774016cd"), "name" : "roahit", "regno" : "18IT001" }
{ "_id" : ObjectId("60dca2a66355fb9d774016ce"), "name" : "Anitha", "regno" : "18IT002",
"Total_Marks" : 456 }
{ "_id" : ObjectId("60dca5f26355fb9d774016cf"), "name" : "Akila", "regno" : "18IT008" }
{ "_id" : ObjectId("60dca5f26355fb9d774016d0"), "name" : "Manoj", "regno" : "18IT067",
"Total_Marks" : 432, "Grade" : "S" }

Insert Many values for a attribute


> [Link]({"name":"Raja","Contact":[8978676754,6578976543]})
WriteResult({ "nInserted" : 1 })
> [Link]()
{ "_id" : ObjectId("60dca1bc6355fb9d774016cd"), "name" : "roahit", "regno" : "18IT001" }
{ "_id" : ObjectId("60dca2a66355fb9d774016ce"), "name" : "Anitha", "regno" : "18IT002",
"Total_Marks" : 456 }
{ "_id" : ObjectId("60dca5f26355fb9d774016cf"), "name" : "Akila", "regno" : "18IT008" }
{ "_id" : ObjectId("60dca5f26355fb9d774016d0"), "name" : "Manoj", "regno" : "18IT067",
"Total_Marks" : 432, "Grade" : "S" }
{ "_id" : ObjectId("60dca7316355fb9d774016d1"), "name" : "Raja", "Contact" : [
8978676754, 6578976543 ] }

To display Result in formatted way


> [Link]().pretty()
{
"_id" : ObjectId("60dca1bc6355fb9d774016cd"),
"name" : "roahit",
"regno" : "18IT001"
}
{
"_id" : ObjectId("60dca2a66355fb9d774016ce"),
"name" : "Anitha",
"regno" : "18IT002",
"Total_Marks" : 456
}
{
"_id" : ObjectId("60dca5f26355fb9d774016cf"),
"name" : "Akila",
"regno" : "18IT008"
}
{
"_id" : ObjectId("60dca5f26355fb9d774016d0"),
"name" : "Manoj",
"regno" : "18IT067",
"Total_Marks" : 432,
"Grade" : "S"
}
{
"_id" : ObjectId("60dca7316355fb9d774016d1"),
"name" : "Raja",
"Contact" : [
8978676754,
6578976543
]
}

To display first record


> [Link]()
{
"_id" : ObjectId("60dca1bc6355fb9d774016cd"),
"name" : "roahit",
"regno" : "18IT001"
}
Remove a document
> [Link]({"name":"roahit"})
WriteResult({ "nRemoved" : 1 })
> [Link]()
{ "_id" : ObjectId("60dca2a66355fb9d774016ce"), "name" : "Anitha", "regno" : "18IT002",
"Total_Marks" : 456 }
{ "_id" : ObjectId("60dca5f26355fb9d774016cf"), "name" : "Akila", "regno" : "18IT008" }
{ "_id" : ObjectId("60dca5f26355fb9d774016d0"), "name" : "Manoj", "regno" : "18IT067",
"Total_Marks" : 432, "Grade" : "S" }
{ "_id" : ObjectId("60dca7316355fb9d774016d1"), "name" : "Raja", "Contact" : [
8978676754, 6578976543 ] }

Find one matching document

> [Link]({"name":"Akila"})
{
"_id" : ObjectId("60dca5f26355fb9d774016cf"),
"name" : "Akila",
"regno" : "18IT008"
}
Use of Relational Operators
> [Link]({$or:[{"name":"Akila"},{"name":"Anitha"}]})
{ "_id" : ObjectId("60dca2a66355fb9d774016ce"), "name" : "Anitha", "regno" : "18IT002",
"Total_Marks" : 456 }
{ "_id" : ObjectId("60dca5f26355fb9d774016cf"), "name" : "Akila", "regno" : "18IT008" }

> [Link]({"Total_Marks":{$gt:450}}).pretty()
{
"_id" : ObjectId("60dca2a66355fb9d774016ce"),
"name" : "Anitha",
"regno" : "18IT002",
"Total_Marks" : 456
}

> [Link]({"Total_Marks":{$lt:450}}).pretty()
{
"_id" : ObjectId("60dca5f26355fb9d774016d0"),
"name" : "Manoj",
"regno" : "18IT067",
"Total_Marks" : 432,
"Grade" : "S"
}
> [Link]( { "Total_Marks": { $not: { $gt: "460" } } } )
{ "_id" : ObjectId("60dca2a66355fb9d774016ce"), "name" : "Anitha", "regno" : "18IT002",
"Total_Marks" : 456 }
{ "_id" : ObjectId("60dca5f26355fb9d774016cf"), "name" : "Akila", "regno" : "18IT008" }
{ "_id" : ObjectId("60dca5f26355fb9d774016d0"), "name" : "Manoj", "regno" : "18IT067",
"Total_Marks" : 432, "Grade" : "S" }
{ "_id" : ObjectId("60dca7316355fb9d774016d1"), "name" : "Raja", "Contact" : [
8978676754, 6578976543 ] }
Update Command
> [Link]({"name":"Akila"},{$set:{"name":"Akhila"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> [Link]()
{ "_id" : ObjectId("60dca2a66355fb9d774016ce"), "name" : "Anitha", "regno" : "18IT002",
"Total_Marks" : 456 }
{ "_id" : ObjectId("60dca5f26355fb9d774016cf"), "name" : "Akhila", "regno" : "18IT008" }
{ "_id" : ObjectId("60dca5f26355fb9d774016d0"), "name" : "Manoj", "regno" : "18IT067",
"Total_Marks" : 432, "Grade" : "S" }
{ "_id" : ObjectId("60dca7316355fb9d774016d1"), "name" : "Raja", "Contact" : [
8978676754, 6578976543 ] }
> [Link]()
4

Projection

> [Link]({},{"name":1})
{ "_id" : ObjectId("60dca2a66355fb9d774016ce"), "name" : "Anitha" }
{ "_id" : ObjectId("60dca5f26355fb9d774016cf"), "name" : "Akhila" }
{ "_id" : ObjectId("60dca5f26355fb9d774016d0"), "name" : "Manoj" }
{ "_id" : ObjectId("60dca7316355fb9d774016d1"), "name" : "Raja" }

> [Link]({},{"name":1,_id:0})
{ "name" : "Anitha" }
{ "name" : "Akhila" }
{ "name" : "Manoj" }
{ "name" : "Raja" }
{ "name" : "roahit" }

> [Link]({},{"name":1,_id:0}).limit(2)
{ "name" : "Anitha" }
{ "name" : "Akhila" }

> [Link]({},{"name":1,_id:0}).limit(2).skip(1)
{ "name" : "Akhila" }
{ "name" : "Manoj" }

> [Link]().sort({"name":1})
{ "_id" : ObjectId("60dca5f26355fb9d774016cf"), "name" : "Akhila", "regno" : "18IT008" }
{ "_id" : ObjectId("60dca2a66355fb9d774016ce"), "name" : "Anitha", "regno" : "18IT002",
"Total_Marks" : 456 }
{ "_id" : ObjectId("60dca5f26355fb9d774016d0"), "name" : "Manoj", "regno" : "18IT067",
"Total_Marks" : 432, "Grade" : "S" }
{ "_id" : ObjectId("60dca7316355fb9d774016d1"), "name" : "Raja", "Contact" : [
8978676754, 6578976543 ] }
{ "_id" : ObjectId("60de9d4a355c9817b1b43b5a"), "name" : "roahit", "regno" : "18IT001" }
> [Link]({},{"name":1,_id:0}).sort({"name":1})
{ "name" : "Akhila" }
{ "name" : "Anitha" }
{ "name" : "Manoj" }
{ "name" : "Raja" }
{ "name" : "roahit" }
> [Link]({},{"name":1,_id:0}).sort({"name":-1})
{ "name" : "roahit" }
{ "name" : "Raja" }
{ "name" : "Manoj" }
{ "name" : "Anitha" }
{ "name" : "Akhila" }

> [Link]({"coursename":"DBMS","Courseno":"18IT44","name":"Anitha"})
WriteResult({ "nInserted" : 1 })
> [Link]({"coursename":"Networks","Courseno":"18IT430","name":"Anitha"})
WriteResult({ "nInserted" : 1 })
> [Link]({"coursename":"Networks","Courseno":"18IT430","name":"roahit"})
WriteResult({ "nInserted" : 1 })
Join Operation:
db.collection_name.aggregation([
{
$lookup:
{
{
from: <collection to join>,
localField: <field from the input documents>,
foreignField: <field from the documents of the "from" collection>,as:
<output array field>
}
}
}

> [Link]([ {$lookup: { from: "courseinfo", localField: "name",foreignField:


"name", as: "stude_course" }} ]).pretty()
{
"_id" : ObjectId("60dca2a66355fb9d774016ce"),
"name" : "Anitha",
"regno" : "18IT002",
"Total_Marks" : 456,
"stude_course" : [
{
"_id" : ObjectId("60dec5ae355c9817b1b43b5b"),
"coursename" : "DBMS",
"Courseno" : "18IT44",
"name" : "Anitha"
},
{
"_id" : ObjectId("60dec5cb355c9817b1b43b5c"),
"coursename" : "Networks",
"Courseno" : "18IT430",
"name" : "Anitha"
}
]
}
{
"_id" : ObjectId("60dca5f26355fb9d774016cf"),
"name" : "Akhila",
"regno" : "18IT008",
"stude_course" : [ ]
}
{
"_id" : ObjectId("60dca5f26355fb9d774016d0"),
"name" : "Manoj",
"regno" : "18IT067",
"Total_Marks" : 432,
"Grade" : "S",
"stude_course" : [ ]
}
{
"_id" : ObjectId("60dca7316355fb9d774016d1"),
"name" : "Raja",
"Contact" : [
8978676754,
6578976543
],
"stude_course" : [ ]
}
{
"_id" : ObjectId("60de9d4a355c9817b1b43b5a"),
"name" : "roahit",
"regno" : "18IT001",
"stude_course" : [
{
"_id" : ObjectId("60dec5d9355c9817b1b43b5d"),
"coursename" : "Networks",
"Courseno" : "18IT430",
"name" : "roahit"
}
]
}

You might also like