Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
AmitDiwan has Published 10740 Articles
AmitDiwan
186 Views
Simply loop with forEach() and set column value from another column. Let us create a collection with documents −> db.demo51.insert({"Name1":"Chris", "Name":"David", "Age":24}); WriteResult({ "nInserted" : 1 }) > db.demo51.insert({"Name1":"Carol", "Name":"Mike", "Age":22}); WriteResult({ "nInserted" : 1 }) > db.demo51.insert({"Name1":"Sam", "Name":"Bob", "Age":26}); WriteResult({ "nInserted" : 1 })Display all documents from a collection ... Read More
AmitDiwan
143 Views
To avoid getting json array and get a value array, use $in. For greater than, use MongoDB $gt. Let us create a collection with documents −> db.demo50.save({"Value":40}); WriteResult({ "nInserted" : 1 }) > db.demo50.save({"Value":100}); WriteResult({ "nInserted" : 1 }) > db.demo50.save({"Value":20}); WriteResult({ "nInserted" : 1 }) > db.demo50.save({"Value":510}); WriteResult({ "nInserted" ... Read More
AmitDiwan
127 Views
To search for an array via id, use positional $ operator. For update, use the UPDATE in MongoDB. Let us create a collection with documents −> db.demo49.insertOne( ... { ... ... "Name": "David", ... "Details": [ ... { ... "_id": "D1234", ... Read More
AmitDiwan
296 Views
To get a specific number of items, use $slice operator in MongoDB. Let us create a collection with documents −> db.demo48.insertOne({"Name":["David", "Chris", "Sam", "Mike", "Carol"]}); { "acknowledged" : true, "insertedId" : ObjectId("5e270491cfb11e5c34d89901") }Display all documents from a collection with the help of find() method −> db.demo48.find();This will produce ... Read More
AmitDiwan
594 Views
To return the position of a document relative to the collection, use sort() along with count(). Let us create a collection with documents −> db.demo47.insertOne({"ClientName":"Adam"}); { "acknowledged" : true, "insertedId" : ObjectId("5e267240cfb11e5c34d898f0") } > db.demo47.insertOne({"ClientName":"John"}); { "acknowledged" : true, "insertedId" : ObjectId("5e267243cfb11e5c34d898f1") } > db.demo47.insertOne({"ClientName":"Chris"}); { ... Read More
AmitDiwan
232 Views
To index large text field, use ensureIndex() along with $regex for text search. Let us create a collection with documents −> db.demo46.ensureIndex({"Name":1}); { "createdCollectionAutomatically" : true, "numIndexesBefore" : 1, "numIndexesAfter" : 2, "ok" : 1 } > db.demo46.insertOne({"Name":"John Smith"}); { "acknowledged" : true, "insertedId" ... Read More
AmitDiwan
280 Views
Let us first create a variable. Following is the query −> var studentDetails={"StudentFirstName":"Chris", "StudentLastName":"Brown", "StudentAge":24};Following is the query to save records using save() −> db.demo45.save(studentDetails); WriteResult({ "nInserted" : 1 })Display all documents from a collection with the help of find() method −> studentDetails;This will produce the following output −{ ... Read More
AmitDiwan
775 Views
For this, in a single query, simply work with forEach() and store output in a temp db. Let us first create a collection with documents −> db.demo43.insertOne({"StudentName":"Chris"}); { "acknowledged" : true, "insertedId" : ObjectId("5e25d4b3cfb11e5c34d898e5") } > db.demo43.insertOne({"StudentName":"Bob"}); { "acknowledged" : true, "insertedId" : ObjectId("5e25d4b8cfb11e5c34d898e6") } > ... Read More
AmitDiwan
667 Views
To rebuild indexes, use reIndex(). Let us first create an index. Following is the query −> db.demo42.createIndex({"StudentFirstName":1});This will produce the following output −{ "createdCollectionAutomatically" : true, "numIndexesBefore" : 1, "numIndexesAfter" : 2, "ok" : 1 }Following is the query to rebuild index in MongoDB −> db.demo42.reIndex({"StudentFirstName":1});This ... Read More
AmitDiwan
1K+ Views
Following is the code to create a navigation bar with equal-width navigation links.−Example Live Demo Document body{ margin:0px; margin-top:60px; padding: 0px; } *, *::before, *::after{ box-sizing: border-box; } nav{ position: fixed; top: 0; width: 100%; background-color: rgb(39, 39, ... Read More