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.
  • Primary key columns cannot be updated.
  • SQL statements cannot be updated in batches.

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