Simple DELETE statement did not work in SQlite [duplicate]

Question

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 ?

Answer 1

db.execSQL("DELETE FROM tbl1 where cat=12");

Answer 2

try this

public void deleteContact(Contact contact) {
    SQLiteDatabase db = this.getWritableDatabase();
    db.delete(TABLE_CONTACTS, KEY_ID + " = ?",
            new String[] { String.valueOf(contact.getID()) });
    db.close();
}