Mysql: money and floats

Question

What do I need to store such amounts, such as: $ 1,200,000, $ 1,000 and $ 14.56? ($ dosn't count, it will be deleted)

Answer 1

not to do. Store as int and multiply / divide by 100. For example. Store 14.56 as 1456, but / 100 when displayed. A floating point for storing currency simply requires rounding problems.

Answer 2

Try DECIMAL. See http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html