MySQL DECIMAL data type

Question

I have a column in MySQL with the type DECIMAL(2,1). When I insert the number 10 into the database it reads 9.9. I want it to read 10.0. Any ideas? Thanks.

possible duplicate of How to use MySQL DECIMAL?

nawfal
– nawfal

2013-03-28 06:52:45 +00:00
Commented Mar 28, 2013 at 6:52 — nawfal
– nawfal, Commented Mar 28, 2013 at 6:52

Bart Friederichs · Accepted Answer · 2013-02-05 15:10:10Z

58

DECIMAL(2,1) means (as the manual suggests) a decimal of 2 characters wide (in total!) and 1 decimal. If you want 10.0, you need DECIMAL(3,1) (three wide, one decimal).

edited Feb 5, 2013 at 15:10

answered Sep 30, 2012 at 20:17

Bart Friederichs

33.8k16 gold badges112 silver badges219 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL DECIMAL data type

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related