How to Update Multiple Rows in a Android Database?

Question

First time using an Android database for my application. I've researched update statements and I keep seeing examples using a single row ID to update but what if I use a composite key? The only way to find a unique row is with a season number and team name and my database. So I need to create a statement like..

UPDATE table_name
SET wins=5, losses=3
WHERE Team_Name='Something' AND Season='1;

Is this possible? There could be multiple rows(around 8), I would need to do this at a time. And would probably use variables for team name and what not. Thanks for any help.

for your info you can do almost everything in sqlite database as you do in MySQL except some data type restrictions — TheMohanAhuja
– TheMohanAhuja, Commented May 8, 2014 at 14:09

Linger · Accepted Answer · 2014-05-08 14:05:46Z

2

Yes it is possible. If your season is a string then you would use:

UPDATE table_name 
SET wins = 5, losses = 3 
WHERE Team_Name = 'Something' 
AND Season = '1'

However, if your season is a number then you would use:

UPDATE table_name 
SET wins = 5, losses = 3 
WHERE Team_Name = 'Something' 
AND Season = 1

answered May 8, 2014 at 14:05

Linger

15.1k23 gold badges54 silver badges79 bronze badges

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

3 Comments

Timeflies Over a year ago

So could I just create a String with the update query within a method and at the end db.execSQL(QueryString)

Linger Over a year ago

Yes, execSQL(String sql)is for executing a single SQL statement that is NOT a SELECT or any other SQL statement that returns data.

CL. Over a year ago

You have SQL Server running on an Android device? What is it with all those tag updates?

Collectives™ on Stack Overflow

How to Update Multiple Rows in a Android Database?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related