MySQL Data Type to Store Negative Number

Question

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

So i need to store the following values

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

Why not a `tinyint`? That will take 1 byte. – Taryn May 17 '13 at 20:23 — Taryn, May 17 '13 at 20:23

score 6 · Accepted Answer · answered May 17 '13 at 20:24

6

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

answered May 17 '13 at 20:24

Ed Gibbs

1 Answers1