MySQL Forums
Forum List  »  Memory Storage Engine

Alter Temporary table in Memory Issue.
Posted by: Ritu Tandon
Date: July 09, 2008 12:41AM


I am creating a temporary table in memory engine. Every time I call the procedure I drop these tables by checking if they already exist or not.

Now I am altering the table by adding some columns to this table. (These columns come on the basis of some results).

Now I use the Select * clause.

The first time it works fine. But 2nd time if my colmns change then even though I am dropping the earlier tables and creating the new ones I get the same old columns.

Is it because of some caching?


Options: ReplyQuote

Written By
Alter Temporary table in Memory Issue.
July 09, 2008 12:41AM
December 08, 2008 10:54PM

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.