You can execute the UPDATE statement to update data in a table.


UPDATE  table_reference
    SET assignment_list
    [WHERE where_condition]
    [ORDER BY ...]     


  • 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.


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