mysql 触发器 null_在MySQL触发器中将Null与另一个值进行比较

So here is my issue I am comparing new and old values when a table row is being updated. But the new or old value will sometimes be null. So the code below doesn't work. Can can I remedy this issue?

Thank You

BEFORE UPDATE ON mytable

FOR EACH ROW

BEGIN

IF OLD.assignedto != NEW.assignedto

THEN

INSERT INTO history

(

asset ,

changedfield ,

oldvalue ,

newvalue

)

VALUES

(

NEW.asset,

'assignedto',

OLD.assignedto,

NEW.assignedto

);

END IF;

END$$

解决方案

Try:

IF ( (OLD.assignedto IS NOT NULL AND NEW.assignedto IS NOT NULL

AND OLD.assignedto != NEW.assignedto)

OR (OLD.assignedto IS NULL AND NEW.assignedto IS NOT NULL)

OR (OLD.assignedto IS NOT NULL AND NEW.assignedto IS NULL)

)

The comment is very much correct.