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.
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Systems & Network Administrator :: Programmer
[ phone - 208.343.3110 ][ pager - 208.387.9983 ]
---------------------------------------------------------------------
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
