$min and $max update operators in MongoDB - Step-by-Step Execution

Concept Flow - $min and $max update operators

Start with document

↓

Apply $min or $max update

↓

Compare current field value with update value

↓

Update

↓

Save updated document

The $min and $max operators compare the current field value with the given value and update the field only if the condition is met.

Execution Sample

MongoDB

db.collection.updateOne(
  { _id: 1 },
  { $min: { score: 50 } }
)

This updates the document with _id 1, setting 'score' to 50 only if the current score is greater than 50.

Execution Table

Step	Current score	Update operator	Update value	Comparison	Action	New score
1	70	$min	50	70 > 50	Update to 50	50
2	50	$min	50	50 > 50 is False	No update	50
3	40	$max	45	40 < 45	Update to 45	45
4	45	$max	45	45 < 45 is False	No update	45

💡 Updates stop after applying $min or $max once per document; no further changes if condition fails.

Variable Tracker

Variable	Start	After Step 1	After Step 2	After Step 3	After Step 4	Final
score	70	50	50	45	45	45

Key Moments - 2 Insights

Why does the score not update when the current value equals the update value?

Because $min and $max only update if the new value is strictly less ($min) or greater ($max) than the current value, as shown in steps 2 and 4 where the condition is false.

What happens if the current value is missing or null?

MongoDB treats missing or null fields as if they don't exist, so $min or $max will set the field to the update value because the comparison treats missing as greater or less accordingly.

Visual Quiz - 3 Questions

Look at the execution table at Step 1. What is the new score after applying $min with value 50 when current score is 70?

A 50

B 70

C 120

D No change

💡 Hint

Check the 'Action' and 'New score' columns in Step 1 of the execution table.

At which step does the $max operator update the score from 40 to 45?

A Step 2

B Step 3

C Step 4

D No update occurs

💡 Hint

Look at the 'Update operator' and 'Action' columns in the execution table.

If the current score was 50 and we apply $min with 50, what happens?

A Score updates to 50

B Score updates to 0

C No update happens

D Score increases

💡 Hint

Refer to Step 2 in the execution table where the condition is false and no update occurs.

Concept Snapshot

$min and $max update operators:
- $min sets field to given value only if given value is less than current.
- $max sets field to given value only if given value is greater than current.
- If condition is false, field stays unchanged.
- Useful for conditional updates without reading first.
- Syntax: { $min: { field: value } } or { $max: { field: value } }

Full Transcript

This visual execution trace shows how MongoDB's $min and $max update operators work. Starting with a document's field value, the update compares the current value with the given value. For $min, if the current value is greater, it updates to the smaller value. For $max, if the current value is smaller, it updates to the larger value. If the values are equal or the condition is false, no update happens. This allows conditional updates directly in the database. The execution table tracks each step, showing the current value, the operator, the comparison, and the resulting action. The variable tracker shows how the field value changes after each update. Key moments clarify common confusions about equality and missing fields. The quiz tests understanding by referencing specific steps in the execution. This helps beginners see exactly how $min and $max behave in practice.

Practice

1. What does the $min update operator do in MongoDB?

easy

A. Updates the field only if the new value is smaller than the current value.

B. Updates the field only if the new value is larger than the current value.

C. Always updates the field with the new value.

D. Deletes the field if the new value is smaller.

Solution

1. Step 1: Understand the purpose of $min

   The $min operator updates a field only if the new value is smaller than the current value stored in that field.

2. Step 2: Compare with other options

   $max updates if the new value is larger, and other options do not match the behavior of $min.

3. Final Answer:

   Updates the field only if the new value is smaller than the current value. -> Option A

4. Quick Check:

   $min updates only if smaller [OK]

Hint: Remember: $min means update if new value is smaller [OK]

Common Mistakes:

• Confusing $min with $max behavior
• Thinking $min always updates the field
• Assuming $min deletes fields

2. Which of the following is the correct syntax to use $max to update the field score to 90 in MongoDB?

easy

A. { $max: [ score: 90 ] }

B. { $max: score: 90 }

C. { $max: { score: 90 } }

D. { $max: { 'score' => 90 } }

Solution

