MySQL Forums
Forum List  »  Newbie

decimal type issue
Posted by: Anthony Nelson
Date: October 25, 2016 11:08PM

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.

Options: ReplyQuote


Subject
Written By
Posted
decimal type issue
October 25, 2016 11:08PM
October 27, 2016 05:30PM
October 27, 2016 05:43PM


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.