> I tried this and doesn't work unforunately. I get "ERROR: Duplicate
> entry..." that occurs when copying from the temporary table back into
> the original table.
> Is there a way to do this, to copy a single record, without moving the
> primary key into the temporary table so I can avoid this
I tried this and doesn't work unforunately. I get "ERROR: Duplicate
entry..." that occurs when copying from the temporary table back into
the original table.
Is there a way to do this, to copy a single record, without moving the
primary key into the temporary table so I can avoid this error?
Ar
Ari Denison wrote:
I have a need to duplicate individual records in a table with a large
number of fields.
This is not part of a backup or restore process. I simply need to be
able to duplicate a record or two on occasion.
Is there an efficient way to do this?
I obviously don't want to duplic
I have a need to duplicate individual records in a table with a large
number of fields.
This is not part of a backup or restore process. I simply need to be
able to duplicate a record or two on occasion.
Is there an efficient way to do this?
I obviously don't want to duplicate keyfields, just
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 -
Is it possible to duplicate a record in a table into the same table with a changed
field? I have a single user who now has authority over an additional database. I
wanted to duplicate the records in myslq.db for this user, changing the Db field to
the name of the additional database.
I searched
14 matches
Mail list logo
