Itay Moav -Malimovka Itay Moav -Malimovka - 1 year ago 68
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?

Answer Source

Open phpMyAdmin with structure option and define the float as:


clear in this picture: enter image description here

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download