Re: Select distinct error!
| From: | Richard Lynch | Date: | Sat, 22 Sep 2001 02:59:24 +0000 |
| Subject: | Re: Select distinct error! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-68275@lists.php.net to get a copy of this message | ||
Whoops. Hit send too soon.
It could just be that your table is too darn big for select distinct on the
hardware you have...
What's your disk space like on MySQL's "data" drive?
df -h
You'll need to figure out which partition holds MySQL's data directory, and
see how much free space is there.
--
WARNING richard@zend.com address is an endangered species -- Use
ceo@l-i-e.com
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
----- Original Message -----
From: Sophokles Zafeiris <sofoklis@biznet.gr>
Newsgroups: php.general
To: <php-general@lists.php.net>
Sent: Thursday, September 20, 2001 9:28 AM
Subject: Select distinct error!
> Hi,
> I' m trying to execute a "select distinct" command on a table and I get
the
> following error:
> ERROR 1022: Can't write, duplicate key in table 'pmall'
> My table is about 2,7 MBytes.
> Does anybody knows what's wrong?
> I use MySQL 3.23.40 on a Solaris 7 (intel) machine.
>
> Sofoklis
>