Re: php/MYSQL remove duplicate records
| From: | Jason Davidson | Date: | Tue, 14 Sep 2004 23:31:27 +0000 |
| Subject: | Re: php/MYSQL remove duplicate records | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-196666@lists.php.net to get a copy of this message | ||
you could select out all the DISTINCT email addresses, and delete the
table, and repopulate it with your selected rows add a constraint to
the table to make email column unique afterwards maybe.
Jason
Dustin Krysak <mailinglists@digitalcollision.com> wrote:
>
> Hi there - I have an extremely simple table that has a unique Id and an
> email address..... what I am looking for is an example of a PHP script
> that will poll the MYSQL database and delete the duplicate records
> leaving only 1 unique (email) record.
>
> can someone point me to the right place?
>
> thanks!
>
> d
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>