- 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
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
505 Views
To get the sum of two columns, use $add. Let us create a collection with documents −> db.demo291.insertOne({"Value1":10, "Value2":50}); { "acknowledged" : true, "insertedId" : ObjectId("5e4c0e1e5d93261e4bc9ea2f") }Display all documents from a collection with the help of find() method −> db.demo291.find();This will produce the following output −{ "_id" : ObjectId("5e4c0e1e5d93261e4bc9ea2f"), "Value1" : 10, "Value2" : 50 }Following is the query to get the sum of two columns and save it to another column “Value3” −> db.demo291.aggregate( ... { "$project" : { ... 'Value1' : '$Value1', ... 'Value2' : '$Value2', ... 'Value3' : ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
674 Views
For exact match, you can use $exists that checks for a match. Let us create a collection with documents −> db.demo290.insertOne({"ListOfName":"Chris"}); { "acknowledged" : true, "insertedId" : ObjectId("5e4c0c9e5d93261e4bc9ea2d") } > db.demo290.insertOne({"ListOfName":["Chris", "David"]}); { "acknowledged" : true, "insertedId" : ObjectId("5e4c0cb05d93261e4bc9ea2e") }Display all documents from a collection with the help of find() method −> db.demo290.find();This will produce the following output −{ "_id" : ObjectId("5e4c0c9e5d93261e4bc9ea2d"), "ListOfName" : "Chris" } { "_id" : ObjectId("5e4c0cb05d93261e4bc9ea2e"), "ListOfName" : [ "Chris", "David" ] }Here is the query for exact match of a value −> db.demo290.find({$and: [{'ListOfName.0': {$exists: false}}, {"ListOfName": 'Chris'}]});This will produce the ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
211 Views
To make an array of multiple arrays, use $unwind in MongoDB aggregate. Let us create a collection with documents −> db.demo289.insertOne({"Section":["A", "B", "E"], "Name":"Chris"}); { "acknowledged" : true, "insertedId" : ObjectId("5e4c06fcf49383b52759cbc3") } > db.demo289.insertOne({"Section":["C", "D", "B"], "Name":"David"}); { "acknowledged" : true, "insertedId" : ObjectId("5e4c070af49383b52759cbc4") }Display all documents from a collection with the help of find() method −> db.demo289.find().pretty();This will produce the following output −{ "_id" : ObjectId("5e4c06fcf49383b52759cbc3"), "Section" : [ "A", "B", "E" ], "Name" : "Chris" } { "_id" : ObjectId("5e4c070af49383b52759cbc4"), "Section" : [ "C", "D", "B" ], "Name" ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
228 Views
Let us create a collection with documents −>db.demo288.insertOne({"Name":"Chris", details:[{"CountryName":"US", Marks:78}, {"CountryName":"UK", Marks:68}]}); { "acknowledged" : true, "insertedId" : ObjectId("5e4c0393f49383b52759cbbe") }Display all documents from a collection with the help of find() method −> db.demo288.find();This will produce the following output −{ "_id" : ObjectId("5e4c0393f49383b52759cbbe"), "Name" : "Chris", "details" : [ { "CountryName" : "US", "Marks" : 78 }, { "CountryName" : "UK", "Marks" : 68 } ] }Following is the query to implement $push in embedded document array −> db.demo288.update( {Name: "Chris"}, {$push:{ "details":{"CountryName" : "AUS", "Marks" : 98} }}, {upsert:true}); WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
4K+ Views
To get distinct values, use distinct() in MongoDB. It finds the distinct values for a specified field across a single collection or view and returns the results in an array.Let us create a collection with documents −> db.demo287.insertOne({"details":{"AllVowels":["a", "u", "u", "o", "e", "a", "o", "i"]}}); { "acknowledged" : true, "insertedId" : ObjectId("5e4c014cf49383b52759cbbd") }Display all documents from a collection with the help of find() method −> db.demo287.find().pretty();This will produce the following output −{ "_id" : ObjectId("5e4c014cf49383b52759cbbd"), "details" : { "AllVowels" : [ "a", "u", "u", "o", "e", "a", "o", "i" ] } }Following ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
1K+ Views
To get the min and max values, use $min and $max. Let us create a collection with documents −> db.demo286.insertOne({"details":[{Value1:70, Value2:50}, {Value1:30, Value2:36}]}); { "acknowledged" : true, "insertedId" : ObjectId("5e4ac743f49383b52759cbbc") }Display all documents from a collection with the help of find() method −> db.demo286.find().pretty();This will produce the following output −{ "_id" : ObjectId("5e4ac743f49383b52759cbbc"), "details" : [ { "Value1" : 70, "Value2" : 50 }, { "Value1" : 30, "Value2" : 36 ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
60 Views
The command you can use is db.runCommand(). Let us first switch to admin −> use admin switched to db adminNow, run the command −> db.runCommand({listDatabases : 1})This will produce the following output −{ "databases" : [ { "name" : "admin", "sizeOnDisk" : 2375680, "empty" : false }, { "name" : "app", "sizeOnDisk" : 32768, "empty" : false }, { ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
186 Views
For this, use aggregate() in MongoDB. Let us create a collection with documents −> db.demo285.insertOne( ... {... details : [ ... { ... Name : "Chris" ... }, ... { ... Name2: "Bob" ... }, ... { ... Name: "Mike" ... } ... ] ... } ...) { "acknowledged" : true, "insertedId" : ObjectId("5e4abffef49383b52759cbb9") }Display all documents from a collection with the help of find() method −> db.demo285.find();This will produce the ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
369 Views
To export MongoDB has a command mongoexport. Following is the syntax −mongoexport -d yourDatabaseName -c yourCollectionName -f yourFieldName --type=csv -o yourFileLocation/FileName;Let us create a collection with documents −> db.demo284.insertOne({"FirstName":"Chris"}); { "acknowledged" : true, "insertedId" : ObjectId("5e4abc9e9127fafea82a2cfc") } > db.demo284.insertOne({"FirstName":"Robert"}); { "acknowledged" : true, "insertedId" : ObjectId("5e4abca39127fafea82a2cfd") } > db.demo284.insertOne({"FirstName":"Bob"}); { "acknowledged" : true, "insertedId" : ObjectId("5e4abca79127fafea82a2cfe") }Display all documents from a collection with the help of find() method −> db.demo284.find();This will produce the following output −{ "_id" : ObjectId("5e4abc9e9127fafea82a2cfc"), "FirstName" : "Chris" } { "_id" : ObjectId("5e4abca39127fafea82a2cfd"), "FirstName" : "Robert" } { "_id" : ... Read More
![AmitDiwan](https://www.tutorialspoint.com/assets/profiles/123055/profile/60_187394-1565938756.jpg)
275 Views
To update array with another field, use $push. Let us create a collection with documents −> db.demo283.insertOne({"Name":"Chris", "Status":["Active", "Inactive"]}); { "acknowledged" : true, "insertedId" : ObjectId("5e4ab97ddd099650a5401a75") }Display all documents from a collection with the help of find() method −> db.demo283.find();This will produce the following output −{ "_id" : ObjectId("5e4ab97ddd099650a5401a75"), "Name" : "Chris", "Status" : [ "Active", "Inactive" ] }Following is the query to update array with another field −> db.demo283.update({}, {$push: {Status:{$each:['Regular', 'NotRegular'], '$slice': -4}}}); WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })Display all documents from a collection with the help of find() method −> ... Read More