Trigger Count Insert and delete

Question

I have a problem in a Rigger that I have here, I want this Rigger after counting and inserting in table x, it deletes the value he searched in table y, can make him count and insert but I’m not able to make him count, insert and then delete.

My code:

BEGIN
    UPDATE g5_member 
    set mb_credit = mb_credit + (ROUND(RAND()*10,0)%7) + 10 
    WHERE mb_id = NEW.PlayerID;
    DELETE FROM PlayerID;
END