建立视图 create view view_stu as select name, age from student; 查看视图基本信息 desc view_stu; 查看视图的详细信息 show create view view_stu; 修改视图 alter view view_stu as select * from student; (下面和表一样) 插入(INSERT) 例: Mysql>INSERT INTO v4 VALUES(NULL,'心理学',45,'三张',4); 更新(UPDATE) 例: Mysql>UPDATE v4 SET bookName='心理学2' WHERE id =5; 删除(DELETE) Mysql>DELETE FROM v4 WHERE id =5; 删除视图 drop view view_stu;