UPDATE with WHERE clause in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the UPDATE statement do in SQL?

The UPDATE statement changes existing data in a table. It modifies one or more rows based on given conditions.

beginner

Why is the WHERE clause important in an UPDATE statement?

The WHERE clause limits which rows get updated. Without it, all rows in the table will be changed.

beginner

Write the syntax of an UPDATE statement with a WHERE clause.

UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;

intermediate

What happens if you run an UPDATE statement without a WHERE clause?

All rows in the table will be updated with the new values, which might cause unintended data changes.

beginner

How can you update multiple columns in one UPDATE statement?

You list each column and its new value separated by commas after SET. For example: SET col1 = val1, col2 = val2.

What does the WHERE clause do in an UPDATE statement?

A Specifies new values for columns

B Deletes rows from the table

C Creates a new table

D Limits which rows are updated

The WHERE clause filters rows so only those matching the condition get updated.

What happens if you omit the WHERE clause in an UPDATE statement?

A All rows in the table are updated

B No rows are updated

C Only one row is updated

D The table is deleted

Without WHERE, the update applies to every row in the table.

Which of these is the correct syntax to update the 'price' column to 10 where 'id' equals 5?

A SET price = 10 WHERE id = 5 UPDATE products;

B UPDATE products WHERE id = 5 SET price = 10;

C UPDATE products SET price = 10 WHERE id = 5;

D UPDATE products price = 10 WHERE id = 5;

The correct syntax places SET before the column assignments and WHERE after.

How do you update multiple columns in one UPDATE statement?

A SET col1 = val1, col2 = val2

B UPDATE col1 = val1, col2 = val2

C WHERE col1 = val1, col2 = val2

D SET col1 = val1 AND col2 = val2

Multiple columns are separated by commas after the SET keyword.

Which keyword is mandatory to specify which rows to update?

A FROM

B WHERE

C SELECT

D JOIN

The WHERE clause specifies the condition to select rows for updating.

Explain how to safely update a specific row in a table using the UPDATE statement with a WHERE clause.

Think about how to avoid changing all rows accidentally.

Describe what could happen if you forget the WHERE clause in an UPDATE statement.

Consider the impact on the whole table.