mysql提供了触发器功能。
以下为触发器创建语句
create trigger trigger_buy_credits
after insert on buy
for each row
update user set credits=credits+100 where id = new.user_id
触发器删除语句
drop trigger_buy_credits
mysql提供了触发器功能。
以下为触发器创建语句
create trigger trigger_buy_credits
after insert on buy
for each row
update user set credits=credits+100 where id = new.user_id
触发器删除语句
drop trigger_buy_credits