Itay Moav -Malimovka Itay Moav -Malimovka - 29 days ago 8
MySQL Question

How to properly define the [float] data type in mysql

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?

Answer

Open phpMyAdmin with structure option and define the float as:

FLOAT(23,19)

clear in this picture: enter image description here