Perform trigger condition

Question

Perform trigger condition

Navigation

#1 by (0 votes)

0

I have a trigger that does an update on my table. I would like to know how to do so that the trigger is only executed if the status column is different from what is already in my table, if it does not, nothing happens.

DELIMITER $$
CREATE TRIGGER trg_anuencias
AFTER UPDATE ON anuencias
FOR EACH ROW BEGIN
INSERT INTO anuencias_auditoria
SET acao = 'update',
id_anuencia = NEW.id,
status = NEW.status,
modificadoem = NOW(); END$$
DELIMITER ;

Thank you in advance.

mysql sql

asked by anonymous 13.07.2017 / 20:22

1 answer

Policy does not work with dynamic properties session comparison with a database field in php

score 0 · Accepted Answer

NEW takes the new values and OLD takes the old values, follow the example below:

DELIMITER $$
CREATE TRIGGER trg_anuencias
AFTER UPDATE ON anuencias
FOR EACH ROW BEGIN
    IF (NEW.status <> OLD.status) THEN
        INSERT INTO anuencias_auditoria
        SET acao = 'update', id_anuencia = NEW.id, status = NEW.status,
        modificadoem = NOW();
    END IF;
END$$
DELIMITER ;