CREATE DEFINER=`root`@`localhost` TRIGGER `after_insert` AFTER INSERT ON `student` FOR EACH ROW begin -- 触发器内容开始
-- 触发器内容主体,每行用分号结尾
update course set grade = grade+1 where new.classid=course.id;
end
插入数据表名:student
更新数据是course表grade
只是实验没关心逻辑,上面代码实现了在 student 插入一条数据,course表中满足 course.id = 插入数据的 classid 的所有数据的grade加1
扩展:
CREATE DEFINER=`root`@`localhost` TRIGGER `after_insert_post` AFTER INSERT ON `post` FOR EACH ROW begin -- 触发器内容开始
-- 触发器内容主体,每行用分号结尾
update invitation set count = count+1 where new.invitationid=invitation.invitationid;
update inv