CREATE view actor_name_view as
select
first_name first_name_v,
last_name last_name_v
from actor
或者:
create view actor_name_view(first_name_v,last_name_v) as
select
first_name,
last_name
from actor
知识点:
1、创建视图:create view view_name as select ....(注意这里不像select后面别名可以省略as,CREATE view创建视图的as必须要有);
2、MySQL查询语句对一些字母大小写并不敏感。