tenho a seguinte trgger:
DELIMITER |
CREATE TRIGGER tgteste AFTER INSERT ON endereco
FOR EACH ROW BEGIN
insert into teste values(0,'aaaaaaaa');
END;
|
DELIMITER ;
mas da este erro:
Can’t update table ‘teste’ in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
pq este erro?