MySQL，有大佬会的吗

create view teacher1_view as select tname as 教师姓名, tgender as 教师性别,tpro as 教师职称
from teacher

create view teacher1_view (教师名称,教师性别,教师职称) as select tname , tgender , tpro from teacher

可以