Update Statement
UPDATE tablename
SET colname = expression { , colname = expression}
[ WHERE search_condition ]
Replaces values of the specified columns with expression values for all rows satisfying the search-condition.
Expressions in the set clause may be constants or column values from the UPDATE tablename or FROM tablename
Example: UPDATE PART
SET price = price * 1.1
WHERE price < 20;