MongoDB 11.B, 12.B : insert,find,update, and delete commands ; count, limit, sort

use AIDS_B 

command creates AIDS_B database. In AIDS_B database to create collection names "register" 

db.register.insertOne({Name:'abc',RegdNo:10001,Year:4,Semester:1,branch:'AIDS'})  

it is implicit way


MongoDB Experiments: 11.B, 12.B


test> use AIDS_B

switched to db AIDS_B

AIDS_B> db.register.insertOne({Name:'abc',RegdNo:10001,Year:4,Semester:1,branch:'AIDS'})

{

  acknowledged: true,

  insertedId: ObjectId('690588f3b25c5cb31d63b112')

}

AIDS_B> db.register.insertOne({Name:'def',RegdNo:10002,Year:4,Semester:1,branch:'AIDS'})

{

  acknowledged: true,

  insertedId: ObjectId('6905891eb25c5cb31d63b113')

}

AIDS_B> db.register.insertOne({Name:'ghi',RegdNo:10003,Year:4,Semester:1,branch:'AIDS'})

{

  acknowledged: true,

  insertedId: ObjectId('69058941b25c5cb31d63b114')

}

AIDS_B> db.register.insertOne({Name:'jkl',RegdNo:10004,Year:4,Semester:1,branch:'IT'})

{

  acknowledged: true,

  insertedId: ObjectId('6905895ab25c5cb31d63b115')

}

AIDS_B> db.register.insertOne({Name:'mno',RegdNo:10005,Year:4,Semester:1,branch:'IT'})

{

  acknowledged: true,

  insertedId: ObjectId('69058969b25c5cb31d63b116')

}

AIDS_B> db.register.insertOne({Name:'pqr',RegdNo:10006,Year:4,Semester:1,branch:'IT'})

{

  acknowledged: true,

  insertedId: ObjectId('6905897fb25c5cb31d63b117')

}

AIDS_B> db.register.find()

[

  {

    _id: ObjectId('690588f3b25c5cb31d63b112'),

    Name: 'abc',

    RegdNo: 10001,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  },

  {

    _id: ObjectId('6905891eb25c5cb31d63b113'),

    Name: 'def',

    RegdNo: 10002,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  },

  {

    _id: ObjectId('69058941b25c5cb31d63b114'),

    Name: 'ghi',

    RegdNo: 10003,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  },

  {

    _id: ObjectId('6905895ab25c5cb31d63b115'),

    Name: 'jkl',

    RegdNo: 10004,

    Year: 4,

    Semester: 1,

    branch: 'IT'

  },

  {

    _id: ObjectId('69058969b25c5cb31d63b116'),

    Name: 'mno',

    RegdNo: 10005,

    Year: 4,

    Semester: 1,

    branch: 'IT'

  },

  {

    _id: ObjectId('6905897fb25c5cb31d63b117'),

    Name: 'pqr',

    RegdNo: 10006,

    Year: 4,

    Semester: 1,

    branch: 'IT'

  }

]

AIDS_B> db.register.update({Name:'pqr'},{$set:{Semester:2}})

DeprecationWarning: Collection.update() is deprecated. Use updateOne, updateMany, or bulkWrite.

{

  acknowledged: true,

  insertedId: null,

  matchedCount: 1,

  modifiedCount: 1,

  upsertedCount: 0

}

AIDS_B> db.register.find({Name:'pqr'})

[

  {

    _id: ObjectId('6905897fb25c5cb31d63b117'),

    Name: 'pqr',

    RegdNo: 10006,

    Year: 4,

    Semester: 2,

    branch: 'IT'

  }

]

AIDS_B> db.register.delete({Name:'abc'})

TypeError: db.register.delete is not a function

AIDS_B> db.register.deleteOne({Name:'abc'})

{ acknowledged: true, deletedCount: 1 }

AIDS_B> db.register.find({Name:'abc'})

AIDS_B> db.register.find().count()

5

AIDS_B> db.register.find().limit(3)

[

  {

    _id: ObjectId('6905891eb25c5cb31d63b113'),

    Name: 'def',

    RegdNo: 10002,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  },

  {

    _id: ObjectId('69058941b25c5cb31d63b114'),

    Name: 'ghi',

    RegdNo: 10003,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  },

  {

    _id: ObjectId('6905895ab25c5cb31d63b115'),

    Name: 'jkl',

    RegdNo: 10003,

    Year: 4,

    Semester: 1,

    branch: 'IT'

  }

]

AIDS_B> db.register.find().limit(2)

[

  {

    _id: ObjectId('6905891eb25c5cb31d63b113'),

    Name: 'def',

    RegdNo: 10002,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  },

  {

    _id: ObjectId('69058941b25c5cb31d63b114'),

    Name: 'ghi',

    RegdNo: 10003,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  }

]

AIDS_B> db.register.find().sort()

