mysql简单触发器

DELIMITER $$

USE `platform`$$

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

CREATE
    /*!50017 DEFINER = 'root'@'%' */
    TRIGGER `invo_dept_day_log_update` AFTER UPDATE ON `invo_dept` 
    FOR EACH ROW BEGIN
	DECLARE  a INT(11) DEFAULT (SELECT id FROM `platform`.`invo_dept_log` WHERE comp_id=NEW.comp_id AND dept_id=NEW.dept_id AND product_id=NEW.product_id AND (DATE_FORMAT(create_time,'%Y-%m-%d') = DATE_FORMAT(NOW(),'%Y-%m-%d')));
	IF a>0 THEN
		UPDATE `platform`.`invo_dept_log` SET `num` = NEW.num , `storage_num` = NEW.storage_num , `extra_num` = NEW.extra_num  WHERE `id` = a;
	ELSE
		INSERT INTO `platform`.`invo_dept_log` (`id`,`comp_id`,`dept_id`,`product_id`,`num`,`storage_num`,`extra_num` ) VALUES (NULL, NEW.comp_id, NEW.dept_id, NEW.product_id, NEW.num, NEW.storage_num, NEW.extra_num );
	END IF;
    END;
$$

DELIMITER ;