MySQL Forums
Forum List  »  Newbie

Re: How do you delete a duplicate row?
Posted by: Roland Bouman
Date: July 06, 2005 03:27AM

You can always delete both, and reinsert just the one. But in mysql, you can also do:

DELETE
FROM [your table]
WHERE [your criteria]
LIMIT [number of records you want to delete]

Options: ReplyQuote


Subject
Written By
Posted
Re: How do you delete a duplicate row?
July 06, 2005 03:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.