You have read the manual? http://www.mysql.com/doc/F/u/Full_table.html
Nathan Cook wrote:
>
> When I run this query on a 20,000 record table with 18 fields. The table
> has some identical entries and I am trying to get a count of those entries
> descending.
>
> SELECT
> email,
> fname,
> lname,
> count(email) as emailcount
> FROM
> referralSpace
> GROUP BY
> email
> ORDER BY
> emailcount ASC
> LIMIT
> 0,10
>
> I get the error: The table 'SQL4a5b_0' is full, Does this error mean a
> temporary table is full?
>
> What can I do to get this query to work.
>
> Thank You
>
> P.S. > The query works on an similar table with 10 fields 10,000 records.
---------------------------------------------------------------------
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
