how to solve this error in mysql

Posted by Shanky11 under Others on 8/28/2012 | Points: 10 | Views : 1520 | Status : [Member] | Replies : 2

This version of MySQL doesn't yet support 'multiple triggers with the same

action time and event for one table'

Reply | Reply with Attachment

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

0	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

0	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

Latest Posts