以下代码是我的触发器,在student_approve
表更新后将数据插入到通知表中,但是在第5行出现了错误。
DROP TRIGGER IF EXISTS `student_approve`;
CREATE TRIGGER `student_approve` AFTER UPDATE ON `student_info`
FOR EACH ROW
BEGIN
IF NEW.student_approval LIKE '1' THEN
INSERT INTO `notifications` (user_to_notify,who_fired_event,noti_event_id)VALUES(NEW.registered_by,1,2);
END IF;
END