Database "Money" (amount) of type storage, applicable to various databases

Because of the angle, we tend to use decimal (18, 2) or float to store money.

However, after the query is difficult to deal with, when the deposit of 20 yuan when the check out is 20.00, but we only want to display 20 but can not be transferred int, because we may save 20.1 yuan.

So with an int or a long to store the amount, the unit is "minutes", the page unit is "meta" when *100 removed/100, so that there will be no more than 0 can not be processed

Database "Money" (amount) of type storage, applicable to various databases