Question

In MongoDB there is the collection

db.CustomerInfo.insert( [{ "name": "Tim",Age:24,Reviews:100},{"name": "jill", Age:25, Reviews:20},{"name":"tom", Age:28, Reviews:5},{"name":"Bill", Age:20, Reviews:120}])

1. What is the script to remove the customer with name jill

2. What is the script to remove customers with more than 90 reviews

Answer 1

1. Remove Record with the name of jill

db.CustomerInfo.remove({name: "jill"}, true);

it will remove the first document/record from the collection. if we want to delete everything which has name jill then we can remove the true from the query.

2. Remove Record with Reviews greater than 90. Here $gt is greater than and we can use $lt for less than function.

db.CustomerInfo.remove({Reviews:{$gt:90}});

If you have any query regarding this please comment below.

Thank you!!!