decimal type issue
I'm running mysql 5.6.29 and I'm getting an unexpected result when I attempt to create a field in a table of type decimal(3,1). I don't know if it matters, but I am using phpmyadmin to create the table and its fields.
I've chosen 3,1 because I want to store numbers with at one or two digits to the left of the decimal point, and one digit to the right of the decimal point (e.g., 11.3, 12.9, 9.4).
When I attempt to create a table with a field of type decimal(3,1) the field gets changed to decimal(3,0).
I've read quite a bit of the mysql doc and I can't determine what the problem is or how to get the format that I'm looking for.
Thanks in advance.
Subject
Written By
Posted
decimal type issue
October 25, 2016 11:08PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.