1)Command to create database
use databasename
use stuinfo (stuinfo is the database)
2) Show database name
db (show only current database)
show dbs (show all databases)
3) Create table in mongo db
db.tablename.insert({"key":"value"})
4) db.dropDatabase()
Collection:- using this we can store different type of data similar to JSON pattern ,if we want to store multiple records into mongodb database then we use collection().
db.createCollection()
how we show collection()
show collections
find record
db.collectionname.find().pretty()
use databasename
use stuinfo (stuinfo is the database)
2) Show database name
db (show only current database)
show dbs (show all databases)
3) Create table in mongo db
db.tablename.insert({"key":"value"})
4) db.dropDatabase()
Collection:- using this we can store different type of data similar to JSON pattern ,if we want to store multiple records into mongodb database then we use collection().
db.createCollection()
how we show collection()
show collections
find record
db.collectionname.find().pretty()
Operation | Syntax | Example | RDBMS Equivalent |
---|---|---|---|
Equality | {<key>:<value>} | db.mycol.find({"by":"tutorials point"}).pretty() | where by = 'tutorials point' |
Less Than | {<key>:{$lt:<value>}} | db.mycol.find({"likes":{$lt:50}}).pretty() | where likes < 50 |
Less Than Equals | {<key>:{$lte:<value>}} | db.mycol.find({"likes":{$lte:50}}).pretty() | where likes <= 50 |
Greater Than | {<key>:{$gt:<value>}} | db.mycol.find({"likes":{$gt:50}}).pretty() | where likes > 50 |
Greater Than Equals | {<key>:{$gte:<value>}} | db.mycol.find({"likes":{$gte:50}}).pretty() | where likes >= 50 |
Not Equals | {<key>:{$ne:<value>}} | db.mycol.find({"likes":{$ne:50}}).pretty() | where likes != 50 |
Post a Comment
POST Answer of Questions and ASK to Doubt