MySQL:(产品)价格的首选列类型？

Question

在 MySQL 中，存储产品价格(或一般货币)的首选列类型是什么？谷歌知道我经常使用 DECIMAL of FLOAT，但我想知道哪个更好。

我存储的价格范围是 0.01 到 25.00。当然更高的值也是可能的。 (注意:我不是要求复制意大利面代码，我只是为您提供更多信息，可以帮助您形成更完整的答案)。

谢谢

Answer 1

十进制是我会使用的

The basic difference between Decimal/Numeric and Float : Float is Approximate-number data type, which means that not all values in the data type range can be represented exactly. Decimal/Numeric is Fixed-Precision data type, which means that all the values in the data type reane can be represented exactly with precision and scale.

Converting from Decimal or Numeric to float can cause some loss of precision. For the Decimal or Numeric data types, SQL Server considers each specific combination of precision and scale as a different data type. DECIMAL(4,2) and DECIMAL(6,4) are different data types. This means that 11.22 and 11.2222 are different types though this is not the case for float. For FLOAT(6) 11.22 and 11.2222 are same data types.