4. Updating data

SELECT * FROM customer;

UPDATE customer SET name = "Leo", address = "123 BCD Street", zip = "88678" WHERE id =5;

Updating data to NULL value

SELECT * FROM customer;

UPDATE customer SET address = NULL, zip = NULL WHERE id =5;