查詢所有觸發(fā)器
show?triggers斤斧；
刪除觸發(fā)器
DROP TRIGGER IF EXISTS `insert_yh_course_loading_tri`;
觸發(fā)器 —— 添加數(shù)據(jù)?
例子 ：
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
觸發(fā)器 ——?更新數(shù)據(jù)
例子 ：
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
觸發(fā)器 —— 刪除數(shù)據(jù)
例子 ：
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;
