mysql float data field not accepting every float number

Question

I have a float data field :

`total` float(20,2) unsigned NOT NULL,

I want to insert a float number like : "815032.68" but it's not accepted and the number is rounded to 815032.69. why?

Answer 1

Use a fixed-point data type

`total` DECIMAL(20,2) unsigned NOT NULL

The DECIMAL and NUMERIC types store exact numeric data values. These types are used when it is important to preserve exact precision, for example with monetary data.

MySQL Doc

Floating-point data types can only store approximate numbers.