new g2d table is what you want you can
safely drop your g2d_old table.
HTH,
Lachlan
-Original Message-
From: Jeroen Van Goey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 11 August 2004 9:16 PM
To: [EMAIL PROTECTED]
Subject: removing duplicates and giving average of other field.
Hi again
ED]
Sent: Wednesday, 11 August 2004 9:16 PM
To: [EMAIL PROTECTED]
Subject: removing duplicates and giving average of other field.
Hi again,
thanks for the quick reply on my previous question, the solution given
by Michael Stassen worked like a charm. But now I've again run into a
situat
Hi again,
thanks for the quick reply on my previous question, the solution given
by Michael Stassen worked like a charm. But now I've again run into a
situation where I'm stuck with my limited knowledge of MySQL.
Given the table:
mysql> select * from g2d;
+---+--+--+--
06/18/2004 10:02 Subject: RE: Fastest way to load a
master table removing duplicates -
Appreciate any help at all
Thanks, Paul
-Original Message-
From: Paul Chu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Fastest way to load a master table removing duplicates
Hi all,
I want to load a Master table millions of rows
Hi all,
I want to load a Master table millions of rows for other sources with a
unique index on e.g. ssn social sec number.
If inserted records have a duplicate SSN I don't want to insert those
but put them in a duplicate table or flag them.
.
The primary key will be an auto-increment fiel
hi!
i have a table with alot duplicates in them. the tables has about 2
million rows
and i expect that there are ca. 20.000 duplicates which have to be removed..
what i basicly wanna do is:
delete rows from that table which have the same value on the column col1,
col2 and col3 of that table.
on 3/8/01 3:40 PM, Scott Wang at [EMAIL PROTECTED] wrote:
> select distinct addr from tablename outfile filename.txt
>
> But how can I write the data to another table or even
> replace the information in the table with the output info?
insert into (addr) select distinct addr from
You would p
Hi guys,
I set up a table that I'll be using for a mailing list. Two
fields: id and addr. The id is a unique primary key that
is used to "identify" (?) the email address in the addr
field.
How can I remove duplicate addresses in the addr field?
I know of the
select distinct addr from tabl
