Mysql multiplication query

Question

I have a table called products containing a field called price and I simply want to double the price on every product. Could you give me a hand with an SQL statement I can run within PHP myAdmin please.

score 35 · Accepted Answer · answered Apr 04 '12 at 16:34

35

update products set price = price * 2;

answered Apr 04 '12 at 16:34

Annabel

1,394
14
23

score 8 · Answer 2 · answered Apr 04 '12 at 16:34

8

it's as easy as

UPDATE
  products
SET
  price = price*2;

answered Apr 04 '12 at 16:34

oezi

51,017
10
98
115

score 5 · Answer 3 · answered Apr 04 '12 at 16:36

5

UPDATE products SET price = price + price;

Didn't want to use multiplication :P

answered Apr 04 '12 at 16:36

hjpotter92

78,589
36
144
183

@ErdalG. That is a good question. (But usually it doesn't matter) – Annabel Mar 09 '17 at 11:43
@Annabel Usually not, indeed. It's pure curiosity :) – Erdal G. Mar 13 '17 at 11:01

Mysql multiplication query

3 Answers3

Linked