What is wrong with this trigger in mysql?
Posted
by Jimit
on Stack Overflow
See other posts from Stack Overflow
or by Jimit
Published on 2010-04-23T05:38:55Z
Indexed on
2010/04/23
5:43 UTC
Read the original article
Hit count: 252
mysql-triggers
Hi all,
Below is trigger that I need to create but It is not getting created.Please any buddy can explain me what is wrong with this trigger ? Help me please.
DELIMITER $$
CREATE TRIGGER property_history_update
AFTER UPDATE ON `properties`
FOR EACH ROW BEGIN
IF OLD.ListPrice != NEW.ListPrice THEN
INSERT INTO `property_history` SET ListingKey=OLD.ListingKey,ListPrice = NEW.ListPrice,
ListingStatus = OLD.ListingStatus,LastUpdatedTime = NEW.LocalLastModifiedOn;
END IF;
END$$
DELIMITER ;
© Stack Overflow or respective owner