在mysql中存储金额 [英] storing money amounts in mysql

问题描述

我想将3.50存储到一个MySQL表中。我有一个float，我存储它，但它存储为3.5，而不是3.50。我怎么能得到它的尾部零？

解决方案

不要存储货币值为浮动，使用DECIMAL或NUMERIC类型：

MySQL数字类型的文档

编辑&澄清：

浮点值容易出现舍入误差，因为它们的精度有限，所以除非你不关心你只能得到9.99而不是10.00，否则应该使用DECIMAL / NUMERIC作为他们是定点数字，没有这样的问题。

I want to store 3.50 into a mysql table. I have a float that I store it in, but it stores as 3.5, not 3.50. How can I get it to have the trailing zero?

解决方案

Do not store money values as float, use the DECIMAL or NUMERIC type:

Documentation for MySQL Numeric Types

EDIT & clarification:

Float values are vulnerable to rounding errors are they have limited precision so unless you do not care that you only get 9.99 instead of 10.00 you should use DECIMAL/NUMERIC as they are fixed point numbers which do not have such problems.

这篇关于在mysql中存储金额的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！