I tried adding "NOT FOR REPLICATION " in many parts in the below code but ended up in the below code. I searched a lot for an example where I can see how its done with a trigger.
Can any one show me how I can modify the below code to add option NOT FOR REPLICATION in the below code.
DELIMITER // CREATE TRIGGER update_table BEFORE UPDATE ON table FOR EACH ROW BEGIN IF (NEW.updated_replication < OLD.updated_replication) THEN CALL raise_error; END IF; SET NEW.updated_replication = NOW(); END //
Or how can I alter this trigger to make it not for replication(Alter Query). I have spent hours trying this but no results.