{"id":1001,"date":"2021-02-02T03:56:31","date_gmt":"2021-02-02T03:56:31","guid":{"rendered":"https:\/\/codeinsightacademy.com\/blog\/?p=1001"},"modified":"2023-12-16T05:56:05","modified_gmt":"2023-12-16T05:56:05","slug":"mongodb-cheat-sheet","status":"publish","type":"post","link":"https:\/\/codeinsightacademy.com\/blog\/database\/mongodb-cheat-sheet\/","title":{"rendered":"MongoDB Cheat Sheet"},"content":{"rendered":"\n

MongoDB is a source-available cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

to start server (mongod<\/strong> is mongo deamon)<\/p>\n\n\n\n

mongod<\/code><\/pre>\n\n\n\n
to start shell<\/p>\n\n\n\n
mongo<\/code><\/pre>\n\n\n\n
show dbs;<\/code><\/pre>\n\n\n\n
create\/use database<\/code><\/pre>\n\n\n\n
Change database<\/p>\n\n\n\n
use db_name;<\/code><\/pre>\n\n\n\n
show current database<\/p>\n\n\n\n
db;<\/code><\/pre>\n\n\n\n
Collections are similar to table<\/p>\n\n\n\n
show collections;<\/code><\/pre>\n\n\n\n
db.createCollection(\"students\");<\/code><\/pre>\n\n\n\n
Drop collection\/table<\/p>\n\n\n\n
db.students.drop();<\/code><\/pre>\n\n\n\n
drop database<\/p>\n\n\n\n
db.dropDatabase();<\/code><\/pre>\n\n\n\n
insertOne<\/p>\n\n\n\n
db.students.insertOne({_id: 1, name: \"shailesh\"});<\/code><\/pre>\n\n\n\n
insertMany<\/p>\n\n\n\n
db.students.insertMany([{_id: 2, name: \"bagde\"}, {_id: 3, name: \"sheldon\"}]);<\/code><\/pre>\n\n\n\n
count document<\/p>\n\n\n\n
db.students.count();<\/code><\/pre>\n\n\n\n
select all documents\/records<\/p>\n\n\n\n
db.students.find();<\/code><\/pre>\n\n\n\n
select with projection<\/p>\n\n\n\n
db.students.find({},{_id: 0});\ndb.students.find({},{name:0});<\/code><\/pre>\n\n\n\n
exists operator<\/p>\n\n\n\n
db.students.find({age: {$exists: false}});<\/code><\/pre>\n\n\n\n
COMPARISON OPERATORS<\/h2>\n\n\n\n
in operator<\/p>\n\n\n\n
db.students.find({_id: {$in: [2,3]}});<\/code><\/pre>\n\n\n\n
not equal operator<\/p>\n\n\n\n
db.students.find({_id: {$ne: 2}});<\/code><\/pre>\n\n\n\n
equal operator<\/p>\n\n\n\n
db.students.find({_id: {$eq: 2}});<\/code><\/pre>\n\n\n\n
less than $lt<\/p>\n\n\n\n
less than equal $lte<\/p>\n\n\n\n
greather than $gt<\/p>\n\n\n\n
greater than equal $gte<\/p>\n\n\n\n
LOGICAL OPERATORS<\/h2>\n\n\n\n
$and operator<\/p>\n\n\n\n
db.students.find({$and : [{_id : {$gt:1}}, {_id: {$lt: 4}}]})<\/code><\/pre>\n\n\n\n
$or operator<\/p>\n\n\n\n
db.students.find({$or : [{name : \"bagde\"}, {name: \"shailesh\"}]})<\/code><\/pre>\n\n\n\n
like case insensitive<\/p>\n\n\n\n
db.students.find({name: \/h\/i})<\/code><\/pre>\n\n\n\n
exact match<\/p>\n\n\n\n
db.students.find({name: \/^BagDe$\/i})<\/code><\/pre>\n\n\n\n
UPDATE<\/h2>\n\n\n\n
db.students.updateOne({_id: 1}, {$set : {age: 23}});\ndb.students.updateMany({age : {$exists: false}}, { $set : {age : 25}})<\/code><\/pre>\n\n\n\n
db.students.updateMany({}, {$set: {address: {city: \"Mumbai\", state: \"MH\"}}})\ndb.students.updateOne({_id: 4}, { $set : {address : {city: \"Nagpur\"}}});<\/code><\/pre>\n\n\n\n
Unset\/Delete Fields<\/p>\n\n\n\n
db.students.updateMany({}, {$unset : {city: \"\"}});<\/code><\/pre>\n\n\n\n
search within sub document<\/p>\n\n\n\n
db.students.find({\"address.city\" : \"Nagpur\"}).pretty();<\/code><\/pre>\n\n\n\n
Delete Records<\/p>\n\n\n\n
db.students.deleteOne({ $or : [{ age : {$lt : 25}}, {name : \"sheldon\"}] })<\/code><\/pre>\n\n\n\n
DISTINCT<\/h2>\n\n\n\n
db.students.distinct(“city”)<\/p>\n\n\n\n
ORDER BY<\/h2>\n\n\n\n
db.students.find().sort({name: -1})<\/code><\/pre>\n\n\n\n
LIMIT<\/h2>\n\n\n\n
db.students.find().limit(10)\ndb.students.find().skip(5).limit(10)<\/code><\/pre>\n\n\n\n
Aggregation<\/h2>\n\n\n\n
Aggregate on all documents\ndb.emps.aggregate([{$group: {\n\t_id : null,\n\ttotal : {$sum : \"$salary\"},\n\taverage : {$avg: \"$salary\"},\n\tmin : {$min: \"$salary\"},\n\tmax : {$max: \"$salary\"},\n\tcount : {$sum: 1}\t\n}}]).pretty()\n\n\nAggregate on group by address\ndb.emps.aggregate([{$group: {\n\t_id : { address: \"$address\" },\n\ttotal : {$sum : \"$salary\"},\n\taverage : {$avg: \"$salary\"},\n\tmin : {$min: \"$salary\"},\n\tmax : {$max: \"$salary\"},\n\tcount : {$sum: 1}\t\n}}]).pretty()\n<\/code><\/pre>\n\n\n\n
ForEach Map<\/h2>\n\n\n\n
db.emps.find().forEach(x => { print(x.name) })\n\ndb.emps.find({salary: { $exists: -1 } }, {\"salary\": 1, _id: 0}).map(x => x.salary * 0.10)<\/code><\/pre>\n\n\n\n\n\n\n\n
MongoDB Assignment for Practice<\/h2>\n\n\n\n
var docs = [\n{\"name\":\"neha\",\"contact_number\":\"9833910534\",\"address\":\"mumbai\",\"salary\":30000,\"employee_id\":98821,\"role\":\"manager\"},\n{\"name\":\"mina\",\"contact_number\":\"9833910535\",\"address\":\"thane\",\"salary\":32000,\"employee_id\":98823,\"role\":\"sales\"},\n{\"name\":\"pankaj\",\"contact_number\":\"9833910536\",\"address\":\"bhopal\",\"salary\":40000,\"employee_id\":98824,\"role\":\"hr\"},\n{\"name\":\"mareena\",\"contact_number\":\"9833910537\",\"address\":\"meerut\",\"salary\":45000,\"employee_id\":98825,\"role\":\"support\"},\n{\"name\":\"pooja\",\"contact_number\":\"9833910538\",\"address\":\"delhi\",\"salary\":50000,\"employee_id\":98826,\"role\":\"developer\"},\n{\"name\":\"namita\",\"contact_number\":\"9833910539\",\"address\":\"surat\",\"salary\":52000,\"employee_id\":98820,\"role\":\"sales\"},\n{\"name\":\"sneha\",\"contact_number\":\"9833910510\",\"address\":\"baroda\",\"salary\":55000,\"employee_id\":98827,\"role\":\"support\"},\n{\"name\":\"anjali\",\"contact_number\":\"9833910511\",\"address\":\"ahmedabad\",\"salary\":60000,\"employee_id\":98828,\"role\":\"tester\"},\n{\"name\":\"harsha\",\"contact_number\":\"9833910512\",\"address\":\"mumbai\",\"salary\":20000,\"employee_id\":98829,\"role\":\"operations\"},\n{\"name\":\"varun\",\"contact_number\":\"9833910512\",\"address\":\"mehsana\",\"salary\":56000,\"employee_id\":98831,\"role\":\"tester\"},\n{\"name\":\"preeti\",\"contact_number\":\"9833910513\",\"address\":\"noida\",\"salary\":87000,\"employee_id\":98832,\"role\":\"developer\"},\n{\"name\":\"madhu\",\"contact_number\":\"9833910525\",\"address\":\"bangalore\",\"salary\":22000,\"employee_id\":98833,\"role\":\"sales\"}\n];\n\ndb.createCollection(\"emps\");\ndb.emps.insertMany(docs);\ndb.emps.find();\n\n<\/pre>\n\n\n\n
var docs = [{“name”:”neha”,”contact_number”:”9833910534″,”address”:”mumbai”,”salary”:30000,”employee_id”:98821,”role”:”manager”},{“name”:”mina”,”contact_number”:”9833910535″,”address”:”thane”,”salary”:32000,”employee_id”:98823,”role”:”sales”},{“name”:”pankaj”,”contact_number”:”9833910536″,”address”:”bhopal”,”salary”:40000,”employee_id”:98824,”role”:”hr”},{“name”:”mareena”,”contact_number”:”9833910537″,”address”:”meerut”,”salary”:45000,”employee_id”:98825,”role”:”support”},{“name”:”pooja”,”contact_number”:”9833910538″,”address”:”delhi”,”salary”:50000,”employee_id”:98826,”role”:”developer”},{“name”:”namita”,”contact_number”:”9833910539″,”address”:”surat”,”salary”:52000,”employee_id”:98820,”role”:”sales”},{“name”:”sneha”,”contact_number”:”9833910510″,”address”:”baroda”,”salary”:55000,”employee_id”:98827,”role”:”support”},{“name”:”anjali”,”contact_number”:”9833910511″,”address”:”ahmedabad”,”salary”:60000,”employee_id”:98828,”role”:”tester”},{“name”:”harsha”,”contact_number”:”9833910512″,”address”:”mumbai”,”salary”:20000,”employee_id”:98829,”role”:”operations”},{“name”:”varun”,”contact_number”:”9833910512″,”address”:”mehsana”,”salary”:56000,”employee_id”:98831,”role”:”tester”},{“name”:”preeti”,”contact_number”:”9833910513″,”address”:”noida”,”salary”:87000,”employee_id”:98832,”role”:”developer”},{“name”:”madhu”,”contact_number”:”9833910525″,”address”:”bangalore”,”salary”:22000,”employee_id”:98833,”role”:”sales”}];<\/p>\n\n\n\n
  1. show employees in descending order – salary<\/li>
  2. show all employees from Mumbai<\/li>
  3. show all employees having salary more 50000<\/li>
  4. show sum of salary from emps collection<\/li>
  5. show all distinct address<\/li>
  6. show names of employees having max salary<\/li>
  7. show employees having 2nd highest salary<\/li>
  8. count employees from mumbai only<\/li>
  9. show all female employees <\/li>
  10. show all male employees <\/li><\/ol>\n\n\n\n\n","protected":false},"excerpt":{"rendered":"
    MongoDB is a source-available cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas. to start server (mongod is mongo deamon) to start shell Change database show current database Collections are similar to table Drop collection\/table drop database insertOne insertMany count document select all documents\/records select with projection […]<\/p>\n","protected":false},"author":1,"featured_media":1910,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[21],"tags":[],"_links":{"self":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/posts\/1001"}],"collection":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/comments?post=1001"}],"version-history":[{"count":33,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/posts\/1001\/revisions"}],"predecessor-version":[{"id":2668,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/posts\/1001\/revisions\/2668"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/media\/1910"}],"wp:attachment":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/media?parent=1001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/categories?post=1001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/tags?post=1001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}