MYSQL视图

介绍

CREATE [OR REPLACE] VIEW 视图名称[(列名列表)] AS SELECT语句 [ WITH [
CASCADED | LOCAL ] CHECK OPTION ]

2）.查询

1.查看创建视图的语句

show create view 视图名称;

2.查看视图数据

select * from 视图名称;

3).修改

1.

create [or replace ] view 视图名称 as SELECT语句 [ WITH
[ CASCADED | LOCAL ] CHECK OPTION ]

2.

ALTER VIEW 视图名称[(列名列表)] AS SELECT语句 [ WITH [ CASCADED |
LOCAL ] CHECK OPTION ]

4).删除

DROP VIEW [IF EXISTS] 视图名称 [,视图名称]

检查选项

更新

作用