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;
，现在知道急了，而且你这个简历完全可以写成一页，劣势太大了，建议转测试
滴滴公司福利 1105人发布