DELIMITER ;;
CREATE TRIGGER `test_compatibility_bu` BEFORE UPDATE ON `test_compatibility` FOR EACH ROW
IF (NEW.not_update=0) THEN
SET NEW.on_update = 1, NEW.on_update_date=NOW(), NEW.not_update=0;
ELSE
SET NEW.not_update=0;
END IF;;
DELIMITER ;