Problems with inserting data in float field in MYSQL

Question

Navigation

#1 by (7 votes)

3

I have a problem inserting a value into a field in the table, this field is as float (15,6).

I circled an insert here

INSERT INTO valores (valor) VALUES ('1160.480000');

Why does he enter the value as 1160.479980?

mysql float

asked by anonymous 11.01.2017 / 15:06

1 answer

Format java.time.Duration for String Link selection between two ListViews

score 7 · Accepted Answer

Formalizing the answer:
The error occurs because float does not store exact details - but rather (monetary values), we should use decimal . ...

The decimal in MySQL has the capacity to store a maximum of 65 digits, and of these, 30 digits can be used for the decimal.

ALTER TABLE valores MODIFY valor decimal(15,6);

INSERT INTO valores (valor) VALUES (1160.480000);