1.创建图视
create [or replace] view view_name [(重新定义的字段名)] as select(查询语句) .................
2.查看视图的结构
DESC 视图名;
3.查看视图定义语句
SHOW CREATE VIEW 视图名;
4.查看视图的详细信息
SELECT * FROM information_schema.views ;
5.删除视图
DROP VIEW [IF EXISTS] 视图1,……视图n;
6.删除视图中数据
DELETE FROM student_view
WHERE studentname=’张丽’;
7.修改视图中数据
UPDATE student_view
SET studentsex=’男’;
8.向视图中插入数据
INSERT INTO student_view
values(‘666666’,'张三',’女’,’888888’);