1137: Can't reopen table: 'mj_tmp_diag' --- This is T1
Is it that I can't use two temporary tables this way?
What can I do to solve this problem?
The error shows when I execute the whole query under MySql Control
Center.
Mysql version is 4.1
Thanks in advance ,
Mauricio
--
MySQL General
). At this point I get the message
ERROR 1137: Can't reopen table: 'mj_tmp_diag' --- This is T1
Is it that I can't use two temporary tables this way?
Right. See:
http://dev.mysql.com/doc/mysql/en/Temporary_table_problems.html
What can I do to solve this problem?
Don't use a TEMPORARY table