Today Mongo DB revision session

Databases - MySQL & Mongo-Node
#1

1- write some basic mongo db commands !!

#2
#3

db.createCollection(‘students’);

1 Like
#4

db.info.deleteOne({ “name”: “Anand”, “age”:99 })

1 Like
#5

show collections
use db
db.info.find()

1 Like
#6

db.users.find({},{first_name:1})

1 Like
#7

db.info.updateOne({“name”:“Lavanya”,“age”:30})

1 Like
#8

2-create a databse “Hospital”
- create patients collections
- single patient document looks like
{
name : “xyz”,
age :58,
illness :“fever”,
gender : “male”,
address :“delhi”
}
- insert 10 patients documents in collection
- perform all find commands

#9

use hospital
db.patients.insertMany([
{
name:“Ramajyothi” ,age:21,illness:“fever”,gender:“female”,adress:“Andhra”} ,
name:“jyothi” ,age:24,illness:“headache”,gender:“female”,adress:“telangana”} ,
name:“Rama” ,age:22,illness:“allergy”,gender:“male”,adress:“UP”} ,
name:“Rami” ,age:23,illness:“cough”,gender:“female”,adress:“Haryana”} ,
name:“jyo” ,age:26,illness:“cold”,gender:“female”,adress:“Kashmir”} ,
name:“maj” ,age:24,illness:“COVID”,gender:“male”,adress:“Andhra”} ,
name:“thilak” ,age:56,illness:“viral fever”,gender:“male”,adress:“Andhra”} ,
name:“Ramya” ,age:21,illness:“fever”,gender:“female”,adress:“Andhra”} ,
]);

db.patients.find({})
db.patients.find({illness:“fever”})
db.patients.find({age:24})

1 Like
#10

use hospital

switched to db hospital
hospital> db.patients.insertOne({ “name”: “anand”, “age”: 53, “gender”: “Male”, “address”:“delhi”,“ilness”:“fever” })

hospital> db.patients.find()
[
{
_id: ObjectId(‘65b7c252bc8ad3f992b7059c’),
name: ‘anand’,
age: 53,
gender: ‘Male’,
address: ‘delhi’,
ilness: ‘fever’
},
{
_id: ObjectId(‘65b7c2d9bc8ad3f992b7059d’),
name: ‘anand’,
age: 53,
gender: ‘Male’,
address: ‘delhi’,
ilness: ‘fever’
}
]

1 Like
#11

use Hospital
db.patients.insertMany([
{name : “patients1”,age :58,illness :“fever”,gender : “male”,address :“delhi”},
{name : “patients2”,age :50,illness :“fever”,gender : “female”,address :“delhi”},
{name : “patients3”,age :45,illness :“fever”,gender : “male”,address :“delhi”},
{name : “patients4”,age :38,illness :“fever”,gender : “male”,address :“delhi”},
{name : “patients5”,age :29,illness :“fever”,gender : “female”,address :“delhi”},
{name : “patients6”,age :32,illness :“fever”,gender : “male”,address :“delhi”},
{name : “patients7”,age :58,illness :“fever”,gender : “female”,address :“delhi”},
{name : “patients8”,age :26,illness :“fever”,gender : “female”,address :“delhi”},
{name : “patients9”,age :56,illness :“fever”,gender : “male”,address :“delhi”},
{name : “patients10”,age :64,illness :“fever”,gender : “female”,address :“delhi”}
])

db.patients.find();
db.patients.find({gender:“male”});
db.patients.find({gender:“female”,age:58});
db.patients.findOne({gender:“male”});
db.patients.findOne({gender:“female”,age:58});
db.patients.find({},{_id:0,name:1,illness:1});
db.patients.find({},{name:1})

1 Like