Мои примеры триггеров

DELIMITER $$CREATE TRIGGER insert_date before INSERT ON vizits FOR EACH ROW begin set new.weeks = weekofyear(new.date); end; DELIMITER ;

----------------------------------------------

DELIMITER $$CREATE TRIGGER lastviz_doctor AFTER INSERT ON vizits FOR EACH ROWBEGINUpdate doctor set lastviz_date = New.date where id=NEW.doctor_id;END;DELIMITER ;

----------------------------------------------

DELIMITER $$CREATE TRIGGER users_autintif AFTER UPDATE ON users FOR EACH ROWBEGININSERT INTO MONITORINGSELECT b.id, a.user, a.HOST, a.DB, a.TIME, a.STATE, a.INFO, b.login, b.pass, b.empl_id, b.cur_id, NOW()FROM information_schema.PROCESSLIST a, users bWHERE b.cur_id=a.ID;END;DELIMITER ; 

Отличная штука эти триггеры, полезная