Question

When you code an UPDATE statement for one or more rows, the SET clause names the columns to be updated and the values to be assigned to those columns, and the ______________________ clause specifies the conditions a row must meet to be updated.

Answer 1

Answer:

the Where clause specifies the conditions a row must meet to be updated.

Explanation:

UPDATE statement is used to update existing records in a database table. The syntax is as follows:

UPDATE table

SET column1 = expression1,

   column2 = expression2,

   ...

[WHERE conditions];

• SET clause names the columns to be updated and the values to be assigned to those columns
• WHERE clause specifies the conditions a row must meet to be updated