更新时间:2022-12-04 13:28:01
您不能在 SQL 中的特定列更新上触发.它应用于一行.
You can't trigger on a particular column update in SQL. It is applied on a row.
您可以使用 IF
语句将 columm 的条件放在触发器中,如下所示:
You can put your condition for columm in your trigger with an IF
statement, as below:
DELIMITER //
CREATE TRIGGER myTrigger AFTER UPDATE ON myTable
FOR EACH ROW
BEGIN
IF !(NEW.column1 <=> OLD.column1) THEN
--type your statements here
END IF;
END;//
DELIMITER ;