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. --------------------------------------------------------------------- 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