- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Found 1349 Articles for MongoDB
![Nishtha Thakur](https://www.tutorialspoint.com/assets/profiles/13598/profile/60_104893-1512719058.jpg)
306 Views
You can perform distinct with multiple keys with the help of an aggregate framework.To understand the concept, let us create a collection with the document. The query to create a collection with a document is as follows −> db.distinctWithMultipleKeysDemo.insertOne({"StudentName":"Mike", "StudentAge":22, "StudentMathMarks":56}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f74488d10a061296a3c53") } > db.distinctWithMultipleKeysDemo.insertOne({"StudentName":"Mike", "StudentAge":22, "StudentMathMarks":56}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f744b8d10a061296a3c54") } > db.distinctWithMultipleKeysDemo.insertOne({"StudentName":"Bob", "StudentAge":23, "StudentMathMarks":45}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f74598d10a061296a3c55") } > db.distinctWithMultipleKeysDemo.insertOne({"StudentName":"Bob", "StudentAge":23, "StudentMathMarks":45}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f745e8d10a061296a3c56") } > db.distinctWithMultipleKeysDemo.insertOne({"StudentName":"Carol", "StudentAge":27, "StudentMathMarks":54}); { "acknowledged" ... Read More
![Smita Kapse](https://www.tutorialspoint.com/assets/profiles/13597/profile/60_103706-1512718957.jpg)
174 Views
Use regexp to make case-insensitive queries on MongoDB. To understand the concept, let us create a collection with the document. The query to create a collection with a document is as follows −> db.caseInsensitiveDemo.insertOne({"UserName":"David"}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f6fec8d10a061296a3c45") } > db.caseInsensitiveDemo.insertOne({"UserName":"DAVID"}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f6ff28d10a061296a3c46") } > db.caseInsensitiveDemo.insertOne({"UserName":"david"}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f6ffa8d10a061296a3c47") } > db.caseInsensitiveDemo.insertOne({"UserName":"Carol"}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f70008d10a061296a3c48") } > db.caseInsensitiveDemo.insertOne({"UserName":"Mike"}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f70058d10a061296a3c49") } > db.caseInsensitiveDemo.insertOne({"UserName":"Sam"}); { "acknowledged" : true, "insertedId" : ... Read More
![Anvi Jain](https://www.tutorialspoint.com/assets/profiles/13591/profile/60_98631-1512716973.jpg)
2K+ Views
To remove an element from a doubly-nested array in MongoDB document, you can use $pull operator.To understand the concept, let us create a collection with the document. The query to create a collection with a document is as follows −> db.removeElementFromDoublyNestedArrayDemo.insertOne( ... { ... "_id" : "1", ... "UserName" : "Larry", ... "UserDetails" : [ ... { ... "UserCountryName" : "US", ... "UserLocation" : [ ... { ... Read More
![Nishtha Thakur](https://www.tutorialspoint.com/assets/profiles/13598/profile/60_104893-1512719058.jpg)
337 Views
You can achieve this with the help of $addFields operator. To understand the concept, let us create a collection with the document. The query to create a collection with a document is as follows −> db.addFieldDemo.insertOne({"EmployeeId":101, "EmployeeName":"Larry", "EmployeeDetails":{ "EmployeeSalary":65000, "EmployeeCity":"New York", "Message":"Hi"}}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f654d8d10a061296a3c44") }Display all documents from a collection with the help of find() method. The query is as follows −> db.addFieldDemo.find().pretty();The following is the output −{ "_id" : ObjectId("5c7f654d8d10a061296a3c44"), "EmployeeId" : 101, "EmployeeName" : "Larry", "EmployeeDetails" : { "EmployeeSalary" : 65000, ... Read More
![Anvi Jain](https://www.tutorialspoint.com/assets/profiles/13591/profile/60_98631-1512716973.jpg)
556 Views
To auto increment in MongoDB to store a sequence of unique user id, let us create a collection which contains information about last sequence values of all documents.Let us first create a collection. The query to create a collection which is as follows −> db.createSequenceDemo.insertOne({_id:"SID", S_Value:0}); { "acknowledged" : true, "insertedId" : "SID" }Now, we will create a function that will generate an auto increment in MongoDB to store sequence. The query is as follows −> function nextSequence(s) { ... var sd = db.createSequenceDemo.findAndModify({ ... query:{_id: s }, ... update: {$inc:{S_Value:1}}, ... Read More
![Smita Kapse](https://www.tutorialspoint.com/assets/profiles/13597/profile/60_103706-1512718957.jpg)
294 Views
Use the aggregate framework to find all duplicate documents in a MongoDB collection by a key field.To understand the concept, let us create a collection with the document. The query to create a collection with a document is as follows −> db.findDuplicateByKeyDemo.insertOne({"StudentId":1, "StudentName":"John"}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f5b168d10a061296a3c3a") } > db.findDuplicateByKeyDemo.insertOne({"StudentId":2, "StudentName":"Carol"}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f5b1f8d10a061296a3c3b") } > db.findDuplicateByKeyDemo.insertOne({"StudentId":3, "StudentName":"Carol"}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f5b248d10a061296a3c3c") } > db.findDuplicateByKeyDemo.insertOne({"StudentId":4, "StudentName":"John"}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f5b2d8d10a061296a3c3d") } > db.findDuplicateByKeyDemo.insertOne({"StudentId":5, "StudentName":"Sam"}); { "acknowledged" : true, ... Read More
![Anvi Jain](https://www.tutorialspoint.com/assets/profiles/13591/profile/60_98631-1512716973.jpg)
400 Views
You need to use some code in order to convert a string to numerical values in MongoDB.Let us first create a collection with a document. The query to create a collection with a document is as follows:> db.convertStringToNumberDemo.insertOne({"EmployeeId":"101", "EmployeeName":"Larry"}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f56528d10a061296a3c31") } > db.convertStringToNumberDemo.insertOne({"EmployeeId":"1120", "EmployeeName":"Mike"}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f56648d10a061296a3c32") } > db.convertStringToNumberDemo.insertOne({"EmployeeId":"3210", "EmployeeName":"Sam"}); { "acknowledged" : true, "insertedId" : ObjectId("5c7f566e8d10a061296a3c33") }Display all documents from the collection with the help of find() method. The query is as follows −> db.convertStringToNumberDemo.find().pretty();The following is the output −{ "_id" ... Read More
![Anvi Jain](https://www.tutorialspoint.com/assets/profiles/13591/profile/60_98631-1512716973.jpg)
267 Views
The $unwind operator in MongoDB is the same for each array, it returns the mapping document. Here is the demo of $unwind operator in MongoDB.To understand the concept, let us create a collection with the document. The query to create a collection with a document is as follows −> db.unwindOperatorDemo.insertOne({"StudentName":"Larry", "StudentAge":23, "StudentSubje ct":["C", "C++", "Java", "MongoDB"]}); { "acknowledged" : true, "insertedId" : ObjectId("5c7ef5f3559dd2396bcfbfc8") }Display all documents from a collection with the help of find() method. The query is as follows −> db.unwindOperatorDemo.find().pretty();The following is the output −{ "_id" : ObjectId("5c7ef5f3559dd2396bcfbfc8"), "StudentName" : "Larry", "StudentAge" : ... Read More
![Smita Kapse](https://www.tutorialspoint.com/assets/profiles/13597/profile/60_103706-1512718957.jpg)
803 Views
You can use $all operator to find by multiple array items. To understand the concept, let us create a collection with the document.The query to create a collection with a document is as follows −> db.findByMultipleArrayDemo.insertOne({"StudentFirstName":"John", "StudentLastName":"Smith", "StudentCoreSubject":["Compiler", "Operating System", "Computer Networks"]}); { "acknowledged" : true, "insertedId" : ObjectId("5c7ef07b559dd2396bcfbfc4") } > db.findByMultipleArrayDemo.insertOne({"StudentFirstName":"Carol", "StudentLastName":"Taylor", "StudentCoreSubject":["MongoDB", "MySQL", "SQL Server"]}); { "acknowledged" : true, "insertedId" : ObjectId("5c7ef09d559dd2396bcfbfc5") } > db.findByMultipleArrayDemo.insertOne({"StudentFirstName":"Bob", "StudentLastName":"Taylor", "StudentCoreSubject":["MongoDB", "MySQL", "SQL Server"]}); { "acknowledged" : true, "insertedId" : ObjectId("5c7ef0c7559dd2396bcfbfc6") } > db.findByMultipleArrayDemo.insertOne({"StudentFirstName":"David", "StudentLastName":"Johnson", "StudentCoreSubject":["Compiler", "Operating System", "Computer Networks"]}); { ... Read More
![Nishtha Thakur](https://www.tutorialspoint.com/assets/profiles/13598/profile/60_104893-1512719058.jpg)
103 Views
You can use $in operator to find with multiple array items. To understand the concept, let us create a collection with the document.The query to create a collection with a document is as follows −>db.findByMultipleArrayDemo.insertOne({"StudentFirstName":"John", "StudentLastName":"Smith", "StudentCoreSubject":["Compiler", "Operating System", "Computer Networks"]}); { "acknowledged" : true, "insertedId" : ObjectId("5c7ef07b559dd2396bcfbfc4") } >db.findByMultipleArrayDemo.insertOne({"StudentFirstName":"Carol", "StudentLastName":"Taylor", "StudentCoreSubject":["MongoDB", "MySQL", "SQL Server"]}); { "acknowledged" : true, "insertedId" : ObjectId("5c7ef09d559dd2396bcfbfc5") } >db.findByMultipleArrayDemo.insertOne({"StudentFirstName":"Bob", "StudentLastName":"Taylor", "StudentCoreSubject":["MongoDB", "MySQL", "SQL Server"]}); { "acknowledged" : true, "insertedId" : ObjectId("5c7ef0c7559dd2396bcfbfc6") } >db.findByMultipleArrayDemo.insertOne({"StudentFirstName":"David", "StudentLastName":"Johnson", "StudentCoreSubject":["Compiler", "Operating System", "Computer Networks"]}); { "acknowledged" : true, ... Read More