storing negative value in mysql

Question

How can I store negative value in mysql decimal? I have data from DMS to Decimal having negative values, so it is decimal and negative. So what can I use to store such value?

Answer 1

In case you want to store a negative integer - (INT) will work nicely, unless it's not UNSIGNED.

https://dev.mysql.com/doc/refman/8.0/en/integer-types.html

In case you want to store a negative decimal - (DECIMAL) is the way to go, as GBN mentioned above.

https://dev.mysql.com/doc/refman/5.7/en/precision-math-decimal-characteristics.html

Answer 2

Use MySQL DECIMAL type?

Standard SQL requires that DECIMAL(5,2) be able to store any value with five digits and two decimals, so values that can be stored in the salary column range from -999.99 to 999.99