$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.