Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= root'@localhost' SQL SECURITY DEFINER VIEW phone_list' AS SELECT e . id as id e . first_name AS first_name' e…

Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= root'@localhost' SQL SECURITY DEFINER VIEW phone_list' AS SELECT e . id as id e . first_name AS first_name' e . last_name AS last_name' coalesce ( ph1.phone_no, --') AS office_no' coalesce (ph2 .phone_no, '--) AS cell_no' FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND ph1.type = office' LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type = mobile' The tables employees and employee_phone are InnoDB tables; all columns are used in this view. The contents of the phone_list view are as follows:

Mysql> select * from phone_list; 1 row in set (0.00 sec) Which method can you use to change the cell_no value to `555-8888' for John Doe?