Mongo DB Tutorial

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

'switched to db phixmandb'

db.customer.insertOne({"custid":1001,"custname":"cust1","email":"cust1@gmail.com"})

{
  acknowledged: true,
  insertedId: ObjectId("64b7ff77de75217206508a24")
}

db.customer.insertOne({"custid":1002,"custname":"cust2","email":"cust2@gmail.com"})

{
  acknowledged: true,
  insertedId: ObjectId("64b7ff8ade75217206508a25")
}

db.student.find()

db.student.find({});

db.customer.find();

{
  _id: ObjectId("64b7ff77de75217206508a24"),
  custid: 1001,
  custname: 'cust1',
  email: 'cust1@gmail.com'
}

{
  _id: ObjectId("64b7ff8ade75217206508a25"),
  custid: 1002,
  custname: 'cust2',
  email: 'cust2@gmail.com'
}

db.customer.updateOne({"custname":"Ravi kumar","email":"ravikumar@gmail.com"},{$set:{"custid":1001}})

{
  acknowledged: true,
  insertedId: null,
  matchedCount: 0,
  modifiedCount: 0,
  upsertedCount: 0
}

db.customer.find();

{
  _id: ObjectId("64b7ff77de75217206508a24"),
  custid: 1001,
  custname: 'cust1',
  email: 'cust1@gmail.com'
}

{
  _id: ObjectId("64b7ff8ade75217206508a25"),
  custid: 1002,
  custname: 'cust2',
  email: 'cust2@gmail.com'
}

db.customer.updateOne({"custname":"Ravi kumar","email":"ravikumar@gmail.com"},{$set:{_id: ObjectId("64b7ff77de75217206508a24")}})

{
  acknowledged: true,
  insertedId: null,
  matchedCount: 0,
  modifiedCount: 0,
  upsertedCount: 0
}

db.customer.find();

{
  _id: ObjectId("64b7ff77de75217206508a24"),
  custid: 1001,
  custname: 'cust1',
  email: 'cust1@gmail.com'
}

{
  _id: ObjectId("64b7ff8ade75217206508a25"),
  custid: 1002,
  custname: 'cust2',
  email: 'cust2@gmail.com'
}

db.customer.updateOne({"custid":1001},{$set:{"custname":"Ravi kumar","email":"ravikumar@gmail.com"}})

{
  acknowledged: true,
  insertedId: null,
  matchedCount: 1,
  modifiedCount: 1,
  upsertedCount: 0
}

db.customer.find();

{
  _id: ObjectId("64b7ff77de75217206508a24"),
  custid: 1001,
  custname: 'Ravi kumar',
  email: 'ravikumar@gmail.com'
}

{
  _id: ObjectId("64b7ff8ade75217206508a25"),
  custid: 1002,
  custname: 'cust2',
  email: 'cust2@gmail.com'
}

db.customer.remove({"custid":1002});

'DeprecationWarning: Collection.remove() is deprecated. Use deleteOne, deleteMany, findOneAndDelete, or bulkWrite.'

{
  acknowledged: true,
  deletedCount: 1
}

db.customer.find();

{
  _id: ObjectId("64b7ff77de75217206508a24"),
  custid: 1001,
  custname: 'Ravi kumar',
  email: 'ravikumar@gmail.com'
}

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