Hi all. I am creating a trigger that update the some table witch call it. Ex: create table t1 ( id int, name varchar(50), c int default 0, father int, primary key(id), index (father), foreign key (father) references t1(id) on update restrict on delete restrict ); create trigger tg_t1 before update on t1 for each row begin update t1 set c=c+1 where father=NEW.id; end;
Something like it... I want to update some colums witch records are referencing by the father record. But when I update the mysql returns: "Can't update table 't1' in stored function/trigger because it is already used by statement which invoked this stored function/trigger" Why I cant make a trigger that update the some table that invoke the trigger??? How can I build it? Thanks. Lucas Vendramin
