What is Mongodb?
.........................................
It is NOSQL based database package that provide easy database based system. without using SQL language we can create database and tables.
Documents means record
Collection means table
if we insert document then collection automatically created.
Syntax to create database
use Databasename;
Syntax to insert record
db.collectionname.insertOne({"columnname":"value",...})
Syntax to view all record
db.collectionname.find()
Syntax to update record
db.collectionname.updateOne({"colname":"value"},{$set:{"colname":"value1",...});
Syntax to delete record
db.collectionname.remove({"colname":"value"});
What is Mongodb?
.........................................
It is NOSQL based database package that provide easy database based system. without using SQL language we can create database and tables.
Documents means record
Collection means table
if we insert document then collection automatically created.
Syntax to create database
use Databasename;
Syntax to insert record
db.collectionname.insertOne({"columnname":"value",...})
Syntax to view all record
db.collectionname.find()
Syntax to update record
db.collectionname.updateOne({"colname":"value"},{$set:{"colname":"value1",...});
Syntax to delete record
db.collectionname.remove({"colname":"value"});
use phixmandb
db.customer.insertOne({"custid":1001,"custname":"cust1","email":"cust1@gmail.com"})
db.customer.insertOne({"custid":1002,"custname":"cust2","email":"cust2@gmail.com"})
db.student.find()
db.student.find({});
db.customer.find();
db.customer.updateOne({"custname":"Ravi kumar","email":"ravikumar@gmail.com"},{$set:{"custid":1001}})
db.customer.find();
db.customer.updateOne({"custname":"Ravi kumar","email":"ravikumar@gmail.com"},{$set:{_id: ObjectId("64b7ff77de75217206508a24")}})
db.customer.find();
db.customer.updateOne({"custid":1001},{$set:{"custname":"Ravi kumar","email":"ravikumar@gmail.com"}})
db.customer.find();
db.customer.remove({"custid":1002});
db.customer.find();
phixmandb
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()
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 Answer of Questions and ASK to Doubt