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)
