方法一:
思路:创建视图语句:
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;
方法一:
思路:创建视图语句:
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;