MongoDB Shell command to read, create, delete and update Data
Please read official documentation and installation guide from MongoDB official site
show dbs; use {your_database_name} db; db.createUser({ user: "sumon", pwd: "sumon", roles: ["readWrite"] }); db.createCollection('customers'); // here db reffer the current database show collections; db.customers.insert({first_name: "Shafikul", last_name: "Islam", age: 26}); On relational database we can only add defined field value, But in nosql database we can add extra field {Not defined} & value as our wish
db.customers.insert([ {first_name: "Hridoy", last_name: "Khan", age: 21}, {first_name: "Simla", last_name: "Akter", age: 26, gender: "female"} ]); db.customers.find(); // For more readable db.customers.find().pretty(); db.customers.update({first_name: "shafikul"}, {first_name: "Shafikul", last_name: "Islam", age: 27, gender: "male"}); // First object for search the item and second object is data need to update db.customers.update({first_name: "Hridoy"}, { $set: { gender: "Male" } }); db.customers.update({first_name: "Hridoy"}, { $inc: { age: 2 } }); If we try update an item , but this is not there in collection, we can add if not exsist {Using additional option upsert}
db.customers.update({first_name: "Ethila"}, { first_name: "Ethila", last_name: "Akter", age: 8 }, { upsert: true }); db.customers.update({first_name: "Ethila"}, { $rename: { "first_name": "nick_name" } }); db.customers.remove({first_name: "Shafikul"}); //If collection has multiple entry with name "Shafikul", But we want to delete one item. We can easily handle by add an additional option db.customers.remove({first_name: "Shafikul"}, {justOne: true}); db.customers.remove({}); db.customers.find({$or:[{first_name: "Shafikul"},{first_name: "Hridoy"}]}); Find with greater then & less then & greater then or equal & less then or equal ($gt & $lt & $gte & $lte)
db.customers.find({ age: {$gt: 10} }); db.customers.find({ age: {$lt: 30} }); db.customers.find({ age: {$gte: 10} }); db.customers.find({ age: {$lte: 30} }); db.customers.find({"address.country": "Bangladesh"}); db.customers.find({"friends.name": "Shaun"}); db.customers.find().sort({first_name: 1}); // 1 means ascending order // -1 for decending order db.customers.find().sort({first_name: -1}); db.customers.find().count(); // count all entry // count all entry where gender is male db.customers.find({gender: "male"}).count(); db.customers.find().limit(4); // return first 4 entry