Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.
I dont get a line in the logger, however if I execute again differently so the so OLD.`phoneNumber` isnt null then trigger fires fine and runs the insert command.
UPDATE `contract` SET `phoneNumber` = '44464' WHERE `contract`.`priID` = 8;
Begin IF OLD.`phoneNumber` <> NEW.`phoneNumber` THEN INSERT INTO `mobilephones`.`_logger` (`dateTime`, `connectionID`, `table`, `priID`, `feild`, `newValue`,`action`) VALUES (NOW(), CONNECTION_ID(), 'contract', NEW.`priID`, 'phoneNumber', NEW.`phoneNumber`, 'Update'); END IF; End
Join the community of 500,000 technology professionals and ask your questions.