How to divide int value of Sqlite db table by 2
-
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 ?
-
@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>@mark_ua_1999
That looks suspiciously like "multiply" rather than "divide" to me....
