snippetModerate
How to views all documents in a particular collection of database in MongoDB through mongo Shell?
Viewed 0 times
allthroughmongomongodbcollectionshellviewsdatabasehowparticular
Problem
In the MongoDB shell, how to views all documents in a particular collection for the current database that I'm using?
when i am trying through the query
To getting the error as mention below
I am also uploading the screen shot of mongo shell command prompt here
when i am trying through the query
> db.getCollection().find()To getting the error as mention below
2017-10-14T00:57:34.363+0530 E QUERY [thread1] Error: collection constructor called with undefined argument :
DB.prototype.getCollection@src/mongo/shell/db.js:34:16
@(shell):1:1I am also uploading the screen shot of mongo shell command prompt here
Solution
OK, let's start from basics!
After you have connected to mongod with command
So, you need to be connected WANTED database with
How to see to what database I'm connected currently? Just give command
After you have connected to mongod with command
mongo.- List databases with command
show dbs
iot:PRIMARY> show dbs
admin 0.000GB
iot 0.020GB
local 0.042GB
test 0.000GB
testi 0.000GB
- Select one of the DB's with
use iotcommand
iot:PRIMARY> use iotswitched to db iot- List collections on that DB with
show collectionscommand
iot:PRIMARY> show collections
data
header
key
- Make query to one of those collections
iot:PRIMARY> db.header.find()
{ "_id" : "1b5caa", "temp1" : "Temperature", "pressure1" : "Pressure", "humidity1" : "Humidity", "uv1" : "UV", "BusV1" : "Solar Panel (V)", "Current1" : "Solar Panel Current (mA)", "BusV2" : "Battery (V)", "Current2" : "Battery Current (mA)" }
{ "_id" : "30444", "temp1" : "Temperature", "pressure1" : "Pressure", "humidity1" : "Humidity" }
{ "_id" : "239684", "temp1" : "Temperature", "pressure1" : "Pressure", "humidity1" : "Humidity" }
So, you need to be connected WANTED database with
use command and you need to show the one collection what you want to query with db..find()How to see to what database I'm connected currently? Just give command
db and you get the answer what is your current DB.Context
StackExchange Database Administrators Q#188441, answer score: 13
Revisions (0)
No revisions yet.