That worked Perfect!!!
Thanks a ton!
On 11/8/05 11:27 AM, "Shen139" <[EMAIL PROTECTED]> wrote:
> ALTER IGNORE TABLE mytbl ADD UNIQUE KEY ( Name, email, sex, country ) ;
Rahul S. Johari
Coordinator, Internet & Administration
Informed Marketing Services Inc.
251 River Street
Troy, NY 12180
Tel:
Hi,
It¹s didn¹t work. I think I know why.
I have 5 fields in my table. ID, name, email, sex, country.
Although in the duplicate rows.. Name, email, sex & country values are
duplicate, the value in the ID column is different for each. It happened so
when people added their entry multiple times. Th
At 02:32 PM 7/30/2003, you wrote:
Group,
I have been working on a project for a while now trying to figure out how
to remove duplicate records from a single table using a query. To
complicate matters, what constitutes a duplicate record is a match on
several fields, but not all fields. I have
To select records only once try something like
select * from your_table
group by field1, field2, ..
Regards, Paul
Kim Mackey wrote:
> Group,
>
> I have been working on a project for a while now trying to figure out
> how to remove duplicate records from a single table using a query. To
D]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 31, 2003 11:41 AM
Subject: Re: Deleting Duplicate Records
> Kim Mackey wrote:
> > Group,
> >
> > I have been working on a project for a while now trying to figure out
> > how to remove duplicate records from a sin
Kim Mackey wrote:
Group,
I have been working on a project for a while now trying to figure out
how to remove duplicate records from a single table using a query. To
complicate matters, what constitutes a duplicate record is a match on
several fields, but not all fields. I have been successful
Unfortunately this is not the case.
Any other ideas?
Kim
If all these fields are defined as not NULL, simply
use alter table with the ignore option to add a unique key on all
pertainant fields.
Kim Mackey wrote:
Group,
I have been working on a project for a while now trying to figure out
ho
If all these fields are defined as not NULL, simply
use alter table with the ignore option to add a unique key on all
pertainant fields.
Kim Mackey wrote:
Group,
I have been working on a project for a while now trying to figure out
how to remove duplicate records from a single table using a qu
DuBois [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 4:32 PM
To: Natividad Castro; [EMAIL PROTECTED]
Subject: RE: Deleting duplicate records
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
On Mon, Mar 04, 2002 at 04:29:16PM -0500, 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?
I can think of others, but they're not nearly as easy or efficient.
Jeremy
--
Jeremy D. Zawod
Message-
>From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
>Sent: Monday, March 04, 2002 3:00 PM
>To: Natividad Castro
>Cc: [EMAIL PROTECTED]
>Subject: Re: Deleting duplicate records
>
>
>On Mon, Mar 04, 2002 at 02:48:06PM -0500, Natividad Castro wrote:
>
>> I
PROTECTED]
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 t
> 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
Why not just filter the data through uniq first?
~~~
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 n
14 matches
Mail list logo
