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