On Tue, Feb 19, 2002 at 09:50:57AM +0200, Mohamed Abd El-Samei Mohamed wrote:
> mysql> insert into table1 select distinct field1 , MIN(field2) from table2
> where field2 >="2001-12-01 00:00:00" group by field2 ;
> ERROR 1114: The table 'SQLb73d_0' is full
> mysql>
>
I've seen this when MySQL uses an internal table for temporary data.
There is a limit on the size of these tables. You can force MySQL to
use a file in its temporary directory to store the results:
set SQL_BIG_TABLES = 1;
An alternative is to do a SELECT SQL_BIG_RESULT ... instead of
SELECT ... . Note that SELECT SQL_BIG_RESULT doesn't work in 3.22.x,
though it is accepted by the parser. You don't mention which version
you use. 'set SQL_BIG_TABLES' works fine in 3.22.x.
Note that if I'm correct, you're using a very old version of MySQL.
You might consider an upgrade.
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
