插入触发器后的mysql，该触发器更新另一个表的列

尝试这个：

DELIMITER $$CREATE TRIGGER occupy_trigAFTER INSERT ON `OccupiedRoom` FOR EACH ROWbegin       DECLARE id_exists Boolean;       -- Check BookingRequest table       SELECt 1       INTO @id_exists       FROM BookingRequest       WHERe BookingRequest.idRequest= NEW.idRequest;       IF @id_exists = 1       THENUPDATE BookingRequestSET status = '1'WHERe idRequest = NEW.idRequest;        END IF;END;$$DELIMITER ;