-Original Message-
From: Chris W [mailto:[EMAIL PROTECTED]
Sent: Monday, February 04, 2008 9:05 PM
To: Daevid Vincent; MYSQL General List
Subject: Re: Deleting duplicate rows via temporary table
either hung or taking way way too long
Daevid Vincent wrote:
DROP TABLE IF
Daevid Vincent wrote:
WOW! You are right! That's silly. It's a table with a single column. All
unique.
With out the index MySQL doesn't know they are unique.
Anyways, here's the magic incantation that worked for me:
DROP TABLE IF EXISTS `dupes`;
CREATE TEMPORARY TABLE dupes
SELECT LogID