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
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