如何在mysql中正确定义[float]数据类型(How to properly define the [float] data type in mysql)
我定义了(通过PHPMYADMIN)一个具有float数据类型的字段。 当我尝试插入一个数字78.556677099932222377时,它会将其转换为79。 如何保存正确的数字,小数点后至少7位?
I defined (through PHPMYADMIN) a field with the float data type. When I try to insert a number as 78.556677099932222377 it will translate it to 79. How do I make it to save the correct number, at least 7 places after the decimal dot?
最满意答案
使用结构选项打开phpMyAdmin并将float定义为:
FLOAT(23,19)在这张图片中清楚:
Open phpMyAdmin with structure option and define the float as:
FLOAT(23,19)clear in this picture:
更多推荐
发布评论