mysql 触发器

mysql 触发器

// An highlighted block
drop trigger if exists fenxdata.tri_ims_ewei_shop_member;


delimiter ||
-- 创建触发器
create trigger tri_ims_ewei_shop_member after update on ims_ewei_shop_member for each row
begin

    update ims_ewei_shop_member set `level` = new.agentlevel where id = new.id;

end
||

delimiter ;