November 29th, 2012, 07:23 AM
How to delete from SQLite
Hi every one
i want to run a delete query with limitation .
I've tried to many queries but they didn't work .
For know , I just want to remove all the rows and I write this code "
DELETE FROM tbl1 where _id IN(select _id from tbl1 WHERE cat=21)
The emulator runs perfectly without any error .
right now , I have 32 rows with cat = 21 .
could you help me to solve this problem ?
January 8th, 2013, 12:54 AM
The delete query only allows for modifiers after the DELETE 'command' to tell the database what/how do handle things.