[

  {

    _id: ObjectId('6905891eb25c5cb31d63b113'),

    Name: 'def',

    RegdNo: 10002,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  },

  {

    _id: ObjectId('69058941b25c5cb31d63b114'),

    Name: 'ghi',

    RegdNo: 10003,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  },

  {

    _id: ObjectId('6905895ab25c5cb31d63b115'),

    Name: 'jkl',

    RegdNo: 10003,

    Year: 4,

    Semester: 1,

    branch: 'IT'

  },

  {

    _id: ObjectId('69058969b25c5cb31d63b116'),

    Name: 'mno',

    RegdNo: 10004,

    Year: 4,

    Semester: 1,

    branch: 'IT'

  },

  {

    _id: ObjectId('6905897fb25c5cb31d63b117'),

    Name: 'pqr',

    RegdNo: 10006,

    Year: 4,

    Semester: 2,

    branch: 'IT'

  }

]

AIDS_B> db.register.find().sort({branch:1})

[

  {

    _id: ObjectId('6905891eb25c5cb31d63b113'),

    Name: 'def',

    RegdNo: 10002,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  },

  {

    _id: ObjectId('69058941b25c5cb31d63b114'),

    Name: 'ghi',

    RegdNo: 10003,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  },

  {

    _id: ObjectId('6905895ab25c5cb31d63b115'),

    Name: 'jkl',

    RegdNo: 10003,

    Year: 4,

    Semester: 1,

    branch: 'IT'

  },

  {

    _id: ObjectId('69058969b25c5cb31d63b116'),

    Name: 'mno',

    RegdNo: 10004,

    Year: 4,

    Semester: 1,

    branch: 'IT'

  },

  {

    _id: ObjectId('6905897fb25c5cb31d63b117'),

    Name: 'pqr',

    RegdNo: 10006,

    Year: 4,

    Semester: 2,

    branch: 'IT'

  }

]

AIDS_B> db.register.find().sort({branch:-1})

[

  {

    _id: ObjectId('6905895ab25c5cb31d63b115'),

    Name: 'jkl',

    RegdNo: 10003,

    Year: 4,

    Semester: 1,

    branch: 'IT'

  },

  {

    _id: ObjectId('69058969b25c5cb31d63b116'),

    Name: 'mno',

    RegdNo: 10004,

    Year: 4,

    Semester: 1,

    branch: 'IT'

  },

  {

    _id: ObjectId('6905897fb25c5cb31d63b117'),

    Name: 'pqr',

    RegdNo: 10006,

    Year: 4,

    Semester: 2,

    branch: 'IT'

  },

  {

    _id: ObjectId('6905891eb25c5cb31d63b113'),

    Name: 'def',

    RegdNo: 10002,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  },

  {

    _id: ObjectId('69058941b25c5cb31d63b114'),

    Name: 'ghi',

    RegdNo: 10003,

    Year: 4,

    Semester: 1,

    branch: 'AIDS'

  }

]

AIDS_B>

AIDS_B>


sort 1 ascending

sort -1 descending


**********************************************************

  ******************************************************

      ***********************************************

Comments

Post a Comment

Popular posts from this blog

1. a. Angular Application Setup

Observe the link http://localhost:4200/welcome on which the mCart application is running. Perform the below activities to understand the features of the application. Angular Application Setup: Install Node.js: Visit the Node.js website ( https://nodejs.org ) and download the latest version of Node.js. Follow the installation instructions specific to your operating system. PRebuilt software (2nd Pane) Install Angular CLI: Open a terminal or command prompt and run the following command to install the Angular CLI globally: npm install -g @angular/cli@13.0 Create a new Angular project: In the terminal or command prompt, navigate to the desired directory where you want to create your Angular project. Run the following command to create a new project named "mCart": ng new mCart Change into the project directory: Move into the newly created project directory by running the following command: cd mCart Serve the application: Start a local development server and s...
Read more

2. Structural Directives - ngIf

 2.a  Structural Directives - ngIf Create a login form with username and password fields. If the user enters the correct credentials, it should render a "Welcome <<username>>" message otherwise it should render "Invalid Login!!! Please try again..." message Step 1: Generate a new component ng generate component login step 2: Update the login component template Open the login.component.html file and replace its content with the following code: <div *ngIf="isLoggedIn; else loginForm"> <h2>Welcome {{ username }}!</h2> </div> <ng-template #loginForm> <form (ngSubmit)="submitForm()"> <div> <label for="username">Username:</label> <input type="text" id="username" name="username" [(ngModel)]="username" required> </div> <div> <label for="password">Password:</label>...
Read more

Assignments - 1

      1) A) Angular Application Setup          Observe   the   link   http://localhost:4200/welcome   on   which   the   mCart             application   is   running.       B)     Elements   of   Template Add   an   event   to   the   hello   component   template   and   when   it   is   clicked,   it   should   change the   courseName. 2)  A)    Components   and   Modules  Create   a   new   component   called   hello   and   render   Hello   Angular   on   the   Page B)     ngFor  Create a courses array and rendering it in the template using ngFor directive in               a list format 3)  ...
Read more