Update all rows in database

Question

What is the effective way to update all records in the database. I try to update all rows for the same key independent from table id, like this:

 for (int i = 0 ; i < rowsCount ; i++) {
      cv.put(column2, columnValue[i]);
      cv.put(column3, columnValue[i]);
      db.update(tableName, cv, null, null);
}

Update: I can't know the id values. The id values in the database looks like this: 1, 22, 50, 67 etc.

I can not know the id value, therefore I need a solution to update all column cells independent from id. — Sam Joos, Dec 15 '16 at 20:06
So you need to update the table with insert into table independently of the id? Then just don't use the where statement like this: — Alberto, Dec 15 '16 at 20:48
String strSQL = "UPDATE theTable SET Column1 = someNewValue; myDataBase.execSQL(strSQL); — Alberto, Dec 15 '16 at 20:53
What I did in my code, update all records with the same value. How can I add all columns values to the all records without using id. — Sam Joos, Dec 16 '16 at 09:03
Just do what i said, dont punt the where statement! :) see my last part of the answer and see this documentation: http://www.w3schools.com/sql/sql_update.asp — Alberto, Dec 16 '16 at 22:14
This is your last part of your answer [WHERE Id = "+ someValueInStrType(someid);]. I said that I do not know the id, so I can not use your code. — Sam Joos, Dec 17 '16 at 05:39
Oh sorry, I edited the answer like 2 days ago but I didn't saved. Now the answer is updated, check it! — Alberto, Dec 18 '16 at 02:38
But this is easy to invoke execSQL() for each value. What I meant, if there is an effective way to update all tables, that means with one call for execSQL or Database.update. — Sam Joos, Dec 19 '16 at 13:23

Alberto · Answer 1 · 2016-12-19T13:30:42.460

0

Updated:

String strSQL = "";

//Get the id that u want
String strSQL = "UPDATE theTable SET Column1 = someNewValue; UPDATE theTable SET Column1 = someNewValue;";
myDataBase.execSQL(strSQL);

Use ";" separator for each update that u want to introduce.

edited Dec 19 '16 at 13:30

answered Dec 15 '16 at 18:35

Alberto

1,423
18
32

The solution here is depended on whereClause. I have different id values, for example 1, 22, 50 etc. – Sam Joos Dec 15 '16 at 18:39
The second link is for different keys that means for all columns in one row. – Sam Joos Dec 15 '16 at 18:46

Update all rows in database

1 Answers1

Updated: