MySQL自定义列名称的问题

mysql> create view v_w_d as
-> select id,name,d_name,score
-> from tb_worker left join tb_department
-> on d_id=der_id;
然后得到下面这个表
mysql> select*from v_w_d;
+----+------+--------+-------+
| id | name | d_name | score |
+----+------+--------+-------+
| 1 | 小赵 | 技术部 | 9.7 |
| 2 | 小钱 | 人事部 | 9.6 |
| 3 | 小孙 | 财务部 | 9.1 |
| 4 | 小李 | 销售部 | 9.2 |
| 5 | 小周 | 人事部 | 9.0 |
| 6 | 小吴 | 财务部 | 9.3 |
| 7 | 小张 | 技术部 | 9.7 |
+----+------+--------+-------+
然后我想自定义一下名称,就报错了
mysql> create view vwd(员工编号,姓名,部门名称,绩效评分)as
-> select id,name,d_name,score from v_w_d;
ERROR 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts
为什么啊!

create view vwd as select id as 员工编号,
name as 姓名,
d_name as 部门名称,
score as 绩效评分
from v_w_d;

创建视图的语法错了,create view as select a as a,b as b from table 这样,不是像创建表一样直接写括号字段

create view vwd as select id as 员工编号,
name as 姓名,
d_name as 部门名称,
score as 绩效评分
from v_w_d;


改用英文命名字段试试