How to divide int value of Sqlite db table by 2
-
wrote on 21 Nov 2017, 20:24 last edited by mark_ua_1999
Hi, I have DB table and want divide row record that is integer by 2 what SQL query could help to do it
thanks for your help. I have tried the following query
query.exec("UPDATE "+people+ " WHERE id = "+id + " SET ticket_price = ticket_price*2") but failed
-
Hi,
Do you want to modify the value in the database or only show the value multiplied by two ?
-
Hi,
Do you want to modify the value in the database or only show the value multiplied by two ?
wrote on 22 Nov 2017, 08:30 last edited by@SGaist Hi the problem is resolved want(modify the value in the database )
UPDATE people
SET ticket_price = ticket_price * 2
WHERE id = <some id> -
@SGaist Hi the problem is resolved want(modify the value in the database )
UPDATE people
SET ticket_price = ticket_price * 2
WHERE id = <some id>wrote on 22 Nov 2017, 08:36 last edited by@mark_ua_1999
That looks suspiciously like "multiply" rather than "divide" to me....
1/4