Gopal
Gopal

Reputation: 745

Error while creating trigger

delimiter #

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

Why is this showing error - unknown system variable 'begin'

Upvotes: 0

Views: 34

Answers (1)

wchiquito
wchiquito

Reputation: 16551

Change for each row set by for each row.

Upvotes: 2

Related Questions