MySQL loses KEY Info after CREATE TEMP..

admin

Administrator
Staff member
Hi,

I found this:

After a
"CREATE TEMPORARY TABLE A SELECT * FROM A"
Statement, the new temptable lost all KEY information. Check "DESCRIBE A" before and after creating it!

Can anyone confirm this? Is there any reason for that?? I NEED the KEY info in my temp tables!!

Thanks
Thomas
 
Back
Top