compare old value and new value
I have a trigger. I want to do insert changed values after every update.
But I get syntax error on line IF .. THEN, and I can't find example.
IF (IFNULL(NEW.symbol,'') <> IFNULL(OLD.symbol,'')) THEN
INSERT INTO LOG(old_value, new_value, DATA, user)
VALUES ('Symbol: '|| IFNULL(OLD.symbol,''), 'Symbol: '
(IFNULL(NEW.symbol,''), CURRENT_TIMESTAMP, id_user)
Can You help me?
No comments:
Post a Comment