1、创建视图“view_info”,查询所有员工姓名、员工联系电话、车间地址、车间主任姓名、主任联系方式
create view view_info as
select shenqin_worker.name,shenqin_worker.phone,shenqin_workshop.address,shenqin_workshop.names,shenqin_workshop.phones
-> from shenqin_workshop inner join shenqin_worker
-> on shenqin_workshop.no=shenqin_worker.shop_no;
2、查看“view_info”视图字段信息
desc vi