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 ?
Re: How to delete from SQLite
Thread moved from Android Development.
Define didn't work...are there exceptions? Are there rows with cat=21?
I've tried to many queries but they didn't work