if I have a list of IDs (1,4,6,7) and a db table where I want to delete all records where ID is in this list, what is the way to do that?
Advertisement
Answer
Your question almost spells the SQL for this:
DELETE FROM table WHERE id IN (1, 4, 6, 7)