UPDATE without WHERE (danger) in SQL - Step-by-Step Execution

Concept Flow - UPDATE without WHERE (danger)

Start UPDATE statement

↓

Check for WHERE clause

↓

Finish

The UPDATE command checks if there is a WHERE clause. If yes, it updates only matching rows. Without WHERE, it updates every row in the table.

Execution Sample

SQL

UPDATE employees SET salary = salary * 1.1;

This query increases the salary of every employee by 10% because it has no WHERE clause.

Execution Table

Step	Action	Rows Affected	Table State Change
1	Start UPDATE employees SET salary = salary * 1.1	0	No change yet
2	Check for WHERE clause	N/A	No WHERE clause found
3	Apply salary = salary * 1.1 to ALL rows	5	All 5 employee salaries increased by 10%
4	Finish UPDATE	5	Table updated with new salaries for all rows

💡 No WHERE clause, so all rows updated

Variable Tracker

Variable	Start	After Update	Final
salary (per employee)	Original salaries	Increased by 10%	Updated salaries

Key Moments - 2 Insights

Why does the UPDATE affect all rows without a WHERE clause?

Because the execution_table row 2 shows no WHERE clause, so the update applies to every row in the table.

Can this cause data loss or unwanted changes?

Yes, as seen in row 3, all rows change. If you wanted to update only some rows, missing WHERE causes unintended updates.

Visual Quiz - 3 Questions

Look at the execution_table, how many rows are updated in step 3?

A Only one row

B No rows

C All rows in the table

D Half the rows

💡 Hint

Refer to execution_table row 3 under 'Rows Affected'

At which step does the query realize there is no WHERE clause?

A Step 1

B Step 2

C Step 3

D Step 4

💡 Hint

Check execution_table row 2 'Check for WHERE clause'

If we add WHERE salary < 50000, how would the 'Rows Affected' change in step 3?

A It would update only rows with salary less than 50000

B It would update no rows

C It would update all rows

D It would update rows with salary greater than 50000

💡 Hint

Adding WHERE limits rows updated as shown in concept_flow

Concept Snapshot

UPDATE table_name SET column = value
Without WHERE, all rows are updated.
Always use WHERE to limit updates.
Missing WHERE can cause unintended data changes.
Check your query before running UPDATE.

Full Transcript

This lesson shows what happens when you run an UPDATE SQL command without a WHERE clause. The flow starts by checking if a WHERE clause exists. If not, the update applies to every row in the table. For example, updating salaries by 10% without WHERE changes all employees' salaries. The execution table traces each step: starting the update, checking for WHERE, applying changes to all rows, and finishing. Variables like salary change from original to updated values. Key points include understanding that missing WHERE updates all rows, which can cause unwanted data changes. The quiz asks about how many rows update, when the query detects no WHERE, and what happens if a WHERE clause is added. Remember, always use WHERE to avoid accidental updates to your entire table.