I have implemented a trigger. But once I try to update the table it is giving me the error:
>can't update table 'booking' in stored function/trigger because it is already used by the statement which invoked this stored function/trigger
This is the trigger
DELIMITER //
CREATE TRIGGER CANCEL_BOOK AFTER UPDATE on BOOKING
FOR EACH ROW
BEGIN
DELETE FROM BOOKING
WHERE NEW.F_ID=NULL AND NEW.H_ID=NULL;
END //
DELIMITER ;
please help
Asked by pksv
(9 rep)
Dec 2, 2018, 10:45 AM
Last activity: May 15, 2025, 05:12 AM
Last activity: May 15, 2025, 05:12 AM