Peter Van Dijck wrote:
Hi all,
I have a table like this
TABLE
----------
tagid
taggerid
objectid
There is a primary key on (tagid, taggerid, objectid).
First I remove that key, then I am changing the object id (because
I've changed my objects), but what happens now is that I suddenly have
duplicate (tagid, taggerid, objectid) rows.
Is there a way to remove duplicate rows like this?
Thanks for any pointers!!
Peter
Use
ALTER TABLE IGNORE
and put the key back.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
