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