好吧，在您的 TRIGGER 中，您可以使用 OLD.your_column_name 访问刚刚删除的值.

Well, in your TRIGGER you can access the value you just deleted with OLD.your_column_name.

所以就这样做:

DELIMITER //
CREATE TRIGGER `update` AFTER DELETE ON table1
FOR EACH ROW BEGIN

UPDATE table2 SET column_name = your_new_value WHERE column_name = OLD.old_value;

END//
DELIMITER ;