I want to multiply 2 cells for each row and put the value of that in the last column called Total. Can this be done by a normal query?
Example:
Pieces | Price | Total
6 | 4 | null // should be 24
2 | 10 | null // should be 10
MySQL - Multiplication Operator (*) This operator is used to multiply two numbers in MySQL.
The SQL multiply ( * ) operator is used to multiply two or more expressions or numbers.
All you need to do is use the multiplication operator (*) between the two multiplicand columns ( price * quantity ) in a simple SELECT query. You can give this result an alias with the AS keyword; in our example, we gave the multiplication column an alias of total_price .
Use this:
SELECT
Pieces, Price,
Pieces * Price as 'Total'
FROM myTable
You can do it with:
UPDATE mytable SET Total = Pieces * Price;
I'm assuming this should work. This will actually put it in the column in your database
UPDATE yourTable yt SET yt.Total = (yt.Pieces * yt.Price)
If you want to retrieve the 2 values from the database and put your multiplication in the third column of the result only, then
SELECT yt.Pieces, yt.Price, (yt.Pieces * yt.Price) as 'Total' FROM yourTable yt
will be your friend
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With