1. Step 1: Recall correct MongoDB update syntax

   MongoDB update operators use the format: { $operator: { field: value } }. So $max must be followed by an object with field and value.

2. Step 2: Check each option

   { $max: { score: 90 } } matches the correct syntax. The options missing braces around the field-value pair or using brackets [] have invalid syntax. { $max: { 'score' => 90 } } uses '=>' which is not valid in MongoDB queries.

3. Final Answer:

   { $max: { score: 90 } } -> Option C

4. Quick Check:

   Correct MongoDB update syntax = { $max: { score: 90 } } [OK]

Hint: Use braces { } around field-value pairs in update operators [OK]

Common Mistakes:

• Using brackets [] instead of braces {}
• Missing braces around field-value pairs
• Using arrow syntax '=>' instead of colon ':'

3. Given a document { _id: 1, highScore: 80 }, what will be the document after applying db.collection.updateOne({_id:1}, { $max: { highScore: 75 } })?

medium

A. { _id: 1, highScore: 75 }

B. { _id: 1, highScore: 155 }

C. No document updated

D. { _id: 1, highScore: 80 }

Solution

1. Step 1: Understand $max behavior on existing value

   The $max operator updates the field only if the new value is greater than the current value. Here, current highScore is 80, new value is 75.

2. Step 2: Compare values and decide update

   Since 75 is less than 80, the field will NOT be updated. The document remains unchanged.

3. Final Answer:

   { _id: 1, highScore: 80 } -> Option D

4. Quick Check:

   $max updates only if new value is larger [OK]

Hint: If new value < current, $max does not update [OK]

Common Mistakes:

• Assuming $max always updates the field
• Confusing $max with $min behavior
• Thinking update fails if condition not met

4. You run this update: db.collection.updateOne({_id: 2}, { $min: { age: 30 } }) but it does not update the document. What could be the reason?

medium

A. The update syntax is incorrect.

B. The current age in the document is less than 30.

C. The document with _id: 2 does not exist.

D. The $min operator requires an array value.

Solution

1. Step 1: Understand $min update condition

   $min updates the field only if the new value is smaller than the current value.

2. Step 2: Analyze why update might not happen

   If the current age is already less than 30, the update will not change the document. Other options are incorrect because $min does not require arrays, the syntax is correct, and the question states the update runs but no change occurs.

3. Final Answer:

   The current age in the document is less than 30. -> Option B

4. Quick Check:

   $min updates only if new value smaller [OK]

Hint: No update if current value is smaller than $min value [OK]

Common Mistakes:

• Thinking $min requires array values
• Assuming syntax error without checking
• Ignoring existing document values

5. You want to keep track of the lowest and highest temperatures recorded in a MongoDB document with fields minTemp and maxTemp. Which update operation correctly updates both fields when a new temperature temp is 15?

hard

A. { $min: { minTemp: 15 }, $max: { maxTemp: 15 } }

B. { $max: { minTemp: 15 }, $min: { maxTemp: 15 } }

C. { $min: { maxTemp: 15 }, $max: { minTemp: 15 } }

D. { $set: { minTemp: 15, maxTemp: 15 } }

Solution

1. Step 1: Understand the goal for minTemp and maxTemp

   We want minTemp to update only if the new temperature is lower, so use $min. For maxTemp, update only if new temperature is higher, so use $max.

2. Step 2: Check each option for correct operator usage

   { $min: { minTemp: 15 }, $max: { maxTemp: 15 } } correctly uses $min for minTemp and $max for maxTemp. { $max: { minTemp: 15 }, $min: { maxTemp: 15 } } and { $min: { maxTemp: 15 }, $max: { minTemp: 15 } } swap operators incorrectly. { $set: { minTemp: 15, maxTemp: 15 } } always sets both fields to 15, ignoring previous values.

3. Final Answer:

   { $min: { minTemp: 15 }, $max: { maxTemp: 15 } } -> Option A

4. Quick Check:

   Use $min for minTemp and $max for maxTemp [OK]

Hint: Use $min for minimum and $max for maximum fields [OK]

Common Mistakes:

• Swapping $min and $max operators
• Using $set which overwrites values blindly
• Updating wrong fields with wrong operators