Simple DELETE statement did not work in SQlite
android, sql-delete, sqlite
Solution
db.execSQL("DELETE FROM tbl1 where cat=12");
Problem
Possible Duplicate: Android Delete Query I've db and right now it has 17 records. This is my code: ``` SQLiteDatabase db=openOrCreateDatabase("mydb", MODE_PRIVATE, null); c= db.rawQuery("DELETE FROM tbl1 where cat='12'",null); db.close(); ``` It's a really simple query but every time I run the app on emulator, it's runs perfectly without any error but I doesn't remove anything either. Could anyone helps me with what is the problem ?