Re: Problem in creating temporary tables

[Shafi Shaik]

Hi,

May be you can't retrieve the data from tempoary tables which are stored inside memory Engine.

So, I have created it in a procedure and it works fine. Hope it will help you.

DELIMITER $$

DROP PROCEDURE IF EXISTS `DB`.`mem_test` $$
CREATE PROCEDURE `DB`.`mem_test` ()
BEGIN

CREATE TEMPORARY TABLE tmpTEST(num VARCHAR(10), src CHAR(1), INDEX USING HASH (num)) ENGINE = MEMORY
SELECT * FROM tmpList;

SELECT * FROM tmpTEST;

END $$

DELIMITER ;

now call the procedure and it returns the values.

CALL mem_test();

bye