Using the Update Statement |
||||||||
The SET clause identifies the names of the columns that receive new values. Each value in the SET clause specifies the corresponding value for the column. This can be a simple value, an expression, or a subquery. Identifying Rows to ModifyYou typically use the table's PRIMARY KEY column to identify a single row. Using a nonunique column causes several rows to be updated. For example, identifying rows in the EMPLOYEES table by the DEPARTMENT ID value causes all the employees in that department to be updated.
|