| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Robert A. Rosenberg | Date: | July 11 2004 2:09am |
| Subject: | RE: Weeding out duplicates | ||
| View as plain text | |||
At 17:25 -0600 on 07/09/2004, Jonathan Duncan wrote about Re: Weeding out duplicates: >For the information of someone who may need it in the future. I used >Jeffrey's idea for determining duplicates. Then I created a temporary >table, and used insert...select to put the id's of the duplicates in the >temporary table. Then it was a simple "delete from table where >temp.id=table.id". > >Thanks for the help. > >Jonathan Duncan I responded to your query earlier with a PHP/MySQL solution that was equivalent to this. I only saw your reply after sending my suggestion. Sorry for giving you an answer you had already discovered.
| Thread | ||
|---|---|---|
| • Weeding out duplicates | Jonathan Duncan | 8 Jul |
| • RE: Weeding out duplicates | Lachlan Mulcahy | 9 Jul |
| • Re: Weeding out duplicates | jeffrey_n_Dyke | 9 Jul |
| • Re: Weeding out duplicates | Jonathan Duncan | 9 Jul |
| • RE: Weeding out duplicates | Jonathan Duncan | 9 Jul |
| • RE: Weeding out duplicates | Robert A. Rosenberg | 11 Jul |
| • RE: Weeding out duplicates | Jonathan Duncan | 10 Jul |
| • RE: Weeding out duplicates | Robert A. Rosenberg | 11 Jul |
| • RE: Weeding out duplicates | Jonathan Duncan | 12 Jul |
| • RE: Weeding out duplicates | SGreen | 14 Jul |
