(Mysql) how to create a column is to multiply two columns

Question

| id  |  price  |   quantity  |  total  |
|  1  |   5     |      5      |    25   |

I want to create a total = price * quantity column. What I have to do??

Note that it's not recommended to store derived data – Strawberry Jul 21 '18 at 16:02 — Strawberry, Jul 21 '18 at 16:02

score 0 · Answer 1 · answered Jul 21 '18 at 15:59

0

You could use generated column:

ALTER TABLE tab
ADD COLUMN total INT GENERATED ALWAYS AS (price*quantity) STORED;
                 -- INT or any appropriate data type

answered Jul 21 '18 at 15:59

Lukasz Szozda

1 Answers1