how to solve this error in mysql

Posted by Shanky11 under Others on 8/28/2012 | Points: 10 | Views : 557 | Status : [Member] | Replies : 2
This version of MySQL doesn't yet support 'multiple triggers with the same

action time and event for one table'




Responses

Posted by: Laurenrodriguez on: 8/28/2012 [Member] Starter | Points: 25

Up
0
Down
I guess there already is an AFTER UPDATE trigger on that table, but it is not named TR_SCIN_BANK_UPD, meaning that your DROP TRIGGER IF EXISTS line does nothing.

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Atal.Upadhyay on: 8/28/2012 [Member] Starter | Points: 25

Up
0
Down
You need to drop your existing trigger before you create the new one:

DROP TRIGGER IF EXISTS trg1;
CREATE TRIGGER trg1


Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response