Google Answers: Deduping MySQL database

View Question

Q: Deduping MySQL database ( No Answer, 3 Comments )

Question

Subject: Deduping MySQL database
Category: Computers
Asked by: macrodisc-ga
List Price: $20.00

Posted: 14 Feb 2005 09:28 PST
Expires: 16 Mar 2005 09:28 PST
Question ID: 474370

How do I remove duplicate entries in a MySQL database (around 30
fields of data) using values in two fields for identifying dupes? If
the 'Name' and 'Email' fields match, then they will be considered
duplicates and one of the entries (does not matter which) needs to be
removed in order to leave only unique records.

Answer

There is no answer at this time.

Comments

Subject: Re: Deduping MySQL database
From: xarqi-ga on 14 Feb 2005 23:25 PST

Will this work for you?
http://free.netartmedia.net/Databases/Databases8.html

Subject: Re: Deduping MySQL database
From: dikw-ga on 15 Feb 2005 04:18 PST

Is the question answered?

I guess it would miss out dupes like:
Name:Bill Add:Boston
Name:Bill Add:Bostom

Subject: Re: Deduping MySQL database
From: macrodisc-ga on 15 Feb 2005 09:26 PST

Actually that is exactly what I was looking for. Thank you.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.

Search Google Answers for

Google Home - Answers FAQ - Terms of Service - Privacy Policy