Itay Moav -Malimovka Itay Moav -Malimovka - 5 months ago 35
MySQL Question

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

I defined (through PHPMYADMIN) a field with the

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?


Open phpMyAdmin with structure option and define the float as:


clear in this picture: enter image description here