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';