查询所有触发器
show triggers；
删除触发器
DROP TRIGGER IF EXISTS `insert_yh_course_loading_tri`;
触发器 —— 添加数据
例子 ：
CREATE TRIGGER `insert_yh_course_loading_tri` AFTER INSERT ON `yh_course_loading` FOR EACH ROW begin
INSERT INTO yh_course_loading_log(loading_id,appo_id,loading,operatetype,operatetime) VALUES (new.id,new.appo_id,new.loading, 'insert course_loading', now());
END
触发器 —— 更新数据
例子 ：
CREATE TRIGGER `add_teacher_earnings` AFTER UPDATE ON `banana_serve`
FOR EACH ROW
BEGIN
IF (new.status = 2) and (old.sid is not null )
THEN
INSERT INTO banana_org_tea_earnings (`earning_sum`, `tea_id`, `stu_uid`, `create_time`, `update_time`) VALUES (7, old.tid, old.sid, NOW(), NOW());
END IF;
END
触发器 —— 删除数据
例子 ：
CREATE TRIGGER `delete_yh_course_loading_tri` AFTER DELETE ON `yh_course_loading` FOR EACH ROW begin
INSERT INTO yh_course_loading_log(loading_id,appo_id,loading,operatetype,operatetime) VALUES (old.id,old.appo_id,old.loading, 'delete course_loading', now());
end;
