MySQL视图 备注:本文仅供参考,如有错误,欢迎指正。 创建视图 create view v1 as select ename,job from emp; 查询视图 select *from v1; 删除视图 drop view v1; 修改视图数据 alter view v1 as select job,ename,sal from emp;