Re: Creating trigger on update of a particular column of a table

[William Chiquito]

Hi mangesh,

Try:

DELIMITER $$

DROP TRIGGER /*!50032 IF EXISTS */ `CHANGEEMP`$$

CREATE TRIGGER `CHANGEEMP` AFTER UPDATE on `EMP`
FOR EACH ROW BEGIN
	IF NEW.salary != OLD.salary THEN
		INSERT INTO tempSalary (Salary) VALUES (NEW.salary);
	END IF;
END$$

DELIMITER ;