MySQL: adding and multiplying

Question

How can I make a query that adds and multiplies two columns?

For example:

id || Price per item || Items purchased
1  || 4------------------- ||     3
2  || 3.2----------------  ||     7

I need a query to do: 4*3 + 3.2*7 and so on... How can I do so?

Thank you!

Chandu · Accepted Answer · 2011-07-22 14:07:24Z

5

Try this:

SELECT SUM(price * items_purchased)
  FROM myTable

answered Jul 22, 2011 at 14:07

Chandu

83.2k19 gold badges136 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shef · Accepted Answer · 2011-07-22 14:07:54Z

0

SELECT *, SUM(price*items) total FROM your_table

It will save the sum in the field total. You can access it in your application with that reference, just like you would access price or items.

answered Jul 22, 2011 at 14:07

Shef

45.6k15 gold badges82 silver badges91 bronze badges