Change number in column

Question

When using MySQL, how do you increase or decrease the number in a particular cell by a specified amount with a single query. For example I have a product table with 5 x product a. I sell 1 item and I want to update the field. I want to do it with one query, not get the number add to it and then update (I know how to do that)

Dharman · Accepted Answer · 2020-05-25 19:14:34Z

2

update products set amount = amount + 1 where productId = 12345

If you are using prepared statements you can replace the amount to add as well as the product id with placeholders

edited May 25, 2020 at 19:14

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Nov 27, 2009 at 9:41

Steve De Caux

1,7791 gold badge12 silver badges13 bronze badges

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

Comments

Dor · Accepted Answer · 2009-11-27 09:40:18Z

1

UPDATE tbl SET col=col+1 WHERE id=1234

answered Nov 27, 2009 at 9:40

Dor

7,5225 gold badges36 silver badges47 bronze badges

Comments

David M · Accepted Answer · 2009-11-27 09:40:21Z

1

UPDATE Product SET Quantity = Quantity - 1 WHERE Id = xxx

answered Nov 27, 2009 at 9:40

David M

73.2k13 gold badges164 silver badges187 bronze badges

Collectives™ on Stack Overflow

Change number in column

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related