At 17:10 -0700 7/5/04, Mauricio Pellegrini wrote:
Hi,
I have this pretty complex query which uses two temporary tables.
The first temporary table ( T1 ) is created as a result from query 'A'
The second temporary table is created as result from a query based upon
temporary table one ( T1 ). 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. :-)
The error shows when I execute the whole query under MySql Control
Center.
Mysql version is 4.1
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]