How to add a value to integer and Update the value in SQLite Database Android

Question

I'm trying to prepare an android app.

I have an column in SQLite Database with type as integer.

For Example the value of the integer in Database is 10. Now i want to update the value of that integer to by adding another value i have say 5.

So finally i want to update the integer value in Database to 15.

Which is the better solution to update the integer value in Database among below options

i) Get the Integer value from Database say 10, then add the value i have say 5 and update that integer value in Database.

ii) Is there any way to add value i have say 5 directly to integer value in Database say 10

Thank You in advance

ehehhh · Accepted Answer · 2015-11-20 21:17:56Z

2

Try something like this:

UPDATE table SET value = value + 5 WHERE id = 1;

answered Nov 20, 2015 at 21:17

ehehhh

1,0683 gold badges16 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

How to add a value to integer and Update the value in SQLite Database Android

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related