mysql - Error while creating trigger -


delimiter #  create trigger update_recharge_due_onrenewal after insert on recharge each row set begin update due_amount set due_amount.amount=due_amount.amount-(select rate internet_package recharge.package_id = internet_package.package_id) due_advance.user_id = recharge.user_id; end;# 

why showing error - unknown system variable 'begin'

change for each row set for each row.


Comments

Popular posts from this blog

css - Which browser returns the correct result for getBoundingClientRect of an SVG element? -

gcc - Calling fftR4() in c from assembly -

Function that returns a formatted array in VBA -