题解 | #针对actor表创建视图actor_name_view#
针对actor表创建视图actor_name_view
http://www.nowcoder.com/practice/b9db784b5e3d488cbd30bd78fdb2a862
create view actor_name_view as select first_name as first_name_v,last_name as last_name_v from actor
创建视图语法：create view 'view_name' as select 'column1','column2' from table_name
创建视图加别名：create view 'view_name' as select 'column1' as 'column1_v','column2' as 'column2_v' from table_name
格力公司福利 247人发布