Create,Read,Drop,Insert One and many, Ordered,Unordered insert in mongoDB

(c) Microsoft Corporation. All rights reserved.

C:\Users\ACER>mongosh

Current Mongosh Log ID: 66611d66e3c4dda298cdcdf5

Connecting to:          mongodb://127.0.0.1:27017/?directConnection=true&serverSelectionTimeoutMS=2000&appName=mongosh+2.2.6

Using MongoDB:          7.0.11

Using Mongosh:          2.2.6

For mongosh info see: https://docs.mongodb.com/mongodb-shell/

------

   The server generated these startup warnings when booting

   2024-06-04T11:56:28.597+05:30: Access control is not enabled for the database. Read and write access to data and configuration is unrestricted

------

test> use students

switched to db students

students> db.data.insertOne({'Name':'Debadatta', age:19})

{

  acknowledged: true,

  insertedId: ObjectId('66611e1ae3c4dda298cdcdf6')

}

students> db.data.insertMany([ {'Name':'Debadatta', age:19}, {'Name':'Jyotiranjan', age:20}, {'Name':'Aditya', age:20})

Uncaught:

SyntaxError: Unexpected token, expected "," (1:108)

> 1 | db.data.insertMany([ {'Name':'Debadatta', age:19}, {'Name':'Jyotiranjan', age:20}, {'Name':'Aditya', age:20})

    |                                                                                                             ^

  2 |

students> db.data.insertMany([ {'Name':'Debadatta', age:19}, {'Name':'Jyotiranjan', age:20}, {'Name':'Aditya', age:20}])

{

  acknowledged: true,

  insertedIds: {

    '0': ObjectId('66611f21e3c4dda298cdcdf7'),

    '1': ObjectId('66611f21e3c4dda298cdcdf8'),

    '2': ObjectId('66611f21e3c4dda298cdcdf9')

  }

}

students> db.data.find()

[

  {

    _id: ObjectId('66611e1ae3c4dda298cdcdf6'),

    Name: 'Debadatta',

    age: 19

  },

  {

    _id: ObjectId('66611f21e3c4dda298cdcdf7'),

    Name: 'Debadatta',

    age: 19

  },

  {

    _id: ObjectId('66611f21e3c4dda298cdcdf8'),

    Name: 'Jyotiranjan',

    age: 20

  },

  {

    _id: ObjectId('66611f21e3c4dda298cdcdf9'),

    Name: 'Aditya',

    age: 20

  }

]

students> db.data.insertMany([ {'Name':'Debadatta', age:19}, {'Name':'Jyotiranjan', age:20}, {'Name':'Aditya', age:20 , 'Course':'CS'}])

{

  acknowledged: true,

  insertedIds: {

    '0': ObjectId('66612163e3c4dda298cdcdfa'),

    '1': ObjectId('66612163e3c4dda298cdcdfb'),

    '2': ObjectId('66612163e3c4dda298cdcdfc')

  }

}

students> db.data.find()

[

  {

    _id: ObjectId('66611e1ae3c4dda298cdcdf6'),

    Name: 'Debadatta',

    age: 19

  },

  {

    _id: ObjectId('66611f21e3c4dda298cdcdf7'),

    Name: 'Debadatta',

    age: 19

  },

  {

    _id: ObjectId('66611f21e3c4dda298cdcdf8'),

    Name: 'Jyotiranjan',

    age: 20

  },

  {

    _id: ObjectId('66611f21e3c4dda298cdcdf9'),

    Name: 'Aditya',

    age: 20

  },

  {

    _id: ObjectId('66612163e3c4dda298cdcdfa'),

    Name: 'Debadatta',

    age: 19

  },

  {

    _id: ObjectId('66612163e3c4dda298cdcdfb'),

    Name: 'Jyotiranjan',

    age: 20

  },

  {

    _id: ObjectId('66612163e3c4dda298cdcdfc'),

    Name: 'Aditya',

    age: 20,

    Course: 'CS'

  }

]

students> db.data.insertMany([ {'Name':'Debadatta', age:19}, {'Name':'Jyotiranjan', age:20}, {'Name':'Aditya', age:20 , 'Course':'CS'}]) cls

Uncaught:

SyntaxError: Missing semicolon. (1:126)

> 1 | db.data.insertMany([ {'Name':'Debadatta', age:19}, {'Name':'Jyotiranjan', age:20}, {'Name':'Aditya', age:20 , 'Course':'CS'}]) cls

    |                                                                                                                               ^

  2 |

students> db.data.find()

[

  {

    _id: ObjectId('66611e1ae3c4dda298cdcdf6'),

    Name: 'Debadatta',

    age: 19

  },

  {

    _id: ObjectId('66611f21e3c4dda298cdcdf7'),

    Name: 'Debadatta',

    age: 19

  },

  {

    _id: ObjectId('66611f21e3c4dda298cdcdf8'),

    Name: 'Jyotiranjan',

    age: 20

  },

  {

    _id: ObjectId('66611f21e3c4dda298cdcdf9'),

    Name: 'Aditya',

    age: 20

  },

  {

    _id: ObjectId('66612163e3c4dda298cdcdfa'),

    Name: 'Debadatta',

    age: 19

  },

  {

    _id: ObjectId('66612163e3c4dda298cdcdfb'),

    Name: 'Jyotiranjan',

    age: 20

  },

  {

    _id: ObjectId('66612163e3c4dda298cdcdfc'),

    Name: 'Aditya',

    age: 20,

    Course: 'CS'

  }

]

students> db.data.insertMany([ {'Name':'Debadatta', age:19}, {    _id: ObjectId('66612163e3c4dda298cdcdfb'),'Name':'Jyotiranjan', age:20}, {'Name':'Aditya', age:20 , 'Course':'CS'}])

Uncaught:

MongoBulkWriteError: E11000 duplicate key error collection: students.data index: _id_ dup key: { _id: ObjectId('66612163e3c4dda298cdcdfb') }

Result: BulkWriteResult {

  insertedCount: 1,

  matchedCount: 0,

  modifiedCount: 0,

  deletedCount: 0,

  upsertedCount: 0,

  upsertedIds: {},

  insertedIds: { '0': ObjectId('66612353e3c4dda298cdcdfd') }

}

Write Errors: [

  WriteError {

    err: {

      index: 1,

      code: 11000,

      errmsg: "E11000 duplicate key error collection: students.data index: _id_ dup key: { _id: ObjectId('66612163e3c4dda298cdcdfb') }",

      errInfo: undefined,

      op: {

        _id: ObjectId('66612163e3c4dda298cdcdfb'),

        Name: 'Jyotiranjan',

        age: 20

      }

    }

  }

]

students> db.data.insertMany([ {'Name':'Debadatta', age:19}, {    _id: ObjectId('66612163e3c4dda298cdcdfb'),'Name':'Jyotiranjan', age:20}, {'Name':'Aditya', age:20 , 'Course':'CS'}], {ordered:false)

Uncaught:

SyntaxError: Unexpected token, expected "," (1:187)

> 1 | db.data.insertMany([ {'Name':'Debadatta', age:19}, {    _id: ObjectId('66612163e3c4dda298cdcdfb'),'Name':'Jyotiranjan', age:20}, {'Name':'Aditya', age:20 , 'Course':'CS'}], {ordered:false)

    |

                                     ^

  2 |

students> db.data.insertMany([ {'Name':'Debadatta', age:19}, {    _id: ObjectId('66612163e3c4dda298cdcdfb'),'Name':'Jyotiranjan', age:20}, {'Name':'Aditya', age:20 , 'Course':'CS'}], {ordered:false})

Uncaught:

MongoBulkWriteError: E11000 duplicate key error collection: students.data index: _id_ dup key: { _id: ObjectId('66612163e3c4dda298cdcdfb') }

Result: BulkWriteResult {

  insertedCount: 2,

  matchedCount: 0,

  modifiedCount: 0,

  deletedCount: 0,

  upsertedCount: 0,

  upsertedIds: {},

  insertedIds: {

    '0': ObjectId('6661240ae3c4dda298cdcdff'),

    '2': ObjectId('6661240ae3c4dda298cdce00')

  }

}

Write Errors: [

  WriteError {

    err: {

      index: 1,

      code: 11000,

      errmsg: "E11000 duplicate key error collection: students.data index: _id_ dup key: { _id: ObjectId('66612163e3c4dda298cdcdfb') }",

      errInfo: undefined,

      op: {

        _id: ObjectId('66612163e3c4dda298cdcdfb'),

        Name: 'Jyotiranjan',

        age: 20

      }

    }

  }

students>