Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|What's the best way to programatically have a MySQL DB update another MySQL DB||4||108|
|Error : [Method Error 500] while loading value from database using web service||2||38|
|Update Set Column Query Not Working as Expected||6||46|
Join the community of 500,000 technology professionals and ask your questions.