mysql-视图

视图

创建视图:和表类似的效果
CREATE [OR REPLACE] VIEW [view_name] AS [SELECT_STATEMENT]

create[or replace] view c1 as select name,age from class_1;
有相同名称视图,替代原来的

删除视图
drop view [IF EXISTS] 视图名

修改视图结构
alter view c1 as select name,age,score from class_1;