On Fri, Feb 16, 2001 at 09:55:32AM +0100, Chappuis J.-Vincent wrote:
> Hi,
> I have this error when I execute a query : ERROR 1114: The table 'SQLb07dc_0' is full
> I can execute other queries without problems but when I want to execute the query :
>
> SELECT DISTINCT person.*
> FROM person, training, cursus
> where training.BRANCH_ID=101
> and training.CURSUS_SID=cursus.CURSUS_SID
> and cursus.STUDENT_SID=person.PERSON_SID;
>
> there is always the same error message.
> How can I do to reset the table 'SQLb07dc_0' or to reset the sql buffer ?
>
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.
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
