List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 4 2002 9:32pm
Subject:RE: Deleting duplicate records
View as plain text  
At 16:29 -0500 3/4/02, Natividad Castro wrote:
>Thank you very much!! that was very helpful. By the way, is there any other
>way to get rid of duplicate records from a text file?

What's wrong with the command Jeremy suggested?

>
>Thanks again
>Nato
>
>-----Original Message-----
>From: Jeremy Zawodny [mailto:jzawodn@stripped]
>Sent: Monday, March 04, 2002 3:00 PM
>To: Natividad Castro
>Cc: mysql@stripped
>Subject: Re: Deleting duplicate records
>
>
>On Mon, Mar 04, 2002 at 02:48:06PM -0500, Natividad Castro wrote:
>
>>  I'm new using mysql. I'm trying to load data from a text file to one
>>  of my table. This text file contains duplicate records. My question
>>  is how do you tell mysql to delete duplicate records and load just
>>  the ones that are not duplicate? I already tried the REPLACE and
>>  IGNORE key words but is I dont get the result that I want.  Any idea
>
>If the data is in a text file, elimiate the duplicates before MySQL is
>even involved:
>
>   cat myfile.txt | sort | uniq > nodups.txt
>
>Jeremy
>--
>Jeremy D. Zawodny, <jzawodn@stripped>
>Technical Yahoo - Yahoo Finance
>Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
>
>MySQL 3.23.47-max: up 25 days, processed 842,341,115 queries (386/sec. avg)

Thread
Deleting duplicate recordsNatividad Castro4 Mar
  • Re: Deleting duplicate recordsJeremy Zawodny4 Mar
    • RE: Deleting duplicate recordsNatividad Castro4 Mar
      • RE: Deleting duplicate recordsPaul DuBois4 Mar
        • RE: Deleting duplicate recordsNatividad Castro5 Mar
      • Re: Deleting duplicate recordsJeremy Zawodny5 Mar
  • Re: Deleting duplicate recordssupport@webmastersguide.com4 Mar