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;