delete a row in SQLite with a value of null

Question

I am trying to delete all rows in an SQLite Database where the Id = null

Here is my code :-

public void deleteNullSongs() {

    SQLiteDatabase db = this.getReadableDatabase();

    String sql = String.format("ID=%s", null);

    db.delete(TABLE_NAME, sql, null);
}

But it does not delete any vlues can't work out what is wrong ?

I have tried different ways of doing this but when i print the contents of the database the rows are still there

Marcin Orlowski · Accepted Answer · 2016-12-07 19:33:12Z

1

You should use IS NULL in your where clause:

db.delete(TABLE_NAME, "ID IS NULL", null);

answered Dec 7, 2016 at 19:33

Marcin Orlowski

75.7k11 gold badges128 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andy Cass Over a year ago

Doh Thanks Marcin

Collectives™ on Stack Overflow

delete a row in SQLite with a value of null

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related