MYSQL38题解
针对actor表创建视图actor_name_view
http://www.nowcoder.com/questionTerminal/b9db784b5e3d488cbd30bd78fdb2a862
*两种写法
方案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;
投递阿里巴巴等公司10个岗位 >
快手二面135人在聊