CREATE TRIGGER `testcmp_bu` BEFORE UPDATE ON `tests_compatibility` FOR EACH ROW IF (NEW.notUpdate=0) THEN SET NEW.onUpdate = 1, NEW.onUpdateDate=NOW(), NEW.notUpdate=0; ELSE SET NEW.notUpdate=0; END IF