Mysql

Decimal(5,3) in Mysql is always 99.999


The maximum value for decimal(5,3) is 99.999, it means 5 digits with 3 digits after decimal, and whenever you try to insert or update more than 99.999 value it is automatically capped to 9.99 in mysql. This Try decimal(5, 2) Decimal(5,3) is used for financial values or less than 100% values. If you want to store larger numbers then use decimal(5,2)
In Simple Words The Decimal(5,3) means first argument is the total number of digits of precision, and the second argument is the number of digits after the decimal point.