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?