Uhh.... not really, the table has about 30000 entries. Don't really want to
risk anything.
I want to know how to do it through a MySQL statement, not a php script.
-----Original Message-----
From: Jason Brooke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 10 January 2001 2:39 PM
To: Matt Stone; PHP List
Subject: Re: [PHP] MySQL Newbie ? -Help!
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]
--
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]
