MYSQL Update

UPDATE mytable SET Total = Pieces * Price;