首先,我创建了两个表,分别是class表和student表,设立了以下触发器
DELIMITER $
create trigger tri_stuInsert after insert
on student for each row
begin
declare c int;
set c = (select stuCount from class where classID=new.classID);
update class set stuCount = c + 1 where classID = new.classID;
end$
DELIMITER ;
在student表里面执行插入操作后,class表的stuCount并没有发生变化,想问下这是什么原因呢?