Chand [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 11:27 AM
To: Jeff McKeon; [EMAIL PROTECTED]
Subject: RE: Deleting duplicating records
Well that is OK if I have only one email.
What if if I have thousands of users duplicated...
Do I need to write SQL query 1000 times
Karam
--- Jeff
Engineering
Test Data Management Group
6824-1367
Karam Chand <[EMAIL PROTECTED]>29/07/2003 01:13 AM
To: Venelin Arnaoudov <[EMAIL PROTECTED]>, [EMAIL PROTECTED],
[EMAIL PROTECTED]
cc: [EMAIL PROTECTED], (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: Re: Deleting duplica
&& ID <> 1
>
> Jeff
> > -Original Message-
> > From: Karam Chand [mailto:[EMAIL PROTECTED]
>
> > Sent: Monday, July 28, 2003 10:33 AM
> > To: [EMAIL PROTECTED]
> > Subject: Deleting duplicating records
> >
> >
> > G
on <[EMAIL PROTECTED]> wrote:
> >
> >
> >>How bout
> >>
> >>Delete from tablename where email like
> >>[EMAIL PROTECTED] && ID <> 1
> >>
> >>Jeff
> >>
> >>
> >>>-Ori
t;>>-----Original Message-
> >>>From: Karam Chand
> [mailto:[EMAIL PROTECTED]
> >>>
> >>>
> >>>Sent: Monday, July 28, 2003 10:33 AM
> >>>To: [EMAIL PROTECTED]
> >>>Subject: Deleting duplicating records
> >>>
D]
Subject: Deleting duplicating records
Greetings
I manage a website wherein i keep track of the
people
email who have downloaded my software and the
version
number.
the structure is like -
id int auto_increment primary key,
email char,
version
now the same person can downlo
mp;& ID <> 1
>
> Jeff
> > -Original Message-
> > From: Karam Chand [mailto:[EMAIL PROTECTED]
>
> > Sent: Monday, July 28, 2003 10:33 AM
> > To: [EMAIL PROTECTED]
> > Subject: Deleting duplicating records
> >
> >
> > Greetings
>
How bout
Delete from tablename where email like [EMAIL PROTECTED] && ID <> 1
Jeff
> -Original Message-
> From: Karam Chand [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 10:33 AM
> To: [EMAIL PROTECTED]
> Subject: Deleting duplicating records
&g
Greetings
I manage a website wherein i keep track of the people
email who have downloaded my software and the version
number.
the structure is like -
id int auto_increment primary key,
email char,
version
now the same person can download different version
therfore my table has data like this -