To start Mongo DB
$ mongosh
Create Database
use Student
switched to db Student
To check which database is in current use
>db
Student
To create Collection
b.createCollection('Student')
{ ok: 1 }
Insert into Collection
Student> db.Student.insert({'Roll No ':78,'Name ':'Yadnesh Wani','Class':'TE'})
{
acknowledged: true,
insertedIds: { '0': ObjectId("6347a9b81e5534350c27020c") }
}
To display data
Student> db.Student.find()
[
{ _id: ObjectId("6347a9721e5534350c27020b"), 'Roll No ': 78 },
{
_id: ObjectId("6347a9b81e5534350c27020c"),
'Roll No ': 78,
'Name ': 'Yadnesh Wani',
Class: 'TE'
}
]
Insert Multiple Record
Student> db.Studen.insertMany( [ { 'Roll No':78, 'Name':'Yadnesh Wani', 'Class':'TE', 'Age':'20' },
{ 'Roll No':81, 'Name':'Dnyanesh Bachhav','Class':'TE','Age':20}])
{
acknowledged: true,
insertedIds: {
'0': ObjectId("6347b0b31e5534350c27020d"),
'1': ObjectId("6347b0b31e5534350c27020e")
}
}
Display
Student> db.Studen.find()
[
{
_id: ObjectId("6347b0b31e5534350c27020d"),
'Roll No': 78,
Name: 'Yadnesh Wani',
Class: 'TE',
Age: '20'
},
{
_id: ObjectId("6347b0b31e5534350c27020e"),
'Roll No': 81,
Name: 'Dnyanesh Bachhav',
Class: 'TE',
Age: 20
}
]
Output Using Pretty Command
Student> db.Student.find().pretty()
[
{ _id: ObjectId("6347a9721e5534350c27020b"), 'Roll No ': 78 },
{
_id: ObjectId("6347a9b81e5534350c27020c"),
'Roll No ': 78,
'Name ': 'Yadnesh Wani',
Class: 'TE'
},
{
_id: ObjectId("6347b3137ee8f58843906905"),
id: 101,
Name: 'Suyog Sabale',
Class: 'TE',
Age: 20
}
]
Find with Condition
Student> db.Student.find({'Roll No ':78})
[
{ _id: ObjectId("6347a9721e5534350c27020b"), 'Roll No ': 78 },
{
_id: ObjectId("6347a9b81e5534350c27020c"),
'Roll No ': 78,
'Name ': 'Yadnesh Wani',
Class: 'TE'
}
]
Sorting in Descending Order
Student> db.Student.find().sort({'Name':1})
[
{ _id: ObjectId("6347a9721e5534350c27020b"), 'Roll No ': 78 },
{
_id: ObjectId("6347a9b81e5534350c27020c"),
'Roll No ': 78,
'Name ': 'Yadnesh Wani',
Class: 'TE'
},
{
_id: ObjectId("6347b445e8a39cff6a5905f2"),
'Roll No': 81,
Name: 'Dnyanesh Bachhav',
Class: 'TE',
Age: 20
},
{
_id: ObjectId("6347b3137ee8f58843906905"),
id: 101,
Name: 'Suyog Sabale',
Class: 'TE',
Age: 20
}
]
Sorting in Ascending Order
tudent> Student> db.Student.find().sort({'Name':-1})
ReferenceError: Student is not defined
Student> [
... {
... _id: ObjectId("6347b3137ee8f58843906905"),
... id: 101,
... Name: 'Suyog Sabale',
... Class: 'TE',
... Age: 20
... },
... {
... _id: ObjectId("6347b445e8a39cff6a5905f2"),
... 'Roll No': 81,
... Name: 'Dnyanesh Bachhav',
... Class: 'TE',
... Age: 20
... },
... { _id: ObjectId("6347a9721e5534350c27020b"), 'Roll No ': 78 },
... {
... _id: ObjectId("6347a9b81e5534350c27020c"),
... 'Roll No ': 78,
... 'Name ': 'Yadnesh Wani',
... Class: 'TE'
... }
... ]
Update Operation
Before Update
Student> db.Student.find()
[
{ _id: ObjectId("6347a9721e5534350c27020b"), 'Roll No ': 78 },
{
_id: ObjectId("6347a9b81e5534350c27020c"),
'Roll No ': 78,
'Name ': 'Yadnesh Wani',
Class: 'TE'
},
{
_id: ObjectId("6347b3137ee8f58843906905"),
id: 101,
Name: 'Suyog Sabale',
Class: 'TE',
Age: 20
},
{
_id: ObjectId("6347b445e8a39cff6a5905f2"),
'Roll No': 81,
Name: 'Dnyanesh Bachhav',
Class: 'TE',
Age: 20
}
]
Update Query
Student> db.Student.update({id:101},{$set:{id:75}})
DeprecationWarning: Collection.update() is deprecated. Use updateOne, updateMany, or bulkWrite.
{
acknowledged: true,
insertedId: null,
matchedCount: 1,
modifiedCount: 1,
upsertedCount: 0
}
After Update
Student> db.Student.find()
[
{ _id: ObjectId("6347a9721e5534350c27020b"), 'Roll No ': 78 },
{
_id: ObjectId("6347a9b81e5534350c27020c"),
'Roll No ': 78,
'Name ': 'Yadnesh Wani',
Class: 'TE'
},
{
_id: ObjectId("6347b3137ee8f58843906905"),
id: 75,
Name: 'Suyog Sabale',
Class: 'TE',
Age: 20
},
{
_id: ObjectId("6347b445e8a39cff6a5905f2"),
'Roll No': 81,
Name: 'Dnyanesh Bachhav',
Class: 'TE',
Age: 20
}
]
Delete Operation
Before Delete
Student> db.Student.find()
[
{ _id: ObjectId("6347a9721e5534350c27020b"), 'Roll No ': 78 },
{
_id: ObjectId("6347a9b81e5534350c27020c"),
'Roll No ': 78,
'Name ': 'Yadnesh Wani',
Class: 'TE'
},
{
_id: ObjectId("6347b3137ee8f58843906905"),
id: 75,
Name: 'Suyog Sabale',
Class: 'TE',
Age: 20
},
{
_id: ObjectId("6347b445e8a39cff6a5905f2"),
'Roll No': 81,
Name: 'Dnyanesh Bachhav',
Class: 'TE',
Age: 20
}
]
Delete Query
Student> db.Student.deleteOne({id:75})
{ acknowledged: true, deletedCount: 1 }
After Delete
Student> db.Student.find()
[
{ _id: ObjectId("6347a9721e5534350c27020b"), 'Roll No ': 78 },
{
_id: ObjectId("6347a9b81e5534350c27020c"),
'Roll No ': 78,
'Name ': 'Yadnesh Wani',
Class: 'TE'
},
{
_id: ObjectId("6347b445e8a39cff6a5905f2"),
'Roll No': 81,
Name: 'Dnyanesh Bachhav',
Class: 'TE',
Age: 20
}
]
Logical Operation
And Operation
Student> db.Student.find({$and: [{Class:'TE'},{'Age':20}]})
[
{
_id: ObjectId("6347b445e8a39cff6a5905f2"),
'Roll No': 81,
Name: 'Dnyanesh Bachhav',
Class: 'TE',
Age: 20
}
]
OR Operation
Student> db.Student.find({$or: [{Class:'TE'},{'Age':20}]})
[
{
_id: ObjectId("6347a9b81e5534350c27020c"),
'Roll No ': 78,
'Name ': 'Yadnesh Wani',
Class: 'TE'
},
{
_id: ObjectId("6347b445e8a39cff6a5905f2"),
'Roll No': 81,
Name: 'Dnyanesh Bachhav',
Class: 'TE',
Age: 20
}
]
Nor Operation
Student> db.Student.find({$nor: [{'Age':20}]})
[
{ _id: ObjectId("6347a9721e5534350c27020b"), 'Roll No ': 78 },
{
_id: ObjectId("6347a9b81e5534350c27020c"),
'Roll No ': 78,
'Name ': 'Yadnesh Wani',
Class: 'TE'
}
]
Not Operation
Student> db.Student.find({'Age':{$not: {$gt:20}}})
[
{ _id: ObjectId("6347a9721e5534350c27020b"), 'Roll No ': 78 },
{
_id: ObjectId("6347a9b81e5534350c27020c"),
'Roll No ': 78,
'Name ': 'Yadnesh Wani',
Class: 'TE'
},
{
_id: ObjectId("6347b445e8a39cff6a5905f2"),
'Roll No': 81,
Name: 'Dnyanesh Bachhav',
Class: 'TE',
Age: 20
}
]
SAVE Method
The save() method replaces the existing document with the new document passed in the save()
method.
Syntax
The basic syntax of MongoDB save() method is shown below −
>db.COLLECTION_NAME.save({_id:ObjectId(),NEW_DATA})
