storing negative value in mysql

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


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