Re: Delete duplicate entry

[gerald_clark]

Daniel Kasak wrote:
gerald_clark wrote:
Batara Kesuma wrote:
Hi,
I have a table that looks like:
CREATE TABLE `message_inbox` (
 `member_id` mediumint(8) unsigned NOT NULL default '0',
 `message_id` int(10) unsigned NOT NULL default '0',
 `new` enum('y','n','replied') NOT NULL default 'y',
 `datetime` datetime default NULL,
 KEY `idx_1` (`member_id`,`new`),
 KEY `idx_2` (`member_id`,`datetime`)
) TYPE=InnoDB
Now, I want to add a primary key to it.
ALTER TABLE message_inbox ADD PRIMARY KEY (member_id, message_id)
But there are already some duplicated entries. ERROR 1062: Duplicate 
entry '10244-80871' for key 1

How can I tell MySQL to delete the duplicated entry and continue to 
make primary key? Is there any efficient way to do this? Thank you 
very much.
 

try ALTER IGNORE TABLE.

That hardly seems like a solution. If the above works, then I'd call 
that 'feature' a bug. 
What an odd statement.
The ignore option is there to allow you to create a unique index, 
discarding duplicates.
Since it does exactly what was asked for, why doesn't it seem like a 
solution.
Why is something that does what it was designed to do a bug?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]