题目内容

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?()

A. INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, '555-8888','mobile')
B. UPDATE phone_list SET cell_name '555-8888' WHERE first_name= 'John' and last_name= 'Doe'
C. DELETE FROM phone_list WHERE first_name= 'John' and last_name= 'Doe'; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES ('John' , 'Doe' , 'x1234' , '555-8888)
D. UPDATE employee_phone SET phone_no= '555-8888' where emp_id=1

查看答案
更多问题

运材索道凸形线路弯挠角正切值W(I)应满足()。

A. [0.1,0.30]
B. [0.1,0.31]
C. [0.1,0.33]
D. [0.1,0.35]

再热器超压试验压力为进口联箱工作压力的()倍。

A. 1.5
B. 2
C. 3

现在电解法烧碱生产工艺基本是水银法和离子交换膜法。

A. 正确
B. 错误

《欧也妮葛朗台》中关于葛朗台鼻子上的肉瘤一共出现过几次?作者有何意图?

答案查题题库