MongoDB python | Delete Data and Drop Collection

Prerequisite : MongoDB Basics, Insert and Update

Aim : To delete entries/documents of a collection in a database. Assume name of collection ‘my_collection’.
Method used : delete_one() or delete_many()

• Remove All Documents That Match a Condition : The following operation removes all documents that match the specified condition.

   result = my_collection.delete_many({"name": "Mr.Geek"})

• To see the number of documents deleted :

   print(result.deleted_count)

• Remove All Documents :
  Method 1 : Remove all documents using delete_many()

   result= my_collection.delete_many({})

  Method 2 : Delete all documents using collection.remove()

   result = my_collection.remove() 

  Best method to remove is to drop the collection so that data indexes are also removed and then create a new collection in that insert data.

• To Drop a Collection :

  db.my_collection.drop()

We first insert a document in the collection then deleted the documents as per query.

OUTPUT (comment line denoted by #)

Connected successfully!!!
Data inserted with record ids     
#Data INSERT
{'_id': ObjectId('5a02227c37b8552becf5ed2b'), 'name': 
'Mr.GfG', 'eid': 45, 'location': 'noida'}
{'_id': ObjectId('5a0c734937b8551c1cd03349'), 'name': 
'Mr.Shaurya', 'eid': 14, 'location': 'delhi'}
{'_id': ObjectId('5a0c734937b8551c1cd0334a'), 'name': 
'Mr.Coder', 'eid': 14, 'location': 'gurugram'}
#Mr.Coder is deleted
{'_id': ObjectId('5a02227c37b8552becf5ed2b'), 'name': 
'Mr.GfG', 'eid': 45, 'location': 'noida'}
{'_id': ObjectId('5a0c734937b8551c1cd03349'), 'name': 
'Mr.Shaurya', 'eid': 14, 'location': 'delhi'}