How can a query multiply 2 cell for each row MySQL

Question

I want to multiply 2 cells for each row and put the value of that in the last column called Total  Can this be done by a normal query   Example    Pieces   Price   Total 6          4      null    should be 24 2         10      null    should be 10

User · Accepted Answer

Use this   SELECT      Pieces  Price       Pieces   Price as  Total   FROM myTable

User · Answer

this was my solution   i was looking for how to display the result not to calculate     so  in this case  there is no column TOTAL in the database  but there is a total on the webpage       lt td gt  lt  php echo  row  amount1      row  amount2     gt  lt  td gt    also this was needed first      lt  php      conn mysql connect  localhost   testbla   adminbla    mysql select db  testa   conn     query1    select   from info2    get mysql query  query1   while  row mysql fetch array  get         gt

User · Answer

You can do it with   UPDATE mytable SET Total   Pieces   Price

User · Answer

I m assuming this should work  This will actually put it in the column in your database  UPDATE yourTable yt SET yt Total    yt Pieces   yt Price    If you want to retrieve the 2 values from the database and put your multiplication in the third column of the result only  then  SELECT yt Pieces  yt Price   yt Pieces   yt Price  as  Total  FROM yourTable yt   will be your friend

[mysql] How can a query multiply 2 cell for each row MySQL?

Examples related to mysql

Examples related to multiplication