I tried to create a temporary memory table using the following:
CREATE TEMPORARY TABLE mytable_tmp LIKE mytable ENGINE=MEMORY;
However, I encountered a problem in that MySQL didn't like this
statement with the clause "ENGINE=MEMORY". If I remove this clause,
all is fine. However, I wanted the temporary table to be a memory
table, though, for the sake of speed. I suspect I may have to process
some of the data before moving it to its final destination.
The statement above clearly shows what I want to do at this stage. Can
I do it this way, or do I have ...