MySQL Forums :: Newbie :: Decimal fields in tables
Re: Decimal fields in tables
Posted by: Peter Brawley ()
Date: February 18, 2012 07:20PM
Have you not read the manual page on numeric datatypes? A column defined as decimal(11,3) holds any number up to 99999999.999 (11 digits of which 3 are decimals).
>So Why, when I put a maximum of 9,3.
>It doesn't cut the extras zeros if a user puts a small decimal.
Because formatting the result to fit the user's wishes is not MySQL's job. It is the application programmer's job.
> do the parameters inside brackets mean the "Maximum " size allowed?
See above.
>So Why, when I put a maximum of 9,3.
>It doesn't cut the extras zeros if a user puts a small decimal.
Because formatting the result to fit the user's wishes is not MySQL's job. It is the application programmer's job.
> do the parameters inside brackets mean the "Maximum " size allowed?
See above.
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.
© 2013, Oracle Corporation and/or its affiliates