On Wednesday 19 April 2006 11:10, Lucas Vendramin wrote:
> Hi all.
> I am creating a trigger that update the some table witch call it.
> 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
> update t1 set c=c+1 where father=NEW.id;
set NEW.c = NEW.c + 1;
or whatever. You dont update on a before trigger..