Re: issues with triggers

[Peter Brawley]

Two problems: an update Trigger mayn't issue an Update command on the table for which it's defined, and an After Update Trigger can't modify a row that was just updated.

Is this what you mean?

create trigger `area_aupd` before update on `area`
for each row set new.nivel=new.nivel+1;