MySQL Forums
Forum List  »  Newbie

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




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.