题解 | #针对actor表创建视图actor_name_view#
针对actor表创建视图actor_name_view
http://www.nowcoder.com/practice/b9db784b5e3d488cbd30bd78fdb2a862
CREATE VIEW actor_name_view(first_name_v,last_name_v)
AS
SELECT first_name,last_name
FROM actor
;
/*方法2：
CREATE VIEW actor_name_view
AS
SELECT first_name AS first_name_v,last_name AS last_name_v
FROM actor
;
*/
两种方法均可以
投递菜鸟集团等公司10个岗位
