Re: MySQL Newbie ? -Help!
| From: | Jason Brooke | Date: | Wed, 10 Jan 2001 04:39:25 +0000 |
| Subject: | Re: MySQL Newbie ? -Help! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-33618@lists.php.net to get a copy of this message | ||
one simple way would be to make a duplicate, empty table and then do:
insert into newtable select distinct * from oldtable
then try adding a uniqueness constraint if you don't want duplicates in the
future
jason
> Hi,
> Is there a way to go through a table and remove all duplicate entries so
> that there is only one? The way I am doing it now is taking FOREVER.
Thanks,
>
> Matt Stone