|
|
| nearestElementary | varchar(40) | | ||
|
| registrationDate | date | | | -00-00 |
|
| fextension| int(4) | | | 0 |
|
| mextension| int(4) | | | 0 |
|
| eextension| int(4) | | | 0 |
|
| yearstamp | int(4) | | | 0 |
|
| seasonstamp | varchar(10) | | ||
|
| ageGroup | tinyint(2) | YES | | NULL |
|
| comment | varchar(255) | YES | | NULL |
|
| seasonPlayed | varchar(255) | YES | | NULL |
|
+---+--+--+-++--
--+
48 rows in set (0.00 sec)
-Original Message-
From: Almar van Pel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 9:33 AM
To: Mayo, Chuck
Cc: [EMAIL PROTECTED]
Subject: RE: JOIN and Table Full error
Hi,
Your setting tmp_table_size is probably very low. (something like 1048576)
Try increasing your value to 2M or 4M, and you might want to increase your
key_buffer as wel to 16M.
I would also like to advise you to rephrase your query to something that
looks like:
select * from players inner join on roster Roster.playerId=Players.id order
by player.plast limit 1,10
or use a left join.
The above query syntax uses less memory.
select * from Players,Roster where Roster.playerId=Players.id order by
Players.plast limit 1,10
Regards,
Almar van Pel
-Oorspronkelijk bericht-
Van: Mayo, Chuck [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag, december 13, 2001 04.11
Aan: '[EMAIL PROTECTED]'
Onderwerp: JOIN and Table Full error
Hi all,
I'm pretty new with MySQL and am trying to implement my first join. All
works as expected until I try to order the output with an order by clause;
select * from Players,Roster where Roster.playerId=Players.id order by
Players.plast limit 1,10
and I receive an error from the MySQL interpreter;
ERROR 1114: The table 'SQLe1b02_0' is full
I have no tables by that name, must be a temp? There seems to be ample space
in my filesystem, can someone tell me why this is happening and, even
better, how to fix it?
-
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
-
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