The interactions in this eCourse require Javascript to be enabled.
Using the Update Statement
previous|next
The syntax of an UPDATE statement is shown in the graphic: table_name in the UPDATE statement specifies the name of the table whose rows you want to update.
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 Modify You 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.