MySQL AFTER UPDATE Trigger Not Firing

Question

I am trying to set-up a trigger that will essentially archive information based on when a certain column is updated. What this should be doing is moving schedule_id and login from the schedule table to the schedule_archive table every time the term_date_schedule column is changed. However, that isn't happening. I am extremely new to MySQL, so I am probably missing something obvious.

CREATE DEFINER=`user`@`%` TRIGGER employee_term 
AFTER UPDATE ON schedule
FOR EACH ROW
BEGIN
    IF NEW.term_date_schedule <=> OLD.term_date_schedule THEN
        INSERT INTO schedule_archive(schedule_id, login) VALUES(old.schedule_id, old.login);
END IF;
END

@AnkitBajpai That did it! Thank you so much. I knew it would be something stupid and simple like that... Want to post as an answer? — doriansm
– doriansm, Commented Aug 28, 2017 at 16:50

Ankit Bajpai · Accepted Answer · 2017-08-28 16:51:13Z

1

What is <=>? Use <> instead.

answered Aug 28, 2017 at 16:51

Ankit Bajpai

13.6k4 gold badges27 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

doriansm Over a year ago

That did it! Thank you.

wchiquito Over a year ago

<=> NULL-safe equal to operator.

Collectives™ on Stack Overflow

MySQL AFTER UPDATE Trigger Not Firing

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related