How to multuply current data base row value in one Update sql query

Question

I have DB table and want divide/multiply row record , how it is possible to do it with one SQL Update query, hope your ideas will help to resolve the problem thanks. I have tried the following query but failed

query.exec("UPDATE "+people+ " WHERE id = "+id + " SET ticket_price = ticket_price*2")

Try this way:`query.exec("UPDATE "+people+ " SET ticket_price = ticket_price*2" +" WHERE id = "+id)` — Harshil Doshi, Nov 21 '17 at 21:04

score 0 · Accepted Answer · answered Nov 21 '17 at 21:05

0

The where clause comes after the set clause, not before it:

UPDATE people
SET    ticket_price = ticket_price * 2
WHERE  id = <some id>

answered Nov 21 '17 at 21:05

Mureinik

297,002
52
306
350

How to multuply current data base row value in one Update sql query

1 Answers1