MySQL-视图

# 视图
-- 视图是映射关系，不会产生新的表，数据来自基表

SELECT * FROM emp
SELECT * FROM dept

-- 创建视图
CREATE VIEW emp_view
	AS
	SELECT empno,ename,job,deptno FROM emp; -- from emp基表，也可以from视图成为新的视图
	
DESC emp_view
	
SELECT * FROM emp_view
 
-- 查看创建视图的指令
SHOW CREATE VIEW emp_view

-- 删除视图
DROP VIEW emp_view

CREATE VIEW emp_view02
	AS
	SELECT empno,ename,dname,grade
	FROM emp,dept,salgrade -- 多表视图
	WHERE emp.deptno = dept.deptno
	AND emp.sal BETWEEN losal AND hisal
	

SELECT * FROM emp_view02
DROP VIEW emp_view02