I was setting up a bank for a personal project and I came across creating a table to save a few values, this would use a TINYINT
as the primary key, since I assume that I will not exceed 100 records, but if I happen I want to have a ceiling greater than 127.
(the above example is hypothetical, serving only to explain the question.I am already using INT(2)
).
So I would like to know, considering that key values start at 0 , does using UNSIGNED
in the primary key allow me to register more values? Since negative values are being used on positives?
(It's okay to use negative keys, and it would be useful to keep it with UNSIGNED
in that case, but it's not something I'll use).
>