Untitled

BEGIN    DECLARE rowcount INT DEFAULT 0;    DECLARE rowcount_temp INT DEFAULT 0;        DELETE FROM friend        WHERE character1_id = char_id        AND character2_id = friend_id;    SELECT row_count() INTO rowcount_temp;    IF (rowcount_temp > 0)        SET rowcount = rowcount + rowcount_temp;                <---------    DELETE FROM friend    WHERE character1_id = friend_id        AND character2_id = char_id;    SELECT row_count() INTO rowcount_temp;    IF (rowcount_temp > 0)        SET rowcount = rowcount + rowcount_temp;    SELECT rowcount;END