RE: [PHP] MySQL Newbie ? -Help!
| From: | Matt Stone | Date: | Wed, 10 Jan 2001 04:57:30 +0000 |
| Subject: | RE: [PHP] MySQL Newbie ? -Help! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-33620@lists.php.net to get a copy of this message | ||
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:jason@qgl.org]
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: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net