题解 | #针对actor表创建视图actor_name_view#
针对actor表创建视图actor_name_view
http://www.nowcoder.com/practice/b9db784b5e3d488cbd30bd78fdb2a862
知识点
- 创建视图的代码为CREATE VIEW <视图名> AS <SELECT语句>
代码
create view actor_name_view as
select first_name as first_name_v, last_name as last_name_v
from actor