Advertisements

MySQL 4.0 Temporary Tables

Postby kmk » Fri Jul 04, 2008 9:38 am

Offline
kmk
Posts: 1
Joined: Fri Jul 04, 2008 9:07 am
Why can't i see a temporary table created in MySQL 4.0?
CREATE TEMPORARY TABLE TEMPEMP AS SELECT * FROM EMP;
This query is executed without error. But if the following is executed, table does not exist error is displayed:
select * from tempemp;

Is there a rights problem involved?
Can someone help me here?

regards,

kmk