# 删除触发器代码
drop trigger 触发器名;
# 当一个学员发生转班,班级对应的总数进行同步变化
# 当一个学员发生转班,班级对应的总数进行同步变化
delimiter !!
create trigger movestudent after update on stu1 for each ROW
BEGIN
#定义两个变量
declare numOld int; # 定义旧班级人数
declare numNew int; # 定义新班级人数
set numOld = (select stu_num from stu2 where class = old.class);
select numOld into @a;
set numNew = (select stu_num from stu2 where class = new.class);
select numNew into @b;
update stu2 set stu_num = numOld - 1 where class = old.class;
update stu2 set stu_num = numNew + 1 where class = new.class;
end !!
delimiter;
update stu1 set class = 2302 where name = "阿涛";
select @a;
select @b;
drop trigger movestudent;
# 创建视图表
create view 视图名称 as select 已查询语句;
# 查询当前数据库所有的视图
create view stu_2301 as
select * from stu1 where class = 2301;
# 删除视图表
drop view 视图名称;
# 查询当前数据库所有视图
# 格式
show full tables in 数据库名称 where table_type like "view";
show full tables in demo924 where table_type like "view";