Hi,
Yes, RTFM.
Your select result is too big for the configure tmp_table_size, and you are
not using --big-tables.
Regards
Quentin
-----Original Message-----
From: Chana Black [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 31 January 2001 09:13
To: [EMAIL PROTECTED]
Subject: Error upon order by with group by and join
Hi,
I am using mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686).
When I try to run the following query:
select tb1.fname, tbl1.lname, tbl2.appID, count(tbl2.appID) as count from
tbl1, tbl2 where tbl1.id = tbl2.appID group by tbl2.appID order by
tbl1.fname
I get the following error:
ERROR 1114: The table 'SQL2ae1_0' is full
Does anyone know what this means? How I can fix this?
Thanks,
Chana Black
---------------------------------------------------------------------
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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
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
