Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: trigger problem
02-28-2013, 09:30 AM #1
- Join Date
- Dec 2005
- Thanked 79 Times in 79 Posts
before update trigger:
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 ?