Have to create a temp table to view in a procedure
<p>Procedure summary: I have created a cursor and extracted data and inserted in a table mm_dummy_table which i created in my db.
I do not want the data to be stored in a created table,a temporary table should be created for that moment and it should get disappeared. Please help in creating a temp table to view the data i extracted in the cursor.how can i get only people having A in their names without using condition where user_username like '%a%'.please help me in this ..</p>

<pre class="lang-sql prettyprint-override"><code>DELIMITER //

CREATE DEFINER=root@localhost PROCEDURE PRO_ABC_DUMMY()
BEGIN
    declare v_user_id int;
    declare v_username varchar(100);
    declare dummy_cur cursor for
    SELECT user_id, user_fullname
    FROM m_users
    WHERE User_FullName LIKE '%a%';

    open dummy_cur;

    BLOCK1:BEGIN
        DECLARE EXIT HANDLER FOR NOT FOUND BEGIN END;
        LOOP1:LOOP
            fetch dummy_cur into v_user_id, v_username;
            insert into mm_users_dummy (user_id, user_name)
            values
            (v_user_id, v_username);
        END LOOP loop1;
    END BLOCK1;

    CLOSE dummy_cur;
END//

DELIMITER ;
</code></pre>