Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Android SQlite update query

Tags:

android

sqlite

i have an update query where i need to pass multiple parameter. Please guide how to do. Here in place of "id" i want multiple parameters for example name age.

//Code

   ContentValues updateCountry = new ContentValues();
   updateCountry.put("country_name", "United States");
   db.update("tbl_countries", updateCountry, "id=?", new String[] {Long.toString(countryId)})
like image 644
Programmer Avatar asked Dec 04 '22 17:12

Programmer


1 Answers

Try

   ContentValues updateCountry = new ContentValues();
   updateCountry.put("country_name", "United States");
   db.update("tbl_countries", updateCountry, "id=? AND name=? AND age=?", new String[]{Long.toString(countryId),"name_value","age_value"});
like image 119
user936414 Avatar answered Dec 24 '22 15:12

user936414