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
Post a Comment