MySQL Forums :: Newbie :: Strange result from DELETE query - can anyone explain?!


Advanced Search

Strange result from DELETE query - can anyone explain?!
Posted by: Chris Watts ()
Date: March 20, 2009 02:39PM

I have a table called "repairs" with multiple rows (let's say for the purposes of this post - from repair_id=1 through to repair_id=10)

Why does this query delete all rows from the table?

DELETE FROM repairs WHERE repair_id=3 OR 4

Any help much appreciated.

Options: ReplyQuote


Subject Written By Posted
Strange result from DELETE query - can anyone explain?! Chris Watts 03/20/2009 02:39PM
Re: Strange result from DELETE query - can anyone explain?! Lee Wood 03/20/2009 03:25PM
Re: Strange result from DELETE query - can anyone explain?! Jay Alverson 03/20/2009 04:17PM
Re: Strange result from DELETE query - can anyone explain?! Chris Watts 03/20/2009 04:19PM
Re: Strange result from DELETE query - can anyone explain?! Jay Alverson 03/20/2009 06:06PM
Re: Strange result from DELETE query - can anyone explain?! Rick James 03/20/2009 10:56PM
Re: Strange result from DELETE query - can anyone explain?! Jay Alverson 03/21/2009 07:14AM


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.