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?