mysql multiply by derived column 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;