题目:针对actor表创建视图actor_name_view,只包含first_name以及last_name两列,并对这两列重新命名,first_name为first_name_v,last_name修改为last_name_v:
创建视图view的代码是
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 )