MYSQL Add to existing value using two columns

Question

I would like to add a value to every row in a table. Using a fixed value would give me the following query

UPDATE your_table SET displayorder = displayorder + C

What would be the right way to run a similar query such that

 UPDATE your_table SET displayorder = displayorder + X(C)

Whereby C is a constant and X is the value of another column of the same row ? How do I get X which is the value of another column and how do I multiply it by C then add to an existing value ?

Gordon Linoff · Accepted Answer · 2017-11-17 12:10:18Z

2

You would just multiply them together:

UPDATE your_table
    SET displayorder = displayorder + X * C;

In most programming languages, * is used for multiplication. Parentheses are just used to group expressions.

edited Nov 17, 2017 at 12:10

answered Nov 17, 2017 at 11:32

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

2 Comments

BKCapri Over a year ago

Im looking for the multiple of X and C whereby X is another column not the sum.

Gordon Linoff Over a year ago

@BKCapri . . . I adjusted the answer.

Collectives™ on Stack Overflow

MYSQL Add to existing value using two columns

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related