MySQL Forums
Forum List  »  Newbie

Re: delete with the "in ()" clause and NULL
Posted by: Wim Roffel
Date: September 06, 2020 09:23AM

SO if I understand it right if I do the following two command the records with NULL values will not be deleted:

DELETE FROM mytable WHERE myfield IN (1,2,3)

DELETE FROM mytable WHERE myfield NOT IN (1,2,3)

Options: ReplyQuote


Subject
Written By
Posted
Re: delete with the "in ()" clause and NULL
September 06, 2020 09:23AM


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.