Re: quick sql question

[Paul DuBois]

At 17:54 -0400 5/10/02, Augey Mikus wrote:
>what i meant is deleting duplicate occurences of records of a 
>certain field. ...sorry...

Ah.

One thing you can do is add a unique index on that field with
ALTER IGNORE TABLE tbl_name ADD UNIQUE (col_name)
or
ALTER IGNORE TABLE tbl_name ADD PRIMARY KEY (col_name)

and MySQL will clobber duplicate records as it builds the index.

>
>
>Paul DuBois wrote:
>
>>At 17:16 -0400 5/10/02, Augey Mikus wrote:
>>
>>>what is the simplest way to delete duplicate occurences of a 
>>>specific field in mysql?
>>>
>>>thanks,
>>>
>>>augey
>>
>>
>>Your question is a bit ambiguous.  You could do this by using ALTER
>>TABLE to remove the column itself from the table, for example, but
>>I'm guessing maybe that's not what you mean.