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
Hi,
I used the following SQL Query to determine Duplicate Records with same Name
& Email in the row:
SELECT email,
COUNT(email) AS NumOccur1, name, COUNT(name) AS NumOccur2
FROM mytbl
GROUP BY name, email
HAVING ( COUNT(email) > 1 ) AND ( COUNT(name) > 1 )
I want to delete all the records whi
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
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 in matching
all
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
Hi to all,
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 b
17 matches
Mail list logo
