MySQL数据库——视图-介绍及基本语法（创建、查询、修改、删除、演示示例）

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

-- 查看创建视图语句：
SHOW CREATE VIEW 视图名称;
 
-- 查看视图数据：
SELECT * FROM 视图名称 ...... ;

-- 方式一：
CREATE [OR REPLACE] VIEW 视图名称[(列名列表)] AS SELECT语句 
[ WITH [ CASCADED | LOCAL ] CHECK OPTION ]
 
-- 方式二：
ALTER VIEW 视图名称[(列名列表)] AS SELECT语句 
[ WITH [ CASCADED | LOCAL ] CHECK OPTION ]

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

-- 创建视图
create or replace view stu_v 
as
select id,name from student
where
id <= 10;
 
-- 查询视图
show create view stu_v;
 
select * from stu_v;
 
select * from stu_v where id < 3;
 
-- 修改视图
create or replace view stu_v 
as 
select id,name,no from student 
where 
id <= 10;
 
alter view stu_v 
as 
select id,name from student 
where 
id <= 10;
 
-- 删除视图
drop view if exists stu_v;

-- 创建视图,设置条件id < 10
create or replace view stu_v 
as 
select id,name from student 
where 
id <= 10 ;
 
-- 插入两条数据,一条id < 10,另一条id > 10
insert into stu_v values(6,'Tom');
 
insert into stu_v values(17,'Tom22');
 
-- 查询视图
select * from stu_v;