Which query will change the cust_address to 'Panama' for those who are from ‘Los Angeles’?
Answer options
A
UPDATE customer SET cust_address = 'Panama' WHERE cust_address = 'Los Angeles';
B
UPDATE customer SET cust_address = 'Los Angeles' WHERE cust_address = 'Panama';
C
INSERT INTO customer (cust_address) VALUES ('Panama');
D
DELETE FROM customer WHERE cust_address = 'Los Angeles';
Correct answer: UPDATE customer SET cust_address = 'Panama' WHERE cust_address = 'Los Angeles';
Explanation
UPDATE with SET and WHERE clause changes the specified rows.