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: 249

Filed under:

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

Related posts about mysql-triggers