mysql视图

-- 创建基于单表的视图
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;