MySQL Forums
Forum List  »  Newbie

Re: DELETE rows?
Posted by: Shah Sahab
Date: June 17, 2010 10:07PM

I found out the problem. It is my fault. I misinformed you guys. The problem is that in some of the rows the value of number is the same as well, in addition to the same id. In this case, the query deletes both of the rows. Is there any way to make it delete only one of them in this case? Actually I also have another column called indx (index of the row - auto-incremented). Could that help? May be delete the larger index one and keep the smaller one? Any help will be appreciated.

Options: ReplyQuote


Subject
Written By
Posted
June 15, 2010 08:53PM
June 15, 2010 10:38PM
June 15, 2010 11:23PM
June 16, 2010 02:29AM
June 16, 2010 07:44AM
Re: DELETE rows?
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.