Re: Trigger Error

[Sultana Jahan Rini]

hi,
i m facing the same error.
I want to handle error like below through trigger:
I also want to restrict the trigger through when clause. Is it possible??

DELIMITER '//';

CREATE TRIGGER trig_prov
AFTER DELETE ON user
FOR EACH ROW
--WHEN (old.acct_type_id = 2)

BEGIN

DECLARE EXIT HANDLER FOR SQLEXCEPTION SELECT 'Unknown error from trig_prov..';

............

END;
//
DELIMITER ';'//