MySQL Forums
Forum List  »  Newbie

Re: DELETE rows?
Posted by: Shah Sahab
Date: June 15, 2010 11:23PM

Great. Thanks.

I had about 743 total rows and there were no more than two rows with duplicate ids. After running your query, the total # of rows dropped down to 337 or something. From the nature of the problem, there is no way the total should have dropped below half of the previous total. I am concerned if it is deleting the rows with unique IDs as well. Can you confirm, and if so adjust the query for me please?

Options: ReplyQuote


Subject
Written By
Posted
June 15, 2010 08:53PM
June 15, 2010 10:38PM
Re: DELETE rows?
June 15, 2010 11:23PM
June 16, 2010 02:29AM
June 16, 2010 07:44AM
June 17, 2010 10:07PM
June 17, 2010 11:40PM
June 18, 2010 09:43AM
June 18, 2010 10:26AM
June 19, 2010 07:26AM


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.