Question

Shopkeeper needs to change the first name of one of his customers in table 'customer'. Which command should he use for the same?

Answer 1

Use the UPDATE command with a WHERE condition identifying the required customer.

UPDATE customer
SET name = 'NewName'
WHERE custno = 101;