www.tutorialspoint.com Forum Index
Register FAQMemberlistUsergroupsTutorials PointLog in
Reply to topic Page 1 of 1
MySQL 4.0 Temporary Tables
Author Message
Reply with quote
Post MySQL 4.0 Temporary Tables 
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

View user's profile Send private message
Display posts from previous:
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum