Welcome To Ask or Share your Answers For Others

php - Float not correct in MySQL

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

I am entering '35444650.00' as a float into my MySQL and it keeps reformatting to 35444648.00, any help welcome...

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

192 views

Welcome To Ask or Share your Answers For Others

1 Answer

answered Oct 17, 2021 by 深蓝 (71.8m points)

Floats only have a certain level of precision, you may be going beyond how precise a float data type can be. Try using a DOUBLE instead.

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

...