*两种写法

方案1：列的别名在select子句中定义

CREATE VIEW actor_name_view
AS
SELECT first_name AS first_name_v,last_name AS last_name_v FROM actor;

方案2：列的别名在视图语句中定义

CREATE VIEW actor_name_view(first_name_v,last_name_v)
AS
SELECT first_name,last_name FROM actor;