DELIMITER $$ CREATE OR REPLACE DEFINER=`vn`@`localhost` TRIGGER `vn`.`priceFixed_beforeUpdate` BEFORE UPDATE ON `priceFixed` FOR EACH ROW BEGIN DECLARE vDated DATE; IF NEW.started > NEW.ended THEN SET vDated = NEW.started; SET NEW.started = NEW.ended; SET NEW.ended = vDated; END IF; END$$ DELIMITER ;