How can I solve this problem? error # 1235

0

This error appears when I try to insert into two tables at the same time using the t3 detonator.

Here's the code:

 drop trigger if exists Actualizador; 
    delimiter go 
    CREATE TRIGGER Actualizador
    AFTER INSERT ON banca
    FOR EACH ROW 
    BEGIN 
    Insert Into  Test (a1, a2, BANCA_ID) VALUES  (new.Hab_Ban, new.Hab_Ban , new.ID_BANCA); 
    Insert Into  Test2 (a1, a2, BANCA_ID) VALUES  (new.Hab_Ban, new.Hab_Ban , new.ID_BANCA); 
    END; 
    go 
    delimiter ; 

    insert into banca (ID_BANCA, Nom_Banca, Hab_Ban, BANCA_ID) values(1 , 'EL PINAR' , 1 , 1); 
  

Error # 1235 This version of MySQL does not support yet   'multiple triggers with the same action time and event for one table'

The only way to make it work is to remove one of the insert instructions. How could I do?

    
asked by David Magnum 05.03.2018 в 21:52
source

0 answers