Menu
I was wondering how you would find all of the column names in a table in MongoDB, like how you use SHOW COLUMNS FROM foo; in mysql.
978
You can use $getField to retrieve the value of fields with names that contain periods ( . ) or start with dollar signs ( $ ).
Use $all with $elemMatch If the field contains an array of documents, you can use the $all with the $elemMatch operator. Both queries will select all documents in the inventory collection where the value of the num field equals 50 .
Fetch all data from the collection If we want to fetch all documents from the collection the following mongodb command can be used : >db. userdetails. find(); or >db.
MongoDB is schemaless and does not have tables. In MongoDB, each collection can have different types of items. You could store two very different items in the same collection:
db.test.insert( { "SomeString" : "How much wood would the woodchop chop ..." } );
db.test.insert( { "Amount": 2040.20, "Due": new ISODate("2012-11-10"), "UserId" : new ObjectId("...")} );
usually the objects are somehow related or have a common base type, but it's not required.
You can, however, take a look at invidual records using
db.collectionName.findOne()
or
db.collectionName.find().pretty()
However, there's no guarantee from MongoDB that any two records look alike or have the same fields: there's no schema.
110
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
