before update trigger:
--> column id_tezaver can not be nullCode:set new.id_tezaver = (select IFNULL(id_tezaver,0) from tezaver t where term = new.term and l2='la' )
Yeah, I know it returns null, but should be sorted by ifnull ?
EDIT: I see it now, it actualy returns nothing, not null.
How to write trigger for that ?