MySQL之视图学习篇

视图：简单理解视图，就是一张虚表，只存储sql逻辑，不会存储数据，实际数据存在表中。视图的优点，查询需要的数据，屏蔽不需要的数据；

下面简单做视图的创建，修改，查询，操作，删除的实战操作。

-- 创建视图
CREATE VIEW view1 AS SELECT
a.age,
b.NAME 
FROM
	stusent a,
	t_user b 
WHERE
	a.id = b.id 
	
	-- 使用视图
SELECT
	* 
FROM
	view1 
WHERE
	age = 20 SELECT
	* 
FROM
	view1 
	
	-- 修改视图
CREATE 
	OR REPLACE VIEW view1 AS SELECT
	a.id,
	b.NAME 
FROM
	stusent a,
	t_user b 
WHERE
	a.id = b.id ALTER VIEW view1 AS SELECT
	a.age,
	b.NAME 
FROM
	stusent a,
	t_user b 
WHERE
	a.id = b.id 
	
	-- 查看视图结构
	DESC view1 
	
	-- 删除视图
	DROP VIEW view1 
	
	-- 操作视图
SELECT
	* 
FROM
	view1 CREATE 
	OR REPLACE VIEW view1 AS SELECT
	a.id,
	a.NAME 
FROM
	stusent a INSERT INTO view1 ( id, NAME ) 
VALUE
	( 5, 'zhangsan' ) UPDATE view1 
	SET NAME = 'ls' 
WHERE
	id = 5 DELETE 
FROM
	view1 
WHERE
	id = 5