MySQL Forums
Forum List  »  Memory Storage Engine

Re: Problem in creating temporary tables
Posted by: Shafi Shaik
Date: July 11, 2007 05:43AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
8360
April 22, 2007 02:25AM
Re: Problem in creating temporary tables
4588
July 11, 2007 05:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.