MySQL data type to keep negative number

Question

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

Therefore, I need to save the following values

-1 0 1 2 3 4 5

What is the best data type, given that I want to get the total of each value (not the sum)?

+4

Harsha mv May 17, '13 at 20:21

1 answer

Ed gibbs · Accepted Answer · 2013-05-17T20:24:07+0000

I would go with TINYINT registered here . It occupies 1 byte of memory, and its range is from -128 to 127.