MySQL Data Type to Store Negative Number

mysql sqldatatypes negative-number
Harsha M V picture Harsha M V · May 17, 2013 · Viewed 9k times · Source

I have a rating system that ranges from -1 to 5 through 0.

So i need to store the following values

-1
0
1
2
3
4
5

Which is the best data type considering i want to fetch a total count of each value (not sum) ?

Answer

Ed Gibbs picture Ed Gibbs · May 17, 2013

I'd go with TINYINT, documented here. It takes 1 byte of storage and its range is -128 to 127.

Related questions

Should I use the datetime or timestamp data type in MySQL?

Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I'm working with PHP on the server side.

Read More
Which MySQL data type to use for storing boolean values

Since MySQL doesn't seem to have any 'boolean' data type, which data type do you 'abuse' for storing true/false information in MySQL? Especially in the context of writing and reading from/to a PHP script. Over time I have …

Read More
Best data type to store money values in MySQL

I want to store many records in a MySQL database. All of them contains money values. But I don't know how many digits will be inserted for each one. Which data type do I have to use for this purpose? …

Read More