MySQL 触发器：更新 B 表后自动递减 A 表 req 字段

DELIMITER //

CREATE TRIGGER update_req AFTER UPDATE ON b FOR EACH ROW BEGIN IF (NEW.req > 0) THEN UPDATE a SET req = req - 1 WHERE id = NEW.id; END IF; END//

DELIMITER ;