2025.4.23

DELIMITER //
CREATE TRIGGER check_construction_creator_role
BEFORE INSERT ON Construction
FOR EACH ROW
BEGIN
DECLARE creator_role VARCHAR(20);
SELECT role INTO creator_role FROM Users WHERE user_id = NEW.creator_id;
IF creator_role != 'construction_manager' THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Only construction_manager can create plans';
END IF;
END//
DELIMITER ;
今天写了以上触发器，期间出现了对于这个并不熟悉，经过两天的学习将这个代码写出来