Mathematical Operations with MySql Php Pdo

[MinusMii]

Hello friends, I would like to multiply two columns in the database with each other and write the result to another column. Then I want to sum these results. How can I do this? One of the columns to be multiplied will have a fixed input that will remain the same, while the other will be variable and increase as operations are added.