When necessary,include a WHERE clause into the UPDATE command to indicate the column on which the change is to take place.

Name: When necessary,include a WHERE clause into the UPDATE command to indicate the column on which the change is to take place.
Brand: Quizplus
Rating: 4.7 (31 reviews)

Question

Quizplus · Accepted Answer

A WHERE clause in an UPDATE command specifies which rows should be updated, not which columns. The columns to be updated are specified directly in the SET clause.

When Necessary,include a WHERE Clause into the UPDATE Command to Indicate