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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]