-- 创建基于单表的视图 CREATE VIEW view_students_info AS SELECT * FROM tb_students_info; -- 根据字段名创建基于单表的视图 CREATE VIEW v_students_info (s_id,s_name,d_id,s_age,s_sex,s_height,s_date) AS SELECT id,name,dept_id,age,sex,height,login_date FROM tb_students_info; -- 创建基于多表的视图 CREATE VIEW view_stu_dept(d_id,s_name,dept_name) AS SELECT s.id,s.name,d.dept_name FROM tb_students_info s,tb_departments d WHERE s.dept_id=d.dept_id; -- 查看视图的定义 DESCRIBE v_students_info; -- 修改视图的定义 ALTER VIEW view_students_info AS SELECT id,name,age FROM tb_students_info; -- 修改视图的内容 UPDATE view_students_info SET age=25 WHERE id=1; -- 删除视图 DROP VIEW IF EXISTS v_students_info;