Q:

merge the sum of 3 columns into another column in php mysql

I want to merge the sum of 3 columns (price_crore,price_lakh,price_thousand) in mysql table into another column called 'amount'. 
For example
price_crore,price_lakh,price_thousand for which values are as follows 1,75,50. on the amount column I want the result 17550000
note: according to indian currency system: price_crore= 10,000,000 (1 crore) and price_lakh=100000 (1 lakh) and price_thousand=1000(1 thousand).
please help me achive the above result in php.

A:

I think you just need to do the math:
select   price_crore
       , price_lakh
       , price_thousand
       ,   (price_crore    * 10000000)
         + (price_lakh     *   100000)
         + (price_thousand *     1000) as amount
from some_table

