$unset operator for removing fields in MongoDB - Mini Project: Build & Apply

$unset Operator for Removing Fields in MongoDB

📖 Scenario: You are managing a MongoDB collection that stores information about books in a library. Some books have an extra field called temporaryNote that is no longer needed. You want to clean up the database by removing this field from all book documents.

🎯 Goal: Learn how to use the MongoDB $unset operator to remove the temporaryNote field from all documents in the books collection.

📋 What You'll Learn

Create a books collection with three documents containing the fields title, author, and temporaryNote.

Create a filter variable called filter that matches all documents in the collection.

Write an update command using the $unset operator to remove the temporaryNote field from all matched documents.

Execute the update command on the books collection.

💡 Why This Matters

🌍 Real World

Cleaning up unnecessary or temporary fields in a MongoDB collection helps keep the database organized and efficient.

💼 Career

Database administrators and backend developers often need to update and maintain collections by removing obsolete fields using operators like $unset.

1

Create the books collection with sample documents

Create a variable called books that contains three documents exactly as follows: { title: "The Hobbit", author: "J.R.R. Tolkien", temporaryNote: "First edition" }, { title: "1984", author: "George Orwell", temporaryNote: "Signed copy" }, and { title: "To Kill a Mockingbird", author: "Harper Lee", temporaryNote: "Library copy" }.

MongoDB

# Create the books collection with three documents
# Your code here

Hint

Use a list of dictionaries to represent the documents in the books collection.

2

Create a filter to select all documents

Create a variable called filter and set it to an empty dictionary {} to match all documents in the collection.

MongoDB

books = [
  { "title": "The Hobbit", "author": "J.R.R. Tolkien", "temporaryNote": "First edition" },
  { "title": "1984", "author": "George Orwell", "temporaryNote": "Signed copy" },
  { "title": "To Kill a Mockingbird", "author": "Harper Lee", "temporaryNote": "Library copy" }
]

# Create a filter variable called filter to match all documents
# Your code here

Hint

An empty dictionary {} matches all documents in MongoDB queries.

3

Write the update command using $unset

Create a variable called update_command and set it to a dictionary that uses the $unset operator to remove the temporaryNote field. The dictionary should be exactly: { "$unset": { "temporaryNote": "" } }.

MongoDB

books = [
  { "title": "The Hobbit", "author": "J.R.R. Tolkien", "temporaryNote": "First edition" },
  { "title": "1984", "author": "George Orwell", "temporaryNote": "Signed copy" },
  { "title": "To Kill a Mockingbird", "author": "Harper Lee", "temporaryNote": "Library copy" }
]

filter = {}

# Create an update_command variable using $unset to remove temporaryNote
# Your code here

Hint

The $unset operator removes fields by setting them to an empty string in the update document.

4

Execute the update command on the books collection

Write a line of code that calls db.books.update_many(filter, update_command) to remove the temporaryNote field from all documents in the books collection.

MongoDB

books = [
  { "title": "The Hobbit", "author": "J.R.R. Tolkien", "temporaryNote": "First edition" },
  { "title": "1984", "author": "George Orwell", "temporaryNote": "Signed copy" },
  { "title": "To Kill a Mockingbird", "author": "Harper Lee", "temporaryNote": "Library copy" }
]

filter = {}

update_command = { "$unset": { "temporaryNote": "" } }

# Execute the update command on the books collection
# Your code here

Hint

Use the update_many method on the books collection with the filter and update_command variables.

Practice

1. What does the $unset operator do in MongoDB?

easy

A. Updates the value of existing fields

B. Adds new fields to documents

C. Removes specified fields from documents

D. Duplicates documents in a collection

Solution

1. Step 1: Understand the purpose of $unset

   The $unset operator is used to remove fields from documents in MongoDB.

2. Step 2: Compare with other operators

   Unlike $set which adds or updates fields, $unset deletes them.

3. Final Answer:

   Removes specified fields from documents -> Option C

4. Quick Check:

   $unset removes fields [OK]

Hint: Remember: $unset deletes fields, $set adds or updates [OK]

Common Mistakes:

• Confusing $unset with $set
• Thinking $unset adds fields
• Assuming $unset duplicates documents

2. Which of the following is the correct syntax to remove the field age from all documents in a collection named users?

easy

A. db.users.updateMany({}, {$unset: {age: null}})

B. db.users.updateMany({}, {$unset: {age: true}})

C. db.users.updateMany({}, {$unset: {age: ""}})

D. db.users.updateMany({}, {$unset: {age: 1}})

Solution

1. Step 1: Recall correct $unset syntax

   The $unset operator requires the field name with a value of 1 to remove it.

2. Step 2: Check each option

   Only db.users.updateMany({}, {$unset: {age: 1}}) uses age: 1, which is the correct way to remove the field.

3. Final Answer:

   db.users.updateMany({}, {$unset: {age: 1}}) -> Option D

4. Quick Check:

   Use 1 as value with $unset [OK]

Hint: Use 1 as value to remove fields with $unset [OK]

Common Mistakes:

• Using true, null, or empty string instead of 1
• Forgetting curly braces around field
• Using $set instead of $unset

3. Given the collection products with documents:

{ "name": "Pen", "price": 5, "color": "blue" }

{ "name": "Notebook", "price": 10, "color": "red" }

What will be the result of this update?

db.products.updateMany({}, { $unset: { color: 1 } })

What will the documents look like after the update?

medium

A. [{ "name": "Pen", "price": 5, "color": "blue" }, { "name": "Notebook", "price": 10, "color": "red" }]

B. [{ "name": "Pen", "price": 5 }, { "name": "Notebook", "price": 10 }]

C. [{ "name": "Pen", "color": "blue" }, { "name": "Notebook", "color": "red" }]

D. [{ "price": 5, "color": "blue" }, { "price": 10, "color": "red" }]

Solution

1. Step 1: Understand $unset effect

   The $unset operator removes the specified field from all documents.

2. Step 2: Apply $unset to color field

   Removing color means it will no longer appear in any document, leaving only name and price.

3. Final Answer:

   [{ "name": "Pen", "price": 5 }, { "name": "Notebook", "price": 10 }] -> Option B

4. Quick Check:

   Fields removed by $unset disappear from documents [OK]

Hint: Fields removed by $unset vanish from all matched documents [OK]

Common Mistakes:

• Expecting fields to be set to null instead of removed
• Thinking $unset changes field values
• Assuming only one document is affected

4. You run this command:

db.orders.updateMany({}, { $unset: { "status" } })

But it throws an error. What is the problem?

medium

A. The field name must be a string key with a value, not just a key

B. You cannot use $unset with updateMany

C. The collection name is incorrect

D. The $unset operator requires an array of fields

Solution

1. Step 1: Check $unset syntax

   The $unset operator requires field names as keys with a value (usually 1) to specify removal.

2. Step 2: Identify missing value

   In the command, { $unset: { "status" } } is invalid because the field "status" has no value.

3. Final Answer:

   The field name must be a string key with a value, not just a key -> Option A

4. Quick Check:

   $unset needs field: value pairs [OK]

Hint: Always provide a value (like 1) with field names in $unset [OK]

Common Mistakes:

• Omitting the value for the field in $unset
• Using $unset with wrong update method
• Assuming $unset accepts arrays

5. You have documents in employees collection with fields name, age, department, and tempField. You want to remove tempField only from employees in the Sales department without affecting others. Which command achieves this?

hard

A. db.employees.updateMany({ department: "Sales" }, { $unset: { tempField: 1 } })

B. db.employees.updateMany({}, { $unset: { tempField: 1 } })

C. db.employees.updateMany({ tempField: { $exists: true } }, { $unset: { department: 1 } })

D. db.employees.updateMany({ department: "Sales" }, { $set: { tempField: null } })

Solution

1. Step 1: Filter documents by department

   Use the query { department: "Sales" } to target only Sales employees.

2. Step 2: Use $unset to remove tempField

   Apply $unset: { tempField: 1 } to remove the field from matched documents only.

3. Final Answer:

   db.employees.updateMany({ department: "Sales" }, { $unset: { tempField: 1 } }) -> Option A

4. Quick Check:

   Filter then $unset removes fields selectively [OK]

Hint: Filter first, then $unset fields to remove selectively [OK]

Common Mistakes:

• Removing fields from all documents unintentionally
• Using $set to null instead of $unset
• Removing wrong fields by mistake