I failed to mention that I have the problem descibed below in MySQL (3.23.36)
To repeat:
CREATE TEMPORARY TABLE TempTable ( ID int, Name char(100) ) TYPE=HEAP;
INSERT INTO TempTable VALUES( 1, "Foo bar" );
SELECT * FROM TempTable;
It returns NOTHING!!! The temporary table is created - if I try to run the first query again an error message states that the table exists... but I can't get any rows in return when I run SELECT * FROM TempTable;
As I understand it the temporary table exists as long as the connection is alive.
ANY ideas????
I'm SOOO FRUSTRATED!!!!
To repeat:
CREATE TEMPORARY TABLE TempTable ( ID int, Name char(100) ) TYPE=HEAP;
INSERT INTO TempTable VALUES( 1, "Foo bar" );
SELECT * FROM TempTable;
It returns NOTHING!!! The temporary table is created - if I try to run the first query again an error message states that the table exists... but I can't get any rows in return when I run SELECT * FROM TempTable;
As I understand it the temporary table exists as long as the connection is alive.
ANY ideas????
I'm SOOO FRUSTRATED!!!!