1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| CREATE TRIGGER my_first_trigger BEFORE INSERT COMMENT values(comment, #commentPIID, #commentUserID)
FOR EACH ROW
BEGIN
IF
(Select USER.ID
From USER left join PI_REMINDER on PI_REMINDER.userID == USER.ID
Where PI_REMINDER.ID == commentPIID && USER.ID == commentUserID) is not null)
OR
((Select userID
From pishared
Where PIID == commentPIID && userID ==commentUserID && acceot == 1) is not null)
THEN
INSERT INTO COMMENT values(comment, #commentPIID, #commentUserID)
END IF;
END; |
Partager