Android SQLite database update method

Question

Maybe this question has been answered but I cannot find it, so:

In SQLiteDatabase update method,

int android.database.sqlite.SQLiteDatabase.update(String table, ContentValues values, String whereClause, String[] whereArgs)

What will happen if the WHERE clause does not exists?. I mean does not return any row, it will perform a normal insert, or do nothing?

EDIT

I think I did not explain it correctly.

Suppose this SQL:

CREATE TABLE weight (weight REAL, date TEXT);

INSERT INTO weight VALUES (78.5,"10/03/2013");
INSERT INTO weight VALUES (68.5,"09/03/2013");
INSERT INTO weight VALUES (79.5,"08/03/2013");

And now suppose this code:

ContentValues values = new ContentValues();
values.put("weight", 90.2);
db.update("weight",values, "date = '15/03/2013'",null);

NOTICE that there is no row with date = '15/03/2013' so, what happen in that case (that was what I wanted to mean) it will insert or do nothing?

It says right in the docs for the parameter 'whereClause' developer.android.com/reference/android/database/sqlite/…, android.content.ContentValues, java.lang.String, java.lang.String[]) — Thomas Dignan
– Thomas Dignan, Commented Mar 17, 2013 at 12:48

Pragnani Kinnera · Accepted Answer · 2013-03-17 13:59:03Z

1

Edit:

It will check is there a row with date = '15/03/2013 if there is no row, then no rows will effect, and the update method will return 0

If I understand your question, Where claus is optional, it may be null, if you don't provide where clause it will update all the rows in a table.

It is just a sql thing, like if you don't supply where condition it will update all rows. documentation clearly says that,

Parameters

whereClause the optional WHERE clause to apply when updating. Passing null will update all rows.

SqlliteData Update

edited Mar 17, 2013 at 13:59

answered Mar 17, 2013 at 12:49

Pragnani Kinnera

20.2k6 gold badges54 silver badges76 bronze badges

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

Comments

StarsSky · Accepted Answer · 2013-03-17 12:49:59Z

0

if you don't use the WHERE clause all the records on the table will be affected

whereClause the optional WHERE clause to apply when updating. Passing null will update all rows.

answered Mar 17, 2013 at 12:49

StarsSky

6,6996 gold badges40 silver badges63 bronze badges

Collectives™ on Stack Overflow

Android SQLite database update method

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related