Writing a MongoDB insert statement for multiple insert at a time

For multiple insert, use insert() in MongoDB. Let us create a collection with document −

> db.demo689.insert([
...    {ClientName:"Chris","ClientAge":34,"ClientCountryName":"US"},
...    {ClientName:"David","ClientAge":28,"ClientCountryName":"UK"},
...    {ClientName:"Bob","ClientAge":39,"ClientCountryName":"AUS"},
... ]);
BulkWriteResult({
   "writeErrors" : [ ],
   "writeConcernErrors" : [ ],
   "nInserted" : 3,
   "nUpserted" : 0,
   "nMatched" : 0,
   "nModified" : 0,
   "nRemoved" : 0,
   "upserted" : [ ]
})

Display all documents from a collection with the help of find() method −

> db.demo689.find();

This will produce the following output −

{ "_id" : ObjectId("5ea580dfa7e81adc6a0b3967"), "ClientName" : "Chris", "ClientAge" : 34, "ClientCountryName" : "US" }
{ "_id" : ObjectId("5ea580dfa7e81adc6a0b3968"), "ClientName" : "David", "ClientAge" : 28, "ClientCountryName" : "UK" }
{ "_id" : ObjectId("5ea580dfa7e81adc6a0b3969"), "ClientName" : "Bob", "ClientAge" : 39, "ClientCountryName" : "AUS" }

AmitDiwan

Updated on 14-May-2020 09:10:04

• Related Questions & Answers
• How to multiple insert or batch insert at a time in MySQL query?
• MongoDB bulk insert for documents
• Insert multiple sets of values in a single statement with MySQL?
• How to insert multiple document into a MongoDB collection using Java?
• Debugging a failed Insert statement in SAP ABAP
• Insert to specific index for MongoDB array?
• Conditional upsert (multiple insert) when updating document in MongoDB?
• How to insert multiple rows in a table using a single INSERT command in program?
• Insert multiple rows in a single MySQL query
• Is there a need to insert auto_increment column values in MySQL while using INSERT statement?
• MySQL - Insert current date/time?
• How to insert a Python object in Mongodb?
• How to insert a boolean field in MongoDB?
• How to add a where clause in a MySQL Insert statement?
• How can we use a MySQL subquery with INSERT statement?