当值为空或不为空时，MySql 在触发器中删除

Question

请问我怎样才能在没有 IF 的情况下触发类似这样的东西？？可能吗？？

...
IF NEW.value IS NULL THEN
       DELETE FROM table WHERE column IS NULL;
ELSE
       DELETE FROM table WHERE column=NEW.value;
END IF;

练习当值为 null 时删除列为 null 的行，当设置值时删除 column=value 的行我希望在没有 IF 的情况下触发

Answer 1

您可以在一条语句中完成:

...
DELETE FROM table WHERE column IS NULL OR column=NEW.value;
...

编辑:

DELETE FROM table WHERE (NEW.value IS NULL AND column IS NULL) OR (NEW.value IS NOT NULL AND column = NEW.value)