At 18:13 -0400 5/10/02, Augey Mikus wrote: >so i suppose an automatic delete of every duplicate record is out of >the question :-)
Sounds like you're trying to have it both ways. > >Paul DuBois wrote: > >>At 18:00 -0400 5/10/02, Augey Mikus wrote: >> >>>is there a way for me to do it in a mysql delete statement? just >>>out of curiosity, for instance, if i wanted to add duplicates >>>later for whatever reason. >> >> >>Okay, let's suppose you have 3947 instances of "abc". >>You can use LIMIT for this: >> >>DELETE FROM tbl_name WHERE col_name = "abc" LIMIT 3946; >> >>> >>>Paul DuBois wrote: >>> >>>>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
