视图

视图

1.为什么有视图？

• 1.对于包含隐私的表，视图可以屏蔽一些私密的字段信息(如个人证件号等)
• 2.视图可以集合几张表的信息进行展示

2.视图会占用空间吗？

• 1.视图不涉及对数据的存储

3.如何创建视图?

CREATE VIEW address_V ( id, country_Code, country, state_Code, state, city_code, city, full_Name_Code, full_name ) 
AS 
	SELECT
			id,
			country_Code,
			country,
			state_Code,
			state,
			city_code,
			city,
			full_Name_Code,
			full_name 
	FROM
		address_T;

4.怎么查看视图的结构？

//查看所有视图
select * from user_views ;