mysql select product of two columns code example
Example 1: mysql multiply
SELECT
Pieces, Price,
Pieces * Price as 'Total'
FROM myTable
Example 2: mysql multiply
update products set price = price * 2;
SELECT
Pieces, Price,
Pieces * Price as 'Total'
FROM myTable
update products set price = price * 2;