lundi 15 juin 2015

Sqlite NOT IN Syntax

I'm doing an audit of one of my Android apps, and I noticed something peculiar.

I have a list of IDs, and I want to remove all rows from a table that don't have an _id in that list.

I would think the correct syntax be:

DELETE FROM table WHERE _id NOT IN...

However, my code has:

DELETE FROM table WHERE NOT _id IN...

Are these equivalent, or will the second statement do something unexpected?

Aucun commentaire:

Enregistrer un commentaire