Android SQLite: Update Statement

Question

I need to implement SQLite in my application. I followed this tutorial... Creating and using databases in Android one

Everything is working fine. I inserted 1 row with 5 columns. Now I want to update the value of 1 column only and others will remain the same.

There is one update method in the tutorial but it needs all the parameters, however, I want to update only one column.

Answer 1

You can use the code below.

String strFilter = "_id=" + Id;

ContentValues args = new ContentValues();

args.put(KEY_TITLE, title);

myDB.update("titles", args, strFilter, null);