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
Implement MongoDB $push in embedded document array?
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" : 1 })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 },
{ "CountryName" : "AUS", "Marks" : 98 }
]
}
Updated on: 31-Mar-2020
206 Views
Advertisements