方法一:

思路:创建视图语句:

CREATE VIEW <视图名称> (<视图列名1>,<视图列名2>…)

AS

<select 语句>;

代码:

CREATE VIEW actor_name_view(first_name_v,last_name_v)
AS
select first_name,last_name
from actor;