Mysql cancel insert record

BEGIN declare pCountAppPoint int default 0; -- Check update app point for upload avatar if NEW.point_type=4 then SET pCountAppPoint= (select count(member_id) from h247app_points where point_type=4 and source_id=NEW.source_...