How can a query multiply 2 cell for each row MySQL? June 5, 2023 by Tarik Use this: SELECT Pieces, Price, Pieces * Price as 'Total' FROM myTable