mysql视图的简单实用

视图是从一个或者多个表导出的出局，与表非常相似但是视图没有物理记录，不占用物理空间，只是逻辑上存在，保障数据表的安全。

创建视图

create view view_name as select field1,field2 from table;

create view view_name(field1,field2) as select field1,field2 from table;

修改视图

create or replace view view_name as select field1,field2 from table;

create or replace view view_name(field1,field2) as select field1,field2 from table;

查询视图

select * from view_name;

查看视图

show create view view_name;

drop view if exists view_name;