Re: Can I place IF statement in trigger?

[William Chiquito]

Hi riko,

This script works well in SQLyog:

DELIMITER $$

DROP TRIGGER /*!50033 IF EXISTS */ `oldFields`$$

CREATE TRIGGER `oldFields` BEFORE UPDATE on `temp_user_attendance`
FOR EACH ROW
BEGIN
	DECLARE mychanged INT DEFAULT 0;
	IF NEW.item_name != OLD.item_name OR NEW.cat_no != OLD.cat_no OR NEW.description != OLD.description
	OR NEW.quantity != OLD.quantity OR NEW.unit_price != OLD.unit_price OR NEW.quotation_no != OLD.quotation_no
	OR NEW.size != OLD.size OR NEW.comment != OLD.comment THEN
		SET mychanged = 1;
	END IF;
	IF mychanged = 1 THEN
		INSERT INTO notification_mail
		SET item_id = NEW.item_id,
		create_time = NOW(),
		mail_to = OLD.end_user,
		item_name = NEW.item_name,
		cat_no = NEW.cat_no,
		description = NEW.description,
		quantity = NEW.quantity,
		unit_price = NEW.unit_price,
		size = NEW.size,
		quotation_no = NEW.quotation_no,
		comment = NEW.comment;
	END IF;
END$$

DELIMITER ;