mysql multiply
snippet in sql

mysql multiply

user6155

SELECT 
    Pieces, Price, 
    Pieces * Price as 'Total' 
FROM myTable

mysql multiply

user2885

update products set price = price * 2;