How to correctly insert decimals to MySQL database

Question

I would like to know the proper way to insert decimals to a MySQL database

When I use the type decimal and if I enter 0.20 to the database its saving the value as 0

And when I use the type float and if I enter 0.20 to the database its saving the value as 0.2

I want to display the same value that enter and also, I want to use this value for filters. So, I don’t want to use the varchar type to inset these values.

Can someone tell me what is the best way to do this? I wouldn't mind using PHP to display the missing end zero.

Appreciate your time.

With the decimal type, you specify the length and number of decimal places. How did you define the column in your example? — Sloan Thrasher
– Sloan Thrasher, Commented Jul 20, 2017 at 16:20
10,0 means 10 characters 0 of which are decimal 10,2 would mean 8 numbers to the left, 2 to the right of the decimal. Float should only be used when you're dealing with extremely large or small numbers. Like the number of atoms in the galaxy where precision doesn't matter but scale does. Lastly don't mix the concepts of "Display"(format) and value. Display is a formatting matter when dealing with numbers. 0005.50000 is the same as 5.5. The value is the same it's just a matter of format/display. — xQbert
– xQbert, Commented Jul 20, 2017 at 16:24
Yes seem 10,2 is working. If you can add this as a answer i can accept it. — Jordyn
– Jordyn, Commented Jul 20, 2017 at 16:27

xQbert · Accepted Answer · 2017-07-20 17:45:59Z

10,0 means 10 characters 0 of which are decimal. 10,2 would mean 8 numbers to the left, 2 to the right of the decimal.

Float should only be used when you are dealing with extremely large or small numbers; like the number of atoms in the galaxy where precision does not matter but scale does.

Lastly don't mix the concepts of "Display"(format) and value. Display is a formatting matter. The value 0005.50000 is the same as 5.5. Their display is just a matter of formating.

Collectives™ on Stack Overflow

How to correctly insert decimals to MySQL database

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related