Mysql 创建视图用union all连接

为了在登录时只用一个登录页面做到验证三种实体用户的账号密码和角色，就创建了这个视图

create view login AS
select sno as username,password as password,role as role from students
union all
select tno as username,password as password,role as role from teachers
union all
select ano as username,password as password,role as role from admins

这样就可以在验证时直接查询这个视图获取三种不同用户的数据进行验证判断了