You can execute the UPDATE
statement to update data in a table.
Syntax
UPDATE table_reference
SET assignment_list
[WHERE where_condition]
[ORDER BY ...]
Precautions
The table on which you execute the UPDATE
statement must have a primary key.
Example
Change the name of the customer who has the customer_id ='2369'
attribute to Claire in the customer table.
update customer set customer_name ='Claire' where customer_id ='2